4.2.Sparkling clean data - sj50179/Google-Data-Analytics-Professional-Certificate GitHub Wiki

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.

Learning Objectives

• 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 in spreadsheets
• Weekly challenge 2