Chevron Left
Back to Analyze Data to Answer Questions

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

4.6
stars
11,194 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:

1801 - 1825 of 2,139 Reviews for Analyze Data to Answer Questions

By Farzin M

Jul 9, 2024

just a suggestion ... it would be better to create some static databases so that the instructions when following along with the instructor makes sense .. its hard to figure it all out when the instructor is saying commands and while they are proficient In using the coding lingos... I am a beginner and I believe we needed more exercises to understand the logic behind the coding and then to code accordingly... this is also difficult because when we make mistakes based on the exact code given ... we don't have any live people to whom we can talk to and clarify the mistakes we have made ... maybe this part of the course can be modified to include some live classes to clarify doubts or errors ...

By Robert M

Feb 3, 2022

Compared to the first 4 course of the certification, this one is much more technical and I thought that they didn't deliver it as well as they should have. First of all, the tutor is anywhere as pleasant as the other ones. Especially after the tutor from course 4. Her explanations are sometimes a bit off and she also makes a few mistakes, which are corrected via a pop-up message. Her SQL coding is a little bit "sloppy" and there is a lot of things that are "assumed" and should be explained better. I think it's absolutely necessary to take a complete SQL course from somewhere else if you are seriously planning to pursue a career in Data related jobs.

By Mark U

May 6, 2022

This course drops a little in quality compared to the previous ones. It seems it can use some quality control, as sometimes concepts are used before being introduced (e.g. GROUP BY), and some materials contain errors, or are not editable without tricks in Google Sheets.

As previous courses, this uses Google Sheets and BigQuery as practice environments and these work really well. The introduction is balanced and introduces a great number of tools to use in each environment. It doesn't go very deep though and leaves several central SQL concept unexplained. I would recommend some further training in SQL as addition to this course.

By Javan F

Aug 15, 2023

Following along with queries can be bit difficult in these lesson some of this issues need to be fixed so students are able to follow along and learn. Week 3 Count & Count Distinct does not seem to be the correct format when running the query there are spaces in the query I stayed on this video for 30 minutes trying to work this query but I was unable to I wish the instructor walked through the queries to make them more explainable or explain where there are spaces in the query when we were advised that there wouldn't be any spaces within a query. Its frustrating leaving an assignment unsure of how to run the query.

By Manas G

Sep 28, 2022

I personally am loving this course, and everything was perfect uptil this course. Everything was messy in this one like in one of the videos the subtitles didnt match the speaker, or for the first two weeks speaker's voice was really low, even when i wore headphones. but most of all, during the last 2 weeks, it seemed like a lot was trying to be fit in and concepts were not being taught, instead only links and urls were given and it was upto us to read and understand. the self reflection assignments were a hassle to deal with. i would've preferred a lot more hands on, easier step by step procedure for sql stuff

By Carmen R

May 4, 2022

This course could have been so rewarding by learning so many new and great things. I wasn't too happy with the instructor because she went over the SQL or spreadsheet functions way too fast. I believe that the instructors sometimes forget that we have little knowledge in an area which they have mastered. PLEASE slow down when explaining and sharing your knowledge with us. We really do want to learn as much as we can but we reach our limits often because the instructors are rushing through the courses. Other then that, I loved learning so many new things. Thank you for offering a course like this!!

By Mac R

Mar 11, 2024

Even with some familiarity with SQL and spreadsheets, Part 6 will challenge you to understand intermediate SQL syntax at strange intervals, then rubberband back to more simple forms of it. There are also queries that don't function with the wildcard "*." the way they're supposed to, nor are there many reminders as to what that is. They talk about it maybe once. This is more of a BigQuery issue, and not a general SQL syntax issue. The lessons are harder at this point, but overall the repetition is there, it will leave you with PLENTY of learned material to grow from. It's just difficult at times.

By Nathan W

Jul 6, 2021

I learned a lot in this course, but the primary presenter was not a very good teacher of the material, even though she clearly knows the subjects very well. She introduced a lot of concepts, but in some cases, she overexplained simple concepts that had already been covered in previous courses within this certificate program, while in other cases she suddenly began to use more complex queries without any explanation.

I do think that the quizzes and assignments had fewer overall issues with questions that didn't make sense or were ambiguous, but some of those issues were still present throughout.

By Hung N

Sep 13, 2024

This course is rather disappointing. There are errors all over. The spreadsheet sections are generally pretty good. However, the SQL part requires much more work to be a good learning experience. It seemed like whoever made this course rushed the SQL section. This is highly disappointing because this is, after all, the ANALYZE course of the certificate series, which is, well, pretty important. I would recommend taking this course more as an 'overarching view' of what analysis of data involves, especially through the Google Sheets sections, than really trying to learn the SQL part of it.

By Erica B

Sep 26, 2023

Hands-on activity through BigQuery had many mistakes in the code, which required troubleshooting. I eventually figured out how to fix it, but since these activities were meant to introduce how to use new commands it made it difficult. I also think some readings/activities were out of order. I would do an activity where I was stumbling through how to use JOIN, TEMP TABLES, or a pivot table, then after the activity there would be a reading that clearly explained the format of the commands. Having the reading first would have helped.

By Tanichea B

Jul 8, 2022

The instructor needed to go a lot slower. Were it not for the fact that I'm already quite familiar with SQL I would be lost. There should also be a little more instruction for excel. Not everyone uses Google Sheets and the functionality can be wildly different at times, making the translation over in assignments difficult.

Also the instructions for doing certains in Big Query need to be updated. Seems like there was a different way to do things before and the documentaion was never updated. Not very intuitive.

By Safia S

Nov 2, 2022

Some are very repetitive and I got really bored. I have a background in Computer science so much of this knowledge overlaps but I still found myself getting off track even though I love SQL. I wish there were more "challenging" interactive questions like some other practice websites in order to really understand the concepts instead of multiple choice. I know its a beginner course, but if I was a beginner I think I would benefit from trying to solve harder queries and data validation/conditioning exercises.

By Winslow J

Feb 13, 2023

Of the 5 certificates from this series I've completed so far, I found this one to be the most difficult to follow and least information-rich. I think those two observations might be related.

To be clear, I did not find the concepts difficult, and when I engaged outside resources to fortify my learning I got through the tests just fine. What was different from the previous 4 certificates in the series was how much information I had to go and find on my own vs. what was clearly presented.

By Raymond C C

Oct 19, 2022

Based on comparison to the four completed, I would rate this the lowest and least effective. Pace at times was much too fast and the instructor even stated that some of the content is advanced...? Not sure why that content was included, but recommend editing the content and pace. On the other hand, if the quick pace was needed to cover all of the material, then recommend, editing early courses to remove some of the redundant material to "buy" time for this course.

By A F

Nov 27, 2021

I think this is a good course but I feel this course is set for people that have previous knowledge with spreadsheets and SQL already because there is not enough repetition on the material to be able to remember all the functions that can be done within spreadsheets and SQL. There is suppose to be a way to go back and redo any courses or materials that you previously learned, yet I have not found a way to go back to any courses or material that I have already completed.

By niloofar r

Jul 29, 2021

This course was so effective with a huge amount of data and new knowledge. Thank yo so much to give me this opportunity to learn them. However, I would like to inform you that some parts like "subqueries" and "join" which are really complicated did not have sufficient explanation and I was confused. Thus I try to use other source to understand these concept. I would like to suggest to focus on this course and add more lesson and practice. Thank you so much again

By Fadhl

Nov 7, 2022

The overall content of the course is good. However, the structure of the course isn't as good, in many places there were repeated topics and topics that should have been explained earlier in the course. In addition in a few instances in the videos, the SQL code wasn't correct. After repeatedly checking the code, I find the correct code in the other forums. This section is by far the was the only course in the series where I rated the course so low.

By Deyvis M

Apr 27, 2024

This is more a criticism of the guided quizzes where you practice, text was difficult to read and distracting because too much was going on. The instructor in the videos was great. I didn't enjoy downloading and then uploading data from coursera onto my laptop then uploading again onto BigQuery. After two times it was tedious. One of the practice SQL code actually did not work in BigQuery despite a literal copy/pate which was frustrating.

By Kartik

Oct 18, 2022

The course covered most of the aspects related to analyzing data. But the course could have been better if it focused more upon elaborating the postioning and usage of different functions, it felt like the course left out the "WHY" part of SQL functions and commands which will eventually confuse beginners a lot. Videos lacked the elaborative part in the course which will slow down the learning process for a beginner.

By Tony D

Oct 17, 2022

This course has provided many good information. However, those good information are surface information.

Instead of repetiting same information in many chapters, i think it is best teching deeper into analyzing data with trends, critical think with data, and predict trends. Most analyzing features or approachs in here are basic and does not give newbie any outlier from other newbie who does not take this course.

By Abdullah N H

Sep 1, 2021

This part of the course focused on items previously discussed unnecessarily such as formulas and functions of Excel and sometimes took really fast pace when new things were being discussed like subqueries in SQL. Should be adjusted.

Furthermore, any content or part for easier transition to Kaggle should be made. Right now whenever I enter Kaggle, I feel overwhelmed and too novice to enter anything.

By Deanna M

May 14, 2023

Although I

enjoyed the class, the instructor was not thorough when it came to SQL. If This course is truly for beginners, then more time should be spent Detailing What all she is doing.

Some of the statements Used in the queries had not ever been introduced during the course so it was confusing. Her spreadsheet Teachings were

awesome, but the SQL teachings, not so much.

Overall not a bad course.

By Marija R

Apr 17, 2022

SQL practise is far too oriented towards technical details and complicated data sets instead of putting practise first. The steps are given up front, often the query came back with a strange error even though I followed every single step The advanced part of sql went by particularly quickly and I personally found it difficult to understand joins and temporary tables. The videos are old fashioned

By Cassius J

May 24, 2022

While I am learning a lot, it has becoming increasely more difficult to participate and learn effectively because everything related to spreadsheets in Google Sheets, I get it...It's a Google Certification. However, everyone and every organization doesn't use Sheets. Also some of the issues wit BigQuery is getting annoying and again difficult to participate when you can't find a dataset.

By Kwstantina P

Oct 16, 2021

I think that in this course about analyzing data they will should add some statistic methods about analyzing. If you go for a job for analysts you must know statistics not only sum and average. They tell you that you learn how to indentify patterns but it is a lie. These simple things that we taught isnt about finding interesting things in data it is only descriptive statistics for kids