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 23,694 times, 5 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

    Thanks
    R.B

Leave a Reply

Your email address will not be published. Required fields are marked *