Bus Matrix… the foundation of your Data Warehouse. Bill Anton Prime Data Intelligence. About Me. I Love Data! …also, Microsoft DW/BI (MCTS/MCITP, MCSA/MCSE) Independent Consultant @ Prime Data Intelligence, LLC Atlanta BI SQL Server Users Group Twitter: @ SQLbyoBI
Prime Data Intelligence
Question: What are the most common types of Data Warehouse methodologies/architectures?
Question: For which of these DW methodologies should you include a dimensional model? Kimball, Inmon, Data Vault
All of them
See TeoLachev’s “WHY SEMANTIC LAYER” newsletter:http://www.prologika.com/Newsroom/Newsletter2013Fall.aspx
“Conformed Dimensions”A conformed dimension is a set of data attributes that have been physically referenced by multiple fact tables using the same key value to refer to the same structure, attributes, domain values, definitions and concepts.
Dimensions are conformed when they are either exactly the same(including keys) or one is a perfect subsetof the other.
Dimension tables are NOTconformed if the attributes are labeled differently or contain different values.
Sum of each month ending inventory cost
Average Monthly GMROII
Profit for total time period
Turns into this ^^
What about a Bus Matrix?
2-dimensional visualization showing the intersection of facts and dimensions
Sprint 1Internet Sales
Sprint 2Reseller Sales
Manual via Excel
Automated via SSRS
Based on example from Alex Whittleshttp://www.purplefrogsystems.com/blog/2010/09/olap-cube-documentation-in-ssrs-part-1/