Pentaho

Pentaho web based Online Training Curriculum

Course objective

• Understanding importance of BI and designing dimensional Model
• Setting up Pentaho BI suite
• Creating Transformation and Jobs with best industry practices and working with Repository
• Designing and developing Reports and Dashboards
• Creating Cubes ,working with MDX and Action Sequence

Introduction to BI and Dimensional Modeling

• Basic Architecture of Pentaho
• Introduction to Pentaho BI suite and number of components
• PDI
• Metadata Editor
• Schema Work bench
• Report Designer
• Design Studio

Dealing with repository

• Importance of repository and its usage
• Creating a repository
• Types of repositories and their specific usage

Dealing with Transformations

• Creating simple transformations
• Saving the transformation to the repository
• Executing the transformation
• Introduction to basic steps (various input, output, transformation steps)

Understanding Steps in details

• Use of various input steps
• Use of various output steps
• Use of various transformation steps
• Use of Joins
• Flow controls available in PDI
• Lookup data at various sources
• Data Validation

Dealing with Jobs

• Creating jobs
• Executing transformation using jobs
• Passing and retrieving data to/from the transformations.
• Conditional execution of jobs
• Pre-execution Validation with job
• File management through Jobs

Dealing with variables

• Creating and using variables within transformation/job
• How to create variables and how to use them in transformations?
• Where to use variables?
• Scope of variables

Dealing with Parameters

• Creating and using parameters
• System parameters
• User defined parameters

Scheduling of Jobs and Transformation

• Running & debugging of jobs and transformation Storing Log Information into log tables

SCD implementation

• How to implement slowly changing dimension using Pentaho Kettle?

CDC Implementation

• How to implement Change Data capture logic using kettle

Schema Workbench

• Introduction to Dimension Modeling Structure
• Creating Schema file
• Creating cube and deploying
• Introduction to MDX

Pentaho Report Designer (PRD)

• Creating data source connection
• JDBC
• JNDI
• XML
• OLAP
• PDI

Report Formatting

• Create a report using different types of database connection
• Create a report using Pentaho OLAP Cube
• Charts
• Use of formula
• Conditional Formatting
• Parameter Creation
• Use of sub-reports
• Publish the Reports to BI Server
• Hyper linking Reports

Dashboard CDE (CDF Framework)

• Create a DATASOURCE at BI Serer
• Create Simple Pentaho Dashboard using Pentaho Dashboard Designer
• Create a drill down dashboard using action sequence and reports

Delivery Methodology

• We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course

Class Delivery

• Live Interactive classes with expert