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