Chinh (lelouvincx) / Inmon - Data Warehousing

Created Mon, 25 May 2026 00:00:00 +0000 Modified Mon, 25 May 2026 06:02:25 +0000
79 Words
page

Keynote

  • Approach: top-down
  • The philosophy is having a centralized, high quality data warehouse
    • By maintaining an EDW - Enterprise Data Warehouse, storing all data as 3NF, aim for data quality and intergrity
    • Then so the star schema - dimensional modelling for each specific reporting topic (dataset)
  • 2-step process
      1. You model the data warehouse using 3NF to ensure truth, quality and consistency
      1. Then feed that data into data marts which use dimensional modeling for the actual BI reporting to consume