Butuh Training?

Silakan ketik kebutuhan training Anda di sini. Ada lebih 14.000 topik dan 300.000 event sepanjang tahun 2023

Pentaho Analysis for Data Analytical Solution

pentaho analysis

pentaho

EVENT

15 – 19 February 2021 | Rp 14.000.000 at Kuningan, Jakarta Selatan
22 – 26 March 2021 | Rp 14.000.000 at Kuningan, Jakarta Selatan
19 – 23 April 2021 | Rp 14.000.000 at Kuningan, Jakarta Selatan

Jadwal Training 2021 Selanjutnya …

 

 

Pentaho Analysis for Data Analytical Solution Program Description

In this program the participants will learn the Online Analytical Processing (OLAP) which is part of BI 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.

 

Pentaho Analysis for Data Analytical Solution Program Objectives

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 BI Platform (BI Server)
  • Develop OLAP security / user access control

 

Pentaho Analysis Program Modules

Module 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

Module 2: Pentaho Analysis / Mondrian

  • Architecture
  • Mondrian as ROLAP (Relational OLAP) engine
  • Aggregation Cache
  • MDX (Multidimensional Expression)
  • Tools
  • Pentaho Workbench Editor
  • Pentaho Aggregation Designer

Module 3: Installation and Configuration

  • Java Runtime
  • MySQL Database Server and Foodmart database sample
  • Pentaho BI Server

Module 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

Module 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

Module 6: 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

Module 7: Pentaho Aggregation Designer

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

Module 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

 

Target Audience

This program is designed for Business Analysts, IT developer, Database Administrator and those who new and interest to OLAP and Pentaho Analysis.

 

Duration

This program is 5 days of intensive training class.

 

Requirement

Pentaho Analysis participants should possess:

  • Basic understanding one of several popular Database Management System (Oracle, SQL Server, MySQL, etc.) and of Structured Query Language (SQL)
  • Basic understanding of XML

 

SCHEDULE

This event will be held on the specified venue and schedule below:

  • 15 – 19 Februari 2021
  • 22 – 26 Maret 2021
  • 19 – 23 April 2021
  • 21 – 25 Juni 2021
  • 12 – 16 Juli 2021
  • 30 Agustus – 03 September 2021
  • 20 – 24 September 2021
  • 11 – 15 Oktober 2021
  • 22 – 26 November 2021
  • 27 – 31 Desember 2021
  • Time: 09.00 AM – 05.00 PM
  • Axa Tower 37th Floor, Kuningan City

 

INVESMENT

Information Fee at proposal

 

Data Analytical Solution with Pentaho Analysis

 

Formulir Pra-Pendaftaran Public Training / Permintaan Informasi Lebih Lanjut
  1. JENIS INFORMASI/TRAINING
  2. (required)
  3. (required)
  4. DATA PRIBADI
  5. (required)
  6. (required)
  7. (required)
  8. (valid email required)
  9. (required)
  10. (required)
  11. DATA PRE REGISTRATION (Tidak Mengikat)
  12. (required)
  13. PESAN UNTUK PENYELENGGARA TRAINING
  14. Captcha
 

cforms contact form by delicious:days