Master Data Warehouse Concepts - Step by Step from Scratch (Part 2) - Dimensional Modeling

Inf Sid, ETL/Data Architect

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
37 Lessons (2h 25m)
    • 1. Data Modelling Introduction

      2:13
    • 2. Data Modelling Techniques

      3:53
    • 3. Entity Relationship (ER) Data Model

      3:41
    • 4. ER Modelling Logical Design

      15:30
    • 5. ER Modelling Logical Design Entity

      1:59
    • 6. ER Modelling Logical Design Types of Entities 1

      4:01
    • 7. ER Modelling Logical Design Types of Entities 2

      2:09
    • 8. ER Modelling Logical Design Attributes

      1:54
    • 9. ER Modelling Logical Design Identifier

      2:02
    • 10. ER Modelling Logical Design Notation

      2:37
    • 11. ER Modelling Logical Design RelationShip

      1:15
    • 12. ER Modelling Logical Design Logical Data Model

      1:29
    • 13. LDM to PDM

      2:26
    • 14. Physical Design

      4:02
    • 15. Differences between CDM, LDM PDM

      3:30
    • 16. Disadvantages of ER Model

      3:33
    • 17. Dimensional Modeling - Introduction

      4:39
    • 18. Dimensional Modeling - Benefits

      1:50
    • 19. Dimensions Explained

      2:48
    • 20. Facts Explained

      2:05
    • 21. Additive Facts

      1:45
    • 22. Semi Additive

      2:28
    • 23. Non Additive Facts

      1:30
    • 24. FactLess Facts

      2:29
    • 25. Surrogate Keys

      4:01
    • 26. Star Schema

      5:23
    • 27. SnowFlake Schema

      3:25
    • 28. Galaxy Schema

      2:20
    • 29. Differences between Star and SnowFlake

      5:27
    • 30. Conformed Dimensions

      6:38
    • 31. Junk Dimension

      3:06
    • 32. Degenerate Dimension

      3:35
    • 33. SCD - Slowly Changing Dimensions

      5:30
    • 34. SCD Type 1 2 3

      12:30
    • 35. SCD Summary

      3:33
    • 36. Step by Step Approach of creating a Dimensional Model

      7:28
    • 37. Differences between ER and Dimensional Modeling For DWH

      5:50
How students rated this class
Leave Review

Watch more to review

We ask our students to watch a few lessons before reviewing to make sure we get quality feedback!

Best Suited for
 --  Beginner Intermediate Advanced Beginner/Intermediate Intermediate/Advanced All Levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Be the first!

No ratings just yet—watch a few lessons to be the first to share whether this class met your expectations.

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Be the first to leave a review in our updated system!
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update. You are welcome to edit your old review into the new system!

1 of 1 students recommend this class