Introduction to dimensional modeling
Download
1 / 10

Introduction To Dimensional Modeling - PowerPoint PPT Presentation


  • 129 Views
  • Uploaded on

Introduction To Dimensional Modeling. Mike Davis. About Mike Davis. MCTS, MCITP SQL Author Managing Project Lead. Our Agenda. What is Dim Modeling Ten Kimball Rules Dimension Types Examples. What is Dimensional Modeling?. Analyzing OLTP system Business Questions Where clauses

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Introduction To Dimensional Modeling' - chester-gilliam


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


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

About mike davis
About Mike Davis

  • MCTS, MCITP

  • SQL Author

  • Managing Project Lead


Our agenda
Our Agenda

  • What is Dim Modeling

  • Ten Kimball Rules

  • Dimension Types

  • Examples


What is dimensional modeling
What is Dimensional Modeling?

  • Analyzing OLTP system

  • Business Questions

  • Where clauses

  • Fact and Measures


Ten rules of the kimball method
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


Ten rules of the kimball method1
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


Ten rules of the kimball method2
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.


Different dimension types
Different Dimension Types

  • Type 0 -Static

  • Type 1 - Updated

  • Type 2 - Historical

  • Many to Many


Examples
Examples

  • Don’t try to tackle it All!

  • Business Units

  • Usable Data Marts


Introduction to dimensional modeling1
Introduction to Dimensional Modeling

  • My Blog: MikeDavisSQL.com and BIDN.com

  • Follow me on Twitter:@MikeDavisSQL


ad