Start Time

12:00 am

Saturday, June 8, 2019

access_time
End Time

12:00 am

Monday, July 8, 2019

access_time
Address

Birmingham, UK

location_on

Pentaho Data Integration Course Content

 

Module 1

  • Dimensional modeling
  • Dimensional deign
  • Star schema-what and by (model)
  • Star schema –what and by (language)
  • Conformed dimensions
  • Additive vs. semi-additive facts
  • Snow flake schema
  • Star vs.  Dimensional schema
  • Slowly changing dimensions.

Module 2

  • Clustering in pentaho
  • Files in pentaho
  • Spoon.bat
  • Pan.bat
  • Kitech.bat
  • Spoon transformation and its steps of transformation
  • How to create a connection in DB
  • How to move a data from CSV file input to table output
  • How to move the data from CSV file input to the Microsoft excel output
  • How to move the data from Microsoft excel input to write to log
  • Data Grid
  • Generate rows

Module 3

  • Data transformation-changing the data from one form to another form
  • How to add constant
  • How to add sequence
  • Add value field changing sequence
  • How the calculator work in pentaho
  • No. range in pentaho
  • Replace in string
  • Select values-select field value
  • Select field value to constant
  • Sort rows
  • Split field to rows
  • String operation-string cut
  • Unique rows
  • Unique rows (hash set)
  • Value mapper

Module 4

  • Revision of SSH command
  • How to handle the null value in pentaho
  • Mail in pentaho
  • Error handling in pentaho
  • Flow
  • Filter rows
  • Priorities stream

Module 5

  • Implementation of Slowly changing dimension
  • Jobs
  • Differences between jobs and transformation
  • How to make ETL dynamic
  • How to make transformation dynamic
  • File management
  • Create folder
  • Conditions
  • Scripting
  • Bulk loading
  • XML
  • Utility
  • Repository
  • File transfer
  • File encryption

Module 6

  • How to make ETL dynamic
  • Difference between parameter and variable
  • How to pass a variable from a job to transformation
  • Hoe to use a parameter within a transformation
  • How to set and get the value from a job to a transformation
  • Environmental variable
  • Functionality of repository in pentaho
  • Types of repository in pentaho
  • Data base connection
  • Repository import

 

Module 7

  • Introduction to Big-Data Pluggin
  • Hands on with Big-Data Pluggin
  • How to set-up environment for PDI on cloud
  • How to execute transformation and job from Cloud