Steps in Designing A Fact Table
- Identify a business process for analysis (like sales).
- Identify measures or facts (sales dollar), by asking questions like 'What number of XX are relevant for the business process?', replacing the XX with various options that make sense within the context of the business.
- Identify dimensions for facts (product dimension, location dimension, time dimension, organization dimension), by asking questions that make sense within the context of the business, like 'Analyse by XX', where XX is replaced with the subject to test.
- List the columns that describe each dimension (region name, branch name, business unit name).
- Determine the lowest level (granularity) of summary in a fact table (e.g. sales dollars).
An alternative approach is the four step design process described in Kimball.
Read more about this topic: Fact Table
Famous quotes containing the words steps, designing, fact and/or table:
“All things uncomely and broken, all things worn out and old,
The cry of a child by the roadway, the creak of a lumbering cart,
The heavy steps of the ploughman, splashing the wintry mould,
Are wronging your image that blossoms a rose in the deeps of my heart.”
—William Butler Yeats (1865–1939)
“We’re designing a new spacecraft to be launched and there are no women. Where are they? I wonder. I worry.”
—Andrea Dupree (b. 1939)
“What makes the United States government, on the whole, more tolerable—I mean for us lucky white men—is the fact that there is so much less of government with us.... But in Canada you are reminded of the government every day. It parades itself before you. It is not content to be the servant, but will be the master; and every day it goes out to the Plains of Abraham or to the Champs de Mars and exhibits itself and toots.”
—Henry David Thoreau (1817–1862)
“In New York, pretending to be above the struggle means no seat on the bus and a table next to the kitchen.”
—Mason Cooley (b. 1927)