Measuring Data Quality
Measuring Data Quality Across Six Dimensions
In the last unit you parked "data quality" as a single placeholder line on your scorecard, with a promise to sharpen it later. This is later. But here's the problem with that placeholder: "quality" is not one thing. When someone says a dataset is "bad," what are they actually claiming? That it's wrong? Out of date? Missing pieces? Full of duplicates? Those are four different problems with four different fixes, and lumping them under one word is how quality issues stay vague forever.
This unit gives you a sharper vocabulary so you can name exactly what broke, trace it to where it broke, and build a loop that stops it from breaking again.
What Does "Good Data" Actually Mean?
Start by refusing the lazy word. Instead of asking "is this data good?", ask six narrower questions. That's the whole idea behind the Six Dimensions of Data Quality: six separate lenses, each catching a failure the others miss.
The first is accuracy: does the record match reality? A customer address with a typo is complete and properly formatted, but still wrong. The second is completeness: is anything required actually missing, like a contact record with no email in a field that should never be blank? The third is timeliness: is the record current, or does it still show an address the customer changed two months ago?
The fourth is consistency: does the same fact agree across systems? If a customer reads "active" in the CRM but "closed" in billing, neither field is missing or malformed, yet they contradict each other. The fifth is validity: does the value follow the agreed rules and format, such as a country code drawn only from the approved list, or a date that is a real calendar date? And the sixth is uniqueness: does each real-world thing appear exactly once, or has the same customer been entered three times?
Notice how a record can pass five of these and still fail the sixth. A duplicate customer can be perfectly accurate, complete, current, consistent, and valid, and still wreck a count. That's why the dimensions matter: they force you to say which problem you actually have.

When a Number Is Wrong, Where Do You Look?
