Creating New BigQuery Datasets and Visualizing Insights
This is the second course in the Data to Insights specialization. Here we will cover how to ingest new external datasets into BigQuery and visualize them with Google Data 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.
What you'll learn
This is the second course in the Data to Insights specialization. Here we will cover how to ingest new external datasets into BigQuery and visualize them with Google Data 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.
Table of contents
- Introducing JOINs and UNIONs 7m
- Introducing BigQuery Table Wildcards for Easy Merges 9m
- SQL JOIN Syntax 3m
- Walkthrough:SQL Join Types 6m
- 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 0m
- Lab: Data to Insights: Unioning and Joining Datasets v1.1 0m
- Lab Solution 16m
