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

When Big Data Meets Tablets

When Big Data Meets Tablets

  Big Data and mobility are converging offering mobile workers access to real time data via mobile dashboard apps. An interview  published in Tech Republic with the Forerunner Group’s managing director Dwight deVera. Big Data and mobility are converging offering...

Tips for Choosing a Real-Time Business Intelligence Solution

Tips for Choosing a Real-Time Business Intelligence Solution

The value of having a Business Intelligence (BI) tool in 2013 is inevitable however; many businesses may be faced with the ultimate business dilemma of having to choose the right BI tool. With every Business Intelligence solution provider claiming access to real-time...

What’s a ‘Deprecated’ Function in Excel?

What’s a ‘Deprecated’ Function in Excel?

  Microsoft tells us that many worksheet functions are 'deprecated.' So what does that mean, exactly? Wikipedia tells us that deprecation is a status applied to a computer software feature, characteristic, or practice indicating it should be avoided, typically...

Introducing Excel’s Three Types of Spreadsheet Databases

Introducing Excel’s Three Types of Spreadsheet Databases

Excel offers at least three ways to set up data so your reports and analyses can use it easily as a reliable data source. by Charley Kyd, MBA Microsoft Excel MVP Excel offers three general ways to arrange data in your spreadsheet so you can use it as a database with...

Five Really Useful Excel Keyboard Shortcuts

Five Really Useful Excel Keyboard Shortcuts

These keyboard shortcuts will help you to things in Excel that are difficult or time-consuming to do any other way. by Charley Kyd, MBA Microsoft Excel MVP Several years ago, I created my Complete Excel Shortcuts Workbook. It contains more that 250 keyboard shortcuts...

Business Analytics – Opposition or Proposition?

Business Analytics – Opposition or Proposition?

Metaphorically, belief and disbelief in business analytics as a competitive edge - and not just a passing fad - meet at a door. On one side is passion, and on the other, fear. Passion always lives with fear. Those with passion for a methodology, like embracing...

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.