Lesson 9 of 10
Auditing an imperfect dataset
Profile NULL, formats, duplicates, domains and breaks before analysis.
34 minSQL Data Analyst
By the end of this lesson
- Profile a column
- Standardize without losing the source
- Quantify anomalies
SQL Essentials
Unlock this lesson and continue the path.
Auditing an imperfect dataset is part of the complete programme: 38 lessons, 62 verifiable exercises and 8 published guided projects.
- Complete content with explained examples
- SQL simulator and expected result
- Detailed answer, common mistakes and challenge