Pentaho Online Training

Pentaho  Online Training By IT Professionals

Prime Online Training offers Pentaho Online Training. Our Pentaho trainers are Highly talented and have Excellent Teaching skills. They are well experienced trainers in their relative field. Our online training is one of the Best online training in India For any technology. All our students were happy With our online training and able to find Jobs quickly in USA, UK, Singapore, Japan, Europe. online training is your one stop & Best solution to learn Pentaho at your home with flexible Timings.

Prime Online Training offers the Pentaho Online Training Course in a true global setting.

What is Pentaho?

Pentaho offers a suite of open source Business Intelligence (BI) products called Pentaho Business Analytics providing data integration,  OLAP services, reporting, dashboarding, data mining and ETL capabilities.

Pentaho Course Content Outline :

1.Introduction to BI and Dimensional Modeling
2. Overview of Pentaho Architecture
3.Introduction to Pentaho BI suite and number of components in it. (PDI,Metadata Editor, Schema Work bench, Report Designer, Design Studio)
4.Various components of PDI a.k.a kettle (Spoon/Pan/Kitchen)Usage of spoon/pan/kitchen
5.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

6.Dealing with Transformations

  • Creating simple transformations
  • Saving the transformation to the repository
  • Executing the transformation
  • Introduction to basic steps (various input,output,transformation steps)

7.Understanding Steps

  • Various input steps
  • Various output steps
  • Various transformation steps
  • Joins
  • Flow controls available in PDI
  • Lookup data at various sources
  • Procedure of Data Validation
  • Mappings
  • Regular Expression

8.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

9.Dealing with Variables

  • Creating and using variables within transformation/job
  • Creating and using Variables
  • Where we use variables
  • Main Scope of variables

10.Dealing with Parameters

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

11.Scheduling of job/transformation
12.Running & debugging of jobs and transformation,Storing Log Information into log tables
13.SCD implementation How to implement Slowly Changing Dimension using Pentaho kettle.
14.CDC Implementation How to implement Change Data capture logic using kettle
15.Best Practices , Performance Tuning and QA

Pentaho Reporting

1.Creating data source connection(JDBC/JNDI/XML/OLAP/PDI)
2.Templates Reporting
3.Formatting Reports
4.Create a report using different types of database connection
5.Create a report using Pentaho OLAP Cube
6.Charts
7.Use of formula
8.Conditional Formatting of Row
9.Conditional Formatting
10.Parameter Creation
11.Use of sub-reports
12.Publish the Reports to BI Server
13.User Level Security
14.Hyperlinking Reports

Pentaho Dashboards

1.Introduction to Pentaho BI Server and Pentaho Enterprise Server
2.Create a DATASOURCE at BI Serer
3.Create Simple Pentaho Dashboard using Pentaho Dashboard Designer.
4.Create a drill down dashboard
5.Best Practices

Pentaho Cubes

1.Introduction to Pentaho BI Server and Pentaho Enterprise Server
2.Create a DATASOURCE at BI Serer
3.Create Simple Pentaho Dashboard using Pentaho Dashboard Designer.
4.Create a drill down dashboard
5.Best Practices

Our Pentaho Online Training batches start every week and we accommodate your flexible timings.

PrimeTrainings provides online training for various courses like DatastageMicrostrategyInformatica QlikviewTeradataBOBICognosOBIEE, , Teradata Development,  Data Modelling 

Comments are closed.