A few years back I inherited a CRM with 47,000 contact records. Nearly a third were duplicates.
Company names were spelled four different ways. Emails bounced to people who’d left their jobs long ago. I remember thinking: how did it get THIS bad?
Here’s what I learned cleaning up that mess. The problem was never one thing. It was a whole family of missing habits.
No owner for the data. No cleanup routine. No way to trust what was in there. That family of habits has a name, and it’s data quality and governance.
So think of this hub as your map. It ties together every term in this category and shows you how they fit. Let me walk you through it 👇
30-Second Summary
Data quality and governance is the discipline of keeping business data accurate, consistent, and trusted, with people and rules in charge of it. Quality is the CONDITION of your data. Governance is the SYSTEM that keeps it in good condition.
What this category covers:
- The trust foundation: governance, quality, integrity, and frameworks
- The cleanup crew: cleansing, deduplication, matching, and enrichment
- The prep bench: wrangling, munging, preparation, and blending
- The tracking tools: lineage, redundancy, and profiling in ETL
📌 Quick take: Quality and governance are two sides of one coin. Governance sets the rules. Quality measures whether the data follows them. You need both, or neither really works.
What Does Data Quality & Governance Cover?
This category covers the practices that decide whether your data can be trusted.
Some terms describe the STATE of your records. Others describe the WORK you do to fix them. And a few describe the OVERSIGHT that keeps the whole thing honest.
I’ve grouped the 15 terms into four small families below. Read them in order and the category clicks into place. Each term links to its own full definition.
The Trust Foundation
Start here. Data Quality measures how fit your data is for its purpose. Is it accurate, complete, consistent, timely, valid, and unique?
Data Governance is the framework of policies, roles, and processes that manage data as a business asset. It decides who owns data and who can touch it.
Two more terms anchor this family. Data Integrity is about relationships holding true, so every order points to a real customer, with no orphan records and no silent corruption.
And a Data Governance Framework is the written blueprint that turns governance from a nice idea into an operating model with owners, stewards, and councils.
The Cleanup Crew
These four terms do the dirty work. Data Cleansing fixes what’s wrong: bad formats, typos, missing fields, stale values.
Data Deduplication finds and removes the copies. So one customer isn’t counted as three.
Data Matching is the smarter cousin of dedup. It links records that BELONG together even when they don’t look identical, like “IBM” and “International Business Machines.”
And Data Enrichment fills the gaps by adding trusted third-party details. It only works if governance keeps the sources clean. Garbage in, enriched garbage out.
The Prep Bench
Before data reaches a dashboard, someone shapes it.
Data Wrangling is the broad craft of reshaping raw data into an analysis-ready form. Data Munging is the scrappy, hands-on version of that same idea, the term analysts use for messy manual reshaping.
Data Preparation is the structured, repeatable process teams build so they aren’t reinventing the wheel each time.
And Data Blending pulls fields from several sources into one combined view without permanently merging the underlying tables.
The Tracking Tools
You can’t govern what you can’t see.
Data Lineage traces where each field came from and every step it took to get here. That’s priceless when a number looks wrong and you need the source.
Data Redundancy is the duplication of data across systems, deliberate or accidental. You manage it carefully so copies don’t drift out of sync.
Finally, Data Profiling in ETL scans a dataset before it enters your pipeline, measuring null rates, value ranges, and patterns.
It’s the health check that makes every other practice on this page easier.
Every Term in This Category, at a Glance
Here’s the whole category in one table. Skim it, then click into any term that matches what you’re wrestling with today.
| Term | What it means |
|---|---|
| Data Governance | The policies, roles, and processes that manage data as a trusted business asset. |
| Data Quality | How fit data is for its purpose across accuracy, completeness, and consistency. |
| Data Integrity | Whether relationships and values stay accurate and uncorrupted over time. |
| Data Governance Framework | The written blueprint of owners, standards, and controls that runs governance. |
| Data Cleansing | Fixing incorrect, malformed, or incomplete records. |
| Data Deduplication | Finding and removing duplicate copies of the same record. |
| Data Matching | Linking records that refer to the same entity, even when they differ. |
| Data Enrichment | Adding trusted third-party details to fill gaps in your records. |
| Data Wrangling | Reshaping raw data into a clean, analysis-ready form. |
| Data Munging | The hands-on, manual side of reshaping messy data. |
| Data Preparation | The structured, repeatable process of readying data for use. |
| Data Blending | Combining fields from multiple sources into one view. |
| Data Lineage | Tracing where data came from and every step it took. |
| Data Redundancy | Managed duplication of data across systems. |
| Data Profiling in ETL | Scanning a dataset’s structure and quality before it enters a pipeline. |
💡 Where to start: New to all this? Begin with Data Quality and Data Governance. Once those two make sense, every other term on this page is just a tool serving one of them.
How These Terms Work Together
Here’s the cycle I’ve watched play out in every healthy data team. Governance sets the standard. Profiling measures the gap.
Cleansing, deduplication, and matching close it. Lineage proves what happened. Then quality metrics report back, and governance adjusts the standard again.
So none of these terms live alone. They’re a loop. Skip one link and the whole chain loosens.
That’s why I stopped treating cleanup as a one-time project years ago. It’s a habit you run forever.
Want the bigger picture? These practices sit on top of the data fundamentals that every data-driven team learns first, and they feed directly into the data lifecycle and migration work that moves records between systems.
Where Should You Start in This Category?
Start with data quality, then data governance. Condition first, control second.
Read data profiling in ETL next. It’s the cheapest way to find out how bad things actually are, and it gives you numbers instead of opinions.
Then work the cleanup crew as a set. Cleansing, deduplication, and matching solve overlapping problems, and the differences matter once you’re choosing a tool.
Save the prep bench and the tracking tools for last. They make more sense after you’ve cleaned something real.
Frequently Asked Questions
What is data quality and governance?
Data quality and governance is the discipline of keeping business data accurate, consistent, and trustworthy while assigning clear ownership and rules for it. Quality describes the condition of the data itself. Governance is the system of policies, roles, and processes that keeps that condition healthy over time.
What is the difference between data quality and data governance?
Data quality is the measurable condition of your data: how accurate, complete, and consistent it is. Data governance is the oversight system that sets standards, assigns owners, and enforces rules. Quality tells you the current state. Governance decides what the state should be and who is accountable for it.
Which practices fall under data quality and governance?
This category covers governance, data quality, data integrity, and governance frameworks for oversight, plus hands-on practices like data cleansing, deduplication, matching, enrichment, wrangling, munging, preparation, blending, lineage, redundancy, and data profiling in ETL. Together they cover setting standards, cleaning records, and tracking data trust.
Where should a team start with data governance?
Start small. Pick one high-value data domain, assign an owner and a steward, and profile it to baseline its quality. Add classification and access rules first, then expand. Trying to write fifty policies on day one is the fastest way to stall a governance program before it delivers value.
Why does data quality matter for enrichment?
Enrichment adds third-party details to your records, but it amplifies whatever is already there. If your base data is messy or your source-priority rules are undefined, enrichment can spread errors instead of fixing them. Governance keeps enrichment sources trusted and auditable so the added data actually improves accuracy.
How often should you run a data quality check?
Continuously for the data your business runs on, and on a schedule for everything else. Profiling at the point of ingestion catches most problems before they spread. A monthly review of the same metrics then shows you whether the trend is improving or quietly sliding back.