This course is designed for data analysts who want to learn about using BigQuery for their data analysis needs. Through a combination of videos, labs, and demos, we cover various topics that discuss how to ingest, transform, and query your data in BigQuery to derive insights that can help in business decision making.
Overview
Syllabus
- Course Introduction
- Course Introduction
- BigQuery for Data Analysts
- Module overview
- Data analytics on Google Cloud
- From data to insights with BigQuery
- BigQuery demo
- Real-world use cases of companies transformed through analytics on Google Cloud
- Exploring and Preparing Your Data with BigQuery
- Module overview
- Common data exploration techniques
- Analyze large datasets with BigQuery
- Query basics
- Lab intro: Exploring an Ecommerce Dataset using SQL in Google BigQuery
- Exploring an Ecommerce Dataset using SQL in Google BigQuery
- Working with functions
- Lab intro: Troubleshooting Common SQL Errors with BigQuery
- Troubleshooting Common SQL Errors with BigQuery
- Enrich your queries with UNIONs and JOINs
- Lab intro: Troubleshooting and Solving Data Join Pitfalls
- Troubleshooting and Solving Data Join Pitfalls
- Cleaning and Transforming your Data
- Module overview
- 5 principles of dataset integrity
- Clean and transform data using SQL
- Clean and transform data: other options
- Ingesting and Storing New BigQuery Datasets
- Module overview
- Permanent versus temporary data tables
- Lab intro: Creating new Permanent Tables
- Creating Permanent Tables and Access-Controlled Views in BigQuery
- Ingesting new datasets
- External data sources
- Lab intro: Ingesting and Querying New Datasets
- Ingesting New Datasets into BigQuery
- Visualizing Your Insights from BigQuery
- Module overview
- Data visualization principles
- Connected Sheets
- Lab intro: Connected Sheets Qwik Start
- Connected Sheets: Qwik Start
- Common data visualization pitfalls
- Looker Studio
- Lab intro: Explore and Create Reports with Looker Studio
- Explore and Create Reports with Looker Studio
- Analysis in a notebook
- Developing scalable data transformations pipelines in BigQuery with Dataform
- Module overview
- What is Dataform ?
- Getting started with Dataform
- Demo
- Lab intro: Create and execute a SQL workflow in Dataform
- Create and execute a SQL workflow in Dataform
- BigQuery Studio
- Module overview
- What is BigQuery Studio ?
- Unified analytics
- Asset management
- Embedded assistance
- Demo
- Lab intro: Analyze Data with Duet AI Assistance
- Analyze data with Gemini assistance
- Summary
- Summary
- Your Next Steps
- Course Badge
