🛡️Data Completeness
Also known as Completeness (Data Quality), Missing Data
Whether all the rows and fields that should be there are there.
Think of it like
A puzzle with three pieces missing. You can see the picture, but not all of it.
Example
A daily load brings 9,800 orders when it usually brings 10,000. A missing file from one shop explains the gap.
Why it matters
Gaps make every total too small, and no one sees it. A report can look fine while a whole region is gone.
Definition
Example code
sql
SELECT COUNT(*) AS total,
COUNT(email) AS with_email,
100.0 * COUNT(email) / COUNT(*) AS pct_complete
FROM customers;Common mistake
Key takeaways
- 1No blanks. Required fields are filled in.
- 2No missing rows. Every expected record arrived.
- 3A percentage. Measured as a share of the total.