Ask five people to define data quality and you'll get some version of the same list: accurate, complete, consistent, timely, valid, unique. It's not wrong. It's just not that useful on its own, because it doesn't tell you what to do when a dataset fails one of those checks but the business still needs an answer today.
Here's a definition that's actually held up for me across every domain I've worked in: data quality is whatever makes a dataset safe to make a decision on. That's it. Not perfect. Not complete in some abstract sense. Safe to act on, for the specific decision someone is trying to make.
That reframing matters because it makes quality contextual instead of absolute. A customer dataset missing phone numbers might be perfectly fine for a revenue report and completely unusable for a support team trying to call people back. Same data, two very different quality bars. Chasing one universal standard of "clean data" across an entire organization is usually the wrong goal. The right question is always: clean enough for what?
The dimensions still matter, just not as a checklist
The standard dimensions of data quality are useful once you treat them as diagnostic tools rather than a certification to pass:
- Accuracy. Does the data reflect reality? A customer's address that's outdated by two years is accurate in the sense that it exists, but not in the sense that matters.
- Completeness. Are the fields you need actually populated? Missing values aren't automatically a problem; missing values in the field a downstream decision depends on are.
- Consistency. Does the same fact agree with itself across systems? This is where "the same customer exists in three systems with three different values" lives.
- Timeliness. Is the data current enough for the decision being made on it? A dashboard refreshed nightly is fine for a monthly business review and useless for fraud detection.
- Validity. Does the data conform to the format and rules it's supposed to? A phone number field with a date in it fails validity even if every other check passes.
- Uniqueness. Is each real-world entity represented once? Duplicate records quietly inflate counts and split a single customer's history into fragments.
None of these matter in isolation. What matters is which of them actually affects the decision someone is trying to make with the data in front of them.
Quality is not a one-time cleanup
The most common mistake I see is treating data quality as a project with an end date: run a cleanup, fix the duplicates, close the ticket. It works for exactly as long as nothing upstream changes. Then a source system adds a field, a team changes how they enter data, a new integration goes live, and the same problems come back, usually discovered by whoever's building the next report.
Quality that holds up is built into the pipeline, not bolted on afterward. That means validation at the point data enters a system, checks that run continuously rather than on demand, and clear ownership so that when something drifts, someone is actually responsible for catching it before it reaches a report.
That's the difference between cleaning data and engineering for quality. One is a task. The other is a property of how the whole pipeline is built, from ingestion through to the report someone reads.
This is the thinking behind how I approach every data pipeline I build.
See My Approach
Comments
Loading comments...