A major UK-based pharmaceutical company aligned data in various source systems with their existing master data hub, cleansing their master data and improving data quality across their organization and branches around the globe.
The pharmaceutical company aimed to determine how closely data in their source systems (including clinical studies, chemical compound and substance information, customer data, and more) corresponded with the information in their existing master data management hub.
The comprehensive data quality solution enabled company data curators to locate and repair any data issues in their source systems and MDM hub. Business users are now able to view data quality improvements over time and raise awareness of the importance of data quality on all levels. The solution included features such as:
Summary reports with an overview of the current state of data
Detailed reports to allow data curators to perform manual corrections in individual source systems
Export to XLS functionality
Color-coded XLS templates that could be populated directly from Ataccama data quality tools, and accessed via Ataccama’s user-friendly GUI
Drill to detail possibilities, including entities (clinical study), parent attributes, and child attributes
The organization utilized the Ataccama ONE platform module for Data Quality Management. Ataccama ONE DQM is a powerful, business rule-driven platform module for complex data curation that enables you to transform, standardize, cleanse, validate, correct, and enrich your data, and prevent incorrect data from entering your systems.
RSA implemented Ataccama’s Reference Data Management solution on AWS to centralize data management, avoid data duplication, and propagate a single version of reference data to consuming systems.
The charity implemented Ataccama ONE MDM to master and consolidate enterprise-wide data into a platform that could be shared across the organization as a single version of the truth.