Advance Data Warehousing

Data Warehousing Concepts

• Dimensional Modelling
  • Star Schema
  • Galaxy Schema
  • Snowflake Schema
  • Starflake Schema
  • Star vs Snowflake
  • GRAIN
  • Multi-Fact Star Schema
  • Vertabelo Tool
• Dimension - Fact
• Sample Excercise
• Keys
  • Why Surrogate Keys are Important
• More Examples
• Master Data Management
• Steps of Dimensional Modeling
• Types of Dimensions
  • Date Dimension Table
  • Degenerate Dimension
  • Junk Dimension
  • Static Dimension
  • Conformed Dimensions
  • Slowly Changing Dimensions
    • SCD - Type 0
    • SCD - Type 1
    • SCD - Type 2
    • SCD - Type 3
    • SCD - Type 4
    • SCD - Type 6
    • SCD - Type 5 - Fun Fact
  • Role Playing Dimension
  • Conformed vs Role Playing
  • Shrunken Dimension
  • Swappable Dimension
  • Step Dimension
  • Temporal
• Types of Facts
  • Factless Fact Table
  • Transaction Fact
  • Periodic Fact
  • Accumulating Snapshot Fact Table
  • Transaction vs Periodic vs Accumulating
  • Additive, Semi-Additive, Non-Additive
  • Periodic Snapshot vs Additive
  • Conformed Fact
• Sample Data Architecture Diagram
• Data Pipeline Models
• New DW Concepts