Pentaho Training

Syllabus of Pentaho Course

Introduction to BI and Dimensional Modeling

Basic Architecture of PentahoIntroduction to Pentaho BI suite and number of components in it.(PDI,Metadata Editor, Schema Work bench, 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 repositoryRestoring 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 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 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 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 Simple Pentaho Dashboard using Pentaho Dashboard Designer.
• Create a drill down dashboard
• Best Practices

Pentaho Training Course Highlights

1) Our Training Center batch sizes are generally very small size 3-5 members OR 1 to 1 also, so students receive direct, hands-on training from us.

2) 100% practical training only. It is not a slide show training program / theory class program. 

3) At the end of this class, definitely you will refer your colleagues / friends / relatives for our training.

4) Conducting regularly online Pentaho training for US peoples in all time zones (PST,CST,EST,HST,MST)

5) Installation of Softwares in your desktop / laptop will be done.

6) Will be provided self evaluation testing software, exam simulator, dumps & books with this training.

7) Continuous support is provided for any of your on-site problems. Assistance will be provided and you will be recommended to some of IT development firms.

Why Enroll with IICT for Pentaho Training Course ?

1) Two days free trial - If candidate likes this course, these days are adjusted in his actual schedule.

2) Live Project Exposure of Fortune companies.

3) Training by Subject Matter experts from CMM Level 5 companies

4) Both Online and Classroom Training offered at Pentaho

5) Our basic course worth more than the advanced course of other institutes/freelancers.

6) Free Interview preparations.

7) 100% free assistance for Pentaho certifications.

8) Practical and Hands on Training for Pentaho Course .

9) 100 % guarantee in succeeding the certification at affordable fees.

10) Also provide online training to students of foreign countries.

Pentaho Trainer Profile

• More than 10+ Years of Experience.
• Trained more than 5000+ students in a year.
• Strong Theoretical & Practical Knowledge.
• Pentaho 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 Placement Training

• More than 5000+ students Trained
• 2000+ students Placed
• 1100+ Interviews Organaized
• Strong Theoretical & Practical Knowledge
• Pentaho certified Professionals