What is OLAP?

OLAP stands for

OnLine Analytical Processing” 

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

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.

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

Scenario Maintenance – Analyzing the 2023 Rugby World Cup with OLAP Cube Technology

Scenario Maintenance – Analyzing the 2023 Rugby World Cup with OLAP Cube Technology

This is where OLAP technology can be especially helpful: we can demonstrate to ourselves how various scenarios generate different versions, all rooted in distinct assumptions. We can even consolidate all these assumptions into a single workbook, allowing us to work with these assumptions where the numbers exist or where actual calculations occur. 

Retail OTB (Open to Buy) Planning with PowerExcel

Retail OTB (Open to Buy) Planning with PowerExcel

OTB (Open-to-Buy) is a forward-looking metric based on future projections. In retail, it involves assessing current stock and estimating the exact amount of stock needed to achieve a predetermined target. It’s a blend of sales forecasting and stock planning, requiring accurate data and meticulous calculations. 

Workforce Planning: Unleashing the Potential of PowerExcel Technology

Workforce Planning: Unleashing the Potential of PowerExcel Technology

In this article, Gareth Jones from PARIS Technologies discusses the challenges faced by companies when managing their payroll and workforce planning.     Payroll planning is crucial for businesses, but it is often difficult to optimize due to the limitations of...

Analyzing the 2023 Rugby World Cup with OLAP Cube Technology

Analyzing the 2023 Rugby World Cup with OLAP Cube Technology

In this article, we explore some “scenario planning” capabilities of cube technology by delving into the world of sports, specifically for the 2023 Rugby World Cup tournament. Using our product’s analytical tool (the front end you will see is PARIS Tech’s PowerExcel; the back end, Olation), we’ll examine historical data, team performances, “dream-killers,” and make predictions for the upcoming competition

Infographic: 5 Signs You are in Excel Hell

Infographic: 5 Signs You are in Excel Hell

Check out this cool infographic! Submitted to OLAP.com by the folks at PARIS Technologies. They’ve mapped here 5 warning signs that you and your professional team are living in Excel Hell.

 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

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.