Multidimensional Analysis with OLAP

http://commons.wikimedia.org/wiki/User:RRZEiconsMultidimensional analysis uses OLAP (OnLine Analytical Processing) to organize numeric data in a clear and easy to understand format. Multidimensional reports empower decision makers by providing a more complete picture of the data and the transactions that are taking place within the company.

The images below demonstrate how a report can become exponentially more valuable by adding meaningful dimensions. For this example we’ll use the annual entertainment revenue for ticket sales at a local venue:

Traditional Reporting: A single dimension

Single Dimension AnalysisThis type of report gives us basic data for quarterly sales of show tickets.

Single Dimension AnalysisThis one-dimensional report provides insight into the audiences and how much revenue each segment generates.

Single Dimension AnalysisThis reports segments the shows into show types, which provides a bit more insight into which shows are bringing in the highest revenue.

While all three of these reports do have some value, they only provide the information in small portions. This is not the ideal presentation of data that will be analyzed to make marketing decisions. A better option is to use two dimensional reports:

Hybrid Reporting: Two dimensions

Two Dimensional AnalysisWhen we combine the data from tables one, two, and three we create a sort of hybrid table that can provide a more complete picture of the data.

The 3-D View: Multiple dimensions

Multidimensional Analysis

This report highlights the capabilities of multidimensional analysis. It presents multipledimensions of data in a clean and easy to read format. An analysis can easily be made to determine which show types and which audiences provide the most revenue in each quarter.

When reports are designed with OLAP using multidimensional techniques your analysts become empowered and their understanding of your company data will present more of a 360 view of activities within your organization.

Advertisements

2 thoughts on “Multidimensional Analysis with OLAP

  1. My husband and i got very ecstatic when Chris could conclude his reports using the ideas he got through the web page. It’s not at all simplistic to just choose to be giving away information the others could have been trying to sell. And we figure out we have got the blog owner to give thanks to for that. The explanations you have made, the easy website navigation, the friendships you make it easier to instill – it’s got all spectacular, and it’s really letting our son in addition to us reckon that that topic is awesome, which is rather indispensable. Many thanks for the whole thing

Leave a Reply

Fill in your details below or click an icon to log in:

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