The Pentaho BI platform provides a solution-oriented infrastructure for deploying multiple types of business intelligence content. This 1-day course provides an in-depth overview of platform architecture and Pentaho's approach to building BI applications. Basic constructs such as components, action sequences, the solution repository, connections, inputs, outputs, resources, looping and result sets are covered in detail. Students walkthrough the installation of the PCI and customize e-mail and repository publishing settings. Pentaho Design Studio is used to examine and test action sequences that "burst" reports with customized data content, as well as to set parameter defaults and retrieve user-supplied values from different input sources. The scheduling and subscription interfaces are presented as core facilities that enable production reporting.

Pentaho Reporting allows organizations to easily access, format, and distribute information to employees, customers, and partners. Pentaho Reporting provides access to information in relational, OLAP, or XML-based data sources, and delivers output in popular formats including Adobe PDF, HTML, Microsoft Excel, Rich Text Format, or plain text. Comprehensive formatting capabilities give report designers the ability to highlight exceptions, create groupings, and add totals and subtotals. This intensive 3-day course focuses on the knowledge and hands-on skills needed to create, customize, deploy and secure Pentaho reports. Using a series of step-by-step, instructor-led labs, students learn basic and intermediate design techniques using the Pentaho Report Designer. Labs emphasize report layout and organization, data source parameterization, grouping, calculations, conditional formatting and charting.