Pentaho Training 10 to 13 January 2011

Home

Introduction to Pentaho BI Server, Pentaho Analysis & Pentaho Data Integration

This comprehensive four-day classroom training covers all the main features of Pentaho BI suite. It also introduces Agile BI; new approach to prototyping and validating business intelligence solutions. By enabling analysts and end-users to rapidly examine, manipulate, model and visualize business data, Agile BI accelerates the discovery of new information and helps organizations establish the value of BI projects before committing to long-term investments. This course uses the following Pentaho modules: Pentaho Platform (reporting), Pentaho Dashboard, Pentaho Analysis and Pentaho Data Integration.

Download Course Outline

Place:

iZeno Sdn Bhd
A-18-16, Level 18, Manara UOA Bangsar,
No. 5, Jalan Bangsar Utama 1,
Bangsar,
59000 Kuala Lumpur.
Malaysia.

Google Maps

Date:

10th to 13rd January, 2011

Time:

1000 to 1700 (GMT + 8)

Targeted Audience:

Solution architects
ETL Developers
Business analysts with basic knowledge of relational database concepts and SQL

Editions: Pentaho Enterprise Edition
Version(s): 3.6, 3.7
Type: Classroom Training with Hands On Lab

Objectives:

At the completion of this course, you should be able to:

Pentaho BI Server
- Install and configure the Pentaho BI Suite
- Understand the value proposition of Open Source Business Intelligence Suite Pentaho
- Understand the typical workflow of solution development
- Understand the basic architecture and tools of Pentaho Reporting and the Pentaho BI Platform
Pentaho User Console Features
- Setting up new datasource
- Using analyzer
- Using adhoc report
- Construct datatable and chart using dashboard designer
Pentaho Report
- Author complex and dynamic reports using the Pentaho Report Designer
- Use the Pentaho Design Studio to parameterize reports
- Construct reports against relational data sources
- Include charts and subreports in reports
- Use hyperlinks within reports to build a network of reports
- Integrate Pentaho Reports into custom web applications
- Employ calculations and grouping techniques within a report
Pentaho Data Integration
- Understand the basic architecture of Pentaho Data Integration (PDI) and its modules
- Load and write data from and to different data sources
- Join data from different sources
- Perform multiple data transformations
- Use PDI and ETL design patterns to populate a data warehouse
- Influence the performance aspects of databases and PDI
- Develop advanced transformations and jobs
- Build portable and flexible jobs
- Use the logging, monitoring and error handling features
- Use JavaScript and Java classes into transformations
- Load, transform and create complex XML structures
- Retrieve and serve data via web services using PDI and the Pentaho BI Server
- Understand the integration in the Pentaho BI Suite