Pentaho Course - Open Source Business Intelligences Training

1. Introduction to Pentaho BI Server, Pentaho Report & Pentaho Data Integration [4 Days Course]

Who Should Attend:

• This course is designed for
  
  • solution architects and business analysts with basic knowledge of relational database concepts and SQL.
  • 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:
  • 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 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

The above mentioned courses are currently carried out at the client office .

All course fees are on a prepayment basis.