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 Work bench, Report Designer, Design Studio)
Various component of PDI a.k.a kettle (Spoon/Pan/Kitchen)
Usage of spoon/pan/kitchen

Importance of repository and its usage
Creating a repository
Three Types of repositories and their specific usage
Taking the backup of repository
Restoring the repository

Creating simple transformations
Saving the transformation to the repository
Executing the transformation
Introduction to basic steps (various input, output, transformation steps).

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.

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.

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

Creating and using parameters
System parameters and 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.

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.

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

Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Mindmajix verifies their technical background and expertise.

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

The Training itself is Real-time Project Oriented.

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

There are some Group discounts available if the participants are more than 2.

As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, India and other parts of the world. We are located in USA. Offering Online Training in Cities like

Minneapolis, Melbourne, Jacksonville, Davidson, Murfreesboro, Auckland, Carlsbad,  San Marcos, Tacoma, Bellevue, Garland, Raleigh-Cary, Fort Lauderdale, Miami, Toronto, Wellington, Gilbert, Tempe, Alexandria, Chandler, Scottsdale, Peoria, Honolulu, Raleigh, Nashville, Plano, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Hyderabad, Bangalore, Pune, Mumbai, Delhi, Dubai, Doha, Brisbane, Perth etc…

• Pentaho BI Training in Washington, DC
• Pentaho BI Training in Virginia
• Pentaho BI Training in New Jersey
• Pentaho BI Training in Illinois
• Pentaho BI Training in North Carolina
• Pentaho BI Training in California
• Pentaho BI Training in Maryland
• Pentaho BI Training in Georgia
• Pentaho BI Training in Texas
• Pentaho BI Training in New York
• Pentaho BI Training in San Francisco
• Pentaho BI Training in Oregon
• Pentaho BI Training in Ohio
• Pentaho BI Training in Florida
• Pentaho BI Training in Seattle
• Pentaho BI Training in Chicago
• Pentaho BI Training in Dallas
• Pentaho BI Training in Los Angeles
• Pentaho BI Training in Baltimore
• Pentaho BI Training in Houston
• Pentaho BI Training in San Diego
• Pentaho BI Training in Santa Clara
• Pentaho BI Training in Columbus
• Pentaho BI Training in Towson
• Pentaho BI Training in Salt Lake City
• Pentaho BI Training in Austin
• Pentaho BI Training in Sunnyvale
• Pentaho BI Training in Franklin
• Pentaho BI Training in Orlando
• Pentaho BI Training in Boston
• Pentaho BI Training in San Jose
• Pentaho BI Training in St. Louis