Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Dimensional Modeling

Dimensional Modeling describes a process of designing a data warehouse assuming that the data are organized as dimensions and facts.

Although the design process is also applicable for OLAP tools, this is a design technique based on the assumption that the data model will be deployed on relational database.

Dimensional modeling is for addressing the reporting requirements.  The data used in answering typically business questions are categorized into two groups: fact and dimension.

A typical business question is like “how many computers we sold by regions last quarter”.

The sales figure is the metric.  The metrics are facts.

There are the dimensions involved here:

  • computer
  • region
  • quarter

Dimensions are used in filtering, grouping and sorting the answers.

From relational modeling perspective, dimensional modeling produces the data model design with denormalization.

Advertisements

2 Responses to “Dimensional Modeling”

  1. […] Moved as a page – Data Modeling […]

  2. […] The data are consolidated and are integrated.  A data warehouse design that follow the dimensional modeling technique may store data in star schema with fact tables and dimension tables.   Typically a […]

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s