OLAP - Online Analytical Processing : Resource Guide

OLAP is an acronym for Online Analytical Processing. OLAP performs multidimensional analysis of business data and provides the capability for complex calculations, trend analysis, and sophisticated data modeling.

For example, a user can request that data be analyzed to display a spreadsheet showing all of a company's beach ball products sold in Florida in the month of July, compare revenue figures with those for the same products in September, and then see a comparison of other product sales in Florida in the same time period. 

Take a look at the following video for basic introduction about OLAP.

If you like to create your first OLAP cube using Microsoft server 2008 please refer to the video below.





More advanced tutorial about Slicing & Dicing with Cubes can be seen below.

To know about Optimizing Cube Performance with OLAP Services click here.

Also take a look at the 3 Common Issues of Data Warehouse project. Its important to engage the right consultant to help you Pre plan, Analyse, and Implement the Data Warehouse Solution with reduced effort and disruption to users. Contact us to know more about Data Warehouse and how it can benefit your organisation. Thanks for dropping by and Have a fantastic day!

Best
Srivats

Srivatsan Aravamudan

Design and Communication

PsiberTech Solutions Private Ltd

Twitter 

Google plus
LinkedIn