Get Flat 20% OFF For Your First Course. Coupon Code: SAVE20   

Pentaho Training

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
1368 Ratings
1147 Learners
20 Hours
15 Hours
Business Intelligence
365 Days
24 / 7 Support
Intermediate
Online Classroom
Attend our Instructor Led Online Virtual Classroom
USD 299 USD 269Enroll now
One to One Training
Get 1-to-1 Live Instructor Led Online Training in flexible timings
USD 599 USD 499Enroll 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
27 Jan 2017 25 Feb 2017 (09:00 PM - 11:30 PM) Fri,Sat
28 Jan 2017 26 Feb 2017 (08:30 AM - 11:00 AM) Sat,Sun
28 Jan 2017 26 Feb 2017 (01:30 AM - 04:00 AM) Sat,Sun
31 Jan 2017 17 Feb 2017 (08:30 AM - 10:30 AM) Tue-Sat
30 Jan 2017 16 Feb 2017 (08:30 PM - 10:30 PM) Mon-Fri
04 Feb 2017 05 Mar 2017 (01:30 AM - 04:30 AM) Sat,Sun
03 Feb 2017 04 Mar 2017 (09:00 PM - 11:30 PM) Fri,Sat
04 Feb 2017 05 Mar 2017 (08:30 AM - 11:00 AM) Sat,Sun
06 Feb 2017 23 Feb 2017 (08:30 PM - 10:30 PM) Mon-Fri
07 Feb 2017 24 Feb 2017 (08:30 AM - 10:30 AM) Tue-Sat
10 Feb 2017 11 Mar 2017 (08:30 PM - 11:30 PM) Fri,Sat
11 Feb 2017 12 Mar 2017 (08:30 AM - 12:30 PM) Sat,Sun
11 Feb 2017 12 Mar 2017 (01:30 AM - 05:30 AM) Sat,Sun

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

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

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

+91 - 755 008 0081
+91 - 755 008 0082

Drop us a Query

Please ensure all fields are valid.

+91

Drop us a Query

We are looking into your query.
Our consultants will get in touch with you soon.
GangBoard 5 Star Rating: Recommended 5 out of 5 based on 1368 ratings.