Pentaho Training

Gangboard Offers Best Pentaho Online Training with Certified Experts. Become Master in Pentaho BI Concepts like Dealing with repository, dealing with Transformations, Dealing with Jobs, Dealing with Variables, Dealing with Parameters, Scheduling of job/transformation, Pentaho Reporting, Pentaho Dashboards, Pentaho Cubes and advanced Pentaho Concepts with our Practical Classes. We guarantee for your Pentaho Online Training Success with Certification. We focused on 100% Practical and Certification Oriented Pentaho Online Course with Placements for our Students. Most Of Our Trainers are currently working as Pentaho ETL TOOL Developer with 10+ Years industry Experienced. Our Pentaho Online Course Syllabus will help you to know basic to advanced level techniques Pentaho BI Tool. Enroll for Pentaho Online Course with Gangboard and get extensive knowledge on Open source Pentaho tool. Pentaho BI Training with specialists in real trend to optimize and Design the Data warehouse and to visualize the data in effective manner. Pentaho BI suite is open source package which consists Data Integration, Report Designer and Schema workbench and it is able to survive any data to effortlessly analyse, visualize, explore report and forecast the requirement. We offer Pentaho BI Training in practical way to ensure our participants acquire understanding all concepts and features very well.
View More
136 Ratings
114 Learners
20 Hours
15 Hours
Business Intelligence
365 Days
24 / 7 Support
Online Classroom
Attend our Instructor Led Online Virtual Classroom
USD 332 Enroll now
One to One Training
Get 1-to-1 Live Instructor Led Online Training in flexible timings
USD 532 Enroll now

About Course

This course gives you an impeccable knowledge about how to use Pentaho BI for corporate project development and that will help you to build a custom data warehouse and design your own reports by yourself. We adapted and designed these course topics to meet the current industry standards.

At end of this Pentaho BI training by (Name) you will be able to,

  • To Know and Design advanced concepts of Data Warehouse and Reporting.
  • Build an independent data warehouse.
  • Understand to learn all necessary steps and components of Pentaho ETL and Reporting
  • Create own Jobs and Transformations in Pentaho Data Integration.
  • Learn how to work with RDBMS like MySQL to extract, transform and load data.
  • Design your reports and OLAP cubes.

People who are willing accommodate their career on Business Intelligence professional, previously having basic knowledge on Data warehousing, New to IT Industry can choose Pentaho BI Training to learn Business Analytics and Intelligence in an organized way. This training will be suitable for,

  • Fresh Graduates
  • College/ school student
  • Job Seekers
  • Who wants to learn from beginner level
  • Anyone wants to build their own data warehouse and reporting from scratch

Prerequisite: Knowledge in Basic SQL and oral knowledge of ETL and Reporting Concepts.

Pentaho BI is an always infrequent technology which is used by corporate companies and plenty of opportunities available in aboard. So learning Pentaho will be good if you want to make this as a full time developer. Also since the open source software corporates are moving to adapt and handle their projects, with in this tool people can easily learn ETL, Reporting and OLAP Cube development.

This Pentaho training will be happen for 20 hours. If you opt for weekend classes both Saturday and Sunday you will be having approximately 2 hours 30 minutes in scheduled time of the batch you chose. If you opt of weekdays classes all Monday to Friday you need to spend at-least 120 minutes.

Pentaho Syllabus

Introduction of Pentaho BI

  • What is Pentaho BI?
  • The history of Pentaho BI
  • Why choose Pentaho?
  • Installation overview
  • Additional Tools of Pentaho

Steps of Pentaho ETL

  • What is ETL?
  • What is Database and Data Warehouse?
  • What is BI?
  • BI tools available in industry
  • About Pentaho Data Integration
  • Different types of files
  • Components in Pentaho DI
  • What is Transformation and Job?
  • Hops
  • Transformation Folders
  • Transformation Steps
  • Input Folder steps
  • Output Folder Steps
  • How to create a connection to DB?
  • How to move data from CSV file input to table output?
  • How to move data from CSV file input to Microsoft excel output?
  • Read data from multiple files at a time with same metadata
  • Add date/time in output file name
  • Perform DML Operations
  • How to write data to log
  • Transform Folder Steps
  • Add constants
  • Add sequence
  • Difference between “Add sequence” and “Add value fields changing sequence”
  • Calculator
  • Concat Fields
  • Number Range
  • Replace in String
  • Row Flattener
  • Select Values
  • Set Field Value
  • Set Field Value to a Constant
  • Sort Rows
  • Split Field to Rows
  • Split Fields
  • String Operations
  • String Cut
  • Unique Rows
  • Unique Rows (HashSet)
  • Value Mapper
  • Utility Folder Steps
  • Clone row
  • Delay row
  • If Field Value is Null
  • Null If
  • Write to Log
  • Table Compare
  • Append Streams
  • Block this step until steps finish
  • Blocking Step
  • Dummy
  • Filter Rows
  • Prioritize Streams
  • Switch / Case
  • Formula
  • Modified Java Script Value
  • User Defined Java Expression
  • What is Variable?
  • How to create and use Variables?
  • Lookup Folder
  • Check if a column exists
  • Database lookup
  • File lookup
  • File Exists
  • Stream lookup
  • Table Exists
  • Join Rows (Cartesian Product)
  • Merge Join
  • Merge Rows
  • Multiway Merge Join
  • Sorted Merge
  • Dimension Lookup/Update
  • How to get Previous/Next row values at current row
  • Group By
  • How to call a transformation inside of another transformation
  • Get Variable
  • Set Variable
  • Jobs
  • Create a Repository
  • Schedule a transformation
  • Run transformations via command line
  • Write a batch script to execute transformation
  • Write a shell script to execute a transformation
  • Monitoring a job/transformation on server

Upcoming Batches

Start Date End Date Time (EST) ( UTC -5) Day
24 Jan 2020 21 Feb 2020 (08:30 PM - 11:00 PM) Fri,Sat
25 Jan 2020 22 Feb 2020 (08:30 AM - 11:00 AM) Sat,Sun
27 Jan 2020 24 Feb 2020 (08:30 PM - 10:00 PM) Mon-Fri
28 Jan 2020 25 Feb 2020 (10:00 AM - 11:30 AM) Tue-Sat
28 Jan 2020 25 Feb 2020 (08:30 AM - 10:00 AM) Tue-Sat
01 Feb 2020 29 Feb 2020 (08:30 AM - 11:00 AM) Sat,Sun
31 Jan 2020 28 Feb 2020 (08:30 PM - 11:00 PM) Fri,Sat

Pentaho Certification

At end of our course, more practical Knowledge will help you to handle any ETL or Reporting projects independently and you will be certified as Pentaho professional by GangBoard, with that we can easily find good job in corporate companies.

Pentaho Training Reviews


Detailed installation of required software will be displayed in your LMS. Our support team will help you to setup software if you need assistance. Hardware requirements need to be fulfilled by participants.

No worries. It might happen. We will assist you by providing recorded session of what you missed in your LMS. And if required you can even attend that topic if any other live batches.

Top-notch professionals in that field who understands how to convey things in technical as well as subject matter experts.

We offer this course in “Live Instructor-Led Online Training” mode. Through this way you won’t mess anything in your real-life schedule. You will be shared with live meeting access while your session starts.

Basically >4GB RAM will be good with Windows Operating System.

You can get a sample class recording to ensure you are in right place. We ensure you will be getting complete worth of your money by assigning a best instructor in that technology.

We are absolutely loved to talk in-person about group training (or) corporate training. So, please get in touch with our team through "Quick Enquiry", "Live Chat" or "Request Call-back" channels.

Payments can be made using any of the following options and a receipt of the same will be issued to you automatically via email.

  1. Visa Debit Card / Credit Card
  2. American Express
  3. Master Card, Or
  4. PayPal

We are providing Pentaho online training, One-to-One training with the help of experts. Our learners and trainers are frequently coming from different countries like USA, India, UK, Australia, New Zealand, Canada and UAE. To specify in cities London, Bangalore, California, New York, Pune, Mumbai, Chennai, New Delhi, San Francisco, New Jersey, Texas, Florida, Kolkata, Gurgaon, Berlin and Hyderabad among many.

For Pentaho Online Training please you can reach us through +91-9791273737 / +91-9791237373. Or you can share your quires through Estimated turnaround time will be 24 hours for emails.

Drop us a Query

Please ensure all fields are valid.


Drop us a Query

We are looking into your query.
Our consultants will get in touch with you soon.
GangBoard Gangboard
5out of 5based on 136 ratings. 114 user reviews.