OLAP/ROLAP and Dimensional Modeling (PDM2004S)

Enroll

Please click the button below to enroll for this training.


FREE

Summary

(30 mins) Self-paced, interactive online training (Part of PDM2000S).

Description

This self-paced eLearning module covers some of the concepts behind dimensional modeling including OLAP / ROLAP, drilling, slicing and dicing.

 

Prerequisites

Some basic knowledge of database design and dimensional modeling is desirable as well as knowledge of Pentaho Interactive Reports and Pentaho Analyzer. These are covered within the course “Pentaho Business Analytics” (PBA1000S self-paced, or PBA1000L instructor-led), or individually in “Pentaho Interactive Reports” (PBA1004S) and “Pentaho Analyzer” (PBA1005S).

 

This training includes:

  • Overview of OLAP / ROLAP
    • Drilling, slicing, dicing
  • Dimensional modeling - cubes and stars
  • Mondrian