PENTAHO

TechgenLabs is one of the leading IT online Training and Placements Organization in USA. Pentaho  Online Training classes by TechgenLabs with highly qualified and excellent experienced trainers. Our trainers are experts and they have more experience in the real time environment in Pentaho  online training. We provide interactive and effective training for our student. So that you can interact with the faculty to clarify your doubts. Our team of well experienced Pentaho  online trainers with vast real time IT experience in Pentaho  Online Training is dedicated towards providing quality training in Pentaho  Online Training. We provide all real time interview questions to the students. We will provide recorded videos and material for future reference. Pentaho  Online Training is your one stop & Best solution to learn at your home with flexible timings. We placed our students in USA, UK, Singapore, Malaysia, Canada, South Africa, and Scotland. We  provide Pentaho  interview support and project support.t.

Pentaho Online Training Course Content

Introduction to BI and Dimensional Modeling
Basic Architecture of Pentaho and Pentaho BI Suite introduction and it’s Components.

  • PDI
  • Design Studio
  • Metadata Editor
  • Report Designer
  • Schema Work Bench.

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 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 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
  • 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