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
14,958 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.

KK

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.

Filter by:

2501 - 2525 of 2,609 Reviews for Process Data from Dirty to Clean

By Joojo S

Apr 5, 2023

OK

By Daniel R

Jul 10, 2022

Dear teachers, These’re a couple of obstacles I found along the way: 1. In reference to the syntax symbols, I find it very difficult to know before hand when I have to introduce one between ‘___’   or “___”. Would you be clearer on that explanation? 2. Optional: upload the store transactions dataset to BigQuery: I could not cut and paste Step 11, for some reason (I tried several times). 3. Why must some functions be written in parentheses and some other not? DISTINCT, for example, doesn’t have parentheses, while CAST does. Could you please explain those basic concepts of the SQL syntax?

4. In one of the videos, “Documenting results and the cleaning process”, you jump from Pivot Tables and other spreadsheet features like Find and Replace, to Big Query without telling, which makes it difficult to follow along. I'm doing my best, but sometimes, especially in reference to the SQL syntax learning, I'm not achieving my goals, and feel very frustrated.

By Ali Y

Oct 29, 2022

This course is structured poorly. More reading materials are needed for SQL. Also, content and materials for inidviduals with no prior experience in progrmaing are necessary, because the right foundation is key for proper understanding and mastering of whatever is taught.

another consideration is the stagerred and overlapping topics among different courses is really confusing.

It is much better to make courses more especialized. For example, one for basics, one for spreadsheets, one for SQL, one for CV and findng the right job instead of talking a little about each topic in each course, which is really impractical and confusing if not provoking.

By Mac R

Feb 21, 2024

Overall, not too bad. It covers a lot of data cleaning principles, but BigQuery setup can be tedious, and there's some confusion about the free account descriptions. They also crank up the SQL learning curve at times from beginner to advanced, but I can see why they do it. SQL students returning to this form of work could breeze through it, but newer students may struggle a bit like I did. The principles discussed are all still very informative, interesting and important. So stay strong, dive in, absorb what you can.

By Jyotsana M

Aug 16, 2022

I wish they seprated the resume and job search topics from cleaning up data. they were drastically different but very useful and needed. I also wish there was a little more details about the differenece of not enough data and using little data. The final quiz questions were harder to answer because they seemed similar, but the outcomes were possibley different.

By todd f

Apr 11, 2022

I learned more from this course than the others. It was a good course and covered what I need to learn with lots of practice opportunities. So I liked it! While this course had the most important content of any so far, it was not well laid out. I flagged some lessons and gave feedback. You might get some feedback from people as they go through it.

Thanks!

By Anthony B

Jan 13, 2024

I learned everything I needed to know in this module in more from using Excel for fifteen minutes and watching one linkedin course. This module lacks in substance and material, and is missing a module test. I'm on module 4 of 6, which means two modules have been left completely untouched, and I've already been awarded the certificate for completion?

By MC G

Oct 20, 2021

There was a lot repeating and redundancy in the class. Also, several of the quizzes didn't test for relevant or important knowledge. They tested for items that never showed up in the class, showed up later in the class (and thus students could never have been expected to know that yet), or tested more about useless jargon than important concepts.

By Walter H I

Jul 15, 2022

this is a great course, i'm enjoying learning data analytics and hopefully the near future i'll be able to work as an entry level data analysis. i just with the course had real time experts to help students navigate some on the SQL probelems. that would be a benefit for us that aren't famaliar with data analytics, SQL, Kaggle etc.,

By Trent R

Jun 22, 2023

The course was well presented overall. However, there were a few places where I felt lost. Most of the SQL commands presented I could not run in the BigQuery Sandbox. After upgrading to a "trial account" I was able to perform the commands without issue. I think this should be mentioned in the videos.

By Aleksandra B

Feb 14, 2024

It's an OK course. I learned a few tricks in spreadsheets, and heard great tips from experts in the field. However, I didn't really enjoy setting up BigQuery account. It felt sometimes that the lecturer isn't using the same version, and just setting up an account wasn't so smooth.

By Angus G

Feb 6, 2022

Week 3, 'Transforming Data' first (Optional) exercise Reading: Upload the store transactions dataset into BigQuery.

This doesn't work. Error messages. Unable to parse data around Date and Time. Tried three times.

I suggest you fix the bug and adjust the material.

By MARIA A

Jul 8, 2021

The process data from dirty to clean was good but the last piece re going through the resume and interview process was wasteful for me. I've been working since I was 16 and just retired. Maybe that should be placed somewhere else and optional.

By Jakub Č

Jan 26, 2023

Week 3 was amazing - a lot of new skills in SQL. Everything else was completely useless - I have seen no point in going through tones of definitions and passed the test even without reading the materials.

By Umar M

Sep 26, 2023

I appreciate the positive gained by Google opportunities, but if the full package including the videos, will be granted to a learner, the course utility would have been better.

By Kristina M

Apr 21, 2024

I would have liked if this course utilized the side by side demo, I think that hands on experience but being guided through the process would have been a lot more helpful .

By Laura S G

Jan 28, 2023

SQL training needs to improve, a lot of the students do not have experience, and the free version of google is extremely limited, so it does not allow to properly learn.

By sujan m

Mar 10, 2024

Regarding SQL I found resources from another website straighter forward and easier to learn like with SQLite. And explanations are good but feels too much stretched

By Haris A

Sep 9, 2023

Very basic teaching, it was too much theory about stuff which doesn't make me better at my Job as a data analyst, should've been more hands-on on SQL spreadsheet

By Tim M

Nov 20, 2022

Some nice bits and pieces but the sections on CV writing distracted from the main focus of the course. Would be better as something completely separate.

By Cassandra P

Jun 15, 2023

The quizzes should be a more hands-on experience. More room for critical thinking and putting it into practice. Less about regurgitating terminology.

By Ivy

Dec 24, 2022

I would like to learn about the functions and tools of spreadsheets, SQL, and Tabulea. This course is a kind of introduction to the main concepts.

By B S

Sep 13, 2022

This course a was bit of waste of time as it dealth with the basic of resume, process atc which I think is not required from my point of view.

By Shubham M

Jun 27, 2021

Some hands-on exercises are inaccessible to the user. Had to write to google labs for every assignment dataset, which they sent me to my email.

By Scott H

Apr 29, 2021

This course contains a lot of information, however some of it is organized haphazardly making it difficult to follow