Summary

Keywords

analytics data warehousing big data business intelligence star schema data warehouse power bi data modeling power bi star schema power bi data modeling fact table dimension data model

Full Transcript

All my FREE resources: https://www.skool.com/moderndata/about Consulting Services: https://go.kahandatasolutions.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

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

Excel for HR Full Course

Unlock HR Potential with Masterful Excel Skills! Enhance your HR expertise from beginner to advanced in engaging, in-depth tutorials. Transform data handling and strategic planning with ease and confidence!

⭐ 4.0

2 ratings

4 hours

Google Data Analytics Professional Certificate

⭐ 4.0

5 ratings

11 min

Database Design & Management Class!

Unlock the Power of Databases: From Fundamentals to Advanced SQL Techniques! Dive deep into database purpose, design, and optimization with Dr. Daniel Soper's comprehensive course—your gateway to mastering data management and analytics!

⭐ 4.0

6 ratings

18.3 hours