Ismail in an explorer's hat on a contour map, beside a signpost from raw data to stg_orders, fct_orders and a dashboard

The Analytics Engineer’s Field Guide

Start here if dbt, Airflow or Snowflake are new to you. Some SQL is all you need.

dbt, Airflow and Snowflake on one pipeline, from your first model to a warehouse that’s fast and cheap.

  • Turn a SQL script into a tested, documented dbt model
  • Write your first Airflow DAG, then run dbt on it with Cosmos
  • Read a Snowflake query profile and bring the bill down
  • Finish on a full case study, the IsmaFrost pizzeria

34 lessons, each ending with a quiz, 6 challenges, 120 questions

Contents

Open any lesson.

Course format

Each lesson ends with a three-question quiz, and you pass it by getting all three right. Each dbt and Airflow part then ends with a three-question challenge. A lesson counts as read once you reach the end of its text or click Next at the bottom, and you can untick it. Challenges count when you finish them. Progress is saved automatically, and a private link moves it to another device.