Weekend Deal - Flat 10% OFF on all courses

Pentaho Training

  • 176 Ratings
  • Learners : 342
  • 30 hrs

Pentaho is a comprehensive Business Intelligence suite, offering incorporation of Hadoop Distribution for managing huge dataset and performing reporting. The training course in Pentaho allows learners familiar with the comprehensive Business Intelligence suite of the technology. Doing the course enables students to know the way of Pentaho data incorporation, creating of Pentaho reports, as well as on the way of using Pentaho dashboards and cubes. Moreover, the training will aid them considerably in coming out of their Pentaho certification exam easily to become a Pentaho expert.

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 main aim of the Pentaho training is to equip participants will all aspects of Business Intelligence. This will offer them the knowledge on the of Business Intelligence features as well as on the concepts of Data warehousing. Additionally, the course is mainly designed to provide delegates with deep coverage of all features, benefits, and applications of the Pentaho technology. The training will equip them to assimilate Pentaho Business Intelligence suite seamlessly and effectively with Hadoop, which is an open source shared processing support that handles processing as well as storage for huge data applications operating in grouped systems.

The other objectives of the course include:

  1. To make learners professionally trained in using the Pentaho Business Intelligence Server to create reports as well as in Pentaho Analytics.

  2. To make them familiar with the ETL and PDI design pattern to inhabit the data-warehouse star plan.

  3. To offer them the ability to build up Mondrian Cube OLAP plans using the Pentaho workbench.

  4. To educate them on the way to adjust PDI job performances and conversions.

The right candidate to do the course

The training course is appropriate and helpful for those who are working as a:

  1. BI developer.

  2. Business Analyst.

  3. Data Scientist.

  4. Solution Architect.

  5. DW programmer.

  6. Testing and Mainframe expert.

The course is also useful for those who want to pursue their career in Data Analytics and Business Intelligence.

What skills will you learn with the course?

Joining the Pentaho training course will offer you:

  1. The skill to use the Pentaho BI Suite architecture in an effective way.

  2. You will be capable of performing manifold data incorporation, conversion, as well as analytics.

  3. You can know the effective use of the Dashboards as well as the Business Analytics of the Pentaho technology.

  4. You will have the ability to generate multifaceted statements as well as dashboards for investigation.

  5. You will be capable of incorporating Pentaho with large data pile, such as Map Reduce, HDFS, etc.

Projects included in the course

The Pentaho training course will offer you the most modernized, pertinent, and high-value projects in real time. These projects will offer you the skill to execute the techniques that you have learned in your theory classes. This will make you familiar with handling the projects in a real-world business setup easily and effectively. As the training is offered with many different real-time projects, you can rest guaranteed that you could master the technology in an effective and easy way. This means that you will be working with projects in a variety of domains, including the latest technology, marketing, e-commerce, sales, banking, networking, insurance, and much more.

Why should you join the course?

Nowadays, Big Data is quickly coming into the mainstream and there exists an urgent necessity for a versatile tool to deal with the ever-changing needs. Pentaho is one such an adaptable tool, which is both simple, as well as an efficient technology to be used in the modern business scenario. Thus, the certification in the Pentaho training will provide you with immense job opportunities.

Moreover, doing the training means you are learning the complete suite of the Pentaho BI. This means that you are becoming a master in using all types of servers, customer tools, and compatible technologies that will aid your organization substantially in attaining an entire range of Business Intelligence functionalities.

Furthermore, the training course is completely structured in proportion to passing the Certification examination in Pentaho Business Analytics. Therefore, you will get a practical training with real-time assignments as well as projects, which are structured in keeping the industry requirements in mind.

Moreover, the training course in Pentaho is being offered in different learning modes, which will allow you to do it at your own pace and convenience. These learning modes will offer you the required flexibility you need to become a professional in the field. Moreover, upon the completion of your projects successfully, your talents will be measured up to six months of painstaking industry experience. As you are working with the real-world projects during your practical sessions, you can rest guaranteed that you would come out of the course with excellence. Once you become a Pentaho professional, you can apply for top-level openings in many nationwide and worldwide organizations.

Career Improvement on doing the course

Nowadays, most businesses start embracing the Pentaho technology to enhance the quality of their data as well as to reduce the associated costs.  With your valuable certification in the technology, you can work as a Pentaho Big Data Analytics, Pentaho expert, as well as an executive in all leading roles in worldwide organizations.

Course Curriculum

Introduction to Pentaho Tool

Pentaho user console, Oveview of Pentaho Business Intelligence and Analytics tools, database dimensional modelling, using Star Schema for querying large data sets, understanding fact tables and dimensions tables, Snowflake Schema, principles of Slowly Changing Dimensions, knowledge of how high availability is supported for the DI server and BA server, managing Pentaho artifacts Knowledge of big data solution architectures

Hands-on Exercise – Schedule a report using user console, Create model using database dimensional modeling techniques, create a Star Schema for querying large data sets, Use fact tables and dimensions tables, manage Pentaho artifacts

Data Architecture

Designing data models for reporting, Pentaho support for predictive analytics, Design a Streamlined Data Refinery (SDR) solution for a client

Hands-on Exercise – Design data models for reporting, Perform predictive analytics on a data set, design a Streamlined Data Refinery (SDR) solution for a dummy client

Clustering in Pentaho

Understanding the basics of clustering in Pentaho Data Integration, creating a database connection, moving a CSV file input to table output and Microsoft Excel output, moving from Excel to data grid and log.

Hands-on Exercise – Create a database connection, move a csv file input to table output and Microsoft excel output, move data from excel to data grid and log

Data Transformation

The Pentaho Data Integration Transformation steps, adding sequence, understanding calculator, Penthao number range, string replace, selecting field value, sorting and splitting rows, string operation, unique row and value mapper, Usage of metadata injection

Hands-on Exercise – Practice various steps to perform data integration transformation, add sequence, use calculator, work on number range, selecting field value, sorting and splitting rows, string operation, unique row and value mapper, use metadata injection

Pentaho Flow

Working with secure socket command, Pentaho null value and error handling, Pentaho mail, row filter and priorities stream.

Hands-on Exercise – Work with secure socket command, Handle null values in the data, perform error handling, send email, get row filtered data, set stream priorities

Deploying SCD

Understanding Slowly Changing Dimensions, making ETL dynamic, dynamic transformation, creating folders, scripting, bulk loading, file management, working with Pentaho file transfer, Repository, XML, Utility and File encryption.

Hands-on Exercise – Make ETL dynamic transformation, create folders, write scripts, load bulk data, perform file management ops, work with Pentaho file transfer, XML utility and File encryption

Type of Repository in Pentaho

Creating dynamic ETL, passing variable and value from job to transformation, deploying parameter with transformation, importance of Repository in Pentaho, database connection, environmental variable and repository import.

Hands-on Exercise – Create dynamic ETL, pass variable and value from job to transformation, deploy parameter with transformation, connect to a database, set pentaho environmental variables, import a repository in the pentaho workspace

Pentaho Repository & Report Designing

Working with Pentaho dashboard and Report, effect of row bending, designing a report, working with Pentaho Server, creation of line, bar and pie chart in Pentaho, How to achieve localization in reports

Hands-on Exercise – Create Pentaho dashboard and report, check effect of row bending, design a report, work with Pentaho Server, create line, bar and pie chart in Pentaho, Implement localization in a report

Pentaho Dashboard

Working with Pentaho Dashboard, passing parameters in Report and Dashboard, drill-down of Report, deploying Cubes for report creation, working with Excel sheet, Pentaho data integration for report creation.

Hands-on Exercise – Pass parameters in Report and Dashboard, deploy Cubes for report creation, drill-down in report to understand the entries, import data from an excel sheet, Perform data integration for report creation

Understanding Cube

What is a Cube? Creation and benefit of Cube, working with Cube, Report and Dashboard creation with Cube.

Hands-on Exercise – Create a Cube, create report and dashboard with Cube

Multi Dimensional Expression

Understanding the basics of Multi Dimensional Expression (MDX), basics of MDX, understanding Tuple, its implicit dimensions, MDX sets, level, members, dimensions referencing, hierarchical navigation, and meta data.

Hands-on Exercise – Work with MDX, Use MDX sets, level, members, dimensions referencing, hierarchical navigation, and meta data

Pentaho Analyzer

Pentaho analytics for discovering, blending various data types and sizes, including advanced analytics for visualizing data across multiple dimensions, extending Analyzer functionality, embedding BA server reports, Pentaho REST APIs

Hands-on Exercise – Blend various data types and sizes, Perform advanced analytics for visualizing data across multiple dimensions, Embed BA server report

Pentaho Data Integration (PDI) Development

Knowledge of the PDI steps used to create an ETL job, Describing the PDI steps to create an ETL transformation, Describing the use of property files

Hands-on Exercise – Create an ETL transformation using PDI steps, Use property files

Hadoop ETL Connectivity

Deploying ETL capabilities for working on the Hadoop ecosystem, integrating with HDFS and moving data from local file to distributed file system, deploying Apache Hive, designing MapReduce jobs, complete Hadoop integration with ETL tool.

Hands-on Exercise – Deploy ETL capabilities for working on the Hadoop ecosystem, Integrate with HDFS and move data from local file to distributed file system, deploy Apache Hive, design MapReduce jobs

Creating dashboards in Pentaho

Creating interactive dashboards for visualizing highly graphical representation of data for improving key business performance.

Hands-on Exercise – Create interactive dashboards for visualizing graphical representation of data

Performance Tuning

Managing BA server logging, tuning Pentaho reports, monitoring the performance of a job or a transformation, Auditing in Pentaho

Hands-on Exercise – Manage logging in BA server, Fine tune Pentaho report, Monitor the performance of an ETL job


Integrating user security with other enterprise systems, Extending BA server content security, Securing data, Pentaho’s support for multi-tenancy, Using Kerberos with Pentaho

Hands-on Exercise – Configure security settings to implement high level security

Pentaho Projects

Project 1– Pentaho Interactive Report

Data– Sales, Customer, Product

Objective – In this Pentaho project you will be exclusively working on creating Pentaho interactive reports for sales, customer and product data fields. As part of the project you will learn to create a data source, build a Mondrian cube which is represented in an XML file. You will gain advanced experience in managing data sources, building and formatting Pentaho report, change the report template and scheduling of reports.


Exam & Certification

The Pentaho training course is designed with the main aim of making learners clear the exam successfully with less effort. This will allow you to have a bright career prospect in your life. Once your training period is over, there will be a quiz program, which will allow you to get a general idea about the questions that may ask in the exam. Specializing these questions will allow you to face the exam with 100% confidence.  

Moreover, you may need to score a minimum of 60% marks in the quiz test. Once you complete your projects successfully, there will be an overall assessment. Based on the quiz marks and the evaluation, you will be provided with the course completion certificate. Upon passing the exam, you will be designated as an expert in the Pentaho technology.


    No Reviews !!


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

You have the liberty to enroll either for the online training mode, self-paced training mode, or instructor-led online training mode.

2. Can I attend a demo session before enrollment?

You, you can attend a demo session prior to your enrollment.

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

All instructors handling the theory and practical classes will usually be a veteran in the field with vast experience and expertise.

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

Regarding group discounts, you have to contact the admission section of your institute.

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

You can certainly make the change from the self-paced learning mode to the online tutor-led education mode.

6. What If I Miss A Class?

You can choose the video tutorial session to keep yourself updated with your missing class.

7. How Will I Execute The Practical?

All practical sessions will be handled by the industry experts, who will guide you professionally in completing your projects easily.

8. What payment options are available?

You can pay the fees through net banking, debit cards, credit cards, or through any other online modes.


Every day, the capacity, range, as well as the speed of data is rising quickly, so businesses require speedy and user-friendly tools to attach data for a fruitful insight. This makes them search for trained professionals in the Pentaho technology. Doing a training course in Pentaho will allow you to cater to the needs of these organizations.

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