What is an Online Analysis Processing System?

2000px-OLAP_Cube.svg

What is an OLAP CUBE?

OLAP simply translated into Online Analysis Processing , it is the process of viewing data in a multi-dimensional format  i.e.  slicing and dicing of data from various  multiple perspectives.

olap

It involves the deployment of both fact and dimensional tables. Many enterprise business use OLAP to view their performance against diverse variables such as sales by locations by a given quarter.

I  have personal experiences with the application of OLAP systems in various data warehousing projects in which i have undertaken in the past. It is feels pretty good to harness the rich capabilities that an OLAP system brings into the business . Some of the features of an OLAP includes hierarchies look ups,drill through of data, slicing and dicing of  data  etc.

Why you need an Online Analysis Processing  System

Sample_JReport_Dashboards

Many contemporary dashboards  reports are built on  existing OLAP systems, Your ROI upon the adoption of an OLAP systems for your business  would be very huge (i.e if you don’t have one already)

Some OLAP vendors

OLAP VENDORS

 

Advertisements

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