1
Getting Started
Course Introduction
Free
Meet the Instructor
Free
Course Outline
Free
Setting Expectations
Free
2
Analytics Engineering Overview
Section Intro
Free
What is Analytics Engineering?
Free
History of Analytics Engineering
Free
Before vs After Analytics Engineering
Free
QUIZ: Analytics Engineering Overview
Pro
3
The Modern Data Stack
Section Intro
Pro
Data Architectures
Pro
Data Pipelines
Pro
Modern Data Stack Tools
Pro
Modern Data Stack Summary
Pro
QUIZ: The Modern Data Stack
Pro
4
Common AE Scenarios
Section Intro
Pro
Scenario 1: Multiple Sources of Truth
Pro
Scenario 2: Raw to BI Ready Data
Pro
Scenario 3: Metric Changes
Pro
Analytics Engineer Responsibilities
Pro
QUIZ: Common AE Scenarios
Pro
5
Data Terms & Definitions
Section Intro
Pro
Data vs Metadata
Pro
Databases
Pro
Data Lakes
Pro
Data Warehouses
Pro
Data Marts
Pro
Lakehouses
Pro
Data Term Summary
Pro
Storage Solutions in Practice
Pro
QUIZ: Data Terms & Definitions
Pro
6
OLTP vs OLAP
Section Intro
Pro
AE Acronyms Overview
Pro
OLTP vs OLAP
Pro
OLTP Example
Pro
OLAP Example
Pro
OLTP to OLAP Summary & FAQs
Pro
QUIZ: OLTP vs OLAP
Pro
7
ETL vs ELT
Section Intro
Pro
ETL: Extract-Transform-Load
Pro
ELT: Extract-Load-Transform
Pro
ETL vs ELT Summary & FAQs
Pro
QUIZ: ETL vs ELT
Pro
8
Key Takeaways
Section Intro
Pro
AE Overview Key Takeaways
Pro
AE Foundations Key Takeaways
Pro
9
Course Feedback & Next Steps
Course Feedback Survey
Pro
Share the Love!
Pro
Next Steps
Pro