What is a dimensional design?
A dimension is the name we use for a business category such as customer, territory, product, or any predefined time period (YTD, Month to Date, etc.) A dimensional design is a structure that yields a unified and consistent view of these business categories (or dimensions). This type of design is extremely beneficial for organizations where information is distributed across different and sometimes inconsistent departmental and divisional databases.