Learn Analytics Engineering

Learn Analytics Engineering

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

Data Modeling

I was wrong about semantic layers.
Why semantic layers are more important now than they ever were, and testing out a cool new open-source tool to help you build one effectively
Jun 11
How to Leverage Claude for Data Analysis
A deep dive into the 3 things you must have in your dbt project to do so
Mar 26
Cursor for Analytics: Where it Fails and Where it Thrives
A step-by-step workflow walk-through with code samples and screenshots
Feb 26
The Truth of Self-Service Analytics
The 4 things that need to be true before self-service BI is even possible.
Feb 19
Will AI Replace Data Modeling?
3 reasons why this is the hardest data skill to hand over to AI
Feb 12
4 Things to STOP Doing
...if you want to become a better analytics engineer this year
Feb 5
How to Decide on a Data Model Design
The order of operations, key design principles, and common pitfalls to avoid
Jan 29
How NOT to Use Medallion Architecture
Differences between them and how to use them together while avoiding the most common mistakes and anti-patterns
Jan 22
How to Build Incremental Models
dbt vs SQLMesh and what is happening beneath the shiny syntax
Dec 11, 2025
Data Modeling Solves What Semantic Layers Can't
Why you need to fix the foundation before you can build more systems
Dec 4, 2025
Data model too coarse?
What is grain and why it's everything in data modeling
May 22, 2025
7 Data Modeling Concepts You Must Know
An introduction to Data Modeling May
May 8, 2025
© 2026 Madison Mae · Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture