Course
Skills Expanded
Creating New BigQuery Datasets and Visualizing Insights
This is the second course in the Data to Insights course series. Here we will cover how to ingest new external datasets into BigQuery and visualize them with Looker Studio.
What you'll learn
This is the second course in the Data to Insights course series. Here we will cover how to ingest new external datasets into BigQuery and visualize them with Looker Studio. We will also cover intermediate SQL concepts like multi-table JOINs and UNIONs which will allow you to analyze data across multiple data sources. Note: Even if you have a background in SQL, there are BigQuery specifics (like handling query cache and table wildcards) that may be new to you. After completing this course, enroll in the Achieving Advanced Insights with BigQuery course.
Table of contents
Course Introduction
1min
Storing and Exporting Data
8mins
- Creating permanent tables 1m
- Temporary tables and query results 1m
- Performance preview: Query cache 1m
- Creating logical Views 1m
- Lab Intro: Creating Permanent Tables and Access-Controlled Views in BigQuery 0m
- Getting Started with GCP and Qwiklabs 4m
- Lab: Creating Permanent Tables and Access-Controlled Views in BigQuery v1.5 0m
Ingesting New Datasets into BigQuery
7mins
Joining and Merging Datasets
23mins
- Introducing JOINs and UNIONs 7m
- Use table wildcards for easy merges 5m
- Linking data across multiple tables 3m
- SQL Join examples 1m
- Avoiding pitfalls when merging datasets 5m
- Recap of Google Analytics ecommerce dataset 1m
- Lab: Troubleshooting and Solving Data Join Pitfalls v1.5 0m
- Lab Intro: Unioning and Joining Datasets 0m
- Lab: Data to Insights: Unioning and Joining Datasets v1.1 0m
Data Visualization
13mins
Course Summary
3mins
Course Resources
0mins
