Master data quality
Master data quality and governance for SAP.
Master data quality is the state of the customer, material and other records every process depends on: complete, valid, unique and owned. Ixia Consulting is a Cape Town enterprise data specialist, delivering globally since 2003, that measures, monitors and governs it across SAP landscapes.
Ixia works alongside SAP MDG and other master data tools. It does not implement MDM platforms.
Master data is small. When it is wrong, everything downstream is.
Customers, business partners, materials and the sales organisation data they trade under are a small share of what an enterprise stores and a large share of what it depends on. SAP will accept a record that is technically valid and wrong for how the business trades. Profiling finds the technically invalid. Only rules the business wrote find the business-invalid.
| Dimension | What it tests | Example check |
|---|---|---|
| Completeness | Fields the business depends on are populated. | Account group, base unit of measure or delivery plant is blank. |
| Validity | Values are allowed, correctly formed and plausible. | A region code not valid for the country, or an EAN with an invalid check digit. |
| Uniqueness | One real-world entity has one record. | The same tax or VAT number on two customers, or one barcode on two materials. |
| Consistency across objects | Records that are valid alone are valid as a set. | A material extended to a sales area with no delivery plant. |
Quality, consolidation and governance, from one team.
Measure and monitor
Ixia DQ runs business-defined rules against extracts or SQL views on a schedule. Failures are counted at business grain, and each domain produces a failure file naming the record, the field and the SAP transaction to correct it.
Ixia DQ for SAPConsolidate and cleanse
Profile every source, match and de-duplicate, and agree survivorship rules with the business so which value wins is recorded and repeatable. Lineage runs back to each contributing source.
Consolidation case studyGovern
Named owners, a glossary that lives in the tools people use, and a council that meets, decides and acts on live exceptions. Rules and their enforcement are the same artefact.
Data governanceHow it runs.
The same five steps apply whether the trigger is an audit, a migration or a standing mandate to keep the data clean. Before a migration, they are how a programme finds out what its data will do to the cutover. See migration readiness.
Assess
Profile the domain as it stands, before anyone argues about it. A scoped Health Check does this for one SAP domain.
Agree the rules
Write each rule in business language with a named owner, a severity and the reason it exists.
Monitor
Run the rules on a schedule and keep every run, so the trend shows whether quality is improving or decaying.
Fix at source
Data owners correct records in SAP, guided by the failure file. Fixes buried in migration or reporting logic do not last.
Prove
A scorecard and trend the business can challenge, not a feeling. The same results feed Power BI and a daily update.
Alongside SAP MDG, not instead of it.
Master data tools such as SAP MDG control how records are created and changed. Ixia DQ measures the quality of the data that results, including records that predate the tool or arrive by other routes. The two answer different questions, and an organisation can run either without the other.
What Ixia does and does not do
- Measures, monitors and reports master data quality against rules the business owns.
- Consolidates and governs master data, with senior practitioners inside the delivery.
- Does not implement MDM platforms.
- Does not change records in SAP. Data owners correct them.
Delivered on real programmes.
Global governance
Master data on one standard across 20+ countries
Governance model, automated rule engines and a Power BI standard for a global consumer goods group, with more than 40 data domains under active governance.
Read the case studyConsolidation
A customer master brought into one governed record set
A customer master spread across many files and SQL sources, profiled, matched and consolidated with survivorship rules the business agreed and lineage back to every source.
Read the case studyMaster data quality, answered
- What is master data quality?
- Master data quality is how complete, valid, unique and consistent the core records of a business are: customers, business partners, materials and the sales organisation data they trade under. It is measured against rules the business owns, and it is only real if it is measured repeatedly, not once.
- What is the difference between master data management, governance and quality?
- Management is the discipline and tooling that creates and maintains master data. Governance sets ownership, rules and decision rights. Quality is the measurable state of the data that results. Ixia works on quality and governance, and works alongside whatever management tooling an organisation runs. Ixia does not implement MDM platforms.
- How do you measure master data quality?
- Against business-defined rules in four families: completeness, validity, uniqueness and consistency across objects. Each rule carries a severity and the business reason it exists, failures are counted once at business grain, and each run is kept so the trend is visible.
- How often should master data quality be checked?
- Continuously rather than annually. Ixia DQ runs on a schedule, nightly in live deployments, so a defect surfaces the day it is created, not at the next audit or migration.
- Does Ixia fix the data in SAP?
- No. Findings go to the data owners with the record, the field, the current value and the SAP transaction to correct it. Correction happens in SAP, by the people who own the data. Ixia DQ does not create, approve or change records.
- Which SAP master data does Ixia DQ cover?
- Customer, Material and Sales Area master data on SAP ECC and S/4HANA, supplied as extracts or SQL views. Nothing is installed on SAP.
- Where does Ixia work?
- Ixia Consulting is based in Cape Town and has delivered enterprise data programmes since 2003 for South African and international organisations, with delivery experience across Europe, the UK, the USA, Asia and the Middle East.
Find out how clean your master data really is.
A scoped Health Check measures one SAP domain against agreed rules and ends with prioritised findings your data owners can act on.
