Training‎ > ‎

Data Analysis Solution with Mondrian (Pentaho Analysis)

Course Introduction

Nowadays information processing has leveraged into two wide area of organizational activities, operation and decision-oriented analysis.  The later problem - mostly required by strategic levels - currently falls into a growingly popular IT solutions, i.e. Business Intelligence (BI).

Online Analytical Processing (OLAP) as part of BI denotes descriptive modeling for analysis based decision-oriented information processing. It is an approach to quickly answer multi-dimensional analytical queries.

Mondrian / Pentaho Analysis is a free open source OLAP Server written in Java. With its constant growth of developers and users adoption around the world, it is now one of the most affordable and popular OLAP solution.

Pair with JPivot you can access Mondrian’s OLAP data in web based manner with unlimited clients. Thus you can easily maintained and deployed OLAP solutions in your organizations.

Who Should Attend ?

This course is designed for business analysts, IT developer, database administrator and those who new and interest to OLAP and Pentaho Analysis. 

Especially those who already implement ERP (Enterprise Resource Planning), CRM (Customer Relationship Management), SCM (Supply Chain Managemen), HRM (Human Resource Management), and other system which had huge data and need to be analysed in multi dimensional way.


At the completion of this course, attendee should be able to :
  • understand basic concepts of OLAP and what kinds of problems can it solved
  • understand multi dimensional modeling like cubes, dimension and measures
  • develop OLAP Schemas for use with Pentaho Analysis
  • integrate Pentaho Analysis solution into Pentaho BI Platform (BI Server)
  • develop OLAP security / user access control

Course Fee

Rp 10.000.000,- / pax  including :
  • 2 snack times + 1 lunch time / day
  • Course Material
  • PHI-Integration Certificate
  • 1 DVD including all softwares used in the training

Course Duration

4 days / 24 hours

Course Schedule

13 December 2010 - 16 December 2010 (9.00 am - 16.00 pm)

Course Prerequisites

  • Basic understanding one of several popular DBMS (Oracle, SQL Server, MySQL, etc) and Structured Query Language (SQL)
  • Basic understanding of Java (platform and programming language) 
  • Basic understanding of XML
  • No understanding of other Pentaho tools is needed

Course Requirements

  • PC or Laptop with minimum of 2GHz CPU, 2 GB of RAM, DVD Drive and 20 GB of available hard disk space.
  • Softwares :
    • Windows XP Pro Operating System
    •  Java Runtime Environment (JRE)
    • Apache Tomcat
    • Notepad ++ Text Editor
    • MySQL 5.0 Database Server
    • Kettle / Pentaho Data Integration
    • Mondrian / Pentaho Data Analysis
    • Pentaho Workbench Editor
    • Pentaho Aggregation Designer
    • Pentaho BI Server
    • Foodmart Sample Database

Course Outline

  1. Introduction to OLAP Concepts
    • Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP)
    • Cubes, Dimensions and Measures
    • Multi Dimensional Modeling
      • Fact and Dimension Tables
      • Star and Snow Flake Schema
  2. Pentaho Analysis / Mondrian
    • Architecture
      • Mondrian as ROLAP (Relational OLAP) engine
      • Aggregation Cache
      • MDX (Multidimensional Expression)
  3. Installation and Configuration
    • Java Runtime
    • MySQL Database Server and Foodmart database sample
    • Apache Tomcat 
    • Deploy Mondrian web archive
  4. JPivot as Mondrian Web Interface
    • Exploring Mondrian Foodmart Sample
    • OLAP Navigator
    • Chart View
    • Export View to Excel / PDF Document
    • Developing JPivot Page :
      • JPivot’s JSP page
      • JPivot Tags
  5. MDX (Multidimensional Expression)
    • Concepts
      • Dimensions, measures, members and cells
      • Tuples and Sets
      • Member properties
    • Queries & Expressions
    • Functions
    • Navigating Hierarchies
    • Common Usage :
      • Averages
      • Period to Period References and Calculations
      • Year to Date Aggregations
  6. Mondrian Schema
    • Schema Files
    • Cubes
    • Dimensions and Shared Dimensions
    • Measures and Calculated Member
    • Virtual Cubes
    • Pentaho Schema Workbench Editor
    • Tuning Performance with Pentaho Aggregation Designer
  7. Pentaho BI Server
    • Pentaho BI Platform and Server
    • Installation
    • Pentaho Solution
    • Pentaho Analysis Component
    • Integrate Pentaho Analysis Schema into Pentaho BI Server
    • Deploy Pentaho Analysis .xaction page
    • Creating User / Role through Administration Console
    • Limiting User Access Control to Analytical Solution
You can also download our course outline in PDF attachments at the end of this page.