Schema Workbench Part 1 (PDM2005S)


Please click the button below to enroll for this training.



(2 hrs) Self-paced, interactive online training with a simulated practice environment (Part of PDM2000S).


This self-paced eLearning module introduces Pentaho Schema Workbench which is visual application for building and testing Mondrian schema files.



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:

  • Introduction to Schema Workbench
  • Viewing an existing schema
  • Viewing the database with JDBC Explorer
  • Creating a schema and cube
  • Connecting to the data source
  • Creating the schema
  • Creating the cube
  • Adding the fact table
  • Adding a measure
  • Creating a dimension hierarchy
  • Adding levels to a hierarchy