Categories: Modeling DW and Data Mart

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:

Corporate Lookup:

Corporate Code	Corporate Name	DateTimeStamp
CO	American Bank	1/1/2005 11:23:31 AM

Region Lookup:

Region Code	Region Name	DateTimeStamp
SE	South East	1/1/2005 11:23:31 AM
MW	Mid West	1/1/2005 11:23:31 AM

Branch Lookup:

Branch Code	Branch Name	DateTimeStamp
FLTM	Florida-Tampa	1/1/2005 11:23:31 AM
ILCH	Illinois-Chicago	1/1/2005 11:23:31 AM

Employee Lookup:

Employee Code	Employee Name	DateTimeStamp
E1	Paul Young	1/1/2005 11:23:31 AM
E2	Chris Davis	1/1/2005 11:23:31 AM

Organization Dimension:

Organization Dimension Id	Corporate Name	Region Name	Branch Name	Employee Name	DateTimeStamp
Organization Dimension Id	Corporate Name	Region Name	Branch Name	Employee Name	DateTime Stamp
1	American Bank	South East	Florida-Tampa	Paul Young	1/1/2005 11:23:31 AM
2	American Bank	Mid West	Illinois-Chicago	Chris Davis	1/1/2005 11:23:31 AM