Chevron Left
Back to Analyze Data to Answer Questions

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

4.6
stars
10,310 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:

76 - 100 of 2,012 Reviews for Analyze Data to Answer Questions

By Senaka S

Apr 4, 2021

I love love love all of the new SQL and spreadsheet functions I've learned. I am really excited to use this skills to making an impact in my future projects.

By Siddikur M

Jul 4, 2021

The course was awesome .I feel very happy when i work through spreadsheet calculation and SQL calculation .Wants to thank my Instructor and also google.

By Aakash B

Apr 26, 2021

Slightly difficult for a person like me, who does not have any prior knowledge about SQL and databases. But still nice experience.

By Bertrand M K

Aug 18, 2021

Great course and great introduction to the technical side of data analytics.

By SHAIKH S A

Nov 25, 2021

instructor wasn't as good as previous course

By Shafraz K

May 23, 2021

amazing course and instructor!

By ELETU K O

Mar 6, 2023

One of the video instructions on using SQL to create a temp table gave me a tough time to debug and run until I carried out an online search for the answer. The instruction omitted a line of instruction. I wish this can be looked into and created. Below is the syntax of the omission and correction.

WITH   

longest_used_bike AS (    

SELECT      bikeid,      

SUM(duration_minutes) AS trip_duration   

 FROM     

 bigquery-public-data.austin_bikeshare.bikeshare_trips    

GROUP BY     

 bikeid    

ORDER BY     

 trip_duration DESC    

LIMIT 1  

)

SELECT  

trips.start_station_id,  

COUNT(*) AS trip_ct

FROM  longest_used_bike AS longest  

INNER JOIN   

 bigquery-public-data.austin_bikeshare.bikeshare_trips AS trips  

ON longest.bikeid = trips.bikeid

**WHERE  

trips.start_station_id IS NOT NULL**

GROUP BY  trips.start_station_id

ORDER BY  trip_ct

 DESC

LIMIT 1;

The missing line is having double asterisks at the beginning and closing **^**

By Annelissa T

Dec 11, 2023

This section covers a LOT of information at a pretty rapid pace. Unfortunately, some of the practice datasets have been updated since the videos were made, so be ready to look in the discussions for answers to how things are supposed to work when they don't. This is also a section where you'll probably want to do a lot of independent study. This is really the nitty gritty of SQL and it's no joke. But if you stick with it, and are dedicated to figuring things out when they don't work the first, second, or sometimes third time, you'll get through it.

By John G

Apr 19, 2021

I wish I could give it 4.5 stars. The content got more advanced, but the pace is still reasonable. Sometimes there are stupid questions on the quizzes and even some wrong formulations. I liked the organization (for the most part) and most of the practice. However, sometimes you still don't need to think enough and can copy/paste in too many places. I believe the instructor is knowledgeable, but so far is the driest of them all. Nevertheless, I learned a lot.

By Gu R

Aug 28, 2021

This course was more difficult to follow compared to the other courses (especially some of sql queries). I have previous sql knowledge but i feel like the instructor was doing a lot of complex examples for doing a query for the first time. I think a more step by step approach and building the query would have been easier. I have realized that I will need to take an additional course on SQL bc some of the concepts in this module i did not follow.

By Tarek K

Jan 2, 2022

The course is amazing, it is rich in important topics and material. It is very interesting for how much practical exercises and hands-on activities it comprises. Learning has been a lot at this level. But in the sections Work with sub-queries / Queries within queries, and Using sub-queries to aggregate data, more elaboration and visual explanation was required to understand the complex concept of nested queries and data aggregation

By Ince A

May 17, 2021

This course was critical to the entire certification; unfortunately, it was plagued with errors, particularly in the videos. In two of the tests I had to select the WRONG answer in order to get scored correctly. The access to the weekly Glossary was not working, and two of the Qwiklabs were horrible. FYI... (A/B*100) is not the same as (A/B)*100.

By Anna M

Jun 3, 2021

I appreciate the many follow along exercises in this course. However, given how much this step is featured within Analytics, I felt fours did not give us ample time to practice the many functions. An additional week where we could practice such functions as Temp Tables and JOINS would be time well spent for the students.

By ARDA H

May 1, 2021

There could be more use cases on analyzing and identifying the trends. I learnt the necessary tools now, but don't feel prepared enough to identify the trends. Lecturers always mention "let data tell the story". But we did not focus on analyzing the data to transform insights. Hope we will do so on part 7.

By navjeet d

Jan 7, 2022

4 ratings because I loved the new knowledge in excel and SQL. Not 5 because I thought the SQL part was bit fast for me and took time to understand compared to other course lessons. The subquery part was bit confusing at first for which I had to do some research. Overall I'm happy to learn something new.

By Suzanne F

May 24, 2021

Lots of valuable information but as I only had basic understanding of SQL coming into this course, it didn't really improve my confidence level in using it. I had to purchase a SQL course from another vendor that was much more helpful in improving my understanding of the why, what and the how.

By Elaine L

Oct 23, 2021

This was the hardest course for me. There were times when it was difficult to follow the instructor because she was going to fast on her explanation and typing SQL series so quick when I thought this program is supposed to be for beginners or those who doesn't have analytics background.

By Drashya P

Apr 29, 2021

not a lot of details about sql even some videos required some more information

and all the files require permission to open so no files for any exercise

By PAVAN K

May 14, 2021

It hasn't been as descriptive and as consistent as the previous courses were and faced very minute trouble catching up with the instructor at times.

By Daniel H

Oct 7, 2021

This course provides a solid introduction to intermediate spreadsheet and basic SQL skills. The instructor is clearly a skilled user of these tools and communicates most concepts and techniques clearly. Occasionally the instructor while demonstrating a taught technique will use unexplained shortcuts in supporting code. This makes replication as a novice more difficult. Supporting information such as https://www.w3schools.com/sql/sql_count_avg_sum.asp is recommended for students to allow less frustration navigating BigQuery. Discussion forums are full of students needing help with SQL syntax, case sensitive error, etc. Responses are understandably slow and an ineffective way of addressing the students need. This course has some sequencing issues where concepts/techniques required are taught after being required to complete an earlier activity. The course should make use of the intracourse SQL functionality more frequently and in graduated complexity before introducing the use of BigQuery. The gates, tested material is too simple to ensure that students have acquired pre-requisite skills before introducing subsequent material.

By Norman C L

Oct 7, 2021

I think the course materials are excellent and relevant, but it didn't do a good job explaining some important concepts, specifically the Subqueries in SQL. Not only did the course fail to explain the relevance and the motivation to initiate subquery, the pace of how different lines do and interact with the core main query way too fast. In addition the time needed to debug the queries to make it work quadrupled at least. How different commands interact (Count/Group By) is also not adequately explained. Going forward, I think it would be more important to use visualization to explain the different parts of the Queries and how they interact, together to form a complex query on SQL. In the final quiz, the spreadsheet had a bug that prevents SORT function to function properly, with regards to sometime about circular and such. Overall it is a challenging course compare to the previous ones, and I hope they could make it much more clearer when doing these type of analysis.

By NG, S L

Jul 11, 2021

The whole specialisation so far (courses 1-5) is just talking without doing. Hands-on experience/practice is really crucial for us to learn and debug our programs. Although labs are provided, it is mostly copy and paste without further explanation. Comparing this to "Managing Big Data with MySQL" by Duke University, the latter has more training to hone our SQL skills and learn through practice. I would not have understood the queries if it weren't for my previous encounter with SQL in another course. Also, the learning curve is gradual in the latter, while Google's goes from 0 to 100 quickly. Last but not least, I think Google should have separate courses dedicated to joins and subqueries respectively. Subqueries are complicated man, give us exercises instead of just links to external sources!

By Akshay U H

May 9, 2021

The evaluations are still quite lenient as in other courses in the specialization but the subject material stepped up to some level of complexity in working with data. I faced a lot of issues with accessing the Google subject material since I received Access Denied messages when I tried to access them. Further, some public datasets referenced in the course material is already unavailable in Google Public Datasets. I expected some statistical methods and tools to be taught as well, but there is none of that here. It is just learning to organize data in SQL and Excel and then making some basic calculations to answer basic questions.

By Lumi C

Jul 19, 2023

Much of the instructional content failed to explain reasons and theories for why we were doing certain queries or functions. There were many times where it felt like I was merely copying a query or set of instructions with no real explanation as to why I was doing so. This was especially prevalent in the videos on using SQL. Mostly silent videos of typing a query with brand new clauses with no further explanation really damages motivation and made me lose my momentum in this course. Definitely could've been executed better in my opinion.

By Christine E

Jun 7, 2023

Not enough time spent on practicing each commonly used SQL clause, SQL syntax, spreadsheet functions, function syntax. These important items are the bulk of tasks in data validation, this course goes through them far too quickly. Slow it down and offer better cheat sheets with commonly used clauses, rather than referring students to W3 Schools site. That takes way too much time, students more likely to quit the course or delay completion due to the time this takes to search and view W3 Schools tutorials.