Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
ISO/IEC 29121:2018 provides a standardised framework for defining, measuring, and reporting data quality metrics. In an era where organisations increasingly depend on data-driven decision-making, the ability to quantify data quality is no longer optional — it is a core requirement for regulatory compliance, operational efficiency, and trustworthy analytics.
The standard establishes a taxonomy of data quality dimensions — categories such as accuracy, completeness, consistency, timeliness, and uniqueness — and defines measurable indicators for each. Rather than prescribing a one-size-fits-all metric set, 29121 provides a flexible framework that organisations can tailor to their specific data domains and use cases.
The core of ISO 29121 is its data quality dimension model, which organises metrics into six primary categories:
| Dimension | Definition | Example Metric |
|---|---|---|
| Accuracy | Degree to which data correctly represents the real-world object | Field error rate (errors per 1000 records) |
| Completeness | Proportion of data that is present and usable | Null rate per mandatory attribute |
| Consistency | Absence of contradictions across data sets or systems | Cross-system value match rate |
| Timeliness | Currency of data relative to its required update cycle | Data age at time of use (hours/days) |
| Uniqueness | Absence of duplicate records within or across data sets | Duplicate record ratio |
| Validity | Conformity of data to its defined format, type, and range | Format compliance percentage |
Each dimension is associated with one or more quantifiable metrics. The standard provides detailed computation formulas, sampling strategies, and reporting templates. Importantly, it distinguishes between direct metrics (measured by inspecting the data itself) and indirect metrics (inferred from process or system characteristics).
The standard defines a systematic measurement lifecycle consisting of five phases:
1. Scope Definition. Identify the data assets, attributes, and quality dimensions relevant to the business context. For example, a customer master data quality assessment might focus on accuracy, completeness, and uniqueness of name, address, and contact fields.
2. Metric Selection. Choose specific metrics from the standard’s catalogue or define custom metrics that conform to the framework. Each metric must have a clear measurement unit, data source, and acceptable threshold.
3. Data Sampling. Determine the sampling method (random, stratified, or systematic) and sample size. The standard provides statistical guidance for achieving a 95% confidence level with a 5% margin of error.
4. Measurement Execution. Run the measurement using automated data profiling tools or manual inspection. The standard specifies precise SQL-like queries for many common metrics.
5. Reporting and Remediation. Present results using the standard’s reporting template, which includes dimension scores, trend data, and recommended actions.
ISO/IEC 29121 is not just a theoretical framework — it provides concrete guidance for implementation:
| Concern | Recommendation | Rationale |
|---|---|---|
| Tool selection | Use tools that support the standard’s SQL-based metric definitions | Reduces rework and ensures auditability |
| Threshold setting | Base thresholds on business impact analysis, not arbitrary targets | Aligns quality levels with risk appetite |
| Measurement frequency | High-volatility attributes daily; stable attributes weekly | Balances monitoring cost with detection speed |
| Ownership | Each metric must have a named data quality owner | Ensures accountability for remediation |
| Documentation | Maintain a data quality metric catalogue with lineage | Supports traceability and regulatory audits |
The standard also addresses the relationship between data quality and data governance, emphasising that metrics alone are insufficient without clear accountability, escalation paths, and remediation processes.