Case Study
Master Data Quality: Paving the Way for Compliance, Productivity, and Long-Term Success
- Industry: Chemicals
- Headquarters: US
One of the world’s largest plastics, chemicals and refining companies, this Fortune 500 company has a global footprint with 55 manufacturing sites in 25 countries.
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 leverages a Connected Data Fabric approach to identify potential business anomalies that need to be captured in Data Quality. A Data Quality dashboard in Power BI provides a holistic view of all data and insights, focusing on:
- Discover & 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 & 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
Azure for Data Staging and Storage
Power BI for Dashboard Monitoring and Insights
Outcome
6%
increase in Auto-PO rate
13%
improvement in 3-way invoice matching
15%
increase in NAFTA/USMCA compliance
increase in NAFTA/USMCA compliance