Business Intelligence using Pentaho 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.

 

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

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
  • 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
  • Designing data models for reporting
  • Pentaho support for predictive analytics
  • Design a Streamlined Data Refinery (SDR) solution for a client
  • 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
  • PRD Layout
  • Understanding its Basic Features
  • Designing Basic Report Containing Graphical Chart
  • Conditional Formatting
  • Studying the PRPT File Format
  • Studying the PRPT File Format
  • Working with Group
  • Group Header
  • Group Footer
  • Data Source Connection
  • Query Designer
  • API Based Reporting
  • Define Extract, Transform, Load (ETL) Concepts
  • PDI GUI Layout
  • Repository
  • Wizard
  • Marketplace
  • Supported Data Types for Connectivity
  • 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
  • What is PDI-job?
  • Integrating Report
  • Entries
  • Job Orchestration
  • Logging
  • Understanding Repository
  • Database Repository
  • File Based Repository
  • Example with Job Containing Multiple Entries
  • Pentaho Business Analytics
  • User Console Navigation
  • JPivot
  • Analysis Tools
  • Using Data Sources
  • Integrating Report on BI
  • Securing data
  • Integrating user security with other enterprise systems
  • Extending BA server content security
  • Pentaho’s support for multi-tenancy
  • Using Kerberos with Pentaho
Live Online Training (Duration : 16 Hours) Fee On Request
Group Training Date On Request
1-on-1 Training
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Comfort Track

If you think 32 hours is too long. We can offer Comfort Track for 16 hours

Course Prerequisites

Participants should have knowledge of :

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

 

Request More Information

Add Name and Email Address of participant (If different from you)

FAQ's


Yes, fee excludes local taxes.
The Fee includes:
  • Courseware
Yes, Koenig Solutions is a Open Source Learning Partner