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 2023

17 – 18 Januari 2023

14 – 15 Februari 2023

20 – 21 Maret 2023

4 – 5 April 2023

16 – 17 Mei 2023

20 – 21 Juni 2023

17 – 18 Juli 2023

15 – 16 Agustus 2023

25 – 26 September 2023

17 – 18 Oktober 2023

21 – 22 November 2023

27 – 28 Desember 2023

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