The Situation with the Absence of Governance
A large pharmaceutical group encountered complex challenges in advancing its data journey and creating a self-service environment for its business areas.
After more than two years investing in cloud solutions, the results were minimal (less than 10% of expectancy).
The barriers were clear:
As a result, few departments were willing to risk using the available information,and even then, confidence in the data was low. To make matters worse, the IT department’s reputation was damaged, being viewed as an unreliable partner.
The Emerging Challenge
The main challenge was to map out the various data sources
and conduct a detailed diagnosis,
documenting the origin of each piece of information and creating ingestion processes that produced reliable datasets aligned with business KPIs.
The extraction process, previously conducted by Jobs on the “Pentaho” platform, lacked documentation and presented outdated KPI calculations, developed by collaborators no longer with the company.
The uncertainty surrounding the accuracy of the KPIs (many of which were over five years old) was constant, affecting decision-making across various departments.
Mouts’ Solution
The first step involved a thorough evaluation of all the jobs in “Pentaho”, identifying data sources and documenting each KPI calculation.
This documentation was validated along with the business areas to ensure that the data accurately reflected operational needs.
Next, we substituted outdated Jobs for modern ingestion processes (using Azure Synapse) and developed specific datasets for each department, integrated to the Power BI environment. This way, users could access information in an efficient way and adapted to daily needs, including through Excel.
To guarantee transparency and compliance, we implemented data governance with Azure Purview, ensuring that the origins, destinations, and calculation rules were fully documented and accessible to all areas of the organizatio.
The Results of the Solution Implemented by Mouts
This work resulted in the following benefits for the company:
The company finally attained a “self-service” data environment, where information is reliable, accessible, and aligned with organizational objectives.
Technologies Utilized by Mouts
Count on Mouts’ expertise to transform your data journey with robust governance solutions, enhancing the efficiency and reliability of your operation.