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

Data Warehouse for Business Intelligence

Data Warehouse for Business Intelligence

A data warehouse is a great thing in concept, and a wonderful thing in actuality! Who could argue with the concept: “a central repository for data integrated from various sources, organized for reporting and analysis.” Anyone who, in actuality, has worked in Business...

Transform Collaboration in Excel by adding Row-Level Security

Transform Collaboration in Excel by adding Row-Level Security

Discover Row-level Security in Excel with an innovative add-in from PARIS Technologies. This tool goes beyond basic security options, offering username/password or integrated Windows security for easy access to centralized databases. You can control user permissions...

Unlocking the Games: The Power of OLAP Cubes in Sports Analysis

Unlocking the Games: The Power of OLAP Cubes in Sports Analysis

Rugby fans, prepare to be exhilarated! PARIS Tech has teamed up with David Newton, a luminary in the world of finance and the founder of Newton Carmen, a prestigious Fractional CFO firm. Together, they've fashioned something extraordinary - an OLAP model tailored...

Pivot Table vs. PowerExcel Pivot

Pivot Table vs. PowerExcel Pivot

This video from our sponsor PARIS Tech compares Microsoft Excel's PivotTable capabilities with the pivot table in PowerExcel. PivotTables are recognized for their ability to organize data effectively, but they are primarily designed for single-user productivity and...

Top-Down Bottom-Up Budgeting with PowerExcel

Top-Down Bottom-Up Budgeting with PowerExcel

What happens it that first the Finance team creates the budget from the bottom up, and then senior management delivers top-down directives.  Meeting those directives requires adjustment, often leading to a time-consuming and demoralizing cycle in Excel to complete the budget.

 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.