$ 199 - (Rs 13,313)
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
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
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
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
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
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
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
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