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 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 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
Day 5
Module
Est. Duration (hours)
Design Studio
Covers Design Studio, Report Calculations, Charts and Style Expressions.
6
Dashboard Designer
Detailed demonstration of the new Dashboard Designer.
English
Deutsch
