Pentaho Training

Share course

Pentaho Online Training Concepts :

Introduction to BI and Dimensional Modeling

  • Basic Architecture of PentahoIntroduction 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
  • 3 Types of repositories and their specific usage
  •  Taking the backup of repositoryRestoring 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

 

Key Highlights

 

  • PSN Trainings is a leading online training provider across the globe. Our online training team is highly qualified, experienced and skilled with real time  industry experience.

PSN Trainings Highlights:

 

  • Instructor Led Online Courses  with 24x7 On-Demand Support
  • World Class Trainers with +12 years Industry Experience. Instructors are not just trainers they are Consultants
  • We provide  24/7 Server access to help our trainees practice exercises
  • Teaching Material Prepared by Experts from PSN Trainings who have real time experience
  • Hands on Lab Assignments
  • 100% Placement Assistance
  • Project Based learning to get hands-on experience on a real life application!
  • Providing high quality interactive and cost effective online Training
  • Live Interactive classes by industry experts.

Trainer Information:

 

  • Having 7  years of  IT Industry Experience
  • 3  years  of Pentaho Real Time Experience
  • Having  2 yrs experience  as an online trainer for Pentaho
  • Held up to 10+ batches in past 2 Years
  • Trainer has an excellent practical & industrial knowledge

Enquiry