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.
Buy Now AED 170.99 + VAT
Monthly Subscription Starting at AED 99 + VAT
- Level Foundation
- Duration 27 hours
- Course by Google
-
Offered by
About
This is the fifth course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs. In this course, you'll explore the "analyze" phase of the data analysis process. You'll take what you've learned to this point and apply it to your analysis 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 on your data to complete 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, you will: - Learn how to organize data for analysis. - Discover the processes for formatting and adjusting data. - Gain an understanding of how to aggregate data in spreadsheets and by using SQL. - Use formulas and functions in spreadsheets for data calculations. - Learn how to complete calculations using SQL queries.
Modules
Let's get organized
-
1
Videos
-
2
Readings
-
1
Plugin
1
Videos
- Introduction to getting organized
2
Readings
- Course 5 overview: Set your expectations
- Helpful resources and tips
Organize data for analysis
-
4
Videos
-
6
Readings
-
1
Quiz
4
Videos
- The analysis process
- Ayanna: Sticking with it
- Always a need to organize
- Filter data with SQL
6
Readings
- Sort and filter data to keep it organized
- Review: Set up your BigQuery account
- Review: Get started with BigQuery
- Working with .csv files
- Upload the movie dataset to BigQuery
- Step-by-Step: Filter data with SQL
1
Quiz
- Test your knowledge on organizing data for analysis
Sort data in spreadsheets
-
3
Videos
-
3
Readings
-
1
Quiz
3
Videos
- Sort data in spreadsheets
- Use the SORT function in spreadsheets
- Emma: Journey to a meaningful career
3
Readings
- Step-by-step: Sort datasets in spreadsheets
- Step-by-step: Use the SORT function in spreadsheets
- Sort and filter in Sheets and Excel
1
Quiz
- Test your knowledge on sorting data in spreadsheets
Sort data using SQL
-
1
Videos
-
1
Readings
-
3
Quiz
1
Videos
- Sort data with SQL
1
Readings
- Step-by-Step: Sort data with SQL
3
Quiz
- Hands-On Activity: SQL sorting queries
- Hands-On Activity: Analyze weather data in BigQuery
- Test your knowledge on sorting data with SQL
Module 1 challenge
-
1
Readings
-
1
Quiz
1
Readings
- Glossary terms from module 1
1
Quiz
- Module 1 challenge
Formatting for better analysis
-
4
Videos
-
3
Readings
-
1
Quiz
4
Videos
- Get started with data formatting
- From one type to another
- Data validation
- Conditional formatting
3
Readings
- Step-by-Step: From one type to another
- Convert data in spreadsheets
- Transform data with SQL
1
Quiz
- Test your knowledge on converting and formatting data
Combine multiple datasets
-
2
Videos
-
4
Readings
-
2
Quiz
-
1
Plugin
2
Videos
- Merge text strings to gain insights
- Strings in spreadsheets
4
Readings
- Import and combine data in spreadsheets and databases
- Step-by-Step: Merge text strings to gain insights
- Step-by-Step: Strings in spreadsheets
- Manipulate strings with SQL
2
Quiz
- Hands-On Activity: Combine multiple pieces of data
- Test your knowledge on combining multiple datasets
Get support during analysis
-
4
Videos
-
1
Readings
-
1
Quiz
4
Videos
- When you get stuck
- Layla: All about the analyze stage
- Running into challenges? Not to worry!
- When to use which tool
1
Readings
- Advanced spreadsheet tips and tricks
1
Quiz
- Self-Reflection: Stack Overflow
Module 2 challenge
-
1
Readings
-
1
Quiz
1
Readings
- Glossary terms from module 2
1
Quiz
- Module 2 challenge
VLOOKUP and data aggregation
-
4
Videos
-
1
Readings
-
2
Quiz
4
Videos
- Aggregate data for analysis
- Prepare for VLOOKUP
- VLOOKUP in action
- Identify and fix common VLOOKUP errors
1
Readings
- VLOOKUP core concepts
2
Quiz
- Hands-On Activity: Use VLOOKUP to perform a task
- Test your knowledge on VLOOKUP
Use JOINS to aggregate data in SQL
-
1
Videos
-
5
Readings
-
3
Quiz
1
Videos
- Explore how JOINs work
5
Readings
- Upload the employee dataset to BigQuery
- Step-by-Step: Explore how JOINs work
- Secret identities: The importance of aliases
- Use JOINs effectively
- Upload the warehouse dataset to BigQuery
3
Quiz
- Hands-On Activity: Queries for JOINS
- Hands-On Activity: COUNT and COUNT DISTINCT
- Test your knowledge on using JOINS to aggregate data
Work with subqueries
-
3
Videos
-
3
Readings
-
3
Quiz
-
1
Plugin
3
Videos
- Queries within queries
- Use subqueries to aggregate data
- Justin: Where data analysis takes you
3
Readings
- Step-by-Step: Queries within queries
- Step-by-Step: Use subqueries to aggregate data
- SQL functions and subqueries: A functional friendship
3
Quiz
- Hands-On Activity: Use subqueries to refine data
- Hands-on activity: Use subqueries
- Test your knowledge on working with subqueries
Module 3 challenge
-
1
Readings
-
1
Quiz
1
Readings
- Glossary terms from module 3
1
Quiz
- Module 3 challenge
Get started with data calculations
-
4
Videos
-
1
Readings
-
2
Quiz
4
Videos
- Data calculations
- Common calculation formulas
- Functions and conditions
- Composite functions
1
Readings
- Functions with multiple conditions
2
Quiz
- Hands-On Activity: Work with conditions
- Test your knowledge on data calculations
Pivot...pivot...pivot...
-
2
Videos
-
2
Readings
-
2
Quiz
2
Videos
- Start working with pivot tables
- Pivot tables continued
2
Readings
- Elements of a pivot table
- Use pivot tables in analysis
2
Quiz
- Hands-On Activity: Explore movie data with pivot tables
- Test your knowledge on pivot tables
Learn more SQL calculations
-
3
Videos
-
2
Readings
-
2
Quiz
3
Videos
- Queries and calculations
- Embed simple calculations with SQL
- Calculations with other statements
2
Readings
- Upload the avocado dataset to BigQuery
- Step-by-Step: Embed simple calculations with SQL
2
Quiz
- Hands-On Activity: Calculations with SQL
- Test your knowledge on SQL calculations
The data-validation process
-
1
Videos
-
1
Readings
-
1
Quiz
-
1
Plugin
1
Videos
- Check and recheck
1
Readings
- Types of data validation
1
Quiz
- Hands-On Activity: From spreadsheets to BigQuery
SQL and temporary tables
-
2
Videos
-
3
Readings
-
2
Quiz
2
Videos
- Temporary tables
- Multiple table variations
3
Readings
- Work with temporary tables
- Your intermediate guide to SQL
- Use Connected Sheets with BigQuery
2
Quiz
- Hands-On Activity: Create temporary tables
- Test your knowledge on using SQL with temporary tables
Module 4 challenge
-
1
Readings
-
1
Quiz
1
Readings
- Glossary terms from module 4
1
Quiz
- Module 4 challenge
Course wrap-up
-
1
Videos
-
3
Readings
1
Videos
- Congratulations! Course wrap-up
3
Readings
- Reflect and connect with peers
- Course 5 glossary
- Coming up next...
Auto Summary
Dive into the world of data analysis with this comprehensive course, part of the Google Data Analytics Certificate. Taught by experienced Google data analysts, you'll master organizing and formatting data using spreadsheets and SQL, perform complex calculations, and apply formulas and functions to meet business objectives. Ideal for beginners, this 1620-minute foundational course on Coursera offers professional and starter subscription options, equipping you with the skills needed for entry-level data analyst roles.
Google Career Certificates