AnalyticsExpert logo

AnalyticsExpert

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

Course syllabus

121 lessons • 96+ hours of content • 18 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
Pre-Read - Data Modeling
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
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
Build your first pipeline with dbt Lab
7
Creating a full dbt Project Lecture
8
Creating a full dbt Project Lab
Week 2: Advanced dbt
1
Advanced dbt: Understanding incremental models Lecture
2
Advanced dbt: Understanding incremental models Lab
3
Advanced pipelines: Blue-green and WAP with Airflow Lecture
4
Advanced pipelines: Blue-green and WAP with Airflow Lab
5
Advanced dbt: Jinja, Macros and variables Lecture
6
Advanced dbt: Jinja, Macros and variables Lab
7
Advanced dbt: Production Pipelines and dbt with Airflow Lecture
8
Advanced dbt: Production Pipelines and dbt with Airflow Lab
Week 3: Data Modeling on Snowflake
1
Snowflake Basics Day 1 Lecture
2
Snowflake Basics Day 1 Lab
3
Conceptual Data Modeling Lecture Day 1
4
Conceptual Data Modeling Lab Day 1
5
How to use Snowpark and Snowflake Optimizations Lecture Day 2
6
How to use Snowpark and Snowflake Optimizations Lab Day 2
7
Advanced Snowflake Data Modeling and UDFs Lecture Day 3
8
Advanced Snowflake Data Modeling and UDFs Lab Day 3
Week 4: 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 5: Data Modeling on Iceberg
1
Apache Iceberg: Big Data History Lecture
2
Apache Iceberg: Partitioning, time travel for RCA and metadata Lab
3
Apache Iceberg: Data Lake Architectures Lecture
4
Apace Iceberg: Data Compression, Run length encoding Lab
5
Apache Iceberg: Data Contracts Lecture
6
Apache iceberg: WAP patterns and Querying branched Data Lab
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 6: Airflow & Pipeline Specs with Trino
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
Orchestration and Airflow Fundamentals Day 1 Lecture
7
Write a comprehensive pipeline spec document
8
Write a comprehensive pipeline spec document Lab
9
Orchestration and Airflow Fundamentals Lecture
10
Orchestration and Airflow Fundamentals Lab
11
Orchestration and Airflow Fundamentals Day 1 Lab
12
Hard Orchestration Lessons Day 2 Lecture
13
Hard Orchestration Lessons Day 2 Lab
14
Cumulative DAGs in Production Day 3 Lecture
15
Cumulative DAGs in Production Day 3 Lab
Week 7: 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 8: Capstone Project
1
Capstone Project Day 1 Lecture
2
Capstone Project Day 1 Lab
3
Capstone Project Day 2 Class
4
Capstone Project Day 3 Class
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
Expert Guest Sessions
1
Jess Ramos - Data Analyst
2
Madison Schott - Analytics Engineer
3
Ben Rogojan - Fractional Head of Data
4
John Kutay - Director of Engineering at Rippling
5
Carly Taylor - Field CTO at Databricks
6
Vin Vashishtha - Author of From Data to Profit
7
Parth Parekh - Director of Data Engineering at Meta
8
Prasad Rao - Principal Solutions Architect
9
Andrew Madson - Head of DevRel at Fivetran
10
Gourav Khanijoe - Engineering Lead at HubSpot
11
Carly Taylor - Field CTO at Databricks (2.0)
12
Jess Ramos - Data Analyst (2.0)
13
Madison Schott - Analytics Engineer (2.0)
14
Vaishali Macwan - Senior Data Scientist
15
Tim Chan - Data at OpenAI
16
Joe Reis - Author of Fundamentals of Data Engineering
17
Madison Schott - Analytics Engineer (3.0)
18
Carly Taylor - Field CTO at Databricks (3.0)
19
Raaid A. - AI, Data, & Product Strategy Leader
20
Parth Parekh - Director of Data Engineering at Meta (2.0)

Get updates for AnalyticsExpert

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