| Module | Est. Duration (hours) |
|---|---|
| Pentaho Platform Concepts Discusses the concepts of Business Intelligence and architecture of the Pentaho BI platform. |
2 |
| Installation of the Pentaho BI
Suite Provides experience installing the Pentaho BI Suite. |
1 |
| Analysis Solutions Overview Presents an overview of the concepts and typical architecture of analysis solutions, including star schemas, fact tables and dimensions. |
1 |
| Dimensional Modeling Describes and provides hands-on experience with dimensional modeling and building star schemas. |
2 |
| ETL and Pentaho Data Integration
Overview Explores the concepts and basics of extract, transform, and load tools and Pentaho Data Integration. |
2 |
| Module | Est. Duration (hours) |
|---|---|
| Pentaho Data Integration Provides hands on experience with the techniques to pull data from a data source (flat file, relational table, etc) and move it to another. Labs will load relational Star Schema designed on Day 1. |
4 |
| Look-ups and Field Transformations Provides experience with the techniques for performing look-ups, joining various sources of data, and transforming individual fields during transformations. |
2 |
| Set and Pivot Transformations Builds on the Look-ups and Field Transformations module by exploring for sorting and manipulating sets of data. |
2 |
| Jobs and Transformations Explores techniques for arranging transformations into jobs including the scheduling of jobs. |
1 |
| Module | Est. Duration (hours) |
|---|---|
| Pentaho Analysis Introduces the tools, concepts, and architecture of Pentaho Analysis. Students create a Mondrian cube against the star schema created on Day 2, then drill and pivot the data using the User Console. |
1 |
| Schema Workbench Students will learn how to use Schema Workbench to create their first Analysis xml schema. |
7 |
| Module | Est. Duration (hours) |
|---|---|
| Introduction to the Reporting
Concepts Introduction of the Report Designer to produce high fidelity reports, including calculations and expressions. |
1 |
| Report Wizard Explores techniques for creating and publishing a report using the Report Wizard. |
1 |
| Report Designer Provides hands on experience with connecting to a dataset, Design Elements, the use of Hyperlinks, Report Functions and Groupings. |
6 |
