Pentaho BI Suite Bootcamp (SLN5000)
Course Benefits:
Business intelligence (BI) is a valuable tool to gain visibility into the health of departments, business, and business processes. The Pentaho BI Suite is provides a platform—including a server, client tools, and technologies—that enable the full spectrum of BI. This course provides a hands-on overview of the Pentaho BI Suite for consultants and those experienced with BI.
Who Should Attend:
This course is designed for system administrators, system integrators, content developers, software developers, and BI consults; however, it is valuable to anyone with a basic understanding of SQL and relational database concepts.
Learning Objectives:
At the completion of this course, you should be able to:
- Understand the architecture of the Pentaho Business Intelligence (BI) Suite
- Describe and Demonstrate the reporting end-user experience with the Pentaho BI Server
- Perform multiple data transformations
- Use PDI and ETL design patterns to populate a data warehouse star schema
- Develop basic OLAP schemas for and using Pentaho Analysis
- Build and deploy reports
Course Prerequisites:
This course has no Pentaho Training course prerequisites. It is, however, a fast paced course intended for technical consults or those experienced in BI.
Course Requirements:
Students will need a Microsoft® Windows XP or Vista computer with a 1GHz CPU, 1 GB RAM, and a DVD drive, and 750 MB of available hard drive space in order to fully participate in the classroom delivered courses. We suggest the computer have at least 1.3 GHz CPU, 2 GB of memory, and 1 GB of available hard drive space. Make sure you have a text editor such as Notepad; you may need it for some of the exercises.
Day 1
| 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 |
Day 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 |
Day 3
| 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 |
Day 4
| Module | Est. Duration (hours) |
|---|---|
| Introduction to the Reporting Concepts Introduction of the Report Designer to produce high fidelity reports, including Sub Report, Charts, Parameter Screens, Calculations and Expressions. |
1 |
| Report Designer Provides hands on experience with Report Wizard, connecting to a Data Source, Design Elements, Hyperlinks, Charts, Groupings. Using Sub Reports, to create a report that displays multiple report objects for a "dashboard feel". |
4 |
| Calculations Use Formula Expressions to add styles to your report like Traffic Lights and the conditional display of objects. Report Functions for creating row and summary calculations and many others. |
1 |
| Parameterized Reports Publish reports to the Pentaho User Console for shared use. Create report parameter screens to prompt users for reporting criteria. |
1 |
| Dashboard Designer Detailed demonstration and lab using the Pentaho Dashboard Designer. A discussion of the Community Dashboard Framework. |
1 |
(+351) 21 896 71 50
