[Verse 1]
In the world of data warehousing there's a name you need to know
Ralph Kimball showed us how to make our business insights flow
He said forget complex structures that are hard to understand
Build it simple, build it clear, with a well-designed plan
[Chorus]
Facts and dimensions, that's the key
Star schema makes it easy to see
Facts in the middle, dimensions around
Business intelligence can be found
Facts are numbers, dimensions describe
That's how we keep our data alive
[Verse 2]
Start with business questions, what do users want to know
Sales and inventory, how fast does revenue grow
Put the measurements in fact tables, every metric that you track
Quantities and dollars, never looking back
[Chorus]
Facts and dimensions, that's the key
Star schema makes it easy to see
Facts in the middle, dimensions around
Business intelligence can be found
Facts are numbers, dimensions describe
That's how we keep our data alive
[Verse 3]
Dimension tables hold the context, who and what and where and when
Customer and product data, again and again
Foreign keys connect them to the facts that matter most
Star pattern makes it simple from coast to coast
[Bridge]
Kimball taught us grain is crucial
Pick the lowest level that's useful
Additive facts work best of all
Semi-additive can sometimes fall
Build it right the first time through
Your analysts will thank you too
[Chorus]
Facts and dimensions, that's the key
Star schema makes it easy to see
Facts in the middle, dimensions around
Business intelligence can be found
Facts are numbers, dimensions describe
That's how we keep our data alive
[Outro]
So remember Ralph Kimball's way
Structure data for the business day
Stars will guide your warehouse design
Making analytics work just fine