Tag Archives: OLAP

Pentaho Analysis for Data Analytical Solution

pentaho analysis
pentaho

Event

01 – 05 July 2019 at Kuningan, Jakarta Selatan
02 – 06 September 2019 at Kuningan, Jakarta Selatan
04 – 08 November 2019 at Kuningan, Jakarta Selatan




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.


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



VENUE AND TIME

  • 06 – 10 May 2019
  • 01 – 05 July 2019
  • 02 – 06 September 2019
  • 04 – 08 November 2019

Time                : 09.00AM – 05.00PM

Venue             : AXA Tower – Kuningan City, Jakarta Selatan



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
 

cforms contact form by delicious:days

Pentaho Data Integration for Data Warehouse

Event

10 – 14 June 2019 at Kuningan, Jakarta Selatan
05 – 09 August 2019 at Kuningan, Jakarta Selatan
07 – 11 October 2019 at Kuningan, Jakarta Selatan




Program Description:

This program presents an overview of data warehouse, multi-dimensional, ETL concept, the extensive use of Pentaho Data Integration to build a powerful data warehouse solution. The practical approach of this program involved many cases we face before, so that participants will get a highly valuable skills from attending the class.



Program Objectives:

At the end of the program, the participants will be able to:

  • Understand the concepts and topics of Data Warehouse, Dimensional Modeling, OLAP and ETL
  • Use Pentaho Data Integration to build simple jobs / transformations
  • Consume data from several data sources
  • Build and Populating Fact and Dimensional tables
  • Apply troubleshooting techniques
  • Schedule job / transformation


Pentaho Data Integration Program Modules:

Module 1: Introduction to Data Warehouse

  • Data Warehouse
  • Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP)
  • Data Warehouse and OLAP
  • Delivering Solution with ETL (Extract, Transform, Load) Tool

Module 2: Installation and Configuration

  • Java Runtime Environment / Java Development Kit
  • Pentaho Data Integration
  • XAMPP package (Apache HTTP Server and MySQL)
  • SQLYog – a GUI based mysql client
  • Data and Script samples

Module 3: Short Introduction to MySQL

  • MySQL Storage Engines
  • Administering MySQL via PHPMyAdmin
  • PHI-Minimart sample database installation

Module 4: Pentaho Data Integration (Kettle)

  • Introducing Kettle as Pentaho’s ETL Suite
  • Architecture
  • Components
  • Spoon : Graphical UI Designer for job / transformation steps
  • Pan : Command line batch script for transformation execution
  • Kitchen : Command line batch script for transformation execution
  • Carte : Cluster server
  • Job / Transformation
  • Step and Hop
  • Row and Meta Data
  • Relation between job and transformation

Module 5: Getting Started with Spoon

  • File system and RDBMS based Repository
  • Spoon Development Environment
  • Database Connections
  • Job and Transformation
  • Creating job
  • Creating transformation
  • Calling transformation from job
  • Configuring Log

Module 6: Multi Dimensional Modelling

  • Normalized versus Multi Dimensional Model
  • Fact and Dimension Tables
  • Star Schema and Snowflake Schema
  • Tasks :
  • Create a Kettle transformation to map PHI-Minimart transactional database sample to dimensional modeling database
  • Create logs for each steps

Module 7: Change Data Capture (CDC)

  • What is CDC ?
  • Why CDC is so hard that heavily relied on data source ?
  • SQL Server 2008’s CDC feature demonstration
  • Tasks :
  • Create a Kettle transformation to map PHI-Minimart transactional database sample to dimensional modeling database
  • Create logs for each steps

Module 8: Slowly Changing Dimension (SCD)

  • Slowly Changing Dimension to solve master data historical problems
  • SCD Types
  • Use of Kettle’s step to solve several SCD types with several schema :
  • Insert / Update
  • Punch Through

Module 9: Orphan / Late Arrival

  • What is Late Arrival Dimension?
  • Typical Situations where Late Arrival occurs
  • Best practice of Late Arrival’s handling

Module 10: OLAP View of Multidimensional Data (Mondrian / JPivot)

  • Mondrian Installation
  • Creating scheme based on our fact and dimension tables
  • View and navigate our Cube using Web Browser

Module 11: Data Staging

  • What is Data Staging?
  • Background : Physical I/O versus In-Memory Processing
  • Task :
  • Create a transformation to join from 3 data sources : text file, Excel spreadsheet, and RDBMS
  • Create a currency staging table to solve sequential dependence problem

Module 12: Advance Controls

  • Environment Variables
  • Shared Objects
  • Error Handling
  • Email job results
  • Task :
  • Create a dynamic tables dump using variable and looping control
  • Refining existing transformations to use email alert

Module 13: Automation

  • Using Windows Task Scheduler to schedule ETL running job and transformation



Target Audience:

This program is designed for those new to Data Warehouse and ETL or need to understand the basics of Pentaho Data Integration.



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)



VENUE AND TIME

Time                : 09.00AM – 05.00PM

Venue             : AXA Tower – Kuningan City, Jakarta Selatan



INVESMENT

Information Fee at proposal

 

Data Warehouse with Pentaho Data Integration

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
 

cforms contact form by delicious:days