Pentaho Training

Pentaho Certification Training Course

The Pentaho Online Course covers Report Designer, Pentaho Data Integration, Mondrian Cubes & Pentaho Dashboards, etc. Our Pentaho certification training course curriculum is aligned with the syllabus needed to clear the Pentaho Data Integration exam. You will get hands-on training, real-time project experience, placement assistance, interview preparation assistance through our Pentaho certification course.

A mid-career experienced professional in Business Intelligence (BI) Developer with Pentaho skills can easily earn around 8 to 10 lacks per year. Besant technologies will provide you a course completion certificate once you complete your online classes, practical sessions, and project work. This certificate is validated and holds goods in every major global multi-national company across the world.

Our Pentaho training and certification will add extra value to your resume. All our trainers are highly experienced and currently working in real-time Pentaho projects. They will not only provide hands-on training on the Pentaho syllabus but also provide assistance in interview preparation, placement assistance, project support, etc.

About Pentaho Online Training Course

The Pentaho online course is conducted in a practical way where the live instructor will explain each module step-by-step from scratch. You will be taught with the help of several use cases and real-world examples for your better understanding. Our Pentaho online course guideline is designed based on the current industry standards which will help you in your real-time project career as well.

The Pentaho certification course will first teach you about working on the Business Intelligence dashboard using the Pentaho tool. Here, you will learn the overview and fundamentals of the Pentaho tool, data integration, integration of Pentaho and Hadoop, developing OLAP cube, data standardization method, Pentaho Mondrian cubes, Dealing with repository and transformation, etc.

Pentaho Course Syllabus

Introduction to BI and Dimensional Modeling

Basic Architecture of Pentaho Introduction to Pentaho BI suite and number of components in it. (PDI, Metadata Editor, Schema Workbench, Report Designer, Design Studio). Various component of PDI a.k.a kettle (Spoon/Pan/Kitchen)Usage of spoon/pan/kitchen

Dealing with repository

• Importance of repository and its usage
• Creating a repository
• Types of repositories and their specific usage
• Taking the backup of repository storing the repository

Dealing with Transformations

• Creating simple transformations
• Saving the transformation to the repository
• Executing the transformation
• Introduction to basic steps (various input, output, transformation steps)  Understanding Steps In Detail
• Use of various input steps
• Use of various output steps
• Use of various transformation steps
• Use of Joins
• Flow controls available in PDI
• Lookup data at various sources
• Data Validation
• Mappings
• Regular Expression

Dealing with Jobs

• Creating jobs
• Executing transformation using jobs
• Passing and retrieving data to/from the transformations.
• Conditional execution of jobs
• Pre-execution Validation with joba .
• File management through Jobs

Dealing with Variables

• Creating and using variables within transformation/job
• How to create variables and how to use them in transformations
• Where to use variables
• Scope of variables

Dealing with Parameters

• Creating and using parameters
• System parameters
• User-defined parameters

Scheduling of job/transformation

Running & debugging of jobs and transformation, Storing Log Information into log tables

SCD implementation How to implement Slowly Changing Dimension using Pentaho kettle.

CDC Implementation How to implement Change Data capture logic using kettle

Best Practices , Performance Tuning and QA

Pentaho Reporting

• Creating data source connection(JDBC/JNDI/XML/OLAP/PDI)  Report Template(Headers etc)  Report Formatting
• Create a report using different types of database connection
• Create a report using Pentaho OLAP Cube
• Charts
• Use of formula
• Conditional Formatting of Row
• Conditional Formatting
• Parameter Creation
• Use of sub-reports
• Publish the Reports to BI Server
• User Level Security
• Hyperlinking Reports

Pentaho Dashboards

• Introduction to Pentaho BI Server and Pentaho Enterprise Server
• Create a DATASOURCE at BI Serer
• Create a Simple Pentaho Dashboard using Pentaho Dashboard Designer
• Create a drill-down dashboard
• Best Practices

Pentaho Cubes

• Introduction to Pentaho BI Server and Pentaho Enterprise Server
• Create a DATASOURCE at BI Server
• Create a Simple Pentaho Dashboard using Pentaho Dashboard Designer.
• Create a drill-down dashboard
• Best Practices

Upcoming Batch Schedule for Pentaho Online Training

Besant Technologies provides flexible timings to all our students. Here is the Pentaho Online Training Class Schedule in our branches. If this schedule doesn’t match please let us know. We will try to arrange appropriate timings based on your flexible timings.

• 29-04-2024 Mon (Mon - Fri)Weekdays Batch 08:00 AM (IST)(Class 1Hr - 1:30Hrs) / Per Session Get Fees
• 02-05-2024 Thu (Mon - Fri)Weekdays Batch 08:00 AM (IST)(Class 1Hr - 1:30Hrs) / Per Session Get Fees
• 27-04-2024 Sat (Sat - Sun)Weekend Batch 11:00 AM (IST) (Class 3Hrs) / Per Session Get Fees

Can’t find a batch you were looking for?

Request a Batch

Trainer Profile of Pentaho Online Training

Our Trainers provide complete freedom to the students, to explore the subject and learn based on real-time examples. Our trainers help the candidates in completing their projects and even prepare them for interview questions and answers. Candidates are free to ask any questions at any time.

• More than 7+ Years of Experience.
• Trained more than 2000+ students in a year.
• Strong Theoretical & Practical Knowledge.
• Certified Professionals with High Grade.
• Well connected with Hiring HRs in multinational companies.
• Expert level Subject Knowledge and fully up-to-date on real-world industry applications.
• Trainers have Experienced on multiple real-time projects in their Industries.
• Our Trainers are working in multinational companies such as CTS, TCS, HCL Technologies, ZOHO, Birlasoft, IBM, Microsoft, HP, Scope, Philips Technologies etc

Pentaho Exams & Certification

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

Key Features of Pentaho Online Training

Training Courses Reviews

Frequently Asked Questions