Chevron Left
Back to Process Data from Dirty to Clean

Learner Reviews & Feedback for Process Data from Dirty to Clean by Google

4.8
stars
17,033 ratings

About the Course

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

Top reviews

LT

Jul 9, 2023

I'm glad I took this course. The instructor is warm, upbeat and very clear. The materials are very informative and helpful. I gained more understanding of cleaning data as well as built my SQL skills.

VC

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.

Filter by:

2476 - 2500 of 2,908 Reviews for Process Data from Dirty to Clean

By A H

•

Mar 19, 2022

A lot of information here, but very approachable, even for a beginner. I think the supplemental section related to resume-building and job prep is nice too, especially to refer back to later. Generally speaking, this was put together well, though I would have liked more optional practice exercises with the SQL concepts.

By Sadiq M

•

Sep 4, 2022

Everything was perfectly explain by the instructor except that the practical aspect needed more examples and explanation for especially people changing career path. But all the same, the instructor was vintage and her mere presence radiated expecially her smile and disposition. Was a great experience by all standards.

By Kresna A

•

Nov 22, 2022

Case example on cleaning data wasnt good enough for me. They assume we already know where the errors are, but how to clean data when we dont know the error yet?

example :

"assume you know there is a duplicate on customer id"

but how if I dont know that there is a duplicate on customer id? how can I find it by myself ?

By Kassie C

•

Apr 27, 2021

This is a pretty extensive course. I am already familiar with Excel, but I found that section particularly useful. I like the way the SQL QwikLabs are organized with the repetition of commands. Unfortunately, not all of the commands work (UPDATE and DELETE). The big picture with the stored data is also a mystery.

By Kaustubh K

•

Feb 14, 2022

This 4th course helped me in introducing to open datasets and how to use them for data analytics, as a ML student, understanding and learning sheets made me realise how easily data can be cleaned rather than using python of the same task. The introduction the SQL was not that great though, it was pretty basic

By Mattia B

•

Nov 15, 2021

The SQL part may be organized better. I get that the technicalities are not taken as in other standard courses, but I feel like it's too dispersive. Some section was called "data cleaning with SQL" and there was literally no trace at all about data cleaning with SQL.

The section about the CV is simply GREAT.

By Susan E H

•

Jun 12, 2021

Great course in learning how to clean data on spreadsheets and datasets. I now have a good feel on how to approach data cleaning, documentation, and verification. My only suggestion is that during the online cleaning spreadsheet exercise you give a few more examples in Excel in addition to Google Sheets.

By Àdèyém̄í K

•

Apr 24, 2022

The course is engaging and if you are new to Spreadsheet and SQL, the presentation of the course will demystify it all. Sally is wonderful and she handled the course with mastery.

Ah, least I forget, are you looking to pivot, in this course it will prepare you for the job market, so no fears.

By Kunle B

•

Oct 24, 2022

It was simply incredible with the hands-on approach and real life applicability of the topics covered. My data cleaning skills were greatly enhanced. The course not only opened my eyes to defects in my Resume, it also instilled in me the abillity to rectify them and upgrade my Resume.

By Mark F

•

Dec 26, 2021

I found it quite good at walking through the steps and some helpful commands to use while cleaning data. It was also useful to see some common pitfalls that occur when processing data. I would have liked more real-world datasets to see just how messy data can be!

By Heli B

•

Jun 23, 2021

Course content is very informative

I am not able to practice the BigQuery part for QuickLabs as it is showing no permission warning.

Though i have started it for free it is not allowing me to create dataset hence i could not practice properly.

Please help.

By Hung N

•

Sep 12, 2024

This course is not superb as the line is blurred somewhat between the 'prepare' and 'process' steps, especially given we have gone this far into the series and probably want to really focus on the break down of the steps. But still is a good course.

By Keneilwe-Khumo M

•

Mar 20, 2024

Very educational and insightful. I've gained an understanding of what a jnr data analyst does to express intergrity and where they fit in an organization or a project. Pity about the repeated errors in the FROM statements in the query exercises.

By Jonathan B

•

Jan 9, 2022

Good SQL skills, a little too much fluff though, but that may just be because I already have resume experience. Also, I feel like course challenge should be a little harder. But, good next step in continuing to get the certificate overall! 4/5.

By GUERCY R

•

Oct 15, 2024

L'une des premières étapes cruciales de tout projet d'analyse de données est le traitement des données brutes. Les données brutes, souvent appelées « ventes », sont rarement prêtes à être analysées sans passer par un processus de nettoyage.

By Pradip S

•

Feb 18, 2023

This is an ideal course to learn the basics about data handling and cleaning. It provides hands on practice on a few of the topics and a base for further exploration. Overall, a great learning adventure to data science enthusiast.

By David S

•

Aug 12, 2021

The material is good, but there were some frustrating technical glitches. The Google Sheets didn't match the UI for some of the data processing in the video and some of the quizzes didn't load all of the details for the questions.

By Luis M

•

Feb 17, 2023

Good overall. I'd like a deeper or more technical view of the statistical concepts for data testing, or maybe some more practical hands-on problems in which you are required to calculate those to provide the correct answer.

By Rochelle S

•

Jul 8, 2023

Overall I loved how enthusiastic the instructor was and her humor as well. There were a few sections I did not quite understand and had to do some outside research for but overall it was easy to follow and understand.

By Jessica R

•

May 1, 2022

I found the instructor personable, enthusiastic, and a clear communicator. Topics were presented in a logical manner, and at a great pace. I wish there was more SQL instruction, but I'm grateful for the career advice.

By Fitrianingrum

•

Aug 7, 2021

Some content can be explained in a bit more detail. For example, there's an explanation that SQL can track changes, but how?? Also, it would be best if some of the multiple questions can be checked again for accuracy.

By Antoine S

•

Jul 15, 2023

Le contenu concernant le language SQL est intéressant, mais les partie telle que les CV et le recrutement sont de trop. C'est très long pour des notions qui pourraient être condensées avec du contenu plus court.

By Deleted A

•

Nov 16, 2022

There were few spreadsheets' tools definition with no explanation of How does this formulas or functions work in order to perform a task or activity, would help a lot same for SQL, how does these software works?

By Alfredo C

•

May 12, 2023

A hands-on approach with various technical features, mainly regarding spreadsheets and sql. Interesting exercises with guides, its just unfortunate that mentors seldom answer questions effectively in the forum.

By Grace Z

•

Oct 16, 2021

I learned a lot, but I think it would be better if you made the quizzes/ course challenges more practical. Instead of asking what the learner should do in a particular scenario, make the learner actually do it.