Analyze Data to Answer Questions
![](https://cloud-hox.com/wp-content/uploads/2024/01/ad.jpg)
What Will You 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.
Course Content
Module 1: Organize data for more effective analysis
-
Introduction to getting organized
00:00 -
The analysis process
00:00 -
Ayanna: Sticking with it
00:00 -
Always a need to organize
00:00 -
Filter data with SQL
00:00 -
Sort data in spreadsheets
00:00 -
Use the SORT function in spreadsheets
00:00 -
Emma: Journey to a meaningful career
00:00 -
Sort data with SQL
00:00
11 readings
-
Course 5 overview: Set your expectations
00:00 -
Sort and filter data to keep it organized
00:00 -
Review: Set up your BigQuery account
00:00 -
Review: Get started with BigQuery
00:00 -
Upload the movie dataset to BigQuery
00:00 -
Step-by-Step: Filter data with SQL
00:00 -
Step-by-step: Sort datasets in spreadsheets
00:00 -
Step-by-step: Use the SORT function in spreadsheets
00:00 -
Sort and filter in Sheets and Excel
00:00 -
Step-by-Step: Sort data with SQL
00:00 -
Glossary terms from module 1
00:00
6 quizzes
-
Module 1 challenge
00:00 -
Test your knowledge on organizing data for analysis
00:00 -
Test your knowledge on sorting data in spreadsheets
00:00 -
Hands-On Activity: SQL sorting queries
00:00 -
Hands-On Activity: Analyze weather data in BigQuery
00:00 -
Test your knowledge on sorting data with SQL
00:00
1 discussion prompt
-
Meet and greet
00:00
1 plugin
-
Refresher: Your Google Data Analytics Certificate roadmap
00:00
Module 2: Format and adjust data
-
Get started with data formatting
00:00 -
From one type to another
00:00 -
Data validation
00:00 -
Conditional formatting
00:00 -
Merge text strings to gain insights
00:00 -
Strings in spreadsheets
00:00 -
When you get stuck
00:00 -
Layla: All about the analyze stage
00:00 -
Running into challenges? Not to worry!
00:00 -
When to use which tool
00:00
9 readings
-
Step-by-Step: From one type to another
00:00 -
Convert data in spreadsheets
00:00 -
Transform data with SQL
00:00 -
Import and combine data in spreadsheets and databases
00:00 -
Step-by-Step: Merge text strings to gain insights
00:00 -
Step-by-Step: Strings in spreadsheets
00:00 -
Manipulate strings with SQL
00:00 -
Advanced spreadsheet tips and tricks
00:00 -
Glossary terms from module 2
00:00
5 quizzes
-
Module 2 challenge
00:00 -
Test your knowledge on converting and formatting data
00:00 -
Hands-On Activity: Combine multiple pieces of data
00:00 -
Test your knowledge on combining multiple datasets
00:00 -
Self-Reflection: Stack Overflow
00:00
1 plugin
-
SQL query syntax
00:00
Module 3: Aggregate data for analysis
-
Aggregate data for analysis
00:00 -
Prepare for VLOOKUP
00:00 -
VLOOKUP in action
00:00 -
Identify and fix common VLOOKUP errors
00:00 -
Explore how JOINs work
00:00 -
Queries within queries
00:00 -
Use subqueries to aggregate data
00:00 -
Justin: Where data analysis takes you
00:00
10 readings
-
VLOOKUP core concepts
00:00 -
Upload the employee dataset to BigQuery
00:00 -
Step-by-Step: Explore how JOINs work
00:00 -
Secret identities: The importance of aliases
00:00 -
Use JOINs effectively
00:00 -
Upload the warehouse dataset to BigQuery
00:00 -
Step-by-Step: Queries within queries
00:00 -
Step-by-Step: Use subqueries to aggregate data
00:00 -
SQL functions and subqueries: A functional friendship
00:00 -
Glossary terms from module 3
00:00
9 quizzes
-
Module 3 challenge
00:00 -
Hands-On Activity: Use VLOOKUP to perform a task
00:00 -
Test your knowledge on VLOOKUP
00:00 -
Hands-On Activity: Queries for JOINS
00:00 -
Hands-On Activity: COUNT and COUNT DISTINCT
00:00 -
Test your knowledge on using JOINS to aggregate data
00:00 -
Hands-On Activity: Use subqueries to refine data
00:00 -
Hands-on activity: Use subqueries
00:00 -
Test your knowledge on working with subqueries
00:00
1 plugin
-
Review subqueries
00:00
Module 4: Perform data calculations
-
Data calculations
00:00 -
Common calculation formulas
00:00 -
Functions and conditions
00:00 -
Composite functions
00:00 -
Start working with pivot tables
00:00 -
Pivot tables continued
00:00 -
Queries and calculations
00:00 -
Embed simple calculations with SQL
00:00 -
Calculations with other statements
00:00 -
Check and recheck
00:00 -
Temporary tables
00:00 -
Multiple table variations
00:00 -
Congratulations! Course wrap-up
00:00
12 readings
-
Functions with multiple conditions
00:00 -
Elements of a pivot table
00:00 -
Use pivot tables in analysis
00:00 -
Upload the avocado dataset to BigQuery
00:00 -
Step-by-Step: Embed simple calculations with SQL
00:00 -
Types of data validation
00:00 -
Work with temporary tables
00:00 -
Your intermediate guide to SQL
00:00 -
Use Connected Sheets with BigQuery
00:00 -
Glossary terms from module 4
00:00 -
Course 5 glossary
00:00 -
Coming up next..
00:00
10 quizzes
-
Module 4 challenge
00:00 -
Hands-On Activity: Work with conditions
00:00 -
Test your knowledge on data calculations
00:00 -
Hands-On Activity: Explore movie data with pivot tables
00:00 -
Test your knowledge on pivot tables
00:00 -
Hands-On Activity: Calculations with SQL
00:00 -
Test your knowledge on SQL calculations
00:00 -
Hands-On Activity: From spreadsheets to BigQuery
00:00 -
Hands-On Activity: Create temporary tables
00:00 -
Test your knowledge on using SQL with temporary tables
00:00
1 plugin
-
Start validating
00:00
Student Ratings & Reviews
No Review Yet