Back to Analyze Data to Answer Questions
Google

Analyze Data to Answer Questions

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.

Status: Data Analysis
Status: Data Compilation
BeginnerCourse26 hours

Featured reviews

SI

5.0Reviewed Apr 13, 2021

This course is very great for gaining hands-on experience with SQL, as well as instilling the critical thinking skills essential to the data analysis process. Definitely worth the pricetag.

MK

5.0Reviewed Nov 25, 2021

Phenomenal course and course instructor! You have made the complex SQL queries quite easy to understand and follow through. Great job!Notably, some of the video lessons had very low volumes.

MB

5.0Reviewed Jul 27, 2022

Excellent course for Learning SQL and important Data analytics, Course well structured for learning we have been provided most useful link to understand cocepts and become expertise in SQL

JC

5.0Reviewed Jan 7, 2023

The course is of high quality to teach students SQL and Spreadsheet coping skills. The hand-on activities can hone students' technical knowledge in a practical way. Thank you, Google team.

PB

5.0Reviewed Dec 24, 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.

ES

4.0Reviewed Jan 22, 2023

It was a bit harder than their other courses, however, I feel like not enough aid was given in order to grasp the concepts that well. It's still a solid Google course though so go ahead and take it

AO

5.0Reviewed Jun 26, 2024

I found this course the hardest within the Google Data Analytics certification. It was challenging, there was a lot of new information, I had to reflect and try new things a lot! Way to go!

IB

5.0Reviewed Mar 18, 2022

Great and thorough demonstration of how the data analysis process is completed through the implementation of different calculation functions in spreadhseets and SQL. Thanks for creating it.

JH

4.0Reviewed Jan 2, 2023

A great segment of the overall course. For a total beginner I learned a lot. Moves kind of quickly over some of the subjects but they are trying to cover a lot of ground in a short space of time.

JC

4.0Reviewed May 30, 2023

alot harder than the other courses but it was still goodsome of the data sets you have to work with is outdated or isnt there on Big query other tha that all was good i learnt alot and enjoyed myself

DV

5.0Reviewed Mar 7, 2025

I have been using spreadsheets for years but learnt a few new tricks which was great! Good introduction to SQL - however obviously very BigQuery focused - learnt a lot about SQL overall.

KH

5.0Reviewed Jul 25, 2022

I have really made a very important practice in this data analysis phase, and I believe that this practice coupled with my previous analysis skills would help me to get a new job.

All reviews

Showing: 20 of 2,307

2.0
Reviewed May 24, 2021
Mahmoud ElSheikh Issa
1.0
Reviewed May 30, 2021
Mohamed Adel Elfaiomy
2.0
Reviewed Apr 18, 2021
Yichen Pan
1.0
Reviewed May 22, 2021
Elzbieta Zdunek
1.0
Reviewed Aug 5, 2021
Ivelina Terziivanova
1.0
Reviewed May 7, 2021
Gyuyong “Q” Hwang
3.0
Reviewed Apr 3, 2021
Mariya Anderson
3.0
Reviewed Apr 29, 2021
Robert William Fitzgerald
2.0
Reviewed May 20, 2021
Apurv Gholap
3.0
Reviewed Apr 6, 2021
Renee E
3.0
Reviewed Mar 20, 2021
Sonu Kumar
1.0
Reviewed May 14, 2021
Xinyu Zhao (US - ADVS)
4.0
Reviewed Mar 25, 2021
Mohit Sharma
1.0
Reviewed Dec 18, 2021
Dona
2.0
Reviewed Jul 21, 2021
Elissa Hartfield
2.0
Reviewed May 2, 2021
Scott Heater
2.0
Reviewed May 5, 2021
Prinn Sriwat
1.0
Reviewed Apr 25, 2021
Ruy Núñez Pawlowsky
3.0
Reviewed Apr 27, 2021
Samantha Bracey
3.0
Reviewed Mar 31, 2021