Company Logo

AnalyticsExpert

Master dbt, Snowflake, Iceberg, and Airflow — and become the analytics engineer every data team fights to hire.

Course syllabus

166 lessons • 129+ hours of content • 23 assignments

Kickoff
1
Understanding Capstone Requirements
2
Analytics Engineering Bootcamp Kickoff
3
Capstone Requirements
4
Data Expert.io Architecture
5
Onboarding Guide for the Data and AI Engineering Bootcamp
Week 1: dbt Basics
1
dbt basics: How dbt works: sources, models, packages Lecture
2
dbt basics: How dbt works: sources, models, packages Lab
3
dbt basics: creating a full dbt project lecture
4
dbt basics: creating a full dbt project lab
5
Build your first pipeline with dbt
6
dbt basics Day1 Lab
7
dbt basics Day2 Lecture
8
dbt basics Day2 Lab
9
dbt basics Day 1 Lecture
10
dbt basics Day 1 Lab
11
dbt basics Day 2 Lecture
12
dbt basics Day 2 Lab
Week 2: Advanced dbt
1
Advanced dbt Lecture Day 1
2
Advanced dbt Lab Day 1
3
Advanced dbt Lecture Day 2
4
Advanced dbt Lab Day 2
5
Advanced dbt: Understanding incremental models Lecture
6
Advanced dbt: Understanding incremental models Lab
7
Advanced pipelines: Blue-green and WAP with Airflow Lecture
8
Advanced pipelines: Blue-green and WAP with Airflow Lab
9
advanced dbt Day 1 Lecture
10
advanced dbt Day 1 Lab
11
advanced dbt Day 2 Lecture
12
advanced dbt Day 2 Lab
Week 3: Snowflake + dbt Basics
1
Snowflake Basics Day 1 Lecture
2
Snowflake Basics Day 1 Lab
3
dbt Basics Day 2 Lecture
4
dbt Basics Day 2 Lab
5
dbt Basics Day 3 Lecture
6
dbt Basics Day 3 Lab
Week 4: Snowflake + Advanced dbt
1
Snowflake Lecture
2
Snowflake Lab
3
Advanced dbt Day 2 Lecture
4
Advanced dbt Day 2 Lab
5
Advanced dbt Day 3 Lecture
6
Advanced dbt Day 3 Lab
Week 5: Data Modeling on Snowflake
1
Conceptual Data Modeling Lecture Day 1
2
Conceptual Data Modeling Lab Day 1
3
How to use Snowpark and Snowflake Optimizations Lecture Day 2
4
How to use Snowpark and Snowflake Optimizations Lab Day 2
5
Advanced Snowflake Data Modeling and UDFs Lecture Day 3
6
Advanced Snowflake Data Modeling and UDFs Lab Day 3
Week 6: Advanced Snowflake
1
Advanced snowflake: Deploying the Capstone dag Lecture
2
Advanced snowflake: Deploying the Capstone dag Lab
3
Advanced Snowflake: Data Modeling and UDFs Lecture
4
Advanced Snowflake: Data Modeling and UDFs Lab
5
Master Advanced Snowflake Data Modeling with the VARIANT data type
6
How to connect Iceberg and Snowflake with Catalogs
7
Advance Snowflake Day 2 Lecture
8
Advance Snowflake Day 2 Lab
Week 7: Data Modeling on Iceberg
1
Apache Iceberg Lecture Day 1
2
Apache Iceberg Lab Day 1
3
Apache Iceberg Lecture Day 2
4
Apace Iceberg Lab Day 2
5
Apache Iceberg Lecture Day 3
6
Apache iceberg Lab Day 3
7
Apache Iceberg Lecture Day1
8
Apache Iceberg Lab Day1
9
Apache Iceberg Lecture Day2
10
Apache Iceberg Lab Day2
11
Apache Iceberg Lecture Day3
12
Apache Iceberg Lab Day3
Week 8: Airflow & Pipeline Specs
1
How to build job orchestration that matters
2
Injecting quality into your Airflow DAG Lab
3
How to load data into Iceberg with Airflow
4
Airflow Day2 Lab
5
Backfilling with Airflow
6
Write a comprehensive pipeline spec document
7
Write a comprehensive pipeline spec document Lab
8
Orchestration and Airflow Fundamentals Lecture
9
Orchestration and Airflow Fundamentals Lab
Week 9: Airflow + Trino
1
Orchestration and Airflow Fundamentals Day 1 Lecture
2
Orchestration and Airflow Fundamentals Day 1 Lab
3
Hard Orchestration Lessons Day 2 Lecture
4
Hard Orchestration Lessons Day 2 Lab
5
Cumulative DAGs in Production Day 3 Lecture
6
Cumulative DAGs in Production Day 3 Lab
Week 10: Analytical Patterns & CDC
1
How to do Growth Accounting like Meta
2
Growth Accounting Lab
3
Mastering Change Data Capture (CDC)
4
Change Data Capture Lab
5
Snowflake and Glue Catalog Integration Lab
6
Understanding Read Streams and SCD Implementation Lab
7
Change Data Capture (CDC) and Snowflake basics Lecture
8
Change Data Capture (CDC) and Snowflake basics Lab
9
How to use snowpark and Snowflake optimization Lecture
10
How to use snowpark and Snowflake optimization Lab
11
Growth Accounting Models Lecture
12
Growth Accounting Models Lab
13
Grouping sets and Window functions Lecture
14
Grouping sets and Window functions Lab
Week 11: End-to-End Project Hacking
1
Capstone Project Day 1 Lecture
2
Capstone Project Day 1 Lab
3
Capstone Project Day 2 Class
4
Capstone Project Day 3 Class
Week 12: Passing Analytics Engineer Interviews
1
SQL
Capstone Project
1
Lesson 1
Q&A with Zach
1
Q&A with Zach Week 1
2
Q&A with Zach Week 2
3
Q&A with Zach Week 3
4
Q&A with Zach Week 4
5
Q&A with Zach Week1
6
Q&A with Zach Week2
7
Q&A with Zach Week3
8
Q&A with Zach Week4
9
Q&A with Zach Week5
Tech Talks
1
Tech Talk 1 - Jess Ramos
2
Tech Talk 2 - Madison
3
Tech Talk 3 - Ben Rogojan
4
Tech Talk 4 - John Kutay
5
Tech Talk 5 - Carly Taylor
6
Tech Talk 6 - Vin Vashishtha
7
Tech Talk 7 - Parth Parekh
8
Tech Talk 8 - Prasad Rao
9
Tech talk with Andrew Madson
10
Tech talk with Gourav Khanijoe
11
Tech talk with Carly Taylor
12
Tech talk with Jess Ramos
13
Tech talk with Madison Schott
14
Tech talk with Vaishali Macwan
15
Tech talk with Tim Chan
16
Tech Talk - Joe
17
Tech Talk - Madison
18
Tech Talks - Carly
19
Tech Talk - Raaid
20
Tech Talk - Parth
TA Office Hours
1
TA Office Hour 1
2
TA Office Hour 2
3
TA Office Hour 3
4
TA Office Hour 4
5
TA Office Hour 5
6
TA Office Hour 6
7
Office Hour 1
8
Office Hour 2
9
Office Hour 3
10
Office Hour 4
11
TA Office hour 1
12
TA Office hour 2
13
TA Office hour 3
14
TA Office hour 4
15
TA Office hour 5
16
TA Office hour 6
17
TA Office hour 7
18
TA Office hour 8
Career Development
1
Build-a-Resume!
2
LinkedIn Like Pro!
3
Career Dev Session 1
4
Career Dev Session 2
5
Career Dev Session 3
6
Career Dev Session 4
7
Career Dev Session 5
Bonus
1
Complex Data Types Lecture
2
Complex Data Types Lab
3
Slowly Changing Dimensions Lecture
4
Slowly Changing Dimensions Lab
5
Graph Data Modeling Lecture
6
Graph Data Modeling Lab
7
Fact Data Modeling Lecture
8
Fact Data Modeling Lab
9
Data modeling with Date lists Lecture
10
Data modeling with Date lists Lab

Get updates for AnalyticsExpert

We'll notify you about updates, new content, and special offers.