Pentaho BI Suite Intellipaat Online Training Course

Our specially designed Pentaho training will include Basic Architecture of Pentaho, Introduction to Pentaho BI suite, PDI, Metadata Editor, Schema Work bench, Report Designer, Design Studio.
1st Floor, 10th Cross,28th Main,Bangalore
INR 18,000

Course at a Glance

Mode of learning : Online - Self Paced

Domain / Subject : Engineering & Technology

Function : Information Technology(IT)

Duration : 16 Hours

Difficulty : Basic

Key Highlights !

  • 16hrs of high quality interactive e-learning sessions with 3 months access
  • Multiple Assignment and lab exercises for practiceand focused on Clearing Pentaho Hadoop Connectivity Certification
  • 24/7 access to video tutorials and Email Support along with online interactive sessiosnsupport with trainer for issue resolving
  • Life time access to Course Material.
  • Job assistance – US, UK, and Indian Clients and partners. Intellipaat enjoys strong industry collaboration with +60 clients and multiple consultancy partners across the globe
  • Sample Resume Preparation along with mock up interview session included
  • Intellipaat Course Completion Certificate at the end of the course
  • Professional faculty with more than 18 years of experience in the industry and trained 50 corporates and 20000 professionals in last 3 yr

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

a.Importance of repository and its usage
b.Creating a repository
c.Types of repositories and their specific usage
d.Taking the backup of repositoryRestoring the repository

  • Dealing with Transformations

a.Creating simple transformations
b.Saving the transformation to the repository
c.Executing the transformation
d.Introduction to basic steps (various input,output,transformation steps)

  • Understanding Steps In Detail

a.Use of various input steps
b.Use of various output steps
c.Use of various transformation steps
d.Use of Joins
e.Flow controls available in PDI
f.Lookup data at various sources
g.Data Validation

  • Dealing with Jobs

a.Creating jobs
b.Executing transformation using jobs
c.Passing and retrieving data to/from the transformations.
d.Conditional execution of jobs
e.Pre-execution Validation with job.
f.File management through Jobs

  • Dealing with Variables

a.Creating and using variables within transformation/job
b.How to create variables and how to use them in transformations
c.Where to use variables
d.Scope of variables

  • Dealing with Parameters

a.Creating and using parameters
b.System parameters
c.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

ETL Connectivity with Hadoop Ecosystem

  • How  Pentaho tools work in Big data Industry
  • End to End ETL PoC showing Hadoop integration with Pentaho ETL tool.
  • Creating Map Reduce job in ETL tool
  • Working with Hive with Pentaho Tool
  • Moving Data from DBMS to HDFS
  • Connecting to HDFS from Pentaho tool and moving data from Local system to HDFS


Write Your Own Review

Write your review here (required)

Is the price of course overrated?
would you recommend this course to others?
Is duration of the course sufficient enough?
Did you like the faculties?
What would you prefer in future classroom or online learning?

Key features

Related Courses:

Disclaimer: The contents of the course & Institute are obtained from the institute’s website by automated scraping or manual updates. For the latest information, please refer the institute website directly. For any discrepancies in the content, contact us at

Sample Video