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:
“Ah, Sun-flower, weary of time,
Who countest the steps of the Sun,
Seeking after that sweet golden clime
Where the traveller’s journey is done:
Where the Youth pined away with desire,
And the pale Virgin shrouded in snow
Arise from their graves, and aspire
Where my Sun-flower wishes to go.”
—William Blake (1757–1827)
“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)
“[Women’s] apparent endorsement of male supremacy is ... a pathetic striving for self- respect, self-justification, and self-pardon. After fifteen hundred years of subjection to men, Western woman finds it almost unbearable to face the fact that she has been hoodwinked and enslaved by her inferiors—that the master is lesser than the slave.”
—Elizabeth Gould Davis (b. 1910)
“For who is greater, the one who is at the table or the one who serves? Is it not the one at the table? But I am among you as one who serves.”
—Bible: New Testament, Luke 22:27.