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 in, steps, designing, fact and/or table:
“Now Morn her rosy steps in th’ eastern clime
Advancing, sowed the earth with orient pearl.”
—John Milton (1608–1674)
“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)
“Apart from the fact that women posess the equipment for lactation, mothers seem no more predisposed to, or innately skilled at, child care than are fathers, siblings or non parents. Besides, women obviously come in a variety of shapes, sizes, talents and temperaments. Why shouldn’t they vary in degrees of motherhood?”
—Shari Thurer (20th century)
“They were not on the table with their elbows.
They were not sleeping in the shelves of bunks.
I saw no men there and no bones of men there.”
—Robert Frost (1874–1963)