Skip to main content

Learn Learning paths Courses

Working With Customer Data

Real customer data does not look like sample data.

중급 · Lessons 30 · Lab 10

Curriculum

Diagnosing Dirty Data

Customer Data Does Not Look Like Sample Data reading
Cleaning a Broken Orders CSV lab
Quiz: Diagnosing Dirty Data quiz

Cleaning and Validation

Finding Answers in SQL

The Most Dangerous SQL Raises No Error reading
Answering the Customer's Question in SQL lab
Quiz: Finding Answers in SQL quiz

The Rules for Handling Customer Data

The Characters Are Broken

CSV That Ignores the Spec

Schemas That Change Without Warning

Missing Values and Duplicate Keys

Files Too Big to Load

The File Does Not Fit in Memory reading
It Worked on My Laptop, It Dies in the Pod lab
Quiz: Files Too Big to Load quiz

Finding Anomalies with Profiles and Statistics

Reference docs