#19 Reference & Master Data in Action - Harmonizing Data

Ever tried to compare sales across regions - only to find every team uses a different currency code, product name, or regional category? That’s exactly what happened to a global manufacturer. For instance, “Euro”, “EUR”, and “€” meant the same thing - but not to their systems.  My personal favorite is punctuation: Europe has 1.000,01, US 1,000.01. My developers found a perfect solution 100001 (cents). But the result is the same: Reports don’t match if this is not aligned accordingly. Financial consolidation takes weeks. And executives are flying blind with conflicting data from different markets.

The culprit? Inconsistent reference and master data. What they needed was a consistent currency code and a global naming convention.

By standardizing definitions, aligning values, and putting proper governance in place, the company enabled accurate global reporting and financial analysis. Suddenly, global sales analysis became fast, accurate, and trusted - turning disconnected data into a unified story.

Main Key DAMA Knowledge Areas Involved

These three key knowledge areas played a critical role:

1. Reference & Master Data Management (explored in our last post) standardizes and governs critical data entities (e.g., product names, region hierarchies, currency codes), ensuring consistency across systems and business functions.
2. Data Governance provides the policies, accountability, and business ownership to ensure that reference and master data is aligned, approved, and maintained over time.
3. Data Quality Management ensures the accuracy, completeness, and consistency of harmonized master data - especially as it is integrated from multiple systems and regions.

Three Key Steps to Solve the Problem

With these knowledge areas in place as a foundation, the company followed a clear, structured approach to solving the problem.

1. Assess and Inventory Inconsistencies

• Take inventory regional systems and identify duplicate or mismatched reference values (e.g., "1.000,00”, "1,000.00", "100000")
• Review master data definitions for products, regions, and categories across systems
• Identify business-critical areas affected by inconsistencies (e.g., sales reporting, finance)

2. Harmonize and Standardize Core Data

• Define global standards for currency, region, product names, and categories
• Create a centralized reference data dictionary with mapped local values
• Align business units on common definitions and naming conventions

3. Implement Governance and Tools

• Assign data owners/stewards to manage master and reference data
• Implement a Master Data Management (MDM) tool or workflow
• Set up ongoing validation and approval processes for new values or changes

6-Month Plan to Harmonize Data

Here is an approach to implement Reference and Master Data step-by-step.

Month 1: Discover the inconsistencies

• Take inventory of regional systems and key data entities
• Identify conflicting values for currency, regions, and products
• Interview business teams to understand reporting pain points

👉 Data Inventory & Conflict Report

The team uncovers a patchwork of currency codes, overlapping product names, and varying region definitions. Everyone finally sees how data inconsistencies are breaking global reporting. The problem is no longer hidden - it’s mapped and understood.

Month 2: Define global standards

• Draft standard definitions
• Agree on and document naming conventions and ownership
• Document mappings from local to global

👉 Global Data Standards Dictionary

Teams across business units are aligned on shared definitions. Finance, sales, and regional leads agree on what “Europe” means and how to report revenue in “EUR”. For the first time, everyone is speaking the same data language.

Month 3: Align and approve across the business

• Host workshops to confirm mappings with regional teams
• Finalize the master data model and ownership plan
• Identify local exceptions or translation rules as edge cases

👉 Harmonized Master Data Framework

Cross-functional collaboration pays off. Local teams feel heard, and global standards are locked in. Business users are now confident that harmonized data reflects both regional needs and enterprise-wide reporting goals.

Month 4: Set up governance and tools

• Assign data stewards and define stewardship responsibilities
• Implement validation workflows for master/reference data
• Configure MDM or centralized reference data platform

👉 Governance Model & Tooling Live

Governance moves from theory to practice. Data stewards begin managing updates, validations are in place, and new values can’t sneak in without checks. The data has guardrails - and trusted oversight.

Month 5: Begin rollout and integration

• Clean and map existing data in operational systems
• Sync harmonized data into key reporting systems
• Test global reporting scenarios using the unified model

👉 Harmonized Data Activated in Key Systems

The team activates the new structure. Clean, standardized data now powers dashboards and finance reports. Duplicate product names vanish, currencies match, and reports align from Athens to Zurich.

Month 6: Monitor, train, and improve

• Set up data quality monitoring dashboards
• Train teams on how to use and maintain harmonized data
• Document maintenance and update process

👉 Data Stewardship Handbook & Success Metrics

The data team closes the loop. Teams are trained, stewards are in place, and reporting stability is now measurable. The organization has a sustainable way to keep data consistent - even as it grows.

Final Result After 6 Months

The manufacturer now has:

• A centralized, governed set of reference and master data used across all regions
• Standardized currency codes, product names, and regions - enabling accurate financial consolidation and sales reporting
• A sustainable data stewardship program and MDM process
• Faster reporting, improved confidence in KPIs, and fewer manual reconciliations

The business can now make decisions based on a single, trusted version of the truth - worldwide.

If this sounds familiar - or if you're tackling similar data challenges in your organization - feel free to reach out. I'm always happy to exchange ideas or explore how I can support your efforts.

With that, we’ve wrapped up the core disciplines of data management - each essential on their own. But the real power comes when they work together. Next up: how it all connects to enable seamless data flows across systems, teams, and time.

Coming next: “#20 Data Integration & Interoperability: Connecting the Dots”

#MasterData #ReferenceData #DataGovernance #DataQuality #DataManagement #DAMA #BusinessData #BetterDataSeries