Pentaho Course - Open Source Business Intelligences Training Class

1. Introduction to Pentaho BI (2 Day Course @ SGD 3,000)

Who Should Attend:

• This course is designed for solution architects and business analysts with basic knowledge of relational database concepts and SQL.

Learning Objectives:

• At the completion of this course, you should be able to:
• 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
• 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
• Dynamically build the SQL for a report
• Understand the architecture of Pentaho Analysis and its integration with the Pentaho BI Platform
• Develop OLAP schemas for and using Pentaho Analysis
• Employ OLAP security
• Utilize aggregates and other techniques to improve Pentaho Analysis performance

2. Pentaho Data Integration for Database Developers (2 Day Course @ SGD 3,000)

Who Should Attend:

• This course is designed for database developers and administrators; however, it is valuable to anyone with at least two years of experience with SQL and relational database design/implementation.

Learning Objectives:

• At the completion of this course, you should be able to:
• 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

The above mentioned courses are currently carried out at the client office with no restrictions on the number of participants. All course fees are on a prepayment basis.