Three data marts, three truths about sales: the bus matrix as common ground
What the Kimball bus matrix is and how to build it: business processes in rows, conformed dimensions in columns, to align data marts. Real insurance case.

What the Kimball bus matrix is and how to build it: business processes in rows, conformed dimensions in columns, to align data marts. Real insurance case.

SCD Type 2 in the data warehouse: historicising dimensions with surrogate keys and validity dates. Real case: a customer dimension that evolves over time.

Data warehouse: fact table grain determines which questions you can answer. Common mistakes in granularity and their impact on the dimensional model.
Start typing to search…
Select a result to see the preview