Time Dimension

In a relational data model, for normalization purposes, year lookup, quarter lookup, month lookup, and week lookups are not merged as a single table.  In a dimensional data modeling (star schema), these tables would be merged as a single table called TIME DIMENSION for performance and slicing data.

This dimensions helps to find the sales done on date, weekly, monthly and yearly basis. We can have a trend analysis by comparing this year sales with the previous year or this week sales with the previous week.

Example of Time Dimension

Time Dimension Diagram

Year Lookup:

[ultimatetables 42 /]

Quarter Lookup:

[ultimatetables 43 /]

Month Lookup:

[ultimatetables 44 /]

Week Lookup:

[ultimatetables 45 /]

Time Dimension:


[ultimatetables 46 /]



(Visited 26,062 times, 10 visits today)

One comment

  • Hi
    I need to create a Datawarehouse for Employees in my company.How to start,How to select as Attributes,Heirarchy ,Facts


Leave a Reply

Your email address will not be published.