Get my Modern Data Essentials training (for free) & start building more reliable data architectures
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
- Data Modeling Tutorial: Star Schema (aka Kimball Approach) ( Download)
- Let's Compare the Kimball and Inmon Data Warehouse Architectures ( Download)
- What is STAR schema | Star vs Snowflake Schema | Fact vs Dimension Table ( Download)
- Master Dimensional Modeling Lesson 01 - Why Use a Dimensional Model ( Download)
- DIMENSIONAL DATA MODELING TUTORIALS - STAR SCHEMA | Based on a case study | Part 1 ( Download)
- Dimensional Data Model Tutorial - A Kimball Style Data Model ( Download)
- New to Data Modelling Watch This First | Kimball, Star Schema ( Download)
- Comparing 3 Types of Data Modeling (Normalized vs Star Schema vs Data Vault) ( Download)
- Is the Kimball Data Warehouse Still Relevant in 2023 ( Download)
- What is Data Modelling Beginner's Guide to Data Models and Data Modelling ( Download)
- Data warehouse schema design - dimensional modeling and star schema ( Download)
- Data modeling interview filters so many data engineers! How to model slowly-changing dimensions ( Download)
- Data Modeling (Star Schema 🌟) in Power BI – Creating Dimension Tables ( Download)
- Data Modeling in the Modern Data Stack ( Download)
- Data Modeling - Walking Through How To Data Model As A Data Engineer - Dimensional Modeling 101 ( Download)
