Chevron Left
Back to Analyze Data to Answer Questions

Learner Reviews & Feedback for Analyze Data to Answer Questions by Google

4.6
stars
10,454 ratings

About the Course

This is the fifth course in the Google Data Analytics Certificate. In this course, you’ll explore what it means to actually analyze your data. You’ll take what you’ve learned up to this point and apply it to make sense of the data you’ve collected. You’ll learn how to organize and format your data using spreadsheets and SQL to help you look at and think about your data in different ways. You’ll also find out how to perform complex calculations with your data to address business objectives. You’ll learn how to use formulas, functions, and SQL queries as you conduct your analysis. 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: - Learn how to organize data for analysis. - Understand the processes for formatting and adjusting data. - Explore how to aggregate data in spreadsheets and by using SQL. - Use formulas and functions in spreadsheets to make data calculations. - Learn how to complete calculations using SQL queries....

Top reviews

PB

Dec 23, 2022

Very good and useful practice of SQL. The JOIN party is pretty hardcore so I definitely couldn't master it but got enough of an understanding where I could learn quickly with some on the job training.

TK

Jan 6, 2022

An excellent course for learning analysis techniques using Spreadsheets and SQL. Recommended for all engineering and data science students as well as for those managing businesses and human resource.

Filter by:

1401 - 1425 of 2,029 Reviews for Analyze Data to Answer Questions

By Rebecca K

Feb 19, 2022

This was by far the most difficult module out of the 5 courses I've completed so far....there's a lot of information and new formulas to digest. Quite challenging but totally worth it! I like that the activities set up are walk throughs/ guided formulas to help practice. However, many complex formulas are first sprang on you in a video and then explained much later, so it did feel a bit confusing at times. Would have been great if there were introductions first to these difficult formulas, then working through threm. Otherwise, I have gained so much knowledge. Totally worth it! My brain cells have definitely expanded!

By Arturo

Sep 30, 2023

The instructor is very professional and has a deep knowledge of the matter. The operations which can be done on the data are shown for spreadsheets and SQL in a coherent manner, which helps to reinforce what has been learned. It will improve the course to show some schematics of the different tables within an SQL dataset, particularly for the sections where nested queries and joins are discussed. It will help to understand better what the code lines in SQL do rather than just displaying the output of the code in BigQuery.

By Sukrit P

Jul 5, 2023

The preparation of the big query was kind of a headache and some tool to show which function works only on BigQuery and not on other tools would be helpful. Also, the other way around like it was said in the Temp table where SELECT INTO does not work in big query. I was using MySQL for some task and FULL JOIN does not work there so you have to do a right and left join with a very weird method which could have been mentioned in the video. Overall the instruction and activities are well done.

By Scotty O

Apr 12, 2022

I enjoyed the course but not as much as previous ones. There was a bit of a disconnect between the material being taught and that being tested (taught material was signifiantly harder than the tests). Also, some of the classes could have been scaffolded better with a bit more guidance particularly around nested queries and temporary tables. I only managed to understand this part of the course because I had already completed a Udacity course on SQL. A complete beginner would've been lost.

By Kay S

Jun 19, 2023

This is the most technical part of the data analytics course certificate, for me. it was really tough and challenging for me to grasp all the technical terms and functions. The facilitator did her best to break it down. The downside I had with it is the audio volume, it was low/ poor in most of the lessons, and I had to strain to hear. she was a bit too fast while showing the practical examples on a spreadsheet or SQL. Apart from these two issues, I enjoyed her teaching. Thank you.

By Kurtis D M

Jan 3, 2023

Content is good, but very fast in places. I had to watch a few of the SQL focused videos several times and pause them repeatedly, especially during Week 3. I am a quick typist and have some experience in SQL, so the fact that it was challenging for me suggests that the target audience will have even more trouble with this. Overall, this has been very good and helpful, but it is the least well-constructed part of the Google Data Analytics certification I've encountered so far.

By Kylee E

Sep 30, 2023

It was a very informative course. however the hands-on activities towards the end were broken or not very helpful in gaining extra knowledge on a subject because it wasn't clear how to get the results they were asking for. The course videos took forever to get through due to their not being elaboration into the information. I had to spend at least an hour per video and play with the systems to learn the concepts though i still am not fully confident i get it fully still

By Tony D

Nov 14, 2022

i so much enjoyed this class. i need to brush up on my Database SQL skills, is one area i know i am really lacking behind. however the lecturer was pretty amazing with a step by step details. but next time when explaining SQL kindly take everyone as an armature because not everyone understand the language and you are too fast. with that said every other thing she touched was beautiful and amazing. thank you for this amazing opportunity.

By Soraya R M

May 22, 2023

I think this is a really good course to keep building knowledge and gaining practice with functions with spreadsheets and SQL following on from the previous courses in the certificate, and, in this sense, I think it is brilliant and a challenge to me. However, I also think that, in terms of analysis, there could have been a few more introductory concepts that will be required in the future like basic statistical analysis.

By Robert H

Aug 16, 2021

This course was well organized and provided loads of great tutorials on using tools for spreadsheets and for SQL. It was a great introductory course for data analysis. My only qualm is that it would make more sense to me to integrate the course project into this stage of the course. It makes much more sense to practice skills for the analysis phase of your final project while we are learning the tools for that analysis.

By Md.Burhanul I

Oct 16, 2023

There are a multitude of things that are not right about this course. That is mainly because of constant updates. I learned a lot of SQL and tried my best to do every one of the SQL tests and training exercises but there are few, even if you try and follow their steps completely you won't get your results. I googled and learned from others on the internet which to tell you the truth the course instructor said herself.

By Mel A

May 18, 2022

Instructor was extremely knowledgable and the course was fairly easy to follow. I had some SQL knowledge prior to the course and found that I still learned quite a bit about SQL through the teachings. I also appreciated that the spreadsheet concepts and resources provided were related to Excel as well as Google Sheets. A few of the quiz and assignment questions were a little convoluted but overall a well done course.

By Michael F

May 7, 2022

Overall, I thought the course was good but I wish we spent more time discussing the more complicated SQL queries. I feel like building up strong SQL skills are really important for a data analyst and when we got to the more complex queries it was more like "here's the code, copy it and use it" rather than slowing down and really explaining what needed to be done to accomplish this complex query.

By YAMUNA J D

Mar 10, 2022

Course conductor teaching and her knowledge was commendable. But the course teaches with google sheet, assisgnment, tests that need to be completed for the course, guided instructions are all in google sheet, if you are learning from excel, corresponding instruction are not given, student has to find on their own. So much time spent on finding the corresponding options was very frusterating

By Holden C

Jul 11, 2022

Content was great and comprehensible , what seemed disappointing to me was that the material was not challenging enough and did not require intensive thinking, many exercises or even the course challenge just hinted the solutions to me, I felt like more learning can be done if I actually practiced solving issues and writing my own code instead of copy and pasting given code on the exercises.

By Dennis T

Dec 7, 2022

Had a great time going through the material though it's pretty much like a review for me as I've been using Spreadsheets and SQL/RDBMS. On the other hand, it's great to refresh and have a better understanding of the analysis phase, and continued data validation processes. I'm primarily taking this whole certification program to earn the Google Professional Certificate as a Data Analyst.

By Moutaz E

May 2, 2022

The course focuses on clauses and statements in SQL, it gives you the concepts to write queries and pull the data you need from your dataset. Some queries were complicated and not explained well by the instructor, however the course gives you the online resources you need to develop your skills.

It also gives you an idea about the required and most common used functions in spreadsheet.

By Rashida C

Jan 4, 2023

Overall, it was a great course to learn the basics of SQL queries and spreadsheets, I feel like this course was a bit rushed a bit challenging for a beginner, however who said this was not going to be a challenge. There were allot of resources provided to help with SQL, but I will definitely need to take a supplementary course to make sure I got the full understanding and grasp of SQL.

By Amelia S

Jul 7, 2022

I found this course a bit more repetitive than the earlier courses in this sequence. On the whole, that may have been a good thing as I got in a bit more practice. However, it also seemed less well-put-together, like it could have used another round of copy editing. There were just a bunch of things that should have been expressed more clearly. On the whole, though, it was pretty good.

By Shady S

Apr 26, 2024

The course is very good with a lot of practice exercises, but it doesn't present the actual concept of analysis in depth. On the other hand, it mainly focuses on the analysis tools like spreadsheets and SQL which is absolutely great, but the course is needed to be a bit longer to elaborate all the needed concepts of analysis with some practice examples that help deepen them.

By Pavel H

Dec 30, 2021

The best course in the whole series, BY FAR. Finally some lecturer with deep knowledge willing to share it, with not-so-easy examples. She is even too fast in some cases, especially when typing the database+table names while joining tables etc. This is how the course should look like consistently, instead of presentation tips, emailing etiquette and empty phrases about bias.

By Bre R

Nov 2, 2021

The worst of it was that the SQL questions on the Weekly Challenges and Practice Quizzes gave me the wrong results which led me to get the answer wrong multiple times! I even had a friend who is currently a Data Analyst and C++ Programmer look at it and she said that the function wasn't working and she got the answer wrong as well!

All in all, Ayranna was a great teacher!

By Nathan D

Jan 21, 2022

I think that this was the first course where I learned something new about both SQL and excel. The program is very slow and up to this point I don't think that I have gotten much out of it. Still doing it though becuase I feel like the certification will be worth it. I think that there should be an accelorated course for those who are more advanced.

By Donna M

Jan 31, 2024

I thought this was the best course in the series so far. I would urge content creators to go over the tests to make sure they are accurate. The next thing I will look for are drills that I can do to practice joins, subqueries, calculations and working with temp tables. If that were part of this course of a separate course--that would be great.

By Sarthak T

Oct 12, 2021

The course material was good for a beginner like me but my rating aren't 5/5 is because the instructor was good but their way of teaching, personally seemed kind of bland or dull only comparing to the 4 courses already covered in this course. Otherwise the materials and teaching are good. If there was an option to give 4.5 stars I would.