Data Warehousing
Data-Warehouses.net

Data Dimensions
Guide to Data Warehousing and Business Intelligence

Data Warehouse and Business Intelligence

Home Introduction Architecture Tools Web Analytics Glossary
 

Menu

Home
Business Intelligence
Conformed Dimensions
Data Dimensions
Data Mart
Data Warehouse
Data Warehousing
Dimensional Model
ETL Technology
Fact Table
Meta Data
Relational Model

A Data Dimension is a set of data attributes pertaining to something of interest to a business.  Dimensions are things like "customers", "products", "stores" and "time".  For users of Data Warehouses, data dimensions are entry points to numeric facts (e.g. sale, profit, revenue) that a business wishes to monitor. 

For example, a business might want to know how may blue widgets were sold at a specific store in Los Angeles last month.

A data dimension can be hierarchical.  For example, "days" can be grouped into "months", "months" into "quarters" and quarters into "fiscal years" or "calendar years".  This allows fact data to be easily aggregated,  summarized and presented.

Back Up Next


• Search Site • Predictive Analysis • Create Website • Business Analysis • Systems Analysis • Programming • Site Map •