P30Data CleaningIntermediateDiagnose12 min
Detect Invalid Customer Records
Flag records with impossible or internally inconsistent customer values.
#validation#business-rules#data-quality
Scenario
A signup table includes negative ages, future birth dates, and countries not supported by the product.
Problem statement
Create validation rules that separate invalid records from merely missing values.
Your Task
- Define explicit rule checks.
- Keep failure reasons per record.
- Avoid deleting data before measuring the issue.
Related Concepts
Validation rulesData observabilityMissing data
Ready to count this problem?
Mark it complete when you have reasoned through the solution in your own words.