Every data analyst wants clean data to work with when performing an analysis. In this part of the course, you’ll learn the difference between clean and dirty data. You’ll also explore data-cleaning techniques using spreadsheets and other tools.

• Differentiate between clean and dirty data
• Explain the characteristics of dirty data
• Describe data cleaning techniques with reference to identifying errors, redundancy, compatibility, and continuous monitoring
• Identify common pitfalls when cleaning data
• Demonstrate an understanding of the use of spreadsheets to clean data

Data cleaning is a must

Begin cleaning data

Cleaning data with SQL