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.
Overview
Syllabus
- Course Introduction
- Course Introduction
- Recap of Google Analytics ecommerce dataset
- Storing and Exporting Data
- Creating permanent tables
- Temporary tables and query results
- Performance preview: Query cache
- Creating logical Views
- Lab Intro: Creating Permanent Tables and Access-Controlled Views in BigQuery
- Creating Permanent Tables and Access-Controlled Views in BigQuery v1.5
- Module Quiz
- Ingesting New Datasets into BigQuery
- Ingesting new data into BigQuery
- Lab Intro: Ingesting New Datasets into BigQuery
- Ingesting New Datasets into BigQuery v1.5
- Module Quiz
- Background: Partitioned tables
- Creating Date-Partitioned Tables in BigQuery v1.5
- Joining and Merging Datasets
- Introducing JOINs and UNIONs
- Use table wildcards for easy merges
- Linking data across multiple tables
- SQL Join examples
- Avoiding pitfalls when merging datasets
- Recap of Google Analytics ecommerce dataset
- Troubleshooting and Solving Data Join Pitfalls v1.5
- Lab Intro: Unioning and Joining Datasets
- Data to Insights: Unioning and Joining Datasets v1.1
- Module Quiz
- Data Visualization
- Overview of data visualization principles
- Comparing good and bad visualizations
- Dimensions, Measures, and Reports
- Introducing Looker Studio
- Lab Intro: Explore and Create Reports with Looker Studio
- Explore and Create Reports with Looker Studio v1.5
- Module Quiz
- Course Summary
- Course summary
- Course Resources
- Course Resources
- Your Next Steps
- Course Badge
