The Analytics Engineer's Guidebook

Serving quality SQL since 1999

*** WELCOME to the Premiere Source for Modern Data Stacks! *** NEW: Semantic Layers Explained! *** Best viewed with a cup of Java! *** Don't forget to sign the Guestbook! ***

Analytics Engineering for K-12

Welcome to the premiere destination for learning Modern Data Stacks in a K-12 context. This 10-module course will take you from SQL novice to Semantic Layer superhero.

Course Announcements

  • Oct 12, 1999 (2025): Module 4 (AI Tools) is now live!
  • Sept 05, 1999 (2025): Enrollment open for the Winter cohort.
  • Aug 20, 1999 (2025): Site launch! Get ready to build.

Why this course?

Education data is messy. You have SIS exports, assessment flat files, and discipline records all over the place. In this course, we use dbt, BigQuery, and AI Coding Assistants to tame the chaos.

What you will build:

  • A full dbt project from scratch
  • A semantic layer for student metrics
  • Automated testing pipelines with Datafold
  • Shiny dashboards in Looker Studio


Students Enrolled: