OLAP/ROLAP and Dimensional Modeling (PDM2004S)


Please click the button below to enroll for this training.



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


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



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