Learn Analytics Engineering

Learn Analytics Engineering

Home
Data Pipeline Summer
Data 101
Back to the Basics with SQL
Data Modeling
Sponsorships
About

Data Pipeline Summer

How to Write a Good README
#6: How to build out your GitHub portfolio projects to attract potential employers
Orchestrate Hourly Models with SQLMesh
#5: Data Pipeline Summer- My dimensional data modeling solution and how to schedule it to run automatically using a local bash script and a cron job
Master the 4-Step Dimensional Modeling Process
#4: Data Pipeline Summer- Including a hands-on project teaching you how to create your own dimensional data model using business data
SQLMesh: The Next-Generation Open Source Data Transformation Tool
#3: Data Pipeline Summer Challenge- Including a hands-on project teaching you how to set up and use SQLMesh for data modeling
Why Use DuckDB?
#2: Data Pipeline Summer- How get started with DuckDB and when to use MotherDuck
4
How to Build an Open-Source Data Pipeline
#1: Data Pipeline Summer: A step-by-step transformation pipeline for subscription changes in Trail Trekker
3
How to Orchestrate Your Data Pipeline
Tasks, flows, and schedules- oh my!
3
How to Test Your Data Models with dbt
#5: Data Pipeline Summer
How to Write an Incremental Data Model with dbt
#4: Data Pipeline Summer Challenge
How to Ingest Data with Airbyte
#3: Data Pipeline Summer
How to Setup a Data Warehouse for Analytics
#2: Data Pipeline Summer Challenge
6
Building Blocks of a Data Pipeline
#1: Data Pipeline Summer Challenge
© 2025 Madison Mae
Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture