Data of Unknown Quality-Getting Started
A Note From UC Davis
Course Introduction
()
Data of Unknown Quality-Course Dataset
Introduction of Data of Unknown Quality
()
Connecting to Mode Analytics
Introduction to the Course Dataset
()
Data of Unknown Quality-Data of Unknown Quality
Error Codes (Solution)
()
Flexible Data Formats
()
Flexible Data Formats (Solution)
()
Identifying Unreliable Data + Nulls
()
Unreliable Data - Part 1 (Solution)
()
Unreliable Data -Part 2 (Solution)
()
Unreliable Data - Part 3 (Solution)
()
Answering Ambiguous Questions
()
Users Table (Solution)
()
Data of Unknown Quality-Review
Not Dumb Questions
Creating Clean Datasets-Creating Clean Datasets
Creating Clean Datasets Introduction
()
Tools of the Trade: Coding Guide with Sublime Text (Optional)
()
Data Types
()
What is a Dependency?
()
Create a View-Item Table
()
Turn a Clean Query Into a Table (Activity/Solution)
()
Hierarchy of Data
()
Create User Info Table
()
Create a User Snapshot Table (Activity/Solution)
()
Partitions in Hive (Optional)
()
SQL Problem Solving-SQL Problem Solving
Introduction to SQL Problem Solving
()
Map Out Your Joins
()
Test Queries vs Final Queries
()
Example: Create an Aggregate Table with a Rolling Date Period
()
Rolling Orders (Solution)
()
Find Each User's Most Recently Viewed Page for an Email Campaign
()
Review Windowing Functions
()
Promo Email (Solution)
()
Product Analysis
()
Product Analysis (Solution)
()
Coding with Style
()
Case Study: AB Testing-Case Study: AB Testing
How is AB Testing Used?
()
Statistics Refresher (Optional)
()
Test Assignments
()
Test Assignments (Solution)
()
Create a New Metric
()
Creating a New Metric (Solution)
()
Analyze Results
()
Analyzing Results (Solution)
()
Case Study: AB Testing-Final Project
Peer Review Overview
()
Additional Thoughts for the Final Project
Case Study: AB Testing-Course Summary
Additional Practice and Reading (Optional)
Course Summary
()