This lab focuses on how to reverse-engineer the relationships between data tables and the pitfalls to avoid when joining them together.
Overview
Syllabus
- GSP412
- Overview
- Setup
- Task 1. Create a new dataset to store your tables
- Task 2. Pin the lab project in BigQuery
- Task 3. Examine the fields
- Task 4. Identify a key field in your ecommerce dataset
- Task 5. Pitfall: non-unique key
- Task 6. Join pitfall solution: use distinct SKUs before joining
- Congratulations!
