Back to Process Data from Dirty to Clean
Google

Process Data from Dirty to Clean

This is the fourth course in the Google Data Analytics Certificate. In this course, you’ll continue to build your understanding of data analytics and the concepts and tools that data analysts use in their work. You’ll learn how to check and clean your data using spreadsheets and SQL, as well as how to verify and report your data cleaning results. Current Google data analysts will continue to instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources. Learners who complete this certificate program will be equipped to apply for introductory-level jobs as data analysts. No previous experience is necessary. By the end of this course, learners will: - Check for data integrity. - Apply data cleaning techniques using spreadsheets. - Develop basic SQL queries for use on databases. - Use basic SQL functions to clean and transform data. - Verify the results of cleaning data. - Write an effective data cleaning report

Status: Analytics
Status: Data Quality
BeginnerCourse16 hours

Featured reviews

RH

5.0Reviewed Oct 27, 2023

Fun, concise, and on point course walking new folks through (or a great review for not so new folks) the process of identification, basic change management, and reporting for dataset validation

AM

5.0Reviewed Jul 7, 2025

Great way of teaching, her lectures were outstaning and engaging, understood each and every concepts very clearly. Thank you Google and Coursera team for making us to interact with such personality...

OO

5.0Reviewed Oct 26, 2021

Good content overall. However it will be nice to have the glossary for each week not mixed up with those from previous as it makes it hard to navigate and know which new words need to be learnt

RK

4.0Reviewed Nov 5, 2022

Sally is the best instructor in this course so far. The content itself started of great but I feel it didn't cover enough data cleaning techniques in the second half of the course. Still recommend!

HA

4.0Reviewed Sep 22, 2025

I think this is the most important course in the Google Data Analytics course series. It has equipped me with practical skills for making data reliable for analysis and data-driven decision-making..

HB

5.0Reviewed Jan 1, 2022

Loved the way Sally presented this course. Always refreshing to learn from Sally throughout. I wish Google continue their amazing work with such expressive tutors who can connect with learners.

VR

5.0Reviewed Apr 24, 2021

Google makes great professional certifications. All the classes so far have been fantastic but getting our hands dirty with the data was fun and challenging. Look forward to completing this series.

YS

5.0Reviewed Jan 11, 2023

I love Sally, I can tell she is passionate about what she is teaching. I really hope I will take more class with her. And I like this course as it talks a lot of knowledge about data analysis.

KK

5.0Reviewed Feb 13, 2022

Every concept they explained crystal clearly and thoroughly. I am so happy that I am learning all these courses at free of cost. As soon as I get data analytics job, I will pay the fees without fail.

LR

5.0Reviewed Sep 14, 2024

The info is well worth it whether you are a novice user or experienced, whether you are going into data analytics or not. The style of teaching and learning continues to be very impressive at Google!

OO

5.0Reviewed Jan 27, 2023

The course covers the topic of data cleaning, handling missing values, outliers and errors using SQL and spreadsheets, which are important skills for data analysis and working with real-world data.

AN

5.0Reviewed Oct 15, 2022

T​he istructor was really cheerful and the classes were pleasant. The lessons were clear and easy to follow. The hand on projects really helped in concreting the knowledge gained from the classes.