>

Pentaho Data Integration & Pentaho Analysis

  • What is Pentaho Data Integration (PDI)?
  • Transformation Basics
  • Learning the PDI User Interface
  • Creating Transformations
  • Generate Rows, Sequence, Select Values
  • Error Handling & Logging Introduction
  • Introduction to Repositories
  • Reading and Writing Files
  • Input and Output Steps
  • Parameters & kettle.properties
  • CSV Input to Multiple Text Output Using Switch/Case
  • Working with Databases
  • Connecting to & Exploring a Database
  • Table Input & Output
  • Reading & Writing to Database Tables
  • Insert, Update, & Delete Steps
  • Data Cleansing
  • Using Parameters & Arguments in SQL Queries
  •   
  • Input with Parameters / Table Wizard
  • Data Flows & Lookups
  • Copying and Distributing Data
  • Lookups & Data Formatting
  • Merging Data
  • Calculations
  • Group By
  • Calculator
  • Sorting, Grouping, & Calculating
  • Job Orchestration
  • Introduction to Jobs
  • Sending Alerts
  • Executing Jobs from a Terminal Window (Kitchen)
  • Scheduling
  • Exploring Data Integration Repositories
  • The Pentaho Data Integration Repository
  • Using the Pentaho Enterprise Repository
  • Detailed Logging

  • Pentaho Analysis


  • Creating Reporting Data Sources with Metadata Editor
  • Creating Metadata Domains with Metadata Editor
  • Using Metadata Concepts
  • OLAP/ROLAP and Dimensional Modeling
  • Introduction to OLAP and ROLAP
  • Dimensional Modeling: Cubes and Stars
  • Introduction to Mondrian
  • Creating Analysis Data Sources with Schema Workbench
  • Introduction to Schema Workbench
  • Creating a Basic Cube
  • Creating Analysis Data Sources with Schema Workbench
  • Creating a Star Schema
  • Creating Calculated Members
  • Access Control with Schema Workbench
  • Using Aggregate Tables in Schema Workbench
  • Using the Data Source Wizard to Build Data Models
  • Use the Data Source Wizard to Build Data Models
  • Use Metadata Editor and Schema Workbench to Edit Data Models
Contact for Demo
Training Enquiry Form





Online Courses Videos