Introduction         
  • Business Intelligence and Data Warehousing Introduction
  • Pentaho Introduction
  • What is the difference between Business Intelligence, Data Warehousing
Data Integration & ETL transformations           
  • Creating transformation
  • Saving the Transformation
  • Load Data into a Relational Database
  • Retrieve Data from a Lookup File
  • Various Input Steps, Various Output Steps & Transformation Steps
Variable and Parameters
  • Variable scope,Environment variables,Kettle variables,Internal variables,Setting the variables,Using the variables
  • Creating parameters,Building the Parameter Query,filtering of report by using parameters
Dealing with Jobs
  • What is PDI-job, Entries, Job Orchestration & Logging
  • Creating & Scheduling Jobs
  • Running a job from file and repository
Dealing with Databases
  • Connecting to a database and extracting data,Changing the database connection at runtime
  • Extracting data with the use of parameters
  • Extracting data with query built at runtime
  • Inserting or updating rows
  • Deleting data
Dealing with Pentaho Repositories
  • Creating Repository
  • Repository Auto-Login
  • Create a Connection to the DI Repository
  • Deleting a Repository
  • Managing Content in the DI Repository

Course Highlights –

  • Every course is trained by working professionals only
  • Ample practical assignments are given to the trainees
  • Real time project and examples to support practical learning
  • Mock interviews to simulate and help students face job interviews
  • Repeat the whole course with no extra cost
  • Flexible weekend classes and special weekday classes
  • Confirmation Letter / Training Letter / Project Letter : For Degree Pursing Candidates To Submit In Colleges
  • Experience Certificates : All students would be given experience certificates after successful completion of project.

Print Friendly