Online Pentaho Training Classes And Courses

Date	Time	Type	Attend
No Schedule Available

Curriculum

Pentaho Download

Pentaho web based Online Training Curriculum

Course objective

Understanding importance of BI and designing dimensional Model
Setting up Pentaho BI suite
Creating Transformation and Jobs with best industry practices and working with Repository
Designing and developing Reports and Dashboards
Creating Cubes ,working with MDX and Action Sequence

Introduction to BI and Dimensional Modeling

Basic Architecture of Pentaho
Introduction to Pentaho BI suite and number of components
PDI
Metadata Editor
Schema Work bench
Report Designer
Design Studio

Dealing with repository

Importance of repository and its usage
Creating a repository
Types of repositories and their specific usage

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 details

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

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 job
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 Jobs and 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

Schema Workbench

Introduction to Dimension Modeling Structure
Creating Schema file
Creating cube and deploying
Introduction to MDX

Pentaho Report Designer (PRD)

Creating data source connection
JDBC
JNDI
XML
OLAP
PDI

Report Formatting

Create a report using different types of database connection
Create a report using Pentaho OLAP Cube
Charts
Use of formula
Conditional Formatting
Parameter Creation
Use of sub-reports
Publish the Reports to BI Server
Hyper linking Reports

Dashboard CDE (CDF Framework)

Create a DATASOURCE at BI Serer
Create Simple Pentaho Dashboard using Pentaho Dashboard Designer
Create a drill down dashboard using action sequence and reports

Delivery Methodology

We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course

Class Delivery

Live Interactive classes with expert

Who should Learn Pentaho?

Database profesionals

Prerequisite to learn Pentaho

Basic Concepts of Business intelegence , Data Warehousing and SQL

Delivery Methodology used to deliver the Pentaho

We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.

Class delivery

Live Interactive classes with expert

Pentaho FAQ

Question: Can I attend the Demo session before enrollment?

Answer: Yes, you may attend the Demo class before enrollment for training Quality Evaluation. You can also Interact with a trainer as one to one session for a specific requirement or discussion

Question: Can you schedule the training based upon my availability?

Answer: Yes, we need to discuss it with a trainer, accordingly, we can schedule training at a convenient time.

Question: How I can pay for the course?

Answer: You can pay the fee or enroll yourself via payment gateway through the course page, make an online payment using various options.

Question: What if I missed any class?

Answer: BISP has a missing class policy. If you missed any session, we will be sharing a recorded session. However, you may retake whole training multiple times within 6 month period but the trainer is the same.

Question: Is there any live project training along with regular training?

Answer: Our training curriculum includes real-time scenarios and lives project working module & the trainer explains every topic with examples. If you have any issue or you are stuck in any scenario the trainer will explain end-to-end.

Question: What about certification preparation and guidance?

Answer: BISP technical faculty assist & guide you completely for certification and preparation. We ensure you will get certified easily after our training.

Question: Who is the trainer & about his experience?

Answer: All our trainers are working professionals and industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo We also ensure that only those trainers with a high alumni rating continue to train for us.

Question: Do you provide Job support?

Answer: Yes, we provide Job support services, but the cost structure is different and fixed. For more details: Just give us a call at: +91 769-409-5404 & +1 678-701-4914 You can also write to us: support@bisptrainings.com

Question: What if I have more queries and doubts?

Answer: Just give us call at : +91 769-409-5404 & +1 678-701-4914 You can also write to us: support@bisptrainings.com

Question: How Fee Refund Policy works?

Answer: Please refer the link for refund policy: https://www.bisptrainings.com/Refund-Policy