Pentaho - Course and Certification

Course Schedule and Upcoming Batches

Please call us to confirm the dates for new batches
Classes Start
Time (IST)
Price (INR)
Price (USD)
To be confirmed
5 Weeks
9:00 AM- 1:00 PM

This course is open for Enrollment and Payment.

In case you want to Register now and take up this course later, you can register by clicking on " Register" section.

If you have any query, you can call/mail or send your query by clicking on " Send a Query" section.

About the Course

Business Intelligence & Data Warehousing is a promising space. There are immense opportunities in this space to start the career, learn and grow.

There are many tools available in the market to carry out Business Intelligence & Data Warehousing tasks. Most of the advanced tools are however proprietary and comes with a high price tag.

In open source space too there are many advanced BI tools, and the most popular tool right now is Pentaho which is adopted and used by many cost conscious customers across the world. Pentaho not only supports Reporting but ETL, Analytics and a Centralized management too.

This course will provide you an in-depth knowledge of Pentaho Architecture and Features and will teach you how to carry out various activities using this tool.

After taking this course, you will be able to carry out real life projects on Pentaho. We also provide basic knowledge of Business Intelligence & Data Warehousing so that you become aware of all theoretical aspects too.

Course Objective

After completion of this course, you will be able to:

  1. Learn basics of Business Intelligence/Data Warehousing.
  2. Gain understanding of all Business Intelligence concepts.
  3. Learn about Business Intelligence components & environment
  4. Learn about end to end system flow of BI systems and BI Architecture.
  5. Learn about BI Design components and BI Quality Management
  6. Gain understanding of all Data Warehousing concepts.
  7. Learn about Data Warehousing building blocks, Master Data Management and Data Warehousing Architecture.
  8. Learn about Data Warehousing systems and end to end system flow.
  9. Learn about Data Warehousing Design components and how to create a Data Warehousing Design.
  10. Learn Pentaho in Detail.
  11. Learn how to do Data Integration & ETL transformations in Pentaho.
  12. Learn about Variable and Parameters in Pentaho.
  13. Learn how to create, schedule and maintain the Jobs in Pentaho.
  14. Learn how to connect and extract data from various Databases from within Pentaho.
  15. Learn how to deal with Pentaho Repositories.
  16. Learn about Pentaho Reporting and its Basic & Advanced features.
  17. Learn about Pentaho Business Analytics Server and User Console
  18. Learn about Pentaho Dashboards, OLAP & integration with Big Data.

Why is it the right course for you?

If you want to get knowledge of Business Intelligence and Data Warehousing and learn practical knowledge of it by using it on BI/DWH tool such as Pentaho then this is the right course for you.


You should be aware of basic database concepts. However it is not mandatory.

Course Curriculum

Section A: Introduction

1. Business Intelligence and Data Warehousing Introduction

What is Business Intelligence?,What is Data Warehousing? Popular Tools, Why tools are important in BI?, Role of a BI professional.

2. Pentaho Introduction

Introduction, Installation, Architecture, Pentaho BI(CE vs. EE), Pentaho Data Integration(PDI), Pentaho Report Designer(PRD), Pentaho Metadata Editor(PME), Mondrian, Pentaho Schema Workbench(PSW)

3. What is the difference between Business Intelligence, Data Warehousing, Analytics and Big Data

In this module you will get a clear idea about the distinctions between BI, Data Warehousing, Analytics and Big Data and learn how these Data Science technologies co-exists together.

4. Framework of Business Intelligence and Data Science Study

In this module you will learn about various discipline of data sciences and how are they interlinked together. You will also learn about various learning and job related opportunities and how can you transition yourself for next generation roles.

Section B: Business Intelligence

After completion of this module, you will be able to:

  1. Gain understanding of all Business Intelligence concepts.
  2. Learn about Business Intelligence components.
  3. Learn about Business Intelligence environment.
  4. Gain a good understanding of Business Intelligence Architecture and its components.
  5. Learn about end to end system flow of BI systems.
  6. Learn about BI Design components and how to create a BI Design.
  7. Learn details about BI Quality Management and BI Testing processes.

Section C: Data Warehousing

After completion of this module, you will be able to:

  1. Gain understanding of all Data Warehousing concepts.
  2. Learn about Data Warehousing building blocks and Master Data Management.
  3. Gain a good understanding of Data Warehousing Architecture.
  4. Learn about Data Warehousing components & systems and how they function together.
  5. Learn about end to end system flow of Data Warehousing systems.
  6. Learn about Data Warehousing Design components and how to create a Data Warehousing Design.

Section D: Pentaho in Detail

  1. Data Integration & ETL transformations
    • Creating transformation
    • Saving the Transformation
    • Load Data into a Relational Database
    • Retrieve Data from a Lookup File
    • Various Input Steps, Various Output Steps & Transformation Steps

  2. Variable and Parameters
    • Variable scope,Environment variables,Kettle variables,Internal variables,Setting the variables,Using the variables
    • Creating parameters,Building the Parameter Query,filtering of report by using parameters

  3. Dealing with Jobs
    • What is PDI-job, Entries, Job Orchestration & Logging
    • Creating & Scheduling Jobs
    • Running a job from file and repository

  4. Dealing with Databases
    • Connecting to a database and extracting data,Changing the database connection at runtime
    • Extracting data with the use of parameters
    • Extracting data with query built at runtime
    • Inserting or updating rows
    • Deleting data

  5. Dealing with Pentaho Repositories
    • Creating Repository
    • Repository Auto-Login
    • Create a Connection to the DI Repository
    • Deleting a Repository
    • Managing Content in the DI Repository

  6. Pentaho Reporting- Basic & Advanced
    • Introduction to Pentaho Reporting, Reporting architecture
    • Report layout, Various Output Formats
    • PRD Layout, Understanding it's Basic Features, Designing Basic Report Containing Graphical Chart and Conditional Formatting, PRPT File, Building a Basic Report in PDF Report
    • Data Source Connection, Query Designer, Working with Groups, Passing Parameter, Using Formula, Designing Report with Subreport
    • Creating a report summary
    • Previewing and saving the report
    • Creating a report using different types of data sources, API Based Reporting

  7. Business Analytics Server and User Console
    • Getting Started with Pentaho Business Analytics, User Console Navigation.
    • Analysis Tools, Using Data Sources, JPivot, Integrating Report on BI.

  8. Pentaho Dashboards, OLAP & Big Data
    • Introduction to Pentaho Dashboards,Pentaho Dashboards Feature Details
    • Introduction to Pentaho OLAP,Kettle OLAP Options
    • Pentaho Big Data Overview

    Section E: Project

    An end to end Pentaho project will be carried out. Project will be done on datasets similar to as used in the Industry. Project will include the following activities:

    • Requirement Analysis
    • Design
    • Test planning/Test case preparation
    • Coding/Development
    • Unit Testing, System Testing
    • Implementation
    • Performance Tuning

    Project Problem will be picked from any of the domain below:

    • Retail
    • Telecom
    • Finance
    • Banking
    • Health Care
    • Others

    Project Assessment

    Project assessment will be done by the Trainer and a grade will awarded based on the performance on project. Grading will be done on the scale of 1 to 5, 5 being the outstanding performance and 1 being the Unsatisfactory performance. Scale is as below:

    1. Outstanding
    2. Very Good
    3. Good
    4. Average
    5. Unsatisfactory

Course Duration

Online Classes : 20 Hours

There will be seven instructor led interactive online classes during the course. Each class will be of approximately four hours. If you miss a class then you can reschedule it in a different batch or you can also access Class video recordings anytime.

Project Work : 25 Hours

Assignment work will be given to learners to be completed during the course duration.

Course Work : 40 Hours

Study material of 40 hours or more will be given as a course work to be completed.

Exam : 1 Hour

A proctored exam of 1 hour will be conducted for final assessment.

Course Features

  • Live Classes

    Live Instructor Led classes from Industry Experts. Option to choose from Online or Classroom Lectures. Case studies from real life projects.

  • Ongoing Research

    Research team works hard to bring out the latest innovations and best practices of course subjects. Courses are evolving continuously; they never get stale.

  • Be More Productive

    Get work related tips and perform your work more efficiently. Once you know the tricks of trade, you become more productive.

  • Industry Experts

    Classes are conducted by Industry Experts. Learners gain from world class curriculum and extensive experiences of Trainers as well.

  • Easy Reschedule

    Have you missed a class? Don't worry !!, You can watch the class videos or you can also request for a reschedule. We will invite you for next class for Free.

  • Learning Material

    Learners get unlimited access to online and offline materials. Don't worry if you miss any class, we will be providing you a repeat class online or offline.

  • Learning Support

    Learners are encouraged to ask online and offline questions. Our team of Trainers makes it a priority to answer these questions.

  • Money-back Guarantee

    If you are not satisfied with the quality then take full refund within the seven days of first class. No questions will be asked.

  • Career Support

    Learner's resume is reviewed and a one-to-one discussion is arranged with an expert to advice on career roadmap and job opportunities. For details, visit Career Centre


Certificate of Participation

A certificate of participation will be awarded after participating in the training program. The name of certificate is "BIWHIZ CERTIFICATE OF PARTICIPATION ON PENTAHO".

Certification after Completion

A certification will be issued after assessment of assignments, course work requirements, projects and a written test as per the course curriculum. After successfully completing all the requirements and passing the written test, a certification will be issued. The name of the certification is "BIWHIZ CERTIFICATION ON PENTAHO".

Certificate Issuing Authority

BIWHIZ is part of the company "Business Intelligence Consultant and Services LLP". Certificates are issued by "Business Intelligence Consultant and Services LLP". This is a registered company with Ministry of Corporate Affairs, Government of India.

Sample Exam Questions

This sample is only for illustrative purpose and only basic level questions are displayed here. Actual exam questions may be completely different with different format as well. Please contact your coordinator to know more about prevailing exam format.

Pentaho is a ?

Choose one.

  1. Reporting Tool
  2. ETL Tool
  3. Dashboard tool
  4. All of above

Pentaho portal can be customized

Choose one.

  1. Yes
  2. No
  3. Can't Say
  4. Only in

Pentaho is free ?

Choose one.

  1. Yes, all version
  2. Yes, Only community version
  3. No
  4. No, its open source

What is false?

Choose one.

  1. Query parameters can be passed from report
  2. Dynamic filters are possible
  3. Pentaho Hadoop connection is possible
  4. ETL can be called from Report

Pentaho Repository?

Choose one.

  1. Store all Reports
  2. Holds all Metadata
  3. Store all ETL
  4. Store all Connections

Freehand SQL is possible in Pentaho?

Choose one.

  1. No
  2. Yes
  3. In some cases
  4. In all cases

Frequently Asked Questions

  1. Is it necessary to have any prior knowledge of Business Intelligence/Data Warehousing before starting this course?

    No, no prior knowledge of Business Intelligence/Data Warehousing is required as we are covering basics of Business Intelligence/Data Warehousing too.

  2. Is this course for me? What value would it add to my career?

    If you are planning to get a practical exposure of how Business Intelligence/Data Warehousing tool works and how various BI activities are performed then this is the right course. This course will give an extra advantage if you are planning to enter into BI.

  3. I guess I need to have very fast Internet connection to be able to attend these courses?

    Generally 1 MB connection is sufficient however lower bandwidth connections are also working fine.

  4. Can I request for another class if I miss it?

    You can watch the recorded session video or you can also attend the same class in next batch.

  5. Why Certification is included in the course?

    This is to make sure that a learner has understood the course content and BIWHIZ has verified the knowledge level of the Learner. Certification is the proof that you have achieved a certain level of expertise on course and any authorized organization can verify that with us.

  6. What if I am not able to clear the Certification exam in first attempt?

    You can take extra attempts for free.

  7. What is the learning support and would it be available after completing the course as well?

    You can raise your queries and doubts during and post training period. All queries will be resolved by Pentaho experts.

  8. Do you help in career related issues as well, like reviewing resume, mentoring for my career growth?

    Yes, we have a panel of Pentaho experts who will guide and mentor you; please check Career Centre for more details.

  9. Will you sell my data to Recruitment/marketing companies or will you use it for Recruitment or any other activities not related with Training?

    NO, Never. Your details are highly confidential and safe with us. But If you are willing to accept any such calls then you can inform us in advance with a specific need and we will contact only for those specific requirements. For a detailed privacy policy please check Terms, Conditions & Privacy Policy.

Register Here

Please register for this course here. Even if you are not ready to Enrol now, you can register now and get an intimation about our next batch whenever it is starting.

Please Fill Your Details

Send a Query

You got a query for us? Please use the Form below to send your query. We will get back to you soon. Have a great day !!

Please Fill Your Details & Query