This comprehensive four-day online 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)

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

• 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

Download Course Outline