Chevron Left
Back to Prepare Data for Exploration

Learner Reviews & Feedback for Prepare Data for Exploration by Google

4.8
stars
20,922 ratings

About the Course

This is the third course in the Google Data Analytics Certificate. As you continue to build on your understanding of the topics from the first two courses, you’ll be introduced to new topics that will help you gain practical data analytics skills. You’ll learn how to use tools like spreadsheets and SQL to extract and make use of the right data for your objectives, and how to organize and protect your data. 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: - Find out how analysts decide what data to collect for analysis. - Learn about structured and unstructured data, data types, and data formats. - Discover how to identify different types of bias in data to help ensure data credibility. - Explore how analysts use spreadsheets and SQL within databases and data sets. - Examine open data and the relationship between, and importance of, data ethics and data privacy. - Gain an understanding of how to access databases and extract, filter, and sort the data they contain. - Learn best practices for organizing data and keeping it secure....

Top reviews

DD

Jul 4, 2021

Thank you for the course! It's a nice introduction to SQL and Google Big Query as well as the concepts of data privacy and security. The course also offers some great tips for professional networking.

RA

Aug 10, 2022

The lessons were easy to follow through and the explanantions were easy to understand. The hands-on practices also helped improve hands-on skills with the data analysis tools introduced in this course

Filter by:

2601 - 2625 of 3,268 Reviews for Prepare Data for Exploration

By Dennis T

•

Nov 16, 2022

Information packed course and loved the introduction of BigQuery and how to use it to look for and use publicly available data for testing as well as allowing us to upload our own data. I particularly liked the virtual machine setup for a guided hands-on use of BigQuery. I felt though that we didn't cover enough about spreadsheets or the SQL language itself (as a professional who has been using these tools it wasn't really much of a problem) but on the other hand, that's also part of the drive in learning something new by using other online resources to learn more advanced Spreadsheet functions and capabilities as well as learn intermediate SQL skills. Love the pace, love the content.

By Kirk M

•

Nov 26, 2022

Overall, I liked this course. I learned quite a bit in a short amount of time, and I worked hard to complete Course 3. I felt that the information I learned was relevant, and easy to retain. My only constructive criticism would be that some of the Hands On learning for week 3 be broken in to smaller separate segments so that it does not become overwhelming. This is the only part of the course I really struggled at first, and I had some trouble identifying with some of the examples. Other than this concern, two thumbs up--great instructor? My instructor made me want to learn more. She was thorough, and spoke clearly. I would like to have heard more about her origin story.

By Victor D

•

Aug 30, 2021

I can understand people who are complaining about this course, which is kind of similar to the previous ones. But I like this one better because it introduces some (actually) useful insight about professional social media and connections. The stuff about SQL (BigQuery) was nice too, just not very complex. It seems to me that things go a bit backwards in these courses. They try to motivate you about professional fields and often ask you to imagine what you would do in certain situations as if you were already getting a job anytime soon, when we still know nothing about real or "tough" data analysis. But well, maybe in the next courses the fun stuff finally appears.

By Jennifer M

•

Oct 8, 2021

Again, this course is a good introduction and overview of preparing data for processing. For those with zero experience, it is a great introduction. If you have previous coding experience, the BigQuery / SQL exercises will be pretty easy. My biggest criticism from this course is that there are no explanations on proper coding syntax/the why of how we code. If you've used R or SAS, coding in BigQuery is very similar. But I kept thinking to myself, if I had no coding prior coding experience to rely on, these exercises would be confusing and difficult. For example, there are no explanations of the DISTINCT, COUNT, or DESC functions and why/how they are used.

By Mattia P

•

Sep 16, 2023

Quite well done, like the previous courses. In this one, you get the sense that this is a learn as you go through the process kid of course. Which works well for me, even though I'm not used to it. I'd appriciate, evey once in a while, a document listing all spreadsheets functions and all SQL commands learned so far, similarly as what is done for vocabulary.

At the beginning of lectures about SQL use in BigQuery, lectures seemed to assume we had a grasp of BigQuery, and that we are more familiar with SQL than we are actually supposed to be thanks to previouse course. In subsequent lectures, the order of lectures seemed a bit off too.

By Rose C

•

Aug 3, 2023

Love every course I have taken so far with google coursera. It hits all learning aspects whether it be someone who learns visually, listening, or physically with try it yourself walk throughs and that's what I love the most. I am someone who has to do all three to be able to grasp something.

The only reason I did not add the 5th star to this course is that with the guided work doing the SQL and the data sets websites the screen has never looked similar to the instructor's so it is extremely hard to follow along let alone understand what I am suppose to be doing since nothing really matches up anymore.

By Lumi C

•

Jun 26, 2023

Great content and good focus on the 2nd phase of data analysis, but week 3 was FAR too long and drawn-out only to be followed by two extremely short weeks of content. The unbalance made the learning process very demotivating, not to mention how there was little to no implementation of discussion forums or learning logs, which made the learning feel very disconnected and "nitty-gritty," which is necessary of course but seems to have been overdone a little here. Overall a great and necessary course that unfortunately suffers from a poorly executed structure.

By Lea H

•

Dec 12, 2023

I learned a lot in this course as it covers a lot. This is where the learning curve gets steep. Some parts of the course was confusing to follow along due to changes to UI. However, the course did a good job by going step by step to more easily digest the info especially since this is the first time looking at most of the material in this course. The course provided many resources available online such as mentorship, it's really good to know. Kaggle could have been explained better for beginners though.

By Alexander

•

Aug 31, 2022

I really wish it was more practical. I mean, if we were given a task to solve and then the tools were introduced to ensure the solution of that task, some parts of the course would be more meaningful. In the current version, i struggled a bit to seee the value in working with the bigquery tables, such as for lightning strikes. However, the funny surprise was that such dataset in fact exists at all))) If we were offered to work with datasets relevant to a practical task, i believe, it would make more sense.

By Nihad I

•

Dec 1, 2021

Definitely better than second module. Speaker speaks much cleaner; you feel that this stuff will be needed for you in future and also optional part is actually in optional part. You will learn basics of SQL and how to sort/filter in spreadsheets, really starts of Big Query. Get useful ideas and advices for your future. I did not put 5 stars only because it felt like there could be more additional material on SQL and more deep dig into the preparing of data

By Norbert D

•

May 30, 2023

Overall, it was good.

However, it would've been helpful if they had a video on SQL syntax - a disclaimer and best practices. I got stuck on a line where the issue was using a back tick instead of a single quote. I wasted an hour on this until I figured it out. The way I figured out was googling the issue!..LOL. I know as DAs troubleshooting is part of the game, but still a quick video would've been helpful ( maybe it was there, but I forgot about it).

By Joe S

•

Aug 22, 2022

Thank you for a well-structured, well-instructed course that was clear about what we were to accomplish. The SQL and spreadsheet work was very helpful and useful. The discussions on data sources and tools was super--these are resources I could not have found on my own. I'm giving four stars becuase I think the level of instruction is a little too elementary. Perhaps a more get-to-the-point script would save some time? Again, thanks very much.

By J C

•

Jul 20, 2022

While the "Ask" course mostly covered softskills and general office behaviour this one is way more specific. You learn how to use BigQuery and set up datasets, table and import open source data. The you go on with real SQL queries. The videos about that are realy quick so you have to pause and rewind often. Also the interface of BigQuery changed a bit since they were recorded so you have to search for some functions but it still works completely.

By Jeannette U

•

Feb 1, 2022

Happy that we are finally getting to the "work" of the data analytics piece. All an all this was pretty easy to follow along with. Would like more hands-on examples and that the data provided in the end of course review is used in the questions. It also would be nice to know when something should be followed along with, and when we should be trying to get accounts and/or access to do what the instructor is doing at the same time.

By Tran T M H

•

May 8, 2022

This course is awesome. I like the way they lead me step by step over the process of preparing the data for analysis . I also love how they guide me on how to create a good networking which really benefits for me to land my job as a data analyst. However, I think the multiple-choice questions are just too easy, I hope it will be more challenge so the course takers would spend more time to reflection on.

By chelsea t

•

May 5, 2022

This course definitely ramps up when you get to week 3 compared to all of the work before it. It is super informative the only reason I am not giving it 5 stars is because when working in SQL the program has us use BigQuery but the reading and videos dont tell you that BigQuery has some coding differences from SQL and they dont tell you that until after you have frustratingly found this out on your own.

By Deleted A

•

May 4, 2022

Course three was getting into the meat and potatoes of the coursework. I was not altogether enamoured with the focus on BigQuery. I am sure there are other websites. But OK. BigQuery is a counter-intuitive site and very difficult to use and understand. I am good at wading through new programs, and this one was hard for me. Also, some of the test questions are coded with the wrong answers marked correct.

By Kathy M

•

Mar 22, 2022

Pretty good overall. There was one or two sections that seem to throw me off. It was the two sections regarding writing code and it was difficult to remember the correct syntax. I also found the intro to Kaggle a little intimidating. I also feel that the screen shots and directions on using Google BigQuery need to be updated. I couldn't find some of the commands during the exercises.

By Tyler C

•

Jun 16, 2023

A little misleading in it's modules. In module 3 I think you are learning about types of data, so simple terminology, and then all of a sudden at the end of the module you get hit with multiple long segments involving BigQuery. While I appreciate being taught BigQuery it would be nice if the module was title BigQuery or SQL so that the user knows this is going to be a bit more involved.

By Diana C

•

May 14, 2021

I enjoyed this course, there was less self-reflection as well. The bias part was truly interesting. I did feel that Kaggle was pushed very much on me and it seemed too advanced. I enjoyed the SQL bit but it was just a bit and I look forward for more. I'm looking to gain practical skills since I am already working for 15+ years but I do see the value in the other topics taught.

By Afdhal I Y

•

Sep 21, 2022

I have learned a lot during this course as well. I rate it slightly lower than the first two because there were some places where the dataset we're supposed to use for the activity were no longer available. I believe this is an oversight that could have been overcome by using datasets that does belong to Google, or at least one that will never be taken off BigQuery.

By sepideh m

•

Nov 11, 2024

i believe it was a good course but only problem was with module three, it takes more than usual expected time so it was tiring but beside that i believe it almost everything. i hope in future course i could learn and practice with SQL. plus i hope at the end of each course there would be more practice either with BigQuery or kaggle. thanks for proving this course.

By Sheri S

•

Nov 3, 2023

Some of the places that require you to go to other sites is difficult to follow if not on dual screens an also as it does not match up I know sites change but for the purpose of following along it can be difficult I figured it put but what about the person that doe not . Also love the presentors curls but it was distracting they are cute just all over the place.

By Philip R

•

Aug 6, 2022

I think this course definitely helps you out a lot when it comes to entering the field. There's a lot of sites that I've never heard of nor interacted with, so I appreciate the information when it comes to finding data sets to operate on and also collaborate with. I only detract a star from this one because some of the pacing early on in the course feels slow.

By Mohamed F

•

Jun 18, 2023

from my point of view:

First note:

Please add some translations to the video clips to facilitate studying and spread the course among many countries.

Second note:

Also with regard to video clips; We ask to improve the color of the font, because the caliph is white and the font used in writing is blue, which makes the contrast low and strains the eyes.