Kimball & Ross - The Data Warehouse Toolkit 2nd... -
: Determine exactly what one row in the fact table represents (e.g., one line item on a retail receipt).
: Choose the descriptive context ("who, what, where, when") for the measurements. Kimball & Ross - The Data Warehouse Toolkit 2nd...
: Select the numeric, quantitative measurements resulting from the business process. Core Modeling Techniques : Determine exactly what one row in the
The book famously outlines a four-step process for designing dimensional models: Kimball & Ross - The Data Warehouse Toolkit 2nd...
: Identify the operational activity to be modeled (e.g., retail sales, insurance claims).