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

BeginnerCourse16 hours

Featured reviews

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

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

VC

5.0Reviewed Nov 8, 2021

Probably one of the more technical courses of the program developing your technical skill set and actually preparing you to become a data analyst by introducing more hands-on Excel and SQL exercises.

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..

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!

NN

5.0Reviewed Aug 25, 2022

S​ally is the best instructor of Google data analystics courses so far. Others are also good too. But I really love Sally's teaching way. She is so clear,knowledgable, and passionate. Geat course!

PL

5.0Reviewed Jul 19, 2023

I learned a lot from this course. The instructor is very enthusiastic and teaches in a very clear way. You'll get hooked in the topics, which are discussed very detailed, clear, and comprehensive.

KA

5.0Reviewed May 17, 2021

Sally was a wonderful instructor. Her enthusiasm for data analysis was apparent and helped to keep me motivated in continuing on in my journey. Her videos were very clear and easy to understand.

NO

5.0Reviewed Aug 15, 2021

A wonderful learning experience with great instructors, easy to understand illustrations and presentations, relevant quizzes to keep you engaged, and most of all aboundant resources for practice.

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.

AS

5.0Reviewed Jul 17, 2023

Great course for the beginner! Only thing that I wanna see in this course in the next edition, if there is any, is the a bit more practice content. Overall great content with legendary tutors.