Download and Learn
From OLAP
Download
The examples here are built using PowerOLAP. To complete the exercises, please download the trial software:
Download Trial PowerOLAP Software
Exercises
Quick Start Introduction
This set of exercises is designed to introduce you to the fundamentals of OLAP by using step-by-step procedures to create an OLAP model. These examples are constructed using the OLAP product PowerOLAP, but you’ll find that the concepts of cubes, slices, and multidimensionality demonstrated here are still representative for OLAP in general.
By working through these Quick Start Exercises you will learn many elemental functions of OLAP:
- How to create Databases, Dimensions, Cubes, and Slices
- How to create an Excel worksheet from a Slice view
These examples show how to construct a model by working entirely with the product’s “modeler,” meaning, the OLAP model will be built from the ground up.
This is a perfect exercise for beginners to understand what OLAP is and how it works, but
it is NOT reflective of how OLAP is usually implemented.
Usually, data is imported or exchanged between existing operating systems and the OLAP system because the amount of data is so vast in the existing system that manual creation of a database and physical entry of data would be impossible. However, you will undoubtedly need to understand the concepts and follow the steps covered in these examples because they convey how to use, customize and advance your own models. These skills, in turn, will enable you to vastly increase the potential business uses and benefits of any OLAP product.
You can download the Quick Start Exercises as a PDF from here, or follow them online: