Pentaho Data Integration for Data Warehouse
Pentaho Data Integration for Data Warehouse
Available Online & Offline Training
- 1-2 September 2026, Online via Zoom Meeting (Confirmed Running)
Tanggal dan Lokasi training lainnya silakan KLIK DI SINI
Pentaho Data Integration for Data Warehouse 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.
Pentaho Data Integration for Data Warehouse 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)
Training Methods
The training can be conducted using two methods, allowing participants to choose the most suitable option:
Offline Training Method:
- The instructor conducts face-to-face training for 8 hours per day (8:00 AM – 4:00 PM (WIB)) over 2 scheduled days.
- Techniques used: presentations, discussions, practical exercises/simulations, roleplay, and case studies.
- The training is conducted in a classroom setting.
Live Online Training Method:
- The instructor conducts live training for 4 hours per day (8:00 AM – 12:00 PM or 1:00 PM – 5:00 PM (WIB)) over 2 scheduled days.
- Techniques used: presentations, discussions, practical exercises/simulations, roleplay, and case studies.
- The training is conducted via Zoom or Google Meet.
- Live Online Training Requirements:
-
- Participant Preparation
- It is recommended to use a laptop instead of a smartphone.
- Ensure a stable internet connection.
- Prepare notebooks and writing tools.
- Participants must install the necessary applications before the training session. If assistance is needed, they may contact our staff before the training begins.
- Platforms Used
- The primary platforms for live training sessions are Zoom or Google Meet.
- Materials, assignments, and documents can be accessed via Google Classroom, Google Drive, Email, or WhatsApp, depending on the organizer’s instructions.
- How to Join the Video Conference
- The organizer will send an invitation link.
- Click on the provided link and follow the instructions.
- You will be directed to the video conference session.
- Participant Preparation
Examination Method
- The examination will be conducted on the third day or according to a mutual agreement.
- The exam will be held online using Zoom or Google Meet.
- Participants will be required to complete 50 multiple-choice questions within a 2-hour time limit.
Instructors
Ifan Prihandi, S.Kom., M.Kom., OCI., CASF™.
and team.
JADWAL TRAINING 2026
The training schedule can be adjusted based on participants’ requests and trainer availability.
|
Month 2026 |
Dates |
|
Januari |
06–07, 08–09, 13–14, 20–21, 22–23, 27–28, 29–30 |
|
Februari |
03–04, 05–06, 10–11, 12–13, 19–20, 24–25, 26–27 |
|
Maret |
03–04, 05–06, 10–11, 12–13, 17–18, 24–25, 26–27, 31 Maret–01 April |
|
April |
07–08, 09–10, 14–15, 16–17, 21–22, 23–24, 28–29 |
|
Mei |
05–06, 07–08, 12–13, 19–20, 21–22, 28–29 |
|
Juni |
02–03, 04–05, 09–10, 11–12, 18–19, 23–24, 25–26, 30 Juni–01 Juli |
|
Juli |
02–03, 07–08, 09–10, 14–15, 16–17, 23–24, 28–29, 30–31 |
|
Agustus |
04–05, 06–07, 11–12, 18–19, 20–21, 27–28 |
|
September |
01–02, 03–04, 08–09, 10–11, 15–16, 17–18, 22–23, 24–25, 29–30 |
|
Oktober |
01–02, 06–07, 08–09, 13–14, 15–16, 20–21, 22–23, 27–28, 29–30 |
|
November |
03–04, 05–06, 10–11, 12–13, 17–18, 19–20, 24–25, 26–27 |
|
Desember |
01–02, 03–04, 08–09, 10–11, 15–16, 17–18, 22–23, 29–30 |
Jadwal Training 2026
Investments and Facilities
Opsi 1 –Online |
|
Opsi 2 –Pelatihan Offline di Yogyakarta |
|
Opsi 3 –Pelatihan Offline di Solo, Semarang |
|
Opsi 4 –Pelatihan Offline di Jakarta, Surabaya, Bandung |
|
Opsi 5 –Pelatihan Offline di Luar Pulau Jawa (Batam, Medan, Balikpapan, Bali dll) |
|
