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:

2776 - 2800 of 2,909 Reviews for Process Data from Dirty to Clean

By T. B

Mar 23, 2022

good

By Siddharth N

Oct 7, 2021

good

By Ivana S

May 23, 2022

...

By KARAN G

Aug 3, 2024

gh

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 samuel c

Oct 26, 2024

several practical exercices don't actually bring the expected results. I struggled more with using bigquery than i spent time actually learning SQL. I think the most troublesome part was creating tables (creating datasets was not a problem) : there was always a problem and it took me a long time to solve most of it (it's kind of okay now). I'll probably have to find more information somewhere else to catch up. The teacher is good and so is the pace but the practice is not as efficient as the one I had with the spreadsheets. I may also add that it would be great in the future to allow Coursera students to get access to some functions in the sandbox like updating or deleting in SQL, just so we get a chance to try it. To summarize : good teacher, good content but BigQuery is definitely not as user-friendly as R.

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 Mohamed E

Oct 2, 2024

After reviewing various resume best practices, I found that highlighting quantifiable achievements is key to making a resume stand out. For example, instead of just listing tasks, emphasizing how those tasks led to measurable improvements or outcomes can provide clear evidence of your impact. This can include numbers like increased efficiency, revenue growth, or improved customer satisfaction. For instance, instead of saying "Managed data analysis," I would say "Managed data analysis that led to a 20% reduction in reporting time."

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 Motlalepula M

Nov 1, 2024

The course on the whole was good but I'm concerned about SQL. I don't feel confident that I learned what was necessary to equip me with the necessary SQL skills.