Conformed Dimensions and the Bus Matrix in SQL
Joining two fact tables made 25 pounds of refunds look like 50, and drilling across fixed it.
Video #259 ยท Data modelling
Steps in the video
Files
- bus.py (73 lines)
- run.py (65 lines)
- source.py (18 lines)
Tested with
Python 3.12.15
What this does not show
Three made-up processes in SQLite; it shows drilling across and two failures, not shrunken rollup dimensions or speed.
Sources
- https://www.kimballgroup.com/?p=19357
- https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/
- https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/conformed-dimension/
- https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/drilling-across/
- https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/enterprise-data-warehouse-bus-matrix/
- https://www.sqlite.org/pragma.html
Learning IT by Example.