Session : 1 – Introduction to BI and Dimensional Modeling

Session : 2 – Basic Architecture of PentahoIntroduction to Pentaho BI suite and number of components in it.(PDI,Metadata Editor, Schema Work bench, Report Designer, Design Studio)

Session 3: – 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
  • Types of repositories and their specific usage
  • Taking the backup of repositoryRestoring the repository

Session : 5 – 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

Session : 5 – 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

Session : 6 – 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

Session : 7 – Dealing with Parameters

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

Session : 8 – Scheduling of job/transformation

Session : 9 – Running & debugging of jobs and transformation,Storing Log Information into log tables

Session : 10 – SCD implementation How to implement Slowly Changing Dimension using Pentaho kettle.

Session : 11 – CDC Implementation How to implement Change Data capture logic using kettle

Session : 12 – Best Practices , Performance Tuning and QA

Session : 13 – Pentaho 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

Session : 14 – Pentaho 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

Session : 15 – Pentaho Cubes

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

Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.

Kaviya