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

26 - 50 of 2,553 Reviews for Process Data from Dirty to Clean

By Sean B

•

Mar 30, 2021

The course was effective in providing an overview of the data cleaning process.

By Mohamed S

•

Nov 19, 2021

My course instructor Sally was really passionate and informative of this course. It motivated to work harder and made me more enthusiastic to indulge in this course even more.

Thank you Sally!

By Christian V

•

Jul 14, 2021

Some parts were a bit confusing. I kinda feel like I floated through the course. More hands on activities would be appreciated so I can get the feel of actually using some of the programs.

By L

•

Sep 17, 2021

Since Google supplies NO MEANS (or if it exists, it is extremely hard to find) way to give feedback in general about its program re certificates, I'm using this module to do that. The illustrations and especially animation used in ALL these courses are EMBARRASSINGly juvenile. By what criteria were these graphics selected? As a professional illustrator with an MFA and BFA from CalArts and 30+ years in animation for companies throughout the silicon valley, these are an embarrassment. Appendages are often completely out of proportion (and not purposefully - they are just produced by clearly someone who has zero actual skill in illustration), light sources in images are inconsistent, perspective is incorrect, and the animation is not even at the level of execution as beginning animation students in high school. Did you use ANY criteria here at all beyond maybe who someone is sleeping with or just what floated the decision maker's boat that afternoon? Is this program intended for people that are under 10 years old or is the program supposed to be for any age because if your target is adults as well as young adults, you need to either get rid of this infantile poorly done stuff or go back and use actual professional criteria in selecting illustrations AND HAVE A PURPOSE BEYOND DECORATION AND AMUSEMENT for them (go and maybe take your own UX courses to learn why we don't just throw in a cute illustration to make things... cuter...). Please grow up and climb out of the 'cuteness' gutter. It's bad enough that you only use your friends and lovers to do the Google doodles but this crap really is nauseating. Grow up. And hire professionals for professional work.

By Priyank

•

Jul 11, 2022

This whole google data analytics course covers very very basics of whole data analytics, I can safely say this course will only teach only 1% of what data analytics in reality is. So if you think after completing this course you know what data analytics is, you are completely wrong. This course just scratches the surface of data analytics. if you are really serious about learning data analytics this course is not for you.

By Nine

•

Aug 25, 2022

Sally 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!

By Olumide O

•

Jan 28, 2023

The course covers the topic of data cleaning, handling missing values, outliers and errors using SQL and spreadsheets, which are important skills for data analysis and working with real-world data.

By Daniel H

•

Sep 30, 2021

Agree with many of the comments made in other reviews. The instructor was clear and effectively used repetition and summation to clearly explain concepts and tasks. Sadly Sally was let down in this course by a poor mix of practical/theoretical confirmation activities. Knowledge/Skill confirmation tests did not effective test the learning outcomes to an appropriate standard. Several test activities created a simple SQL workspace but this functionality wasn't utilised effectively to consolidate and confirm learning objectives. Resume section was valuable, but completely out of place in this course.

By Venus B

•

Aug 17, 2021

Although I believe that we learn through repetition, I just find some of her lessons repetitive. It also seems a bit disorganized for some reason.

By Eser B

•

Jan 31, 2023

I would recommend instead of this much text more analytical course content would help solidify the learning. This was the only module that after I finished all new information was floating without any context or structure. Even with the existing questions in quiz (es) and content it was more like a science course where the teacher asks for a unique terminology to make sure you've memorized the whole syllabus. Please update this module asap so it is well outlined, with less text more example under categories. It may be with very good intentions too many topics were included but not enough interactive exercise were provided with either split screen, or video tutorials. Simplest suggestion, just split the course into 1-) Principles for Clean Data in Business Intelligence and 2-) Technical Skills to create clean data for Business Intelligence; or just divide it at least into 2 main parts as needed.

By wa

•

Jan 19, 2022

This is my least favorite course so far. It has a great introduction part about why data needs to be cleaned, but the instructions on how to use spreadsheet formulas and functions and SQL are lack of details. And the instructor does not explain well about why certain function is used for what purpose in the examples. I learnt more SQL syntax from a blog than what I learnt in this course. The course challenge are all multiple choice questions, no hand-on exercise, such as writing SQL statements or cleaning data in spreadsheets. I hope the course gets redesigned.

By Muhammad S

•

Jun 26, 2021

Hi

Thanks for the overall course on Data Analytics.

Process Course needs improvement as long videos were captures and instructor was in a rush, not explaining the topics in full and moving and jumping to next topic.

Thanks

By MONICA M D

•

Jan 10, 2022

Many video had problems uploading. Course instructor did not break down class instructions effectively. Crash coursed through a lot of info. Made it difficult to keep up with the course

By Mohammad M

•

Jul 8, 2023

If you want to be treated like a toddler, this is the place for it. No challenge whatsoever in their courses that it feels like a total waste of time. I could learn all the Excel tools discussed in this course from a 10 min YouTube video, and not just that, they explain them properly on YouTube. Let me give you an example. If you want to find blank entries and highlight them or get rid of them or whatever, they tell you to go sort your data and check where the blank entries are. A much easier way I found online is to highlight your table, go to "Find & Select" > "Go To Special" > Pick "Blank" > Now you can delete those rows with Ctrl + minus and pick rows, or you can highlight them, or or or.. And don't get me started on the SQL part, they give you the MOST BASIC COMMANDS EVER. You can't do anything exceptional with those. Challenge us with some assignments or tasks for god's sake.

By Taharia B

•

Nov 26, 2022

This course is frustrating. There are instances when I try to follow along with the instructor and do as she does and nothing happens. There's no one to reach out to for assistance when hitting roadblocks. In Week 2, there is a video where the instructor is completing different steps and does not explain what she's doing. She shows how to remove duplicates from Google Sheets and when I attempted to follow along there was no option for it. Also, in Week 2 there is a section to do a transposing exercise. And nothing happens when I followed it step by step as stated. This is extremely frustrating because I am paying to learn this material and cannot reach out to anyone to get assistance.

By Nick C

•

Apr 13, 2022

This has no practical use for actual SQL.

Let me explain. This presents basics of SQL which took me perhaps 15 minutes to learn. As others have noted, there are nowhere near enough hands-on tasks to practice. Further, none of the practiced SQL skills are of any value in the real world. This course did not teach how to, for example, join to tables, perform a calculation on some lines of one of the tables, enter that as a new column, and output only a selection from all three dependent on the value in a tertiary column.

I might mark the coursera charges as fraud after I get my certificate, becuase this course DID NOT teach SQL.

By Glenn F

•

Nov 23, 2021

I'm only rating this way because I can't rate the entire Google Data Analytics Professional Certificate. I just wasted 6 months on this course with the promise I could get a job in data analysis. Well, I can crush data analysis! But my lack of background in math is proving to make me unhirable. I wish I'd known this before wasting time and money on this program. Now I'm 6 months behind training for another career.

By Ahmet G

•

Nov 23, 2022

It was one of the most enjoyable courses for me. I will watch and do my own practice until I memorize the parts of the information in this course, especially those related to Data cleaning functions in BigQuery and Spreadsheet, over and over again. Also the most important part is the suggestions for creating a job search resume are great. You can feel that even the Instructors ( Sally and others )are with you. Thanks Coursera and Google.

By Abdelrhman M

•

Jun 5, 2021

The instructor was fantastic, her passion, her excitement, her easy way of delivering the information was great, she had done a great job, actually I got %100 in the five exams which is the first time, she might be the best instructor I had so far and not only for the Data analytics, if applicable thank her for me.

By dax

•

Apr 4, 2021

One question on the final asks for a function that all allows you to divide a text string around a specific character. The answer is SPLIT but that is not a function in Excel. To do this you would use text to columns in Excel. Maybe is works in Sheets but I didn't check.

By Alexander T M

•

Jun 4, 2021

I totally enjoyed this course. It was is very practical and applicable in my line of work. I am already using the learnings in my day job. The instructor was just great, I could not wait to see what she had to deliver next after each session.. .Great Job!!

By Alain M

•

May 25, 2021

All the courses were great but this one is the one I enjoyed the most by far. Sally is an amazing teacher and we can feel her passion and eagerness to share her knowledge, which makes us want to give very best of ourselves.

By Matthew B

•

Mar 25, 2021

The labs were more informative in this course than the earlier courses in the certification series. I appreciated being able to practice the skills that we were learning about a little bit more through them.

By Rosana S

•

Mar 28, 2021

Gratitude for learning about how to improve my resume. Loved data cleaning but never dreamed of hearing and reading the concepts about job search in such an empathetic way!

By Naman J

•

Mar 24, 2021

Each and every concept related to dirty data, Data integrity, Data Cleaning etc.. Are explained in a nice way with awesome analogies.... Loved it...