Organization Dimension

In a relational data model, for normalization purposes, corporate office lookup, region lookup, branch lookup, and employee 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 ORGANIZATION DIMENSION for performance and slicing data.

This dimension helps us to find the products sold or serviced within the organization by the employees. In any industry, we can calculate the sales on region basis, branch basis and employee basis. Based on the performance, an organization can provide incentives to employees and subsidies to the branches to increase further sales.

Example of Organization Dimension:

Example of Organization Dimension

Corporate Lookup:

Corporate CodeCorporate NameDateTimeStamp
COAmerican Bank1/1/2005 11:23:31 AM

Region Lookup:

Region CodeRegion NameDateTimeStamp
SESouth East1/1/2005 11:23:31 AM
MWMid West1/1/2005 11:23:31 AM

Branch Lookup:

Branch CodeBranch NameDateTimeStamp
FLTMFlorida-Tampa1/1/2005 11:23:31 AM
ILCHIllinois-Chicago1/1/2005 11:23:31 AM

Employee Lookup:

Employee CodeEmployee NameDateTimeStamp
E1Paul Young1/1/2005 11:23:31 AM
E2Chris Davis1/1/2005 11:23:31 AM

Organization Dimension:

Organization Dimension IdCorporate NameRegion NameBranch NameEmployee NameDateTimeStamp
Organization Dimension IdCorporate NameRegion NameBranch NameEmployee NameDateTime
1American BankSouth EastFlorida-TampaPaul Young1/1/2005 11:23:31 AM
2American BankMid WestIllinois-ChicagoChris Davis1/1/2005 11:23:31 AM

Next⇒ Time Dimension

Leave a Reply

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