TRAINING PENTAHO ANALYSIS FOR DATA ANALYTICAL SOLUTION

TRAINING PENGENALAN PENTAHO ANALYSIS FOR DATA ANALYTICAL SOLUTION

TRAINING ANALISIS DATA

DESCRIPTION

In  this  program  the  participants  will learn the Online Analytical
Processing  (OLAP)  which  is  part  of  Business Intelligence denotes
descriptive  modeling for analysis based information processing. It is
an approach to quickly answer multi-dimensional analytical queries.

The  participants will be able to apply Mondrian/Pentaho Analysis as a
free  open source OLAP Server written in Java which is one of the most
affordable and popular OLAP solution.

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

Â

OBJECTIVE

At the end of the program, the participants will 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  Business
Intelligence Platform (Business Intelligence Server)
* Develop OLAP Security/User Access Control

COURSE OUTLINE

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

Pentaho Analysis/Mondrian
* Architecture
* Mondrian as ROLAP (Relational OLAP) Engine
* Aggregation Cache
* MDX (Multidimensional Expression)
* Tools
* Pentaho Workbench Editor
* Pentaho Aggregation Designer

Installation and Configuration
* Java Runtime
* MySQL Database Server and Foodmart Database Sample
* Pentaho Business Intelligence Server

Pentaho Business Intelligence Server
* Pentaho Business Intelligence Platform and Server
* Pentaho Solutions
* Pentaho Analysis Component (JPivot, Schema, XAction)
* Administration Console
* Creating and Maintaining User/Role
* Creating and Maintaining Database Connections

Mondrian Schema
* Mondrian Schema XML File
* Pentaho Schema Workbench Editor
* Defining Cubes, Dimensions and Shared Dimensions
* Creating Measures and Calculated Measures
* Virtual Cubes
* Roles

MDX (Multidimensional Expression)
* MDX Queries & Syntax
* Concepts
* Dimensions, Measures, Members and Cells
* Tuples and Sets
* Member Properties
* MDX Expression & Functions
* Navigation Functions
* Time Functions
* Filter and Slices
* Aggregate Functions

Pentaho Aggregation Designer
* Mondrian’s Aggregate Tables
* Schema Map of Aggregate Tables
* Tuning Performance with Pentaho Aggregation Designer

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  Business
Intelligence Server
* Creating User/Role Through Administration Console

TRAINING METHOD

Pre test

Presentation

Discussion

Case Study

Post test

Evaluation

JADWAL TRAINING TAHUN 2026

03 – 04 Januari 2026 | 16 – 17 Januari 2026

06 – 07 Februari 2026 | 20 – 21 Februari 2026

05 – 06 Maret 2026 | 19 – 20 Maret 2026

03 – 04 April 2026 | 23 – 24 April 2026

07 – 08 Mei 2026 | 21 – 22 Mei 2026

05 – 06 Juni 2026 | 25 – 26 Juni 2026

09 – 10 Juli 2026 | 23 – 24 Juli 2026

06 – 07 Agustus 2026 | 20 – 21 Agustus 2026

04 – 05 September 2026 | 18 – 19 September 2026

08 – 09 Oktober 2026 | 22 – 23 Oktober 2026

06 – 07 November 2026 | 26 – 27 November 2026

04 – 05 Desember 2026 | 18 – 19 Desember 2026

Metode Training

1. Tatap Muka/offline
2. Online via zoom

Kota Penyelenggaraan jika offline :

1. Bandung
2. Jogjakarta
3. Surabaya
4. Jakarta

fasilitas yang didapatkan

1. Training Kit Eksklusif
   • Tas
   • Name Tag
   • Modul
   • Flash disk
   • Ballpoint
   • Block Note
   • Souvenir
2. Harga yang Reliable
3. Trainer Kompeten di bidangnya
4. Pelayanan Maksimal untuk peserta
5. Penjemputan dari dan ke bandara

Investasi :

Public training : Rp. 4.500.000 (minimum 3 pax)

In House Training : on Call