How Euvic helped Roche’s business grow with Business Intelligence
5 March 2019
Roche, the global medical company, lacked a consistent reporting system to the CEO level. As a result, it was hard for the management to choose the right global strategy for the company. Euvic created a platform based on the rules that recognize, collect and transform data from every region and – when it is necessary – country. The platform created by Euvic has streamlined the decision-making process at the highest level at Roche
SEE OUR CASE STUDY:
Roche is a global medical corporation, made up of pharmaceutical manufacturer Hoffmann-La Roche and supplier of medical equipment Roche Diagnostics. In 2016 it employed more than 94,000 people in more than 100 countries around the world.
What was the problem
Each of the markets where Roche operates had its own way of reporting. The company lacked a consistent reporting system to the CEO level. The way of calculating the business coefficients also depended on the region. As a result, it was hard for the management to choose the right global strategy for the company.
Roche launched a tender and hired, among others, Euvic (within the DVM group) to create a common reporting platform for all the markets. Over time, Euvic became the main contractor and author of the Puls system. The company’s specialists were also architects, responsible for the global platform concept and vision. Because this project was one of the key projects for Roche, engineers were under huge pressure and bore a great deal of responsibility.
The project started in 2013. International teams worked in sprints, with face to face workshops in Mannheim lasting from 2 to 5 days.
The main problem was how to unify data from all the regions, so that a centralized database could generate standardized reports. It is the so called “single version of truth” concept. To make the whole task even more challenging, the programmers had to take into consideration the fact that the data differed even within the same region – as for instance in Asia. China, Singapore, India – each Roche branch had a differently configured system.
What was the solution
Euvic created a platform based on the rules that recognize, collect and transform data from every region and – when it is necessary – country. The is no need to write a script. When data processing begins (usually according to a predefined schedule), a code is generated on the fly, which is able to download and process the data to the selected format.
The processed data are sent to the data marts, which are divided thematically. For example, there is a data mart “sales” and a data mart “commercial excellence”. They are available to managers and heads of departments, whether they work in the United States or Taiwan. Specialists from the region only see their data whereas global receivers have access to all reports.
Other teams worked on data marts independently from Euvic specialists. At some point it became clear that even though all of the teams operated on identical data, they calculated them differently. To solve the problem of incompatible data, Euvic wrote another system that calculates all the reports for all the recipients. It is the so called CDS – common data storage, a new calculation layer. Thanks to it there is no need to calculate the same data by different teams, which saves time and money.
To support the platform, Roche created a separate department called SMS. Its workers are recruited from the engineers that created the system and have the know-how and permission to configure the EDW platform. They can connect local systems to the platform, which starts to accelerate and sends data to the company’s head office right away. The SMS team can also diagnose the platform, improve it and add new functionalities. Because of its size, part of the system is implemented on Microsoft Azure cloud.
This unique solution operates on a data volume of 27 terabytes. The platform operates day and night, processing 300 gigabytes daily. There are about 3,5 thousand source systems connected to it and more or less 5 thousand subscribers. EDW platform is failure-free from the very beginning. Even though it does not rest, there have been no error reports for 1.5 year. The platform is scalable without having to change the code.
A help-check is implemented on the platform and it can be extended. If, in the future, Roche would like to get access to the historical data on the operation of processing operations, Euvic specialist can start machine learning algorithms to generate such information. Algorithms can also identify unusual behavior of systems so that engineers can be sure, that the whole platform is working properly.
Why was it important
The platform created by Euvic has streamlined the decision-making process at the highest level at Roche. With a common source of truth, company managers can trust the data they get and use them to create a sales strategy for their products and company growth.back