All Courses

One to One Training

Get 1-to-1 Live Instructor Led Online Training in flexible timings

Program Fees:  40,000 Discount Price: 29,000

You Save:  11,000 (27.5% OFF)

Online Classroom

Attend our Instructor Led Online Virtual Classroom

Program Fees:  20,000 Discount Price: 18,000

You Save:  2,000 (10% OFF)

About Pentaho Online Training

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 the Open source Pentaho tool. Pentaho BI Training with specialists in real trends to optimize and Design the Data warehouse and to visualize the data in an effective manner. Pentaho BI Suite is an open-source package that consists of Data Integration, Report Designer and Schema workbench and it is able to survive any data to effortlessly analyze, visualize, explore report and forecast the requirement. We offer Pentaho BI Training in a practical way to ensure our participants acquire an understanding of all concepts and features very well.

What is this course about?

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.

What are the course objectives?

At the 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.

Who should do this course?

People who are willing to accommodate their career on Business Intelligence professionals, previously having a basic knowledge of 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.

Job Opportunity for Pentaho?

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, within this tool people can easily learn ETL, Reporting, and OLAP Cube development.

Course Duration Information

This Pentaho training will 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.

What you'll learn from this course?

  • Introduction of Pentaho BI
  • Steps of Pentaho ETL
  • What is ETL?
  • What is Database and Data Warehouse?
  • What is BI?
  • BI tools available in the industry
  • About Pentaho Data Integration
  • Different types of files
  • Components in Pentaho DI
  • What are Transformation and Job?

Upcoming Batches for Pentaho Training

Our Pentaho Online Course gives students the opportunity to take classes on your flexible timings. Choose from a number of batches as per your convenience. If you got something urgent to do, reschedule your batch for a later time. The classes can be attended to at any place and at any time as per your choice.

Course Price at

Program Fees:  20,000 Discount Price: 18,000

You Save:  2,000 (10% OFF)

Calender

Can’t find a batch you were looking for?

Request a Batch

Pentaho Training 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 the industry
  • About Pentaho Data Integration
  • Different types of files
  • Components in Pentaho DI
  • What are 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 the same metadata
  • Add date/time in an output filename
  • 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 the 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 a transformation
  • Write a shell script to execute a transformation
  • Monitoring a job/transformation on the server
Request Syllabus

Are you Looking for Customized Syllabus

We are also providing customized syllabus to the students according to their needs and projects requirements for the cons

Request a Call

Program Features

IT Professionals as Trainers

Learning a technology with a professional who is well expertise in that solve 60% of your needs.

Fully Hands-on Training

We support any training should be more practical apart from theoretical classes. So, we always gives you hands-on training.

Affordable Fees

We are dead cheap in fees. We are having options to make the payment in instalments as well if needed.

10000+ old students to believe

We satisfied 10000+ students from the day we started GangBoard. Take a look of our old student’s video reviews and it says all.

Counselling by Experts

If you are in dilemma to choose a course, we are having experts in counselling team to help you with perfect projection of your career.

Own Course Materials

We have every course material to understand which is prepared by our trainers and we will share with you after session completes.

FAQ

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 reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. 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.

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. Debit Card / Credit Card, American Express, Master Card, or PayPal.

You can reach us through +91-9707240250. Or you can share your queries through enq@gangboard.com. Estimated turnaround time will be 24 hours for emails.

Request more information

Our Advisor will get in touch with you in the next 24 Hours

Call Us: +91-9707 240 250

Pentaho Exams & Certification

GangBoard Certification is Accredited by all major Global Companies around the world. We provide after completion of the theoretical and practical sessions to fresher’s as well as corporate trainees.

Our certification at GangBoard is accredited worldwide. It increases the value of your resume and you can attain leading job posts with the help of this certification in leading MNC’s of the world. The certification is only provided after successful completion of our training and practical based projects.

5000

Total Number of Reviews

4.57

Aggregate Review Score

97%

Course Completion Rate

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

Average Ratings

Activity from April 2018

4.8

Course Reviews

Activity from Last Year

1596 Reviews

Average Ratings

GangBoard Total Reviews in all Medium

21,596 Reviews