OLAP and Business Intelligence Tutorials

I. Download Free OLAP Software

PARIS Technologies  features a set of exercises designed to introduce you to the fundamentals of OLAP by using step-by-step procedures to create an OLAP model. These example steps use PARIS’s OLAP product PowerOLAP, but you’ll find that the concepts of Cubes, Dimensions, Slices, multidimensionality, etc., that are demonstrated using PowerOLAP are representative of OLAP in general.

 

To follow these exercises download PowerOLAP:

 
 
Download OLAP
 
Once installed, follow the tutorials below.

II. OLAP Tutorials

You can also follow the PowerOLAP Quick Start Exercises and access other related videos on the PARISTech TV YouTube Channel

OLAP Basics

OLAP  Reporting

OLAP Cube Modeling

*One additional note about these Quick Start exercises: these steps explain how to construct a model by working entirely with the PowerOLAP product’s “modeler.” Note that—especially if you are an administrator or power user—you will not build Cubes (business models) only by these steps. Instead, many Cube features (Meta Data) and the actual figures you work with (Fact Data) will likely come from another source and will therefore be built by using an integration capability (OLAP Exchange®, in PowerOLAP) to reach logic in, for example, and ERP or general ledger package.  That said, the concepts and the steps covered in these pages and videos should be very helpful as they convey how to use, customize and advance your OLAP models. These skills, in turn, will enable you to vastly increase the potential business uses and benefits of using an OLAP modeling tool like PowerOLAP at your firm.

More Articles on OLAP & Business Intelligence

EPM in the Cloud—Overcoming the Resistance

EPM in the Cloud—Overcoming the Resistance

0 Comments

In the far distant past (OK, just a few years ago) prospects would balk at the idea of EPM in the Cloud. Things sure have changed: the Cloud, as a means to do everything—from data storage, to playing music, to business application hosting—is as much a part of our technology ecosystem as the phones in our hands and the laptops on our desks.

read more
7 Interesting Facts About OLAP History

7 Interesting Facts About OLAP History

0 Comments

Not too long ago businesses found it very difficult to query data out of their recently acquired relational databases. These queries were too slow to be processed by computer systems of the time as well as too inflexible to navigate the data. After trying different...

read more