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,973 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:

2201 - 2225 of 2,611 Reviews for Process Data from Dirty to Clean

By Gerald H

•

Apr 15, 2022

N

By Natsag

•

Mar 31, 2022

5

By Pedro P V

•

Mar 10, 2022

.

By Piotr N

•

Jan 27, 2022

!

By Hamdy E

•

Jan 22, 2022

r

By Mohamed L

•

Nov 27, 2021

g

By Shubham S

•

Oct 16, 2021

E

By Kumaaravelu T

•

Aug 10, 2021

m

By Md. S I

•

Jul 12, 2021

By SHIJIE Z

•

May 3, 2021

y

By Richard C

•

Jun 17, 2022

I really like the course overall. The instructor is great. I love the videos and I think that they are some of the highest quality that I have ever seen on Coursera.

My criticism has to do with the quizzes. I honestly found the quizzes to be ridiculously nitpicky to the point of being almost funny. I'd watch around an hour of videos for a week, read everything, and then I'd have issues with certain mulitiple choice questions. Sometimes for the mutiple choice questions that require a single answer, I think at least two of the options are arguably acceptable, but only one is correct. It gets goofy when the questions overly emphasize definitions of non-technical terms which are stipulatively defined in the videos and then we get quizzed on extremely precise aspects of those definitions. In general, this makes the quizzes a lot harder than they need to be, but in a way that is artificial and doesn't really do anything to help us learn. You could learn this material, be able to do the SQL queries and data cleaning in spreadsheets easily, and then still have an issue with the quizzes. That ends up making a great course into a really frustrating experience.

By Sherry R

•

Nov 14, 2023

While this is all fascinating, I feel it went by very quickly and that I didn't get enough practice with all the SQL and even spreadsheet functions. I am not confident that I really know all this and will definitely need to review a lot of the videos, probably make flashcards, review the glossary, etc. It's kind of cumbersome, with the templates and stuff, to follow along with the videos while the instructor is talking. This is something that either needs to be viewed more than once (although of course some people learn faster than others, and some come into it with experience others don't have), or needs extra time studying on one's own. I really love it, don't get me wrong, but I don't want to rush myself and then realize I don't really understand, know, and remember everything. So, what I'm saying is, be prepared to spend more time on this section than the previous ones.

By lisa h

•

Aug 31, 2021

It was my understanding that you could accomplish the course of data analyst without any background in this field and I do not find this to be true. There have been many times that I have had to venture out on my own to gain understanding of what is being taught to me and how to complete some of the assignments. This is a great course for someone that has some understanding of spreadsheets to start with. I do recommend this course and and enjoying the challenges in front of me. When I have received my certificate I will truly know how hard I worked to achieve it.

ADDENDUM: Apparently this course is over and I have earned my certificate. I feel like there is so much more for me to learn and I did keep hearing the instructors say there is more that we will get to ... but where and when? There isn't even anything directing me to more courses.

By Anna B

•

Aug 9, 2021

Each course improves upon the last. I am enjoying this certificate. Thank you.

Here are some ideas that I think may add value to the course:

2. Since this course is about cleaning data, I feel providing a dataset to clean would be more valuable as a final course challenge than a multiple choice quiz. It would provide practice, encourage starting to make independent cleaning decisions and be a valuable learning too.

3. My next point is best made with a description. In the Hands On Activity, Week3, we are directed what to do. However, I do not know, for instance, when to decide to use the SELECT DISTINCT statement or the SELECT MIN/MAX statement. Activities like this have been really valuable and I think they would benefit if students could understand more about what to do rather than following instructions.

By Natalie W

•

Jul 24, 2022

I work in post-secondary (college) where resumes and job search skills are a required part of our programs. I wasn’t expecting to learn these skills in this certificate! Although I found the information invaluable, the placement within this course bogged…..me….. down. My mind just wasn’t ready for it yet. I found it difficult to speculate what my new skillset would be mid-way through the certificate. It will be much easier to complete a new resume once I have completed the certificate and have all the information at the time. I feel it would be best delivered as an optional part of the certificate at the end when my mind and my attention can focus on completing my resume, and begin to look for new employment in the data analytics industry. Having said this, data cleaning is what I enjoyed the most so far!

By Mattia P

•

Sep 22, 2023

Pretty good course, like the previous ones. I like the hands on approach. Even though it never gives you a feeling of having covered everything in a topic, and no theoretical boxes where to put new information, it's very stimulating and I can say I learned a lot. Now for some criticism: The first two weeks were hard. New terms were not very well defined, and the structure of the lectures wasn't clear. They felt redundant and blurry. More than once I felt like lectures or assignments assumed I knew something thant hadn't been covered. In later weeks, I have the feeling that we were not prepared to answer some of the questions, most frequently because the wording of the questions were different than the wording in the lectures. I wish I didn't need a free trial version of BigQuery.

By Maksim N

•

Mar 18, 2022

This is where things got a bit more complex. From the very first video I felt like I cannot speed up the videos anymore, and I have to pay closer attention. But after I got into it, it got easier and easier. The instructor is very genuine and charismatic. Despite the increased complexity however, after you get a hold of SQL, it feels a bit basic.

After using one or two functions all the rest follow the same pattern. I would have enjoyed more direct practice of SQL. Maybe a dataset that we could practice on with tons of simple function excersises. After finishing this course I feel like I am more than half-way done, considering that the last course is a project, and the penultimate one is focused on programming.

By Shantanu K

•

Aug 22, 2023

I feel that learning what the error codes mean has been so useful to me in any programming language in order to identify why the code is not working. If the issue is not solved after some attempts, Stack Overflow, GitHub or similar webpages may show the solution to your problems, or at least give you some ideas of how to try to solve them. It's also very important to keep calm and pay attention to all details, because a simple comma can be the cause of all your problems (like in the SELECT argument when you want to use more than one column and you miss the comma between them). Practice and have fun!

By Ronald D

•

Aug 19, 2023

I would have liked more explanation of how not to screw up the database. The BigQuery version that I had did not allow UPDATE etc. What is the danger of that. Also, when or should you ever use DELETE. Perhaps this will be covered in coming modules but how can I know? I am a programmer and need to know if I am destroying something.

I also feel that database creation using Microsoft Access would have been very instructive. It would provide the visualization needed to make the SQL teachings more complete. Also, one can practice with Access as they use another type of SQL, mySQL?.

By Gadi S S

•

Mar 4, 2023

Content-wise there are 1 or 2 issues which hardly matters because of the over-all quality of the teaching and guidance, this was a bit of a 'hard' course and i believe i had few hiccups over few topics and there is definite need to improve the sampling size calculator, i have found it hard to understand the confidence level, confidence interval & margin of error, although i can understand the basic concept i needed to understand the difference between margin of error high and low percentages & so on, little confused.

I Wholeheartedly Thank All The Tutors.

By Katty A

•

Dec 19, 2022

I like data cleaning, I feel was able to get into the data analyst roll. I learned a lot new skills and functions which will be useful for the future. I Didn't like the fact that I encountered few obstacles. For example, in the hang on activities and on a quiz. The LENGHT function was not recognized by the exercise even though the query was well perform. I also found trouble in SQL as well. I would say the biggest problem is when you get stuck in a exercise sometimes the forums no solution. Basically there is no one available to ask for assistance.

By Md. H

•

Jun 25, 2021

Clean data is essential for flawless data analysis. So, cleaning a dataset before analysis is one of the most important considerations. This course is designed to give basic idea of cleaning process. It has vague information about SQL data cleaning process and some terminologies. If anyone who is new at SQL will get some hard time dealing with it. It is understandable that there are some limitations to improve the content of SQL in this course. But it could be better. The instructor was great. Her method to interact was amiable.

By David K

•

Jan 30, 2023

This was a good course, and I learned a lot. The instructor was great and definitely someone I enjoyed learning from. I really wish there would have been more useable examples for practice with SQL functions. Also, each time we used BigQuery I was very lost. The examples and instructions do not match the current BigQuery platform. Each time there were instructions of how to use BigQuery the instructions were not correct. It made it very frustrating which made it hard for me to focus on the functions and learn them very well.

By Alberto J S M

•

May 15, 2023

In the weeks for SQL teaching, I would prefer hat the time use to explain this topic were more focus on general SQL Knowledge like why are the syntax just like they are. for example why we start with select? I have a little understanding of SQL but I compare this course with the one I did in W3 and the last one is better structured. They start from the most basic. Of course this is a good learning course but to be Google I feel there are some improvements to consider with SQL lessons.

By Chinenye A

•

Feb 14, 2023

Sally Did an excellent job. For me, she is essentially the only instructor whose speech has been very clear Yet. I totlally enjoyed her jovial nature too as it kept me engaged when I was almost losing interest.

It got a bit overwhelming at some point but it was expected. Now that I am done, I am happy to have learned quite some useful tips to help me on my Data Analytics Journey. More skills to my toolkit and also for my career advancements. Onto the next one!