Interactive Lesson: Data Quality Investigation
🕵️
Data Detective Agency
Investigate and solve data quality crimes in the suspect database!
📋
Case #2024-DQ: The Corrupted Suspect Database
Urgent! The city’s suspect database has been corrupted. Multiple data quality issues are preventing detectives from solving cases.
Your mission: Identify and fix all data quality “crimes” using SQL. Each type of issue requires different detective skills and SQL techniques to solve.
Your Tools: SQL queries to detect and fix: duplicates, NULL values, invalid data, inconsistencies, and outliers.
Your Tools: SQL queries to detect and fix: duplicates, NULL values, invalid data, inconsistencies, and outliers.
🎯 Investigation Progress
Score: 0 / 500
Duplicate Suspects
Same person, multiple records
3 cases
✓
Missing Evidence
NULL values in critical fields
5 cases
✓
Invalid Data
Impossible or incorrect values
4 cases
✓
Inconsistent Format
Same data, different formats
6 cases
✓
Suspicious Outliers
Extreme values that don’t fit
2 cases
✓
🗃️ Suspect Database