What is OLAP?

OLAP stands for

OnLine Analytical Processing” 

It is the most powerful and exciting business technology available for real-time decision making.

Financial modeling and collaboration promotion with hands holding a digital globe.

ebooks_olap101-01

Download the OLAP 101 eBook

This book offers context for newbies to OLAP technology. Learn where OLAP came from and how it developed into the Business Intelligence technology we know today.

Click here prompt for OLAP and Excel integration details

ebooks_eguide-01

Download the eGuide OLAP and BI Terms

A quick reference guide to commonly used Business Intelligence and OLAP words. Keep up with the techie talk with this handy reference.

 Our Recent Blog Posts

Forget big data — let’s talk about all data

Forget big data — let’s talk about all data

We constantly hear people talking about big data as a monstrous mess. They usually describe it as a difficult problem to tackle, as though big data itself has a beginning and an end, or a neat solution. I’ve been to many conferences in the last few weeks, and over and...

From Business Intelligence to Advanced Analytics

From Business Intelligence to Advanced Analytics

  Big Data and Analytics are still a hot ticket, both in the venture community and in the IT budgets of selected verticals—including any of the e-commerce enterprises competing directly with Amazon, any of the online transaction companies voluntarily exposing their...

How to Transform Data into Intelligence that Promotes Growth

How to Transform Data into Intelligence that Promotes Growth

Most businesses have the ability to capture data from customer transactions and day-to-day operations, and through research. However, the significant problem after accumulating data is how to turn the data into intelligence that can improve the bottom line. A major...

What Really Is Big Data? And Why It Will Change the World

What Really Is Big Data? And Why It Will Change the World

  Big Data is THE biggest buzzword around at the moment, and I guess it makes sense to start my new ‘The Big Data Guru’ column with a post that goes back to basics and establishes what big data really is, what is isn’t and why it matters to everyone. One thing is...

Map Your Financial Health With an Excel DuPont Dashboard

Map Your Financial Health With an Excel DuPont Dashboard

Your Return On Equity ratio is a key indicator of financial health. This report lets you show the components of that ratio in a unique Excel display. by Charley Kyd, MBA Microsoft Excel MVP Management reporting is all about communication. Reporting Return On Equity...

Create Variable-Length, Dynamic Reports Linked to Excel Tables

Create Variable-Length, Dynamic Reports Linked to Excel Tables

When you change a criteria value in a cell, Excel can use formulas and conditional formatting to expand or contract your report automatically, without macros. Here's how. by Charley Kyd, MBA Microsoft Excel MVP Excel Tables are a powerful feature introduced in Excel...

Hand drawing an upward arrow labeled 'Productivity.'

 Follow OLAP Tutorials

Exercises with a real OLAP product will teach you about Business Intelligence and OLAP basics.

These tutorials give you a chance to get hands on with data modeling and analysis with access to actual software and step-by-step instructions.   To follow these tutorials as they are intended, please first download the Free OLAP and Business Intelligence software provided by our sponsors at PARIS Tech.

OLAP Tutorials

 Learn about Types of OLAP Systems

Read about different types of OLAP and what is new in the market now.

First there was ROLAP, and then MOLAP, and Hybrid systems as well as in-memory systems.  Read about what defines different systems, their limitations and what is trending in the OLAP and Business Intelligence market now.

Types of OLAP

Businessman holding transparent financial graphs.

ebooks_worldcup-01 (1)

Download the World Cup Analysis eBook

This eBook takes it beyond just business, showing what can be done with OLAP technology with any kind of data. In this case, it’s sports data, applying OLAP technology to World Cup data.