Learn Analytics Engineering

Learn Analytics Engineering

Data Modeling 101: Keys

Surrogate vs composite keys- what they are, when to use them, and how to generate them

Mar 07, 2024
∙ Paid

One of the skills every data person wants to learn and improve upon is data modeling.

Data modeling has been around long before the modern data stack. It’s nothing new. And I think that is what makes it so powerful.

Most technologies you spend time learning today will no longer be around 10-20 years from now. However, the core concepts behind them will.

Data modeling will last the test of time, and so will the foundational knowledge that you learn while studying it.

This being said, welcome to my new series- Data Modeling 101 🎉

Throughout this series, I will be introducing you to basic principles of data modeling- ones that will contribute to your foundational knowledge and last the test of time.

Learn Analytics Engineering is a reader-supported publication. To receive new posts and support my work, consider becoming a free or paid subscriber.

But first, I'm thinking about building a live, 2-week cohort-based course for aspiring analytics engineers on how to improve data quality with dbt.

You’ll learn how to build a dbt project, add tests, and utilize packages.

Fill out this survey to get on the waitlist & be the first to hear when enrollments open: https://lnkd.in/eEDXqdR5

Did you fill it out? Ok, cool, let’s get into Data Modeling 101!

Keep reading with a 7-day free trial

Subscribe to Learn Analytics Engineering to keep reading this post and get 7 days of free access to the full post archives.

Already a paid subscriber? Sign in
© 2025 Madison Mae
Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture