What background is required?

No prior experience with spreadsheets or data analytics is required. All you need is high-school level math and a curiosity about how things work.

What tools and platforms are taught in the curriculum?

You'll learn to use analysis tools and platforms such as spreadsheets (Google Sheets or Microsoft Excel), SQL, presentation tools (Powerpoint or Google Slides), Tableau, Python, and Kaggle.

Which “spreadsheet” platform is being taught?

Learners can self-select which platform they want to use throughout the program: Google Sheets or Microsoft Excel. It’s up to the learner’s preference, and all activities throughout the syllabus can be performed on either platform.

Do you need to take each course in course order?

We highly recommend completing the courses in the order presented because the content in each course builds on information from earlier lessons.

What will I get if I subscribe to this Certificate?

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Analyze Data to Answer Questions

Seize the savings! Get 40% off 3 months of Coursera Plus and full access to thousands of courses.

Analyze Data to Answer Questions

This course is part of Google Data Analytics Professional Certificate

Instructor: Google Career Certificates

787,304 already enrolled

Included with

Learn more

4 modules

Gain insight into a topic and learn the fundamentals.

12,184 reviews

Beginner level

Recommended experience

Flexible schedule

3 weeks at 10 hours a week

Learn at your own pace

96%

Most learners liked this course

4 modules

Gain insight into a topic and learn the fundamentals.

12,184 reviews

Beginner level

Recommended experience

Flexible schedule

3 weeks at 10 hours a week

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

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

30 assignments

Taught in English

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

Learn more about Coursera 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

There are 4 modules in this 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.

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

What's included

9 videos13 readings6 assignments

9 videos Total 37 minutes

Introduction to getting organized 3 minutes
The analysis process 5 minutes
Ayanna: Sticking with it 2 minutes
Always a need to organize 3 minutes
Filter data with SQL 5 minutes
Sort data in spreadsheets 5 minutes
Use the SORT function in spreadsheets 5 minutes
Emma: Journey to a meaningful career 2 minutes
Sort data with SQL 8 minutes

13 readings Total 70 minutes

Course 5 overview 8 minutes
Helpful resources and tips 4 minutes
Sort and filter data to keep it organized 8 minutes
Review: Set up your BigQuery account 8 minutes
Review: Get started with BigQuery 4 minutes
Working with .csv files 4 minutes
Upload the movie dataset to BigQuery 4 minutes
Step-by-Step: Filter data with SQL 4 minutes
Step-by-step: Sort datasets in spreadsheets 4 minutes
Step-by-step: Use the SORT function in spreadsheets 4 minutes
Sort and filter in Sheets and Excel 8 minutes
Step-by-Step: Sort data with SQL 8 minutes
Glossary terms from module 1 2 minutes

6 assignments Total 184 minutes

Test your knowledge on organizing data for analysis 8 minutes
Test your knowledge on sorting data in spreadsheets 8 minutes
Hands-On Activity: SQL sorting queries 60 minutes
Hands-On Activity: Analyze weather data in BigQuery 60 minutes
Test your knowledge on sorting data with SQL 8 minutes
Module 1 challenge 40 minutes

As you move closer to analyzing your data, you’ll want to have it formatted and ready to go. In this part of the course, you’ll learn all about converting and formatting data, including how SQL queries can help you combine data. You’ll 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 videos Total 38 minutes

Get started with data formatting 1 minute
From one type to another 5 minutes
Data validation 4 minutes
Conditional formatting 5 minutes
Merge text strings to gain insights 5 minutes
Strings in spreadsheets 3 minutes
When you get stuck 3 minutes
Layla: All about the analyze stage 3 minutes
Running into challenges? Not to worry! 6 minutes
When to use which tool 2 minutes

9 readings Total 58 minutes

Step-by-Step: From one type to another 8 minutes
Convert data in spreadsheets 8 minutes
Transform data with SQL 4 minutes
Import and combine data in spreadsheets and databases 8 minutes
Step-by-Step: Merge text strings to gain insights 8 minutes
Step-by-Step: Strings in spreadsheets 8 minutes
Manipulate strings with SQL 4 minutes
Advanced spreadsheet tips and tricks 8 minutes
Glossary terms from module 2 2 minutes

5 assignments Total 136 minutes

Test your knowledge on converting and formatting data 8 minutes
Hands-On Activity: Combine multiple pieces of data 60 minutes
Test your knowledge on combining multiple datasets 8 minutes
Self-Reflection: Stack Overflow 20 minutes
Module 2 challenge 40 minutes

1 plugin Total 10 minutes

SQL query syntax 10 minutes

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

What's included

8 videos10 readings9 assignments1 plugin

8 videos Total 41 minutes

Aggregate data for analysis 3 minutes
Prepare for VLOOKUP 5 minutes
VLOOKUP in action 3 minutes
Identify and fix common VLOOKUP errors 6 minutes
Explore how JOINs work 8 minutes
Queries within queries 7 minutes
Use subqueries to aggregate data 7 minutes
Justin: Where data analysis takes you 2 minutes

10 readings Total 74 minutes

VLOOKUP Core Concepts 8 minutes
Upload the employee dataset to BigQuery 8 minutes
Step-by-Step: Explore how JOINs work 8 minutes
Secret identities: The importance of aliases 8 minutes
Use JOINs effectively 8 minutes
Upload the warehouse dataset to BigQuery 8 minutes
Step-by-Step: Queries within queries 8 minutes
Step-by-Step: Use subqueries to aggregate data 8 minutes
SQL functions and subqueries: A functional friendship 8 minutes
Glossary terms from module 3 2 minutes

9 assignments Total 364 minutes

Hands-On Activity: Use VLOOKUP to perform a task 60 minutes
Test your knowledge on VLOOKUP 8 minutes
Hands-On Activity: Queries for JOINS 60 minutes
Hands-On Activity: COUNT and COUNT DISTINCT 60 minutes
Test your knowledge on using JOINS to aggregate data 8 minutes
Hands-On Activity: Use subqueries to refine data 60 minutes
Hands-on activity: Use subqueries 60 minutes
Test your knowledge on working with subqueries 8 minutes
Module 3 challenge 40 minutes

1 plugin Total 10 minutes

Review subqueries 10 minutes

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

What's included

13 videos13 readings10 assignments1 plugin

13 videos Total 70 minutes

Data calculations 2 minutes
Common calculation formulas 10 minutes
Functions and conditions 9 minutes
Composite functions 6 minutes
Start working with pivot tables 7 minutes
Pivot tables continued 5 minutes
Queries and calculations 4 minutes
Embed simple calculations with SQL 7 minutes
Calculations with other statements 4 minutes
Check and recheck 5 minutes
Temporary tables 6 minutes
Multiple table variations 4 minutes
Congratulations! Course wrap-up 1 minute

13 readings Total 80 minutes

Functions with multiple conditions 8 minutes
Elements of a pivot table 4 minutes
Use pivot tables in analysis 8 minutes
Upload the avocado dataset to BigQuery 8 minutes
Step-by-Step: Embed simple calculations with SQL 8 minutes
Types of data validation 4 minutes
Work with temporary tables 8 minutes
Your intermediate guide to SQL 8 minutes
Use Connected Sheets with BigQuery 8 minutes
Glossary terms from module 4 4 minutes
Reflect and connect with peers 4 minutes
Course 5 glossary 4 minutes
Coming up next... 4 minutes

10 assignments Total 372 minutes

Hands-On Activity: Work with conditions 60 minutes
Test your knowledge on data calculations 8 minutes
Hands-On Activity: Explore movie data with pivot tables 60 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 BigQuery 60 minutes
Hands-On Activity: Create temporary tables 60 minutes
Test your knowledge on using SQL with temporary tables 8 minutes
Module 4 challenge 40 minutes

1 plugin Total 10 minutes

Start validating 10 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Instructor ratings

(3,543 ratings)

Google Career Certificates

Google

386 Courses 15,716,773 learners

Offered by

Google

Explore more from Data Analysis

Status: Free Trial
Google
Ask Questions to Make Data-Driven Decisions
Course
Status: Free Trial
Google
Foundations: Data, Data, Everywhere
Course
Status: Free Trial
Google
Ask Effective Questions
Course
Status: Free Trial
EDUCBA
Analyze and Interpret Data Using Excel
Course

Why people choose Coursera 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, Coursera 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. Coursera allows me to learn without limits."

Learner reviews

5 stars
74.61%
4 stars
16.40%
3 stars
5.22%
2 stars
2.13%
1 star
1.61%

Showing 3 of 12184

Reviewed on Jun 25, 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!

Reviewed on Apr 12, 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.

Reviewed on Jan 6, 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

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

Data is a group of facts that can take many different forms, such as numbers, pictures, words, videos, observations, and more. We use and create data everyday, like when we stream a show or song or post on social media.

Data analytics is the collection, transformation, and organization of these facts to draw conclusions, make predictions, and drive informed decision-making.

The amount of data created each day is tremendous. Any time you use your phone, look up something online, stream music, shop with a credit card, post on social media, or use GPS to map a route, you’re creating data. Companies must continually adjust their products, services, tools, and business strategies to meet consumer demand and react to emerging trends. Because of this, data analyst roles are in demand and competitively paid.

Data analysts make sense of data and numbers to help organizations make better business decisions. They prepare, process, analyze, and visualize data, discovering patterns and trends and answering key questions along the way. Their work empowers their wider team to make better business decisions.

You will learn the skill set required for becoming a junior or associate data analyst in the Google Data Analytics Certificate. Data analysts know how to ask the right question; prepare, process, and analyze data for key insights; effectively share their findings with stakeholders; and provide data-driven recommendations for thoughtful action.

You’ll learn these job-ready skills in our certificate program through interactive content (discussion prompts, quizzes, and activities) in under six months, with under 10 hours of flexible study a week. Along the way, you'll work through a curriculum designed with input from top employers and industry leaders, like Tableau, Accenture, and Deloitte. You’ll even have the opportunity to complete a case study that you can share with potential employers to showcase your new skill set.

After you’ve graduated from the program, you’ll have access to career resources and be connected directly with employers hiring for open entry-level roles in data analytics.

You don't need to be a math all-star to succeed in this certificate. You need to be curious and open to learning with numbers (the language of data analysts). Being a strong data analyst is more than just math, it's about asking the right questions, finding the best sources to answer your questions effectively, and illustrating your findings clearly in visualizations.

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.