Case Study
15% increase in compliance with master data quality solutions to enhance compliance and productivity for a Fortune Global 500
- Industry:Chemicals
This global company is one of the largest in the plastics, chemicals, and refining industries. It is publicly traded and features on the Fortune Global 500 list. The company has a presence in over 100 countries and multiple manufacturing sites across continents.
Challenge
- Inconsistent and incomplete vendor and item master data
- Lack of data quality assessment and benchmarking
- Inefficient data extraction and population processes
- Compliance risks due to poor data quality
Solution
Our team of experts leveraged a connected data fabric approach to identify potential business anomalies that needed to be captured in data quality. A data quality dashboard in Power BI provided a holistic view of all data and insights, focusing on:
- Discover and extract: identify data sources, extract data, and populate it to a staging area in azure.
- Quality assessment: leverage existing data models, identify key attributes and dependencies, and perform data profiling and quality benchmarking.
- Cleanse and enrich: identify quality issues, establish business rules, perform data cleansing and enrichment, and review output through a data quality scorecard.
- Repopulate the data: merge enriched data from the staging area back into the source while managing dependencies.
Tech stack
Outcome
6%
Increase in auto-po rate
13%
Improvement in 3-way invoice matching
15%
Increase in NAFTA/USMCA compliance
Better data quality enhanced governance and decision-making.