Open Source/Business Intelligence using Pentaho

Business Intelligence using Pentaho Certification Training Course Overview

Pentaho Training from Koenig teaches you how to develop Business Intelligence (BI) dashboard using Pentaho BI tool from scratch. This course explores the fundamentals of Pentaho Data integration, creating an OLAP Cube, integrating Pentaho BI suite with Hadoop, and much more through the best practices. Our Online Pentaho Training Course also provides real-time projects to enhance your skills and successfully clear the Pentaho Data Integration certification exam.

 

Business Intelligence using Pentaho (16 Hours) Download Course Contents

Live Online Training Fee On Request
Group Training Date On Request
1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Buy Flexi For Only $99 (Online Training Re-imagined)

Course Modules

Module 1: Introduction to Pentaho Tool
  • Pentaho user console
  • Overview of Pentaho Business Intelligence and Analytics tools
  • Database dimensional modelling
  • Using Star Schema for querying large data sets
  • Understanding fact tables and dimensions tables
  • Snowflake Schema
  • Principles of Slowly Changing Dimensions
  • Knowledge of how high availability is supported for the DI server and BA server
  • Managing Pentaho artifact
  • Knowledge of big data solution architectures
Module 2: Introduction to Pentaho BI Suite
  • Describe Pentaho
  • Pentaho BI (CE vs. EE)
  • Pentaho Data Integration (PDI)
  • Pentaho Report Designer (PRD)
  • Pentaho Metadata Editor (PME)
  • Pentaho Schema Workbench (PSW)
  • Dashboard Capabilities
Module 3: Data Architecture
  • Designing data models for reporting
  • Pentaho support for predictive analytics
  • Design a Streamlined Data Refinery (SDR) solution for a client
Module 4: Clustering in Pentaho
  • Understanding the basics of clustering in Pentaho Data Integration
  • Creating a database connection
  • Moving a CSV file input to table output and Microsoft Excel output
  • Moving from Excel to data grid and log
Module 5: Pentaho Report Designer - Basic
  • PRD Layout
  • Understanding its Basic Features
  • Designing Basic Report Containing Graphical Chart
  • Conditional Formatting
  • Studying the PRPT File Format
  • Studying the PRPT File Format
Module 6: Pentaho Report Designer – Advanced
  • Working with Group
  • Group Header
  • Group Footer
  • Data Source Connection
  • Query Designer
  • API Based Reporting
Module 7: PPentaho Data Integration – Introduction
  • Define Extract, Transform, Load (ETL) Concepts
  • PDI GUI Layout
  • Repository
  • Wizard
  • Marketplace
  • Supported Data Types for Connectivity
Module 8: Pentaho Data Integration – Transformation
  • What is Transformation?
  • Variable
  • Step
  • Hop
  • Various Input Steps
  • Various Output Steps
  • Transformation Steps
  • Scripting
  • Big Data Steps
  • Integration with Hadoop HDFS and NOSQL MongoDB
  • PDI and Map Reduce
Module 9: Pentaho Data Integration – Job and More
  • What is PDI-job?
  • Integrating Report
  • Entries
  • Job Orchestration
  • Logging
  • Understanding Repository
  • Database Repository
  • File Based Repository
  • Example with Job Containing Multiple Entries
Module 10: Pentaho BA Server and USER Console
  • Pentaho Business Analytics
  • User Console Navigation
  • JPivot
  • Analysis Tools
  • Using Data Sources
  • Integrating Report on BI
Module 11: Security
  • Securing data
  • Integrating user security with other enterprise systems
  • Extending BA server content security
  • Pentaho’s support for multi-tenancy
  • Using Kerberos with Pentaho
Download Course Contents

Request More Information

Course Prerequisites

Participants should have knowledge of :

  • Basic Database concepts
  • Data warehouse concepts
  • knowledge of any one programming language
  • basic familiarity with IT terms.