Weekend Deal - Flat 10% OFF on all courses

Pentaho Data Integration training

  • 155 Ratings
  • Learners : 310
  • 30 hrs

Pentaho Data Integration is a comprehensive Business Intelligence suite to construct end-to-end Business Intelligence solutions. The Pentaho Data Integration training course will not only assist the novices to appreciate different Pentaho tools and their corresponding features. It will also offer an insight into those tools to the experienced users. This will help both to construct an effective solution around it.

Watch Demo
Watch Demo Video

Key Features

  • 30 Hours of instructor-led live online training
  • 100% Practical approach with hands-on practice
  • Live project based on real-life case studies
  • Most experienced & certified trainers
  • Lifetime access to class recordings
  • 24x7 Teaching assistance and support

Upcoming Batches

  • 17


    7:00 AM IST (Saturday)

    Sat-Sun (5 Weeks)
  • 19


    7:00 AM IST (Monday)

    Mon-Fri (15 days)
  • 21


    7:00 AM IST (Wednesday)

    Sat-Sun (5 Weeks)

Modes of Training

Self-paced Video Learning
  • Access to high quality pre-recorded Hadoop Training videos ( from a previous live training )
  • LMS Access
  • Access to self-paced haddop Training material designed by experts.
Instructor Led
Instructor led live training
  • Live online training by Certified & industry expert Trainers.
  • On Demand Dedicated Cloud lab and LMS access.
  • 24X7 teaching assistance and suppoert.
  • Fast-track / Regular / Weekend batches.
Corporate training
Corporate training
  • Self-paced-e-learning and/or instructor led Live-online training options.
  • Learning Management System access.
  • Enhanced reporting for individuals and teams.
  • 24X7 Support

Course Details

Objectives of the course

The major goal of the Pentaho Data Integration is to make learners familiar with its Business intelligence suite by covering the Data Incorporation, Report Designer, Mondrian Cubes as well as Dashboards of Pentaho.  It is also useful for those who want to clear the Pentaho Data Integration examination successfully, as the course involves practicing of different projects in the real time.

Some of the other major goals of the course include:

  1. Make students gain acquaintance with the tools of Pentaho.

  2. Let learners understand the reporting concepts of the business and create reports using the Report Designer of Pentaho.

  3. Make them know the way to extract, transform, and load the data and get the practical experience with the Data Integration using Pentaho.

  4. Make participants familiar with the BI suite structural design of Pentaho.

  5. Make delegates acquainted with the Pentaho BI Server to create reports.

The right candidate to do the course

Although the Pentaho Data Integration does not need any prior knowledge and experience in BI, it is quite useful for:

  • BI developers.

  • Business Analysts.

  • Data Scientists.

  • Solution Architects.

  • DW programmers.

  • Mainframe and Testing experts.

Those who would like to assume a career in BI and Data Analytics can also join the course.

What skills will you learn with the course?

All the learning modes of the Pentaho Data Integration training offer a bounty of skills to learners, so you are no poles apart. Some of the skills you can develop by doing the course include:

  1. The training will offer you the skill to handle the lifecycle of projects in diverse development settings in an efficient way.

  2. You will have the ability to use the streaming data process of Pentaho Data Integration with Kafka and MQTT.

  3. You will get the skill to harness the metadata injection power by reducing physical tasks.

  4. You will be capable of scaling Pentaho Data Integration effectively by making use of Carte clustering, supervising, and partitioning.

  5. You can adjust Pentaho Data Integration with logging and checkpoints.

Projects included in the course

Moving further than the fundamentals of creating jobs and transformations, trainees will be provided with real-world projects in different business scenarios. They will know the way to add Pentaho Data Integration as a data resource for a range of visualization options, use its features for the streaming data processing, make conversions by injecting the metadata and can tune the scale as well as the performance in their Pentaho Data Integration solution. As the course mainly focuses on practical sessions, learners can rest guaranteed that they would get the best practical experience in implementing different projects in diverse business settings.

Why should you join the course?

In this digital world, as data is escalating and penetrating in varied forms, there is an increasing need for an adaptable, flexible, resourceful, and cost-efficient analytical platform to consume as minimum loading time as possible. Here only the Pentaho tool lends its helping hand. It will function in a perfect way to achieve all these aspects. Therefore, being trained in Pentaho will allow you to meet a variety of job challenges in the digital field easily and successfully.

As Pentaho Data Integration is an element of BI suite, learning it will allow you to use all the features of the software easily and effectively while making important business decisions, including the data warehouse running utilities, data incorporation and investigation tools, software manager, and data pulling out tools.

Pentaho Data Integration is renowned for its simple to use and fast culture curve. This is because it uses an approach that is driven by the metadata. This means that its development is purely based on indicating important things to perform. The tool will also allow you to generate your own data handling tasks with its easy to use graphical creator.

As Pentaho uses a universal, common repository, it will enable you to extract, transform, and load your data easily. Moreover, it will facilitate teamwork, as well, and it will make your development process simpler.

As many worldwide organizations have started embracing the Pentaho Data Integration tool for their everyday operations, they may need a skilled and trained expert in the software. Having a Pentaho certification with you will offer you many highly paid positions in these organizations.

Course Curriculum


  Lesson 1: Objectives & Class Logistics

  Lesson 2: What is Pentaho Data Integration (PDI)?


  Lesson 1: Learning the PDI User Interface

  Lesson 2: Creating Transformations

      Exercise 1: Generate Rows, Sequence, Select Values

  Lesson 3: Error Handling & Logging Introduction

  Lesson 4: Introduction to Repositories


  Lesson 1: Input & Output Steps

  Lesson 2: Parameters & kettle.properties

      Exercise 2: CSV Input to Multiple Text Output Using Switch/Case

      Exercise 3: Serializing Multiple Text Files

      Exercise 4: De-serialize a File


  Lesson 1: Connecting to & Exploring a Database

  Lesson 2: Table Input & Output

      Exercise 5: Reading & Writing to Database Tables

  Lesson 3: Insert, Update, & Delete Steps

  Lesson 4: Data Cleansing

  Lesson 5: Using Parameters & Arguments in SQL

      Exercise 6: Input with Parameters & Table Copy Wizard


  Lesson 1: Copying and Distributing Data

      Exercise 7: Parallel Processing

  Lesson 2: Lookups

      Exercise 8: Lookups & Data Formatting

  Lesson 3: Merging Data


  Lesson 1: Using the Group By Step

  Lesson 2: Calculator

      Exercise 9: Calculating & Aggregating Order Quantity

  Lesson 3: Regular Expression

  Lesson 4: User Defined Java Expression

  Lesson 5: JavaScript


  Lesson 1: Introduction to Jobs

      Exercise 10: Loading JVM Data into a Table

  Lesson 2: Sending Alerts

  Lesson 3: Looping & Conditions

       Exercise 11: Creating a Job with a Loop

       Lesson 4: Executing Jobs from a Terminal Window (Kitchen)


      Lesson 1: Setting up the Scheduler

      Lesson 2: Monitoring Scheduled Tasks


      Lesson 1: The Pentaho Data Integration Repository

      Exercise 12: Using the Pentaho Enterprise Repository


    Lesson 1: Detailed Logging throughout Execution

Exam & Certification

Once the course is completed all the trainees, who have successfully qualified their quizzes, model exams, and project review will be awarded a course completion certificate in the digital format. The certificate is recognized by all the global organizations that are using the Pentaho Data Integration tool. Qualified candidates can apply for many high position jobs in these organizations.


    No Reviews !!


1. What are the modes of training offered for this course?

You can register for the instructor-led, online, or self-paced training mode.

2. Can I attend a demo session before enrollment?

Yes to know about the course, you can attend a video session.

3. Who are the instructors taking the theory and practical classes?

All instructors handling the course have a rich experience and knowledge in the domain.

4. Are there any group discounts for classroom training programs?

Some institutes do offer but get in touch with your institute.

5. Can I switch from Self-Paced Training To Online Instructor-Led Training?

You can positively make the change to any learning mode you want from the current one.

6. What If I Miss A Class?

You can join the currently running batch or see the video tutorial of the missed class.

7. How Will I Execute The Practical?

All practical sessions are handled only by experienced trainers in the domain, so executing your practical is not at all a big issue.

8. What payment options are available?

Besides cash, you can pay your fees in different modes you want.

Request more information
By providing your contact details, you agree to our Privacy Policy