Orange and Bronze Software Labs, Inc

Pentaho Business Analytics Boot Camp

We have no schedule for the Boot Camp right now.

For inquiries:
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.
Contact numbers:
624.9790, 894.3415 and 813.5967, (0917) 878 9708


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:

  1. Understand the architecture of the Pentaho Business Analytics suite
  2. Describe and Demonstrate the reporting end-user experience with the Pentaho BI Server
  3. Perform multiple data transformations
  4. Use PDI and ETL design patterns to populate a data warehouse star schema
  5. Develop basic OLAP schemas for and using Pentaho Analysis
  6. 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 hours
Installation of the Pentaho Business Analytics Suite
Provides experience installing the Pentaho Business Analytics suite.
 1 hour
Analysis Solutions Overview
Presents an overview of the concepts and typical architecture of analysis solutions, including star schemas, fact tables and dimensions.
 1 hour
Dimensional Modeling
Describes and provides hands-on experience with dimensional modeling and building star schemas.
 2 hours

ETL and Pentaho Data Integration Overview
Explores the concepts and basics of extract, transform, and load tools and Pentaho Data Integration.

 2 hours


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 hours
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 hours
Set and Pivot Transformations
Builds on the Look-ups and Field Transformations module by exploring for sorting and manipulating sets of data.
 2 hours
Jobs and Transformations
Explores techniques for arranging transformations into jobs including the scheduling of jobs.
 1 hour


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 hour
Schema Workbench
Students will learn how to use Schema Workbench to create their first Analysis xml schema.
 7 hours


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 hour
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 hours
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 hour
Parameterized Reports
Publish reports to the Pentaho User Console for shared use. Create report parameter screens to prompt users for reporting criteria.
1 hour
Dashboard Designer
Detailed demonstration and lab using the Pentaho dashboard designer. A discussion of the Community Dashboard Framework.
1 hour

For more information, please contact This email address is being protected from spambots. You need JavaScript enabled to view it. or call 8943415.

Contact us at
+632 894.34.15

Call us now for more info
about our services or email This email address is being protected from spambots. You need JavaScript enabled to view it.