Share Description
In this course, you will :
- Validate and clean a dataset.
- Assess and create datasets to answer your questions.
- Solve problems using SQL.
- Build a simple testing framework to touch on AB Testing.
Syllabus :
1. Data of Unknown Quality
- Introduction of Data of Unknown Quality
- Introduction to the Course Dataset
- Flexible Data Formats
- Identifying Unreliable Data + Nulls
2. Creating Clean Datasets
- Creating Clean Datasets Introduction
- Data Types
- What is a Dependency?
- Create a View-Item Table2
- Hierarchy of Data
- Create User Info Table
3. SQL Problem Solving
- Map Out Your Joins
- Test Queries vs Final Queries
- Example: Create an Aggregate Table with a Rolling Date Period
- Find Each User's Most Recently Viewed Page for an Email Campaign
- Review Windowing Functions
- Product Analysis4
- Coding with Style
4. Case Study: AB Testing
- How is AB Testing Used?
- Test Assignments8m
- Create a New Metric
- Analyze Results
- Peer Review Overview
