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

Project Description

As a project, lets try and make the list of tables/entities required for us to set up a Coffee shop. Please note, this is not a data modeling exercise. Think in the lines of what is required for the set up from the raw material perspective and how to collect information from multiple sources and centralize this. 

Note: This might sound very silly and simple exercise for the experienced. But, for the beginners it will give an idea on what is required based on the concepts learnt. 

Student Projects