For individuals

Recorded Video Learning

  • Access to high quality Videos
  • Self-paced learning content designed by Experts

Instructor Led Live Online Training

  • Live Interactive training
  • Certified & industry expert Trainers
  • On Demand Dedicated Cloud lab access
  • 24x7 Support & Assistance
  • Fast-track / Regular / Weekend

  • Start training at your convenient time
  • For business

    Corporate training

    • Self-paced e-learning and/or instructor-led options)
    • Course, category, and all-access pricing
    • Enterprise-class learning management system (LMS)
    • Enhanced reporting for individuals and teams
    • 24x7 assistance and support

    Course Details

    Pentaho Business Analytics is a suite of open source Business Intelligence hosts content created both in the server through plug-ins or files published to the server. It provides data integration, OLAP services, reporting, dashboard, data mining and ETL capabilities. Commercial plug-ins from Pentaho expand out-of-the-box features. It uses an innovative metadata driven approach. It enables Streaming engine architecture, enterprise-class performance and scalability with a broad range of deployment options.

    Pentaho BI Training Overview

    Our training emphasis on high quality course content. The course is delivered in a deep and clear, articulate with complete knowledge on structured information and data integration in a step by step pattern for solid foundation with hands-on. The case study consists of several concepts of Pentaho as per industry requirements customized by real-time working IT Professionals.

    Pentaho BI Training Curriculum

    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


    Exam Certification

    How to get certified in Pentaho?

    Earning your pentaho certification is your silver bullet to ensuring the best possible Pentaho implementation and experience. The detailed information regarding pentaho certification is given here. For passing these tests, an in-depth understanding of all the pentaho concepts is recommended. The learning path and the project Mindmajix comes up with will be exactly in line with the certification program which enables you to clear pentaho certification exam with greater ease and secure a job in top multinationals.

    Course Reviews


    1573 ratings
    • 51101
    • 4236
    • 3157
    • 263
    • 116

    Drop Us A Query

    Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
    Course Adviser

    Fill your details, course adviser will reach you.