Data Modeling Tutorial: Star Schema (aka Kimball Approach)

Get my Modern Data Essentials training (for free) & start building more reliable data architectures
https://www.ModernDataCommunity.com

-----

It's hard to last as a data engineer without understanding basic data modeling.

In this video we'll cover the basics of one of the most common approaches: Star Schema data modeling.

...Aka Kimball modeling.

...Aka Dimensional modeling.

We'll discuss the high level concepts, I'll show how to build one from scratch and we'll end with a review of the benefits & future topics to explore.

Thank you for watching!

Timestamps:
00:00 - Intro
00:31 - High-level Overview
01:35 - Intro to Fact Tables
03:56 - Create a Fact Table
07:25 - Intro to Dimension Tables
08:43 - Create Dimension Tables
11:53 - Join to Create Marts
14:55 - Benefits & Future Topics


Title & Tags:
Data Modeling Tutorial: Star Schema (aka Kimball Approach)
#kahandatasolutions #dataengineering #datamodeling