Pentaho BI Certification Training


Pentaho BI Certification Training

A self-paced online training designed for both technical and non-technical BI practitioners to develop their skills and knowledge for the most effective use of the Pentaho Business Intelligence (BI) Suite, required for successful projects.


Online self paced classes

Online Self Learning Courses are designed for self-directed training, allowing participants to begin at their convenience with structured training and review exercises to reinforce learning. You’ll learn through videos, PPTs and complete assignments, projects and other activities designed to enhance learning outcomes, all at times that are most convenient to you.

Introduction to Pentaho BI Suite

Learning Objectives: In this module, you will understand Pentaho’s journey till date and get familiar with their various product offerings.


  • About Pentaho
  • Pentaho BI(CE vs. EE)
  • Pentaho Data Integration(PDI)
  • Pentaho Report Designer(PRD)
  • Pentaho Metadata Editor(PME)
  • Mondrian
  • Pentaho Schema Workbench(PSW)
  • Dashboard Capabilities

Pentaho Report Designer - Basic

Learning Objectives: In this module, you will design, build and publish custom reports using Pentaho Report Designer.


  • PRD Layout
  • Understanding it’s Basic Features
  • Designing Basic Report Containing Graphical Chart
  • Conditional Formatting
  • Studying the PRPT File Format
  • Building a Basic Report in PDF Report

Pentaho Report Designer - Advanced

Learning Objectives: In this module, you will get acquainted with advance features of reporting and getting hands on with features like sub-report, cross tabs.


  • Data Source Connection
  • Query Designer
  • Working with Group(Group Header, Group Footer)
  • Passing Parameter
  • Using Formula
  • Designing Report with Subreport
  • API Based Reporting

Pentaho Data Integration - Introduction

Learning Objectives: In this module, you will Understand ETL (Data Extract, Transform and Load) and learn PDI features.


  • ETL Concepts
  • PDI GUI Layout
  • Repository
  • Supported Data Types for Connectivity
  • Wizard
  • Marketplace

Pentaho Data Integration - Transformation

Learning Objectives: In this module, you will understand transformation and various steps.


  • What is Transformation
  • Step
  • Hop
  • Variable
  • Various Input Steps
  • Various Output Steps
  • Transformation Steps
  • Big Data Steps
  • Scripting
  • Integration with Hadoop HDFS and NOSQL MongoDB
  • PDI and Map Reduce

Pentaho Data Integration - Job and More

Learning Objectives: In this module, you will understand PDI – Job and various entries, file formats for KTR (Kettle Transformation) and KJB (Kettle Job).


  • What is PDI-job
  • Entries
  • Job Orchestration
  • Integrating Report
  • Logging
  • Understanding Repository
  • File Based Repository
  • Database Repository
  • Example with Job Containing Multiple Entries

Pentaho BA Server and User Console

Learning Objectives: In this module, you will understand Pentaho BA Server and its administration through user console.


  • Getting Started with Pentaho Business Analytics
  • User Console Navigation
  • Analysis Tools
  • Using Data Sources
  • JPivot
  • Integrating Report on BI

How will I execute the practicals?

For your practical work, detailed step by step installation guides will be present in your LMS which will help you to install and set-up Pentaho Suite.

Will I get placement assistance?

To help you in this endeavor, we have added a resume builder tool in your LMS. Now, you will be able to create a winning resume in just 3 easy steps. You will have unlimited access to use these templates across different roles and designations. All you need to do is, log in to your LMS and click on the “create your resume” option.

Who are the Instructor at CertAdda?

All the instructors at CertaAdda are practitioners from the Industry with minimum 10-12 yrs of relevant IT experience. They are subject matter experts and are trained by edureka for providing an awesome learning experience.

What if I have more queries?

Just give us a CALL at +91 8178510474 / +91 9967920486 OR email at