Kimball Vs. Inmon! Data Warehouse Architectures Compared and Explained

Two teams get the same brief. One builds an integrated, normalized warehouse first; the other ships a star schema and builds the next one. Both end up with stars. So which team should you join? This is Kimball vs Inmon compared from the source material: Inmon's papers, the Kimball Group's own articles, and Oracle's data warehousing guide. You'll see what each architecture actually is, the myth about each one that turns out to be wrong, and the single difference the whole argument comes down to, which is where integration happens. Then the same order-to-cash process built both ways (nine normalized core tables against seven star tables), the same finance question queried against each, a head-to-head on time to first report, new source systems, query simplicity and single source of truth, and where dbt, the medallion architecture and Data Vault sit on the map today. I call a winner, and name the two conditions that would make me switch. ⏱️ Chapters 0:00 - Two teams, one brief 1:16 - Inmon's warehouse: integrated and normalized 2:04 - The Inmon myth: years of modeling first 2:36 - Kimball's four-step dimensional design 3:03 - Conformed dimensions and the bus matrix 3:25 - The Kimball myth: departmental summary marts 4:10 - The real difference: where integration happens 5:21 - Order to cash, built both ways 6:38 - One finance question, two queries 7:06 - Head-to-head on four dimensions 8:43 - dbt, medallion architecture and Data Vault 10:13 - The verdict: my pick 10:59 - Two conditions that flip it to Inmon 11:43 - Recap 🔗 Links Kimball Group dimensional modeling techniques: https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/ Oracle Data Warehousing Guide: https://docs.oracle.com/en/database/oracle/oracle-database/ dbt project structure guide: https://docs.getdbt.com/best-practices/how-we-structure/1-guide-overview Databricks medallion architecture: https://www.databricks.com/glossary/medallion-architecture Data Vault: https://datavaultalliance.com #Kimball #Inmon #kimballvsinmon #datawarehouse #datawarehousearchitecture #datamodeling #dimensionalmodeling #starschema #conformeddimensions #busmatrix #thirdnormalform #DataVault #medallionarchitecture #dbt #dataengineering