Course:
Pentaho Business Analytics Bootcamp(retired)
Id: SLN5000
Audience: All
Delivery Method: Instructor-led Lecture/Lab
Duration: 4 Days
Cost: USD $2,500 ($2,500 for international locations)
Course placement: This course was formerly the first course in the Pentaho Business Analytics learning path.
It has been replaced by Pentaho Business Analytics for Business Analysts – SLN4000.
Outside the United States, Pentaho Authorized Training Providers may still offer the Pentaho Business Analytics Bootcamp course until preparatory and
translation work has been completed. As of January 1, 2013, the Pentaho Business Analytics Bootcamp course will no longer be offered in any location.
Note: Discounts do not apply to the Bootcamp course.
Course Benefits:
Business intelligence (BI) is a valuable tool to gain visibility into the health of departments, business, and business processes. The Pentaho Business Analytics suite is 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 Business Analytics 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:
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 attending classroom courses in the United States are provided with a PC to use during class. Students attending courses outside the US should contact the Authorized Training Provider regarding PC requirements for Pentaho courses.
In general, if your training provider requires you to bring a PC to class, it must meet the following requirements (you can also verify your system against the Compatibility Matrix: List of Supported Products topic in the Pentaho InfoCenter :
| Module | Est. Duration (hours) |
|---|---|
| Pentaho Platform Concepts Discusses the concepts of Business Intelligence and architecture of the Pentaho platform. |
2 |
| Installation of the Pentaho Business Analytics Suite Provides experience installing the Pentaho Business Analytics 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 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 |
