The Business Intelligence Guide
   BI Strategy | BI Program | BI Projects | BI Data | BI Infrastructure | BI User Tools | BI Vendors | Resource Guides | Articles | BI Blog | BIG Bookstore

Get a FREE Sample of the
The Total BI Guide
THE LOGICAL ORGANIZATION

and receive the
TLO NEWSLETTER
Just enter your details below

Email:
Name:
 
HOME
 
Business Intelligence
BI Strategy
BI Program Guide
BI Tools
- Dashboards
- Scorecards
- Operational BI
- Analytics
BI Software Solutions
Data Management
Databases
DataWarehouses
Decision Support
Marketing Tools
Industry Solutions
Case Studies
BI Surveys & Awards
RESOURCES
ARTICLES
BI EVENTS
BI NEWS
Sitemap

About the Author

View Gail La Grouw's profile on LinkedIn

Google+ Gail La Grouw

Bookmark and Share

OLAP - Online Analytical Processing


Defintion of OLAP

OLAP, or online analytical processing, presents and stores data in a format that is easily understood, and uses calculations that measure data, to respond in meaningful ways to questions asked by a user.

 

How OLAP Works

An OLAP engine takes data from single or multiple data sources and reorganizes it into a multidimensional structure. This structure makes navigating and analyzing data more intuitive and faster.

 

OLAP Engines

Microsoft SQL Server 2005 Analysis Services

Microsoft SQL Server 2005 Analysis Services is the most commonly deployed OLAP engine, that both stores business logic and key performance indicators [KPI's] and combines data for easy analysis.

Data in the OLAP engine is accessed using an analysis too, such as Business Intelligence [BI] applications, and desktop applications such as:

  • Microsoft Office Excel 2007
  • Office PerformancePoint Server 2007
  • ProClarity Analytics
  • Scorecards
  • Dashboards

 

Back To Top

Find Out About Our Leading Executive Guide To BI Strategy, Program & Technology


BI Tools Index | Advanced Analytics | OLAP | Cube Analysis | Ad Hoc Query Analysis | Data Mining | Alerting | Scorecards | Dashboards | Using A Dashboard | BI in BPM | MS Excel | Text Mining

Bookmark and Share
 


SALES ANALYTICS GUIDE

SELL MORE & HAVE YOUR CUSTOMERS LOVE YOU FOR IT

Power up your pipeline profit and manage sales performance in less time with less stress.
Sell More & Have Your Customers Love You For It

Now Also Available in
EBOOK VERSION

Find out more