Skip to content
Technology transformation expertise firm · ARDIANE Group Innovate, secure, succeed

Data

Data quality and master data management (MDM)

Data is not good or bad in the absolute: it is either sufficient for a given use or it is not. Our consultants help your teams measure quality where it matters, control it automatically and address the causes at the source.

Our principles

  • Quality rules written with the business
  • Automated controls, not clean-up campaigns
  • Single, shared master data
In brief

Data quality refers to the ability of a piece of data to serve the use for which it is intended, measured along dimensions such as accuracy, completeness or timeliness. Management Square consultants help your teams define with the business the rules to be respected, automate controls in the processing pipelines and structure master data management (MDM).

Scope

How we contribute

  1. Profiling and assessment

    Measurement of the real state of critical data: missing values, duplicates, invalid formats, inconsistencies between systems. The assessment replaces impressions with findings.

  2. Quality rules

    Writing, with the business, the rules to be respected, their acceptance threshold and the course of action in the event of a deviation, for each critical data item and each use.

  3. Automated controls

    Translation of the rules into tests run by the processing pipelines, at ingestion, during transformation and before exposure, with alerts sent to an identified owner.

  4. Anomaly handling process

    Qualification, assignment, correction and closure of anomalies, with a search for the cause in the application or process that produced the data.

  5. Master data management

    Framing the MDM: scope of the master data domains, choice of implementation style, matching rules and the process for creating and modifying records.

  6. Quality monitoring

    A dashboard by domain and by dimension, reviewed by the data owners, to make trade-offs on corrections and see their effect.

Page contents

Clean-up campaigns that do not last

Almost every organisation has already run a clean-up campaign: deduplicating the customer file before a migration, making addresses reliable, putting a product master back in order. The result holds for a while, then data quality returns to its starting level. The same causes have produced the same anomalies.

Three methodological errors explain this backsliding. The data was corrected without touching the process that produces it: an entry screen without controls, an interface that truncates a field, a business rule understood differently by different teams. The aim was “clean” data in general, whereas the level required depends on the use. And checks, where they exist, are manual and one-off: they observe, they do not prevent.

The subject takes on particular significance with AI. A model trained on erroneous data learns those errors, and an assistant that relies on a document base reproduces its contradictions with confidence.

The six dimensions of data quality

Talking about quality without specifying the dimension concerned leads to endless debates. Six dimensions cover most needs.

Dimension Question asked Example rule
Accuracy Does the value reflect reality? The delivery address corresponds to an existing address
Completeness Is the necessary information present? Every active contract has an effective date
Consistency Are the values compatible with one another and from one system to another? A customer’s status is identical in the sales tool and in billing
Validity Does the value respect the expected format and list of values? The country code belongs to the current nomenclature
Uniqueness Does a given entity appear only once? A supplier has only one identifier
Timeliness Is the data up to date and available in time? The previous day’s sales are loaded before the stores open

These dimensions do not carry the same weight depending on the use. A regulatory report requires accuracy and completeness. A recommendation engine tolerates missing values, but not out-of-date data. This is why a quality rule is always written for a use and with the business concerned.

The law, moreover, recognises some of these dimensions. The GDPR, Regulation (EU) 2016/679, sets out in its Article 5 a principle of accuracy of personal data. Article 10 of the AI Act, Regulation (EU) 2024/1689, requires for high-risk AI systems training, validation and testing datasets that are relevant, sufficiently representative and, to the best extent possible, free of errors and complete in view of the intended purpose of the system (paragraph 3).

From rules to automated controls

A usable rule has four elements: a statement the business can understand, an acceptance threshold, an owner and a course of action on failure. Without the last two, the control produces alerts that nobody reads.

Controls are placed at four points in the chain.

  • At data entry, in the source application: lists of values, mandatory fields, duplicate detection at creation. This is the least costly control.
  • At ingestion: schema conformity, expected volumes, freshness of the load.
  • During transformation: business rules, integrity between tables, reconciliations between systems.
  • Before exposure: plausibility of aggregates, comparison with previous periods.

Each control is either blocking or merely flagged. A blocking control stops the release of questionable data, at the cost of a late report. This choice belongs to the business, not to the technical team. In addition to explicit rules, there is statistical detection of unusual variations in volume or distribution, useful for anomalies that nobody had anticipated.

Master data: what MDM resolves, and its four styles

Master data is the data that several applications share: customers, products, suppliers, sites, organisational structure. Nomenclatures (country codes, currencies, charts of accounts) are also included. When each application keeps its own version, no consolidation is reliable.

MDM (Master Data Management) is the discipline that maintains a reference version of these entities: rules for matching records, choice of the value retained in the event of a conflict, process for creation and modification. It is implemented in one of four styles, from the lightest to the most demanding.

Style How it works Consequence
Registry An index links the applications’ records without copying or modifying them Quick to set up, corrects nothing at the source
Consolidation Data is copied and matched in a hub to produce a reference version intended for analysis Makes reporting and analytics reliable, leaves applications unchanged
Coexistence The reference version is built in the hub, then synchronised back to the applications Aligns systems, requires flows in both directions
Centralised The hub becomes the single place of creation and modification Maximum control, profound transformation of processes

The choice depends less on the tool than on the organisation’s ability to modify its processes and applications. It determines the place of the hub in the information system, which we address with the methods of IT architecture.

Our approach: start from a use, trace back to the source

We start with a use whose value is recognised and with the data it consumes. Profiling that data gives a measured state: the discussion then turns on findings rather than impressions.

The rules are then written with the owners and stewards appointed by data governance. If these roles do not yet exist within the scope, we recommend having them appointed: a rule without an owner is not applied.

Controls are developed as code, versioned and run by the platform’s processing pipelines. Each anomaly follows an explicit process, from qualification to closure. For recurring anomalies, we trace back to the cause and propose the correction in the originating application or process. An MDM workstream is opened only if the assessment shows a problem of sharing between systems, and not a simple data entry defect.

What makes a quality initiative fail

  • Cleaning without addressing the cause. A downstream correction has to be redone with every load.
  • Requiring the same level everywhere. Quality has a cost. It is concentrated on critical data and proportioned to the use.
  • Multiplying controls with no recipient. Alerts that are too numerous and unassigned are ignored, including those that matter.
  • Launching MDM as a tool project. Without agreed matching rules or a decision process, the hub becomes one more application to reconcile.
  • Forgetting documents. The unstructured content that feeds a RAG system also has its duplicates, its out-of-date versions and its contradictions.

The indicators to track

  • The compliance rate by rule and by dimension on critical data, and how it changes over time.
  • The number of open anomalies, their age and their correction time.
  • The share of anomalies corrected at the source rather than downstream.
  • The share of incidents detected by controls before being reported by a user.
  • For master data: the duplicate rate and the time taken to create a new record.

The fourth indicator sums up the ambition of the initiative. As long as it is users who discover the errors, trust is not restored, whatever compliance rate is displayed.

Typical work

What our consultants contribute to

Profiling report

Measured state of critical data, anomalies ranked by impact on uses and probable causes.

Rule repository

Documented quality rules: business statement, dimension, threshold, owner and action on failure.

Automated controls

Automated tests integrated into the processing pipelines, versioned and accompanied by their alerting procedure.

MDM framing file

Scope, chosen implementation style, matching rules, roles and deployment path.

Management Square in figures

300+
projects completed
43+
clients supported
Since2015
serving our clients
  • Allianz
  • Euler Hermes
  • Groupe BPCE
  • ODDO BHF
  • Candriam
  • Ledger
  • Saur
  • Veolia
  • Voltalia
  • emeis
  • Bonpoint
  • Legal Suite

FAQ

Frequently asked questions

Another question? Ask us

What is data quality?

Data quality is the ability of a piece of data to fulfil the use for which it is intended. It cannot therefore be judged in the absolute: an address that is sufficient for a statistical study may be insufficient for a delivery. It is measured along dimensions such as accuracy, completeness, consistency, validity, uniqueness and timeliness.

What is the difference between data quality and MDM?

Data quality concerns all data and consists of defining rules, checking that they are respected and correcting deviations. MDM (Master Data Management) covers only the data shared between applications, such as customers, products or suppliers, and aims to maintain a single version of it. MDM is one means among others of achieving quality within that scope.

Where should quality controls be placed?

As close as possible to the source, because an error stopped at data entry costs less than an error corrected in a report. In practice, controls are spread across four points: at data entry in the application, at ingestion into the platform, during transformations and before exposure to users.

Who is responsible for data quality?

The business that produces and uses the data, through the data owner, who sets the expected level and arbitrates corrections. Technical teams provide the controls, alerts and correction tools. A data team cannot decide on its own whether a value is correct: it does not always know its business meaning.

Do you need an MDM tool to make a customer or product master reliable?

Not necessarily. If the duplicates come from uncontrolled data entry in a single application, the correction is made in that application. An MDM tool is justified when several systems create and modify the same entities and none of them can serve as the reference for the others.

A project to bring to completion?

A first conversation is enough to understand your challenge, identify the right people and tell you frankly what we can bring.