Pentaho Online Training

Pentaho Online Training

  • 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 aka kettle (Spoon/Pan/Kitchen) Usage of spoon/pan/kitchen
  • Dealing with repository
  • Importance of repository and its usage
  • Creating a repository
  • 3 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 Join
  • 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
  • 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 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 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 Cubes

  • 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