Training - Course Description
Course:
Pentaho Business Analytics Bootcamp
Id: SLN5000
Audience: All
Delivery Method: Instructor-led Lecture/Lab
Duration: 4 Days
Cost: USD $2,500 ($2,500 for international locations)
Note: Discounts do not apply to the Bootcamp course.
Course Availability
| Location | Language | Provider | Date/Time | Availability |
| Geneva, , Switzerland | Français | Feb 14, 2012 9:00 AM | Register Now | |
| San Francisco, CA | English | Feb 28, 2012 9:00 AM | Register Now | |
| Paris, , France | Français | Mar 13, 2012 1:00 PM | Register Now | |
| Chicago, IL | English | Mar 20, 2012 9:00 AM | Register Now | |
| Zurich, , Switzerland | English | Apr 17, 2012 9:00 AM | Register Now |
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:
- Understand the architecture of the Pentaho Business Analytics 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 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 |
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 |