Schema Workbench Part 1 (PDM2005S)

Enroll

Please click the button below to enroll for this training.


FREE

Summary

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

Description

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

 

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:

  • 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