Learn Analytics Engineering

Learn Analytics Engineering

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

Data Modeling

4 Things to STOP Doing
...if you want to become a better analytics engineer this year
How to Decide on a Data Model Design
The order of operations, key design principles, and common pitfalls to avoid
How NOT to Use Medallion Architecture
Differences between them and how to use them together while avoiding the most common mistakes and anti-patterns
How to Build Incremental Models
dbt vs SQLMesh and what is happening beneath the shiny syntax
Data Modeling Solves What Semantic Layers Can't
Why you need to fix the foundation before you can build more systems
Data model too coarse?
What is grain and why it's everything in data modeling
7 Data Modeling Concepts You Must Know
An introduction to Data Modeling May
Data Modeling is NOT Dead
Why it can't (and shouldn't) be replaced by AI
Your Guide to Slowly Changing Dimensions (SCDs)
What they are, why they're important, and the 4 different types
7 Data Modeling Concepts You Must Know
Easy-to-understand explanations of foundational terminology
Data Modeling 101: Keys
Surrogate vs composite keys- what they are, when to use them, and how to generate them
© 2026 Madison Mae · Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture