Pentaho BI Training

Pentaho BI Training is essential to work with the customers and learn how to set the environment to deploy actual customer premises to identify solutions. Pentaho’s core offering is frequently enhanced by add-on products, and plug-ins in the Pentaho ecosystem.

Pentaho BI Training Curriculum

Pentaho BI Concepts

Introduction to BI and Dimensional Modeling, Basic Architecture of Pentaho, Introduction to Pentaho BI suite and number of components in it. (PDI, Metadata Editor, Schema Work bench, Report Designer, Design Studio), Various component of PDI a.k.a kettle (Spoon/Pan/Kitchen), Usage of spoon/pan/kitchen Dealing with repository.

Importance of repository and its usage, Creating a repository, Three Types of repositories and their specific usage, Taking the backup of repository, Restoring the repository

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 Detail

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 Mappings Regular Expression.

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 and User defined parameters

Scheduling of job/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, Best Practices Performance Tuning and QA.
Pentaho BI Reporting

Creating data source connection (JDBC/JNDI/XML/OLAP/PDI), Report Template (Headers etc), Report Formatting, Create a report using different types of database connection, Create a report using Pentaho, OLAP Cube Charts, Use of formula, Conditional Formatting of Row Conditional Formatting Parameter, Creation Use of sub-reports, Publish the Reports to BI Server, User Level Security Hyperlinking Reports.
Pentaho BI Dashboards

Introduction to Pentaho BI Server and Pentaho Enterprise Server, Create a DATASOURCE at BI Serer, Create Simple Pentaho Dashboard using Pentaho Dashboard Designer, Create a drill down dashboard, Best Practices
Pentaho BI Cubes