Data Analytical Solution with Pentaho Analysis (Mondrian)

Course ID : PHI-BI-003 Platform : Windows / Fedora Linux http://www.phi-Integration.com

Data Analysis Solution with Mondrian (Pentaho Analysis)

PHI-Integration.com Page : 2 / 5

Data Analytical Solution with Mondrian (Pentaho Analysis)

I. 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 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.

Data Analysis Solution with Mondrian (Pentaho Analysis)

PHI-Integration.com Page : 3 / 5

II. 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.

III. Objectives

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

IV. Course Duration

5 days / 30 hours

V. Course Prerequisites

Basic understanding one of several popular DBMS (Oracle, SQL Server, MySQL, etc) and Structured Query Language (SQL)

Basic understanding of XML

No understanding of other Pentaho tools is needed

VI. Course Resources

PC or Laptop with minium of 2GHz CPU, 1 GB of RAM, DVD Drive and 2 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 Schema Workbench Editor

◦ Pentaho Aggregation Designer

◦ Pentaho BI Server

◦ PHI-Minimart Sample Database

Data Analysis Solution with Mondrian (Pentaho Analysis)

PHI-Integration.com Page : 4 / 5

VII. Course Outline

1. Introduction to OLAP Concepts

◦ Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP)

◦ Cubes, Dimensions, Hierarchies, Levels 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)

◦ Tools

▪ Pentaho Workbench Editor

▪ Pentaho Aggregation Designer

3. Installation and Configuration

◦ Java Runtime

◦ MySQL Database Server and Foodmart database sample

◦ Pentaho BI Server

4. Pentaho BI Server

◦ Pentaho BI Platform and Server.

◦ Pentaho Solutions.

◦ Pentaho Analysis Component (JPivot, Schema, XAction).

◦ Administration Console :

▪ Creating and maintaining User / Role.

▪ Creating and maintaining Database Connections.

5. Mondrian Schema

◦ Mondrian Schema XML File

◦ Pentaho Schema Workbench Editor

◦ Defining Cubes, Dimensions and Shared Dimensions

◦ Creating Measures and Calculated Measures

◦ Virtual Cubes

◦ Roles

6. MDX (Multidimensional Expression)

◦ MDX Queries & Syntax

◦ Concepts :

Data Analysis Solution with Mondrian (Pentaho Analysis)

PHI-Integration.com Page : 5 / 5

▪ Dimensions, measures, members and cells

▪ Tuples and Sets

▪ Member properties

◦ MDX Expression & Functions

▪ Navigation Functions

▪ Time Functions

▪ Filter and Slices

▪ Aggregate Functions

7. Pentaho Aggregation Designer

◦ Mondrian’s Aggregate Tables

◦ Schema Map of Aggregate Tables

◦ Tuning Performance with Pentaho Aggregation Designer

8. JSP based Dashboard Solution

◦ Short Introduction to Java and JDBC connection

◦ Creating Java Server Pages (JSP)

◦ Map JSP to web server’s URL

◦ Creating shortcut into Pentaho User Console’s menu

◦ Integrate Pentaho Analysis Schema into Pentaho BI Server

◦ Creating User / Role through Administration Console