AnalyticsExpert
Master dbt, Snowflake, Iceberg, and Airflow — and become the analytics engineer every data team fights to hire.
Status
Not Enrolled
This program is not accepting enrollments right now!
Program Structure
1
Kickoff
5 Lessons•3h 8m
2 Assignments
2
Week 1: dbt Basics
12 Lessons•10h 16m
3 Assignments
Lessons
dbt basics: How dbt works: sources, models, packages Lecture
43m
dbt basics: How dbt works: sources, models, packages Lab
36m
dbt basics: creating a full dbt project lecture
28m
dbt basics: creating a full dbt project lab
49m
Build your first pipeline with dbt
59m
dbt basics Day1 Lab
55m
dbt basics Day2 Lecture
55m
dbt basics Day2 Lab
58m
dbt basics Day 1 Lecture
60m
dbt basics Day 1 Lab
51m
dbt basics Day 2 Lecture
49m
dbt basics Day 2 Lab
67m
3
Week 2: Advanced dbt
12 Lessons•10h 44m
3 Assignments
Lessons
Advanced dbt Lecture Day 1
54m
Advanced dbt Lab Day 1
60m
Advanced dbt Lecture Day 2
58m
Advanced dbt Lab Day 2
54m
Advanced dbt: Understanding incremental models Lecture
44m
Advanced dbt: Understanding incremental models Lab
34m
Advanced pipelines: Blue-green and WAP with Airflow Lecture
25m
Advanced pipelines: Blue-green and WAP with Airflow Lab
56m
advanced dbt Day 1 Lecture
68m
advanced dbt Day 1 Lab
60m
advanced dbt Day 2 Lecture
65m
advanced dbt Day 2 Lab
62m
4
Week 3: Snowflake + dbt Basics
6 Lessons•3h 30m
1 Assignment
5
Week 4: Snowflake + Advanced dbt
6 Lessons•4h 6m
1 Assignment
6
Week 5: Data Modeling on Snowflake
6 Lessons•5h 11m
1 Assignment
Lessons
Conceptual Data Modeling Lecture Day 1
57m
Conceptual Data Modeling Lab Day 1
51m
How to use Snowpark and Snowflake Optimizations Lecture Day 2
52m
How to use Snowpark and Snowflake Optimizations Lab Day 2
45m
Advanced Snowflake Data Modeling and UDFs Lecture Day 3
47m
Advanced Snowflake Data Modeling and UDFs Lab Day 3
58m
Assignments
7
Week 6: Advanced Snowflake
8 Lessons•6h 4m
2 Assignments
Lessons
Advanced snowflake: Deploying the Capstone dag Lecture
18m
Advanced snowflake: Deploying the Capstone dag Lab
47m
Advanced Snowflake: Data Modeling and UDFs Lecture
41m
Advanced Snowflake: Data Modeling and UDFs Lab
50m
Master Advanced Snowflake Data Modeling with the VARIANT data type
48m
How to connect Iceberg and Snowflake with Catalogs
55m
Advance Snowflake Day 2 Lecture
51m
Advance Snowflake Day 2 Lab
50m
8
Week 7: Data Modeling on Iceberg
12 Lessons•8h 58m
1 Assignment
Lessons
Apache Iceberg Lecture Day 1
40m
Apache Iceberg Lab Day 1
50m
Apache Iceberg Lecture Day 2
58m
Apace Iceberg Lab Day 2
32m
Apache Iceberg Lecture Day 3
47m
Apache iceberg Lab Day 3
55m
Apache Iceberg Lecture Day1
40m
Apache Iceberg Lab Day1
50m
Apache Iceberg Lecture Day2
46m
Apache Iceberg Lab Day2
32m
Apache Iceberg Lecture Day3
47m
Apache Iceberg Lab Day3
38m
Assignments
9
Week 8: Airflow & Pipeline Specs
9 Lessons•6h 46m
2 Assignments
Lessons
How to build job orchestration that matters
53m
Injecting quality into your Airflow DAG Lab
53m
How to load data into Iceberg with Airflow
59m
Airflow Day2 Lab
58m
Backfilling with Airflow
12m
Write a comprehensive pipeline spec document
47m
Write a comprehensive pipeline spec document Lab
35m
Orchestration and Airflow Fundamentals Lecture
43m
Orchestration and Airflow Fundamentals Lab
42m
10
Week 9: Airflow + Trino
6 Lessons•3h 44m
1 Assignment
Lessons
Assignments
11
Week 10: Analytical Patterns & CDC
14 Lessons•9h 2m
2 Assignments
Lessons
How to do Growth Accounting like Meta
46m
Growth Accounting Lab
61m
Mastering Change Data Capture (CDC)
49m
Change Data Capture Lab
13m
Snowflake and Glue Catalog Integration Lab
7m
Understanding Read Streams and SCD Implementation Lab
33m
Change Data Capture (CDC) and Snowflake basics Lecture
58m
Change Data Capture (CDC) and Snowflake basics Lab
40m
How to use snowpark and Snowflake optimization Lecture
48m
How to use snowpark and Snowflake optimization Lab
25m
Growth Accounting Models Lecture
51m
Growth Accounting Models Lab
38m
Grouping sets and Window functions Lecture
30m
Grouping sets and Window functions Lab
38m
Assignments
12
Week 11: End-to-End Project Hacking
4 Lessons•4h 54m
2 Assignments
13
Week 12: Passing Analytics Engineer Interviews
Lessons
14
Capstone Project
2 Assignments
15
Q&A with Zach
9 Lessons•7h 59m
16
Tech Talks
20 Lessons•17h 52m
Lessons
Tech Talk 1 - Jess Ramos
52m
Tech Talk 2 - Madison
58m
Tech Talk 3 - Ben Rogojan
55m
Tech Talk 4 - John Kutay
57m
Tech Talk 5 - Carly Taylor
56m
Tech Talk 6 - Vin Vashishtha
41m
Tech Talk 7 - Parth Parekh
58m
Tech Talk 8 - Prasad Rao
60m
Tech talk with Andrew Madson
52m
Tech talk with Gourav Khanijoe
52m
Tech talk with Carly Taylor
58m
Tech talk with Jess Ramos
56m
Tech talk with Madison Schott
33m
Tech talk with Vaishali Macwan
45m
Tech talk with Tim Chan
41m
Tech Talk - Joe
63m
Tech Talk - Madison
55m
Tech Talks - Carly
58m
Tech Talk - Raaid
55m
Tech Talk - Parth
58m
17
TA Office Hours
18 Lessons•15h 53m
Lessons
TA Office Hour 1
65m
TA Office Hour 2
39m
TA Office Hour 3
48m
TA Office Hour 4
75m
TA Office Hour 5
52m
TA Office Hour 6
57m
Office Hour 1
54m
Office Hour 2
114m
Office Hour 3
19m
Office Hour 4
46m
TA Office hour 1
40m
TA Office hour 2
58m
TA Office hour 3
62m
TA Office hour 4
49m
TA Office hour 5
45m
TA Office hour 6
44m
TA Office hour 7
38m
TA Office hour 8
39m
18
Career Development
7 Lessons•2h 46m
19
Bonus
10 Lessons•6h 46m
Lessons
Complex Data Types Lecture
48m
Complex Data Types Lab
30m
Slowly Changing Dimensions Lecture
46m
Slowly Changing Dimensions Lab
37m
Graph Data Modeling Lecture
38m
Graph Data Modeling Lab
42m
Fact Data Modeling Lecture
46m
Fact Data Modeling Lab
37m
Data modeling with Date lists Lecture
38m
Data modeling with Date lists Lab
39m