Analyze Data to Answer Questions

This course is part of Google Data Analytics Professional Certificate

Instructor: Google Career Certificates

Top Instructor

Access provided by New York State Department of Labor

680,407 already enrolled

4 modules

Gain insight into a topic and learn the fundamentals.

4.6

(11,740 reviews)

Beginner level

Recommended experience

Flexible schedule

Approx. 26 hours

Learn at your own pace

96%

Most learners liked this course

4 modules

Gain insight into a topic and learn the fundamentals.

4.6

(11,740 reviews)

Beginner level

Recommended experience

Flexible schedule

Approx. 26 hours

Learn at your own pace

96%

Most learners liked this course

What you'll learn

Discuss the importance of organizing your data before analysis by using sorts and filters.
Convert and format data.
Apply the use of functions and syntax to create SQL queries to combine data from multiple database tables.
Describe the use of functions to conduct basic calculations on data in spreadsheets.

Skills you'll gain

Data Analysis

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

4 quizzes, 26 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about 糖心vlog官网观看 for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your Data Analysis expertise

This course is part of the Google Data Analytics Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from Google

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 4 modules in this course

This is the fifth course in the Google Data Analytics Certificate. In this course, you鈥檒l explore what it means to actually analyze your data. You鈥檒l take what you鈥檝e learned up to this point and apply it to make sense of the data you鈥檝e collected. You鈥檒l 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鈥檒l also find out how to perform complex calculations with your data to address business objectives. You鈥檒l 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.

Organizing data makes the data easier to use in your analysis. In this part of the course, you鈥檒l learn the importance of organizing your data through sorting and filtering. You鈥檒l explore these processes in both spreadsheets and SQL as you continue to prepare your data.

What's included

9 videos13 readings1 quiz5 assignments1 plugin

9 videosTotal 37 minutes

Introduction to getting organized3 minutesPreview module
The analysis process4 minutes
Ayanna: Sticking with it1 minute
Always a need to organize 2 minutes
Filter data with SQL5 minutes
Sort data in spreadsheets4 minutes
Use the SORT function in spreadsheets5 minutes
Emma: Journey to a meaningful career2 minutes
Sort data with SQL7 minutes

13 readingsTotal 70 minutes

Course 5 overview: Set your expectations8 minutes
Helpful resources and tips4 minutes
Sort and filter data to keep it organized8 minutes
Review: Set up your BigQuery account8 minutes
Review: Get started with BigQuery4 minutes
Working with .csv files4 minutes
Upload the movie dataset to BigQuery4 minutes
Step-by-Step: Filter data with SQL4 minutes
Step-by-step: Sort datasets in spreadsheets4 minutes
Step-by-step: Use the SORT function in spreadsheets4 minutes
Sort and filter in Sheets and Excel8 minutes
Step-by-Step: Sort data with SQL8 minutes
Glossary terms from module 12 minutes

1 quizTotal 60 minutes

Hands-On Activity: Analyze weather data in BigQuery60 minutes

5 assignmentsTotal 124 minutes

Module 1 challenge40 minutes
Test your knowledge on organizing data for analysis8 minutes
Test your knowledge on sorting data in spreadsheets 8 minutes
Hands-On Activity: SQL sorting queries60 minutes
Test your knowledge on sorting data with SQL 8 minutes

1 pluginTotal 10 minutes

Refresher: Your Google Data Analytics Certificate roadmap10 minutes

As you move closer to analyzing your data, you鈥檒l want to have it formatted and ready to go. In this part of the course, you鈥檒l learn all about converting and formatting data, including how SQL queries can help you combine data. You鈥檒l also find out the value of feedback and support from your colleagues and how it can lead to learnings that you can apply to your work.

What's included

10 videos9 readings5 assignments1 plugin

10 videosTotal 39 minutes

Get started with data formatting 1 minutePreview module
From one type to another 5 minutes
Data validation3 minutes
Conditional formatting 4 minutes
Merge text strings to gain insights4 minutes
Strings in spreadsheets 3 minutes
When you get stuck3 minutes
Layla: All about the analyze stage3 minutes
Running into challenges? Not to worry!6 minutes
When to use which tool3 minutes

9 readingsTotal 58 minutes

Step-by-Step: From one type to another8 minutes
Convert data in spreadsheets 8 minutes
Transform data with SQL4 minutes
Import and combine data in spreadsheets and databases8 minutes
Step-by-Step: Merge text strings to gain insights8 minutes
Step-by-Step: Strings in spreadsheets 8 minutes
Manipulate strings with SQL4 minutes
Advanced spreadsheet tips and tricks8 minutes
Glossary terms from module 22 minutes

5 assignmentsTotal 136 minutes

Module 2 challenge40 minutes
Test your knowledge on converting and formatting data8 minutes
Hands-On Activity: Combine multiple pieces of data60 minutes
Test your knowledge on combining multiple datasets 8 minutes
Self-Reflection: Stack Overflow 20 minutes

1 pluginTotal 10 minutes

SQL query syntax10 minutes

As part of your analysis, you鈥檒l often have to combine data in order to gain insights and complete business objectives. In this part of the course, you鈥檒l explore the functions, procedures, and syntax involved in combining, or aggregating, data. You鈥檒l learn how to do this from multiple cells in spreadsheets and from multiple database tables using SQL queries.

What's included

8 videos10 readings2 quizzes7 assignments1 plugin

8 videosTotal 40 minutes

Aggregate data for analysis 3 minutesPreview module
Prepare for VLOOKUP4 minutes
VLOOKUP in action3 minutes
Identify and fix common VLOOKUP errors 5 minutes
Explore how JOINs work 7 minutes
Queries within queries6 minutes
Use subqueries to aggregate data 7 minutes
Justin: Where data analysis takes you 2 minutes

10 readingsTotal 74 minutes

VLOOKUP Core Concepts 8 minutes
Upload the employee dataset to BigQuery8 minutes
Step-by-Step: Explore how JOINs work8 minutes
Secret identities: The importance of aliases8 minutes
Use JOINs effectively 8 minutes
Upload the warehouse dataset to BigQuery8 minutes
Step-by-Step: Queries within queries8 minutes
Step-by-Step: Use subqueries to aggregate data8 minutes
SQL functions and subqueries: A functional friendship8 minutes
Glossary terms from module 32 minutes

2 quizzesTotal 120 minutes

Hands-On Activity: Use subqueries to refine data60 minutes
Hands-on activity: Use subqueries60 minutes

7 assignmentsTotal 244 minutes

Module 3 challenge40 minutes
Hands-On Activity: Use VLOOKUP to perform a task60 minutes
Test your knowledge on VLOOKUP8 minutes
Hands-On Activity: Queries for JOINS60 minutes
Hands-On Activity: COUNT and COUNT DISTINCT60 minutes
Test your knowledge on using JOINS to aggregate data 8 minutes
Test your knowledge on working with subqueries 8 minutes

1 pluginTotal 10 minutes

Review subqueries10 minutes

Calculations are a common task for data analysts. In this part of the course, you鈥檒l explore formulas, functions, and pivot tables in spreadsheets and queries in SQL, all of which will help with your calculations. You鈥檒l also learn about the benefits of using SQL to manage temporary tables.

What's included

13 videos13 readings1 quiz9 assignments1 plugin

13 videosTotal 69 minutes

Data calculations 2 minutesPreview module
Common calculation formulas 9 minutes
Functions and conditions8 minutes
Composite functions 5 minutes
Start working with pivot tables 7 minutes
Pivot tables continued5 minutes
Queries and calculations4 minutes
Embed simple calculations with SQL6 minutes
Calculations with other statements 4 minutes
Check and recheck4 minutes
Temporary tables6 minutes
Multiple table variations3 minutes
Congratulations! Course wrap-up1 minute

13 readingsTotal 80 minutes

Functions with multiple conditions8 minutes
Elements of a pivot table4 minutes
Use pivot tables in analysis 8 minutes
Upload the avocado dataset to BigQuery8 minutes
Step-by-Step: Embed simple calculations with SQL8 minutes
Types of data validation4 minutes
Work with temporary tables 8 minutes
Your intermediate guide to SQL 8 minutes
Use Connected Sheets with BigQuery8 minutes
Glossary terms from module 44 minutes
Reflect and connect with peers4 minutes
Course 5 glossary4 minutes
Coming up next...4 minutes

1 quizTotal 60 minutes

Hands-On Activity: Create temporary tables 60 minutes

9 assignmentsTotal 312 minutes

Module 4 challenge 40 minutes
Hands-On Activity: Work with conditions60 minutes
Test your knowledge on data calculations 8 minutes
Hands-On Activity: Explore movie data with pivot tables60 minutes
Test your knowledge on pivot tables 8 minutes
Hands-On Activity: Calculations with SQL 60 minutes
Test your knowledge on SQL calculations 8 minutes
Hands-On Activity: From spreadsheets to BigQuery60 minutes
Test your knowledge on using SQL with temporary tables 8 minutes

1 pluginTotal 10 minutes

Start validating10 minutes

Instructor

Instructor ratings

4.5 (3,430 ratings)

Top Instructor

Google Career Certificates

Google

326 Courses12,345,222 learners

Offered by

Google

Why people choose 糖心vlog官网观看 for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, 糖心vlog官网观看 is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. 糖心vlog官网观看 allows me to learn without limits."

Learner reviews

4.6

11,740 reviews

5 stars
74.54%
4 stars
16.51%
3 stars
5.24%
2 stars
2.10%
1 star
1.59%

Showing 3 of 11740

Reviewed on Jan 23, 2022

This course needs time to take in information - some of the materials are very technical, but can be mastered with the right amount of practice. Highly relevant content for data analytics!

Reviewed on Dec 26, 2021

subquery examples were unnecessarily complex. ultimate course design and deliverables were up to the mark no doubt. more detail and easy to understand technical examples would be much appreciated.

Reviewed on 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.

View more reviews