Pentaho BI Certification Training

Architecture & Design Patterns     Artificial Intelligence     Big Data     Blockchain     Business Intelligence & Visualisation     Cloud Computing
Cyber Security Data Science Data Warehousing & ETL Databases DevOps Digital Marketing Front-End Development Health & Safety Training Mobile Development Operating Systems Programming & Frameworks Project Management & Methodologies Robotic Process Automation Software Testing

A self-paced online training designed for both technical and non-technical BI practitioners to develop their skills and knowledge for the most effective use of the Pentaho Business Intelligence (BI) Suite, required for successful projects.

 

Curriculum

Introduction to Pentaho BI Suite

Learning Objective: In this module, you will understand Pentaho's journey till date and get familiar with their various product offerings.

Topics: About Pentaho, Pentaho BI(CE vs. EE), Pentaho Data Integration(PDI), Pentaho Report Designer(PRD), Pentaho Metadata Editor(PME), Mondrian, Pentaho Schema Workbench(PSW), Dashboard Capabilities

Pentaho Report Designer - Basic

Learning Objective: In this module, you will design, build and publish custom reports using Pentaho Report Designer.

Topics: PRD Layout, Understanding it's Basic Features, Designing Basic Report Containing Graphical Chart, Conditional Formatting, Studying the PRPT File Format, Building a Basic Report in PDF Report, Example

Pentaho Report Designer - Advanced

Learning Objective: In this module, you will get acquainted with advance features of reporting and getting hands on with features like sub-report, cross tabs.

Topics: Data Source Connection, Query Designer, Working with Group(Group Header, Group Footer), Passing Parameter, Using Formula, Designing Report with Subreport, API Based Reporting, Example

Pentaho Data Integration - Introduction

Learning Objective: In this module, you will Understand ETL (Data Extract, Transform and Load) and learn PDI features.

Topics: ETL Concepts, PDI GUI Layout, Repository, Supported Data Types for Connectivity, Wizard, Marketplace

Pentaho Data Integration - Transformation

Learning Objective: In this module, you will understand transformation and various steps.

Topics: What is Transformation, Step, Hop, Variable, Various Input Steps, Various Output Steps, Transformation Steps, Big Data Steps, Scripting, Integration with Hadoop HDFS and NOSQL MongoDB, PDI and Map Reduce, Example

Pentaho Data Integration - Job and More

Learning Objective: In this module, you will understand PDI - Job and various entries, file formats for KTR (Kettle Transformation) and KJB (Kettle Job).

Topics: What is PDI-job, Entries, Job Orchestration, Integrating Report, Logging, Understanding Repository, File Based Repository, Database Repository, Example with Job Containing Multiple Entries

Pentaho BA Server and User Console

Learning Objective: In this module, you will understand Pentaho BA Server and its administration through user console.

Topics: Getting Started with Pentaho Business Analytics, User Console Navigation, Analysis Tools, Using Data Sources, JPivot, Integrating Report on BI

Projects

Which Case-Studies will be part of this course.

Learning Objectives - In this module, you will apply all the acquired knowledge for one case study.

Topics - Discuss the project starting with its problem statement, probable solutions, and implement one solution using Pentaho BI stack

How will I execute the practicals?

For your practical work, detailed step by step installation guides will be present in your LMS which will help you to install and set-up Pentaho Suite.

Your Online (Pentaho BI Certification Training) Package
Upon purchase, you will receive a password via the email you used to purchase the course.

You will then be able to login to our online learning portal with your email and password.

You will have access to the portal for 12 months to complete your course.

£ £ + VAT