Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Google

Analyze Data to Answer Questions

Google via Google Skills

Overview

Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
Apply your data analytics knowledge to real-world scenarios. Learn to organize and format data using spreadsheets and SQL, perform complex calculations, and leverage formulas, functions, and SQL queries for effective analysis. This is the fifth course in the Google Data Analytics Certificate, a series designed to prepare you for an introductory-level data analyst role.

Syllabus

  • Organize data for more effective analysis
    • Introduction to getting organized
    • Course 5 overview
    • The analysis process
    • Ayanna: Sticking with it
    • Always a need to organize
    • 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
    • Filter data with SQL
    • Practice Quiz: Test your knowledge on organizing data for analysis
    • Step-by-step: Sort datasets in spreadsheets
    • Sort data in spreadsheets
    • Step-by-step: Use the SORT function in spreadsheets
    • Use the SORT function in spreadsheets
    • Sort and filter in Sheets and Excel
    • Emma: Journey to a meaningful career
    • Practice Quiz: Test your knowledge on sorting data in spreadsheets
    • Step-by-Step: Sort data with SQL
    • Sort data with SQL
    • Practice Quiz: Hands-On Activity: SQL sorting queries
    • Practice Quiz: Hands-On Activity: Analyze weather data in BigQuery
    • Practice Quiz: Test your knowledge on sorting data with SQL
    • Glossary terms from module 1
    • Graded Quiz: Module 1 challenge
  • Format and adjust data
    • Get started with data formatting
    • Step-by-Step: From one type to another
    • From one type to another
    • Convert data in spreadsheets
    • Data validation
    • Conditional formatting
    • Transform data with SQL
    • Practice Quiz: Test your knowledge on converting and formatting data
    • Import and combine data in spreadsheets and databases
    • Step-by-Step: Merge text strings to gain insights
    • Merge text strings to gain insights
    • Practice Quiz: Hands-On Activity: Combine multiple pieces of data
    • Step-by-Step: Strings in spreadsheets
    • Strings in spreadsheets
    • Manipulate strings with SQL
    • Practice Quiz: Test your knowledge on combining multiple datasets
    • When you get stuck
    • Advanced spreadsheet tips and tricks
    • Layla: All about the analyze stage
    • Running into challenges? Not to worry!
    • When to use which tool
    • Practice Quiz: Self-Reflection: Stack Overflow
    • Glossary terms from module 2
    • Graded Quiz: Module 2 challenge
  • Aggregate data for analysis
    • Aggregate data for analysis
    • Prepare for VLOOKUP
    • VLOOKUP in action
    • Identify and fix common VLOOKUP errors
    • VLOOKUP core concepts
    • Practice Quiz: Hands-On Activity: Use VLOOKUP to perform a task
    • Practice Quiz: Test your knowledge on VLOOKUP
    • Upload the employee dataset to BigQuery
    • Step-by-Step: Explore how JOINs work
    • Explore how JOINs work
    • Secret identities: The importance of aliases
    • Use JOINs effectively
    • Practice Quiz: Hands-On Activity: Queries for JOINS
    • Upload the warehouse dataset to BigQuery
    • Practice Quiz: Hands-On Activity: COUNT and COUNT DISTINCT
    • Practice Quiz: Test your knowledge on using JOINS to aggregate data
    • Step-by-Step: Queries within queries
    • Queries within queries
    • Practice Quiz: Hands-On Activity: Use subqueries to refine data
    • Step-by-Step: Use subqueries to aggregate data
    • Use subqueries to aggregate data
    • SQL functions and subqueries: A functional friendship
    • Justin: Where data analysis takes you
    • Practice Quiz: Hands-On Activity: Use subqueries
    • Practice Quiz: Test your knowledge on working with subqueries
    • Glossary terms from module 3
    • Graded Quiz: Module 3 challenge
  • Perform data calculations
    • Data calculations
    • Common calculation formulas
    • Functions and conditions
    • Functions with multiple conditions
    • Practice Quiz: Hands-On Activity: Work with conditions
    • Composite functions
    • Practice Quiz: Test your knowledge on data calculations
    • Start working with pivot tables
    • Pivot tables continued
    • Elements of a pivot table
    • Use pivot tables in analysis
    • Practice Quiz: Hands-On Activity: Explore movie data with pivot tables
    • Practice Quiz: Test your knowledge on pivot tables
    • Queries and calculations
    • Upload the avocado dataset to BigQuery
    • Step-by-Step: Embed simple calculations with SQL
    • Embed simple calculations with SQL
    • Calculations with other statements
    • Practice Quiz: Hands-On Activity: Calculations with SQL
    • Practice Quiz: Test your knowledge on SQL calculations
    • Check and recheck
    • Types of data validation
    • Practice Quiz: Hands-On Activity: From spreadsheets to BigQuery
    • Temporary tables
    • Practice Quiz: Hands-On Activity: Create temporary tables
    • Multiple table variations
    • Work with temporary tables
    • Your intermediate guide to SQL
    • Use Connected Sheets with BigQuery
    • Practice Quiz: Test your knowledge on using SQL with temporary tables
    • Glossary terms from module 4
    • Graded Quiz: Module 4 challenge
    • Course 5 glossary
    • Congratulations! Course wrap-up
    • Coming up next...
    • Course 5 resources and citations

Reviews

Start your review of Analyze Data to Answer Questions

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.