Transcription of Kimball Dimensional Modeling Techniques
{{id}} {{{paragraph}}}
Example: dental hygienist
Kimball Dimensional Modeling Techniques
Kimball Dimensional Modeling Techniques Table of Contents Fundamental Concepts .. 1 Gather business Requirements and Data Realities .. 1 Collaborative Dimensional Modeling Workshops .. 1 Four-Step Dimensional Design process .. 1 business Processes .. 1 Grain .. 2 Dimensions for Descriptive Context .. 2 Facts for Measurements .. 2 Star Schemas and OLAP cubes .. 2 Grace Extensions to Dimensional Modeling .. 3 Basic Fact Table Techniques .. 4 Fact Table Structure .. 4 Additive, Semi-Additive, and Non-Additive Facts .. 4 Nulls in Fact Tables .. 4 Conformed Facts.
Select the business process. 2. Declare the grain. 3. Identify the dimensions. 4. Identify the facts The answers to these questions are determined by considering the needs of the business along with the realities of the underlying source data during the …
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: