Pentaho BI

1. Introduction to Pentaho BI Suite

Learning Objectives - 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

2. Pentaho Report Designer - Basic

Learning Objectives - 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

3. Pentaho Report Designer - Advanced

Learning Objectives - 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

4. Pentaho Data Integration - Introduction

Learning Objectives - 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

5. Pentaho Data Integration - Transformation

Learning Objectives - 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

6. Pentaho Data Integration - Job and More

Learning Objectives - 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

7. Pentaho BA Server and User Console

Learning Objectives - 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

8. Project

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