+45 XP

Data quality dimensions: why 'good enough' destroys trust

A hand holds a wide sieve over a bowl; grain falls through the mesh onto a table

IBM famously estimated that poor data quality costs the US economy $3.1 trillion per year. Gartner puts the average cost to an individual organization at $12.9 million annually.

These numbers sound abstract until you trace specific costs to specific data quality failures: a bank sending loan offers to deceased customers. A manufacturer shipping products to wrong addresses because of duplicate postal codes. A hospital administering the wrong medication dosage due to a unit conversion error in the EHR system. A retailer's demand forecast 40% off because historical sales data included returns.

Data quality isn't a technical concern. It's a business risk with a measurable price tag.

The six dimensions of data quality

The DAMA-DMBOK defines six dimensions of data quality. Every data quality problem maps to at least one of them:

1. Accuracy, Does the data correctly represent the real-world entity or event it describes? A customer's address is accurate if it matches their actual address. Accuracy failures: "Paris" recorded as "Parsi" due to a typo; transaction amounts rounded incorrectly; product weight recorded in the wrong unit.

2. Completeness, Are all required data elements present? A customer record missing an email address is incomplete if email is required for the business process. Completeness failures are often systemic: optional fields that should be mandatory, API integrations that drop fields, migration scripts that don't transfer all attributes.

3. Consistency, Is the same data represented the same way across all systems? A customer's date of birth recorded as DD/MM/YYYY in the CRM but MM/DD/YYYY in the billing system is an inconsistency. Consistency failures are the most common root cause of "which system is right?" debates.

4. Timeliness, Is the data available when it's needed, and does it reflect the current state? A customer's credit score updated monthly is timely for annual mortgage reviews but not for real-time lending decisions. Timeliness failures often emerge as "we knew about the issue but the data hadn't refreshed yet."

5. Validity, Does the data conform to defined formats, ranges, and business rules? A phone number with 11 digits in a field defined for 10 is invalid. A transaction date in the future is invalid. Validity failures are the easiest to detect and fix at the point of entry.

6. Uniqueness, Is each real-world entity represented exactly once? Duplicate customer records are a uniqueness failure. Deduplication is one of the most common data quality initiatives, and one of the most underestimated in complexity.

Data Quality Management | DAMA DMBOK Chapter 13 Explained

Watch on YouTube

Knowledge check

1. A customer's date of birth is stored as DD/MM/YYYY in the CRM but as MM/DD/YYYY in the billing system. Which data quality dimension does this failure primarily violate?

2. A lender uses a customer's credit score for real-time lending decisions, but the score only refreshes monthly. What dimension of data quality is most at risk here?

3. What is the core message behind framing poor data quality with a dollar cost to the economy and to organizations?

MULTIPLE CHOICE

4. Select ALL scenarios that are examples of a VALIDITY failure (data not conforming to defined formats, ranges, or business rules).

Select all the correct answers.

MULTIPLE CHOICE

5. Select ALL statements that correctly describe how the six DAMA-DMBOK dimensions relate to data quality problems.

Select all the correct answers.

Measuring data quality: from subjective to quantitative

"Our data quality is pretty good" is not a measurement. "Our customer master data is 94% complete, 87% accurate, and 91% consistent across CRM and billing systems" is.

Data quality scoring: For each data domain, define a quality score as a weighted average of the six dimensions. Weight dimensions according to business importance. For customer data used in marketing, completeness and accuracy of contact information might weight heavily. For financial data used in reporting, consistency and timeliness matter most.

Profiling: Before you can score, you need to profile. Data profiling tools (Great Expectations, Informatica Data Quality, Ataccama) analyze datasets to reveal: null rates, value distributions, format violations, duplicate rates, referential integrity failures. Profiling a new dataset for the first time is almost always revealing, and often alarming.

Quality dashboards: The CDO should have a real-time data quality dashboard showing quality scores by domain, trending over time. This dashboard should be shared with domain data owners, making quality visible is the first step to making it accountable.

The business case for data quality investment

The ROI calculation for data quality is straightforward:

Current cost of poor quality: Quantify at least one measurable cost, rework time, error corrections, customer complaints, regulatory fines, missed opportunities from incomplete data.

Cost of quality initiative: Tool licensing + implementation + ongoing stewardship + profiling and monitoring.

Target state: What quality score will you achieve, and what business outcome does that enable?

A European telecom calculated that 12% of their marketing budget was wasted targeting inactive customers due to poor data completeness and accuracy. A €50K data quality initiative that reduced waste by 50% delivered a €3M annual saving on a €25M marketing budget, a 60x ROI. That's the language CFOs understand.

What to do, from this lesson

These actions are compiled in the role's Playbook.

  • Profile datasets and publish real-time quality dashboards by domain
See the full action playbook →

Related articles

Recent articles from the blog that build on this lesson.