Kimball Dimensional Modeling Techniques

← Back to document page

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.

Kimball Dimensional Modeling Techniques 2 Grain Declaring the grain is the pivotal step in a dimensional design. The grain establishes exactly what a single fact table row represents. The grain declaration becomes a binding contract on the design. The

  Modeling, Technique, Dimensional, Dimensional modeling techniques