About The Course
Pentaho BI suite is a complete platform to build end-to-end BI solution. This course will not only help the beginners to understand various Pentaho tools and their features but will also give the experienced users insight into those tools which will help them in building a solution around it.
After completion of Pentaho BI suite, you will be able to:
1. Gain familiarity with Pentaho tools
2. Understand the business reporting concepts and build reports using Pentaho Report Designer
3. Understand ETL and get hands on with Pentaho Data Integration (aka Kettle)
4. Integrate Pentaho with Big Data stack like HDFS, MongoDB
5. Understand BI Server integration
Who should go for this course?
This course is a foundation to all those enthusiasts who aspires career in Business Intelligence (BI) and Data Analytics.
Professionals wearing caps of Business Analyst, BI developer, Data Scientist, DW programmer, Solution Architect could gain mileage out of this course in their respective fields as Pentaho can make them aware of its potential in building indigenous as well as integrated solution.
Basic Database concepts, Data warehouse concepts, knowledge of any one programming language, basic familiarity to IT terms
Why learn Pentaho BI?
Today, when data is mushrooming and coming in heterogeneous forms, there is a growing need for a flexible, adaptable, efficient and cost effective analytical platform which will take minimum on-boarding time. Pentaho fits just perfect in this space with a proven track record, so learning Pentaho makes lot of sense for anybody associated with digital world.
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
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