Pentaho Developer course structure is a focused on learning Pentaho BI suite. Topics covered in this course, include Pentaho Data Integration (Kettle) , Reports, Dashboard, Cubes, Action Sequence. Pentaho developer course focuses on traini…
4.8 · Rated by learners Certificate of completion
Duration
20 Hours
Mode
Live + Recorded
Level
Beginner → Pro
Language
English / Hindi
AI practice, included with this course
Rehearse the interview and test yourself before the real thing.
Available in your student dashboard as soon as you enrol —
no extra charge, nothing to install.
Course overview
About the Pentaho program.
Pentaho Developer course structure is a focused on learning Pentaho BI suite. Topics covered in this course, include Pentaho Data Integration (Kettle) , Reports, Dashboard, Cubes, Action Sequence. Pentaho developer course focuses on training participants on creating dimensional model , Understanding implementation large scale data warehouses , setting up Pentaho BI Suite, writing ETL transformations and Jobs, creating Reports and Dashboards, Creating Cubes and working with MDX and Action Sequence.
Why learn with BISP
Trusted by professionals across 30+ countries.
Industry trainers
Certified consultants with 12+ years of real project experience.
Hands-on practice
Real-time scenarios & live project modules, not just slides.
Placement support
Resume building, mock interviews & job referrals.
Certification
BISP certificate + full guidance for official exams.
Course curriculum
Designed by real-time industry professionals around current job roles.
Understanding importance of BI and designing dimensional Model
Setting up Pentaho BI suite
Creating Transformation and Jobs with best industry practices and working with Repository
Designing and developing Reports and Dashboards
Creating Cubes ,working with MDX and Action Sequence
02Introduction to BI and Dimensional Modeling7 topics
Basic Architecture of Pentaho
Introduction to Pentaho BI suite and number of components
PDI
Metadata Editor
Schema Work bench
Report Designer
Design Studio
03Dealing with repository3 topics
Importance of repository and its usage
Creating a repository
Types of repositories and their specific usage
04Dealing with Transformations4 topics
Creating simple transformations
Saving the transformation to the repository
Executing the transformation
Introduction to basic steps (various input, output, transformation steps)
05Understanding Steps in details7 topics
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
06Dealing with Jobs6 topics
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
07Dealing with variables4 topics
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
08Dealing with Parameters3 topics
Creating and using parameters
System parameters
User defined parameters
09Scheduling of Jobs and Transformation1 topics
Running & debugging of jobs and transformation Storing Log Information into log tables
10SCD implementation1 topics
How to implement slowly changing dimension using Pentaho Kettle?
11CDC Implementation1 topics
How to implement Change Data capture logic using kettle
12Schema Workbench4 topics
Introduction to Dimension Modeling Structure
Creating Schema file
Creating cube and deploying
Introduction to MDX
13Pentaho Report Designer (PRD)6 topics
Creating data source connection
JDBC
JNDI
XML
OLAP
PDI
14Report Formatting9 topics
Create a report using different types of database connection
Create a report using Pentaho OLAP Cube
Charts
Use of formula
Conditional Formatting
Parameter Creation
Use of sub-reports
Publish the Reports to BI Server
Hyper linking Reports
15Dashboard CDE (CDF Framework)3 topics
Create a DATASOURCE at BI Serer
Create Simple Pentaho Dashboard using Pentaho Dashboard Designer
Create a drill down dashboard using action sequence and reports
16Delivery Methodology1 topics
We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course
17Class Delivery1 topics
Live Interactive classes with expert
Course details
Who it is for, what you need, and how it is delivered.
Who should learn Pentaho?
Database profesionals
Prerequisites
Basic Concepts of Business intelegence , Data Warehousing and SQL
Delivery methodology
We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.
Class delivery
Live Interactive classes with expert
Certificate of completion
Earn an industry-recognised BISP Trainings certificate when you finish the course.
Verifiable certificate with a unique ID
Shareable on LinkedIn & your resume
Recognised by our hiring partners
Frequently asked questions
Everything you need before you enroll.
Can I attend a demo session before enrollment?
Yes. You may attend a demo class before enrollment for training quality evaluation, and interact one-to-one with the trainer for any specific requirement.
Can you schedule training as per my availability?
Yes. We discuss it with the trainer and schedule the training at a convenient time for you.
What if I miss a class?
You get the recorded session. You may also retake the whole training multiple times within a 6-month period with the same trainer.
Is there live project training?
Yes. The curriculum includes real-time scenarios and live project modules, with the trainer explaining every topic end-to-end.
How can I pay for the course?
Enroll securely via the payment gateway on this page using card, UPI or net-banking. EMI options are available.
More queries?
Call us at +91 769-409-5404 & +1 678-701-4914, or write to support@bisptrainings.com.