Download
introduction to dimensional modeling n.
Skip this Video
Loading SlideShow in 5 Seconds..
Introduction To Dimensional Modeling PowerPoint Presentation
Download Presentation
Introduction To Dimensional Modeling

Introduction To Dimensional Modeling

166 Views Download Presentation
Download Presentation

Introduction To Dimensional Modeling

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Introduction To Dimensional Modeling Mike Davis

  2. About Mike Davis • MCTS, MCITP • SQL Author • Managing Project Lead

  3. Our Agenda • What is Dim Modeling • Ten Kimball Rules • Dimension Types • Examples

  4. What is Dimensional Modeling? • Analyzing OLTP system • Business Questions • Where clauses • Fact and Measures

  5. Ten Rules of the Kimball method 1: Load detailed atomic data into dimensional structures 2: Structure dimensional models around business processes 3: Ensure that every fact table has an associated date dimension table

  6. Ten Rules of the Kimball method 4: Ensure that all facts in a single fact table are at the same grain or level of detail 5: Resolve many-to-many relationships in fact tables 6: Resolve many-to-one relationships in dimension tables

  7. Ten Rules of the Kimball method 7: Store report labels and filter domain values in dimension tables. 8: Make certain that dimension tables use a surrogate key 9: Create conformed dimensions to integrate data across the enterprise. 10: Continuously balance requirements and realities to deliver a DW/BI solution that's accepted by business users and that supports their decision-making.

  8. Different Dimension Types • Type 0 -Static • Type 1 - Updated • Type 2 - Historical • Many to Many

  9. Examples • Don’t try to tackle it All! • Business Units • Usable Data Marts

  10. Introduction to Dimensional Modeling • My Blog: MikeDavisSQL.com and BIDN.com • Follow me on Twitter:@MikeDavisSQL