Course
Skills Expanded
BigQuery for Data Analysts
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.
What you'll learn
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.
Table of contents
Course Introduction
3mins
BigQuery for Data Analysts
19mins
Exploring and Preparing Your Data with BigQuery
36mins
- Module overview 1m
- Common data exploration techniques 3m
- Analyze large datasets with BigQuery 2m
- Query basics 11m
- Lab intro: Exploring an Ecommerce Dataset using SQL in Google BigQuery 1m
- Lab: Exploring an Ecommerce Dataset using SQL in Google BigQuery 0m
- Working with functions 8m
- Lab intro: Troubleshooting Common SQL Errors with BigQuery 0m
- Lab: Troubleshooting Common SQL Errors with BigQuery 0m
- Enrich your queries with UNIONs and JOINs 10m
- Lab intro: Troubleshooting and Solving Data Join Pitfalls 0m
- Lab: Troubleshooting and Solving Data Join Pitfalls 0m
Cleaning and Transforming your Data
27mins
Ingesting and Storing New BigQuery Datasets
16mins
- Module overview 1m
- Permanent versus temporary data tables 5m
- Lab intro: Creating new Permanent Tables 0m
- Lab: Creating Permanent Tables and Access-Controlled Views in BigQuery 0m
- Ingesting new datasets 4m
- External data sources 5m
- Lab intro: Ingesting and Querying New Datasets 0m
- Lab: Ingesting New Datasets into BigQuery 0m
Visualizing Your Insights from BigQuery
28mins
- Module overview 2m
- Data visualization principles 7m
- Connected Sheets 5m
- Lab intro: Connected Sheets Qwik Start 0m
- Lab: Connected Sheets: Qwik Start 0m
- Common data visualization pitfalls 3m
- Looker Studio 5m
- Lab intro: Explore and Create Reports with Looker Studio 0m
- Lab: Explore and Create Reports with Looker Studio 0m
- Analysis in a notebook 6m
Developing scalable data transformations pipelines in BigQuery with Dataform
16mins
Summary
3mins
