Troubleshooting and Solving Data Join Pitfalls

Offered By: Google via Google Cloud Skills Boost

Tags

BigQuery Courses Data Analysis Courses Data Engineering Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

This lab focuses on how to reverse-engineer the relationships between data tables and the pitfalls to avoid when joining them together.

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!

Tags

united states

Related Courses

Social Network Analysis
University of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX