Call us on 07035368449 or Request a call back Today !

Pentaho Data Integration Fundamentals

5 Day Pentaho Course  – Integrate, blend & Analyze

What is Pentaho?

Pentaho is open source software for Business Intelligence (BI). Pentaho provides end to end solution, comprehensive reporting, OLAP analysis, dashboard, data integration, data mining, ETL capabilities and a BI platform. Pentaho data integration prepares and blends data to create a complete picture of your business that drives actionable insights.

About the course

This 4 day Pentaho Data Integration Fundamentals training course provides an overview of the Data Integration. This course will develop the skills to create easy ETL solutions using the UI based designer. Pentaho can connect to various data sources including Hadoop, NoSQL and relational databases.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Pentaho.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators

Recommended Prerequisites: None

Course Syllabus: 4 day, 32 Academic hours

This 4 day course will give delegates a thorough study on the following topics:

Day 1  

The course will begin with an Introduction to Pentaho Data Integration. We will then continue to look at the following:

    • Lesson 1: Objectives & Class Logistics
    • Lesson 2: What is Pentaho Data Integration (PDI)?

Transformation Basics

    • Lesson 1: Learning the PDI User Interface
    • Lesson 2: Creating Transformations
    • Exercise 1: Generate Rows, Sequence, Select Values
    • Lesson 3: Error Handling & Logging Introduction
    • Lesson 4: Introduction to Repositories

Reading & Writing Files

      • Lesson 1: Input & Output Steps
      • Lesson 2: Parameters & kettle properties
      • Exercise 2: CSV Input to Multiple Text Output Using Switch/Case
      • Exercise 3: Serializing Multiple Text Files
      • Exercise 4: De-serialize a File

Day 2

Working with Databases

      • Lesson 1: Connecting to & Exploring a Database
      • Lesson 2: Table Input & Output
      • Exercise 5: Reading & Writing to Database Tables
      • Lesson 3: Insert, Update, & Delete Steps
      • Lesson 4: Data Cleansing
      • Lesson 5: Using Parameters & Arguments in SQL
      • Exercise 6: Input with Parameters & Table Copy Wizard

Data Flows and Lookups

      • Lesson 1: Copying and Distributing Data
      • Exercise 7: Parallel Processing
      • Lesson 2: Lookups
      • Exercise 8: Lookups & DataFormatting
      • Lesson 3: Merging Data

Day 3

Calculations

      • Lesson 1: Using the Group By Step
      • Lesson 2: Calculator
      • Exercise 9: Calculating & Aggregating Order Quantity
      • Lesson 3: Regular Expression
      • Lesson 4: User Defined Java Expression
      • Lesson 5: JavaScript

Job Orchestration

      • Lesson 1 : Introduction to Jobs
      • Exercise 10: Loading JVM Data into a Table
      • Lesson 2: Sending Alerts
      • Lesson 3: Looping & Conditions
      • Exercise 11: Creating a Job with a Loop
      • Lesson 4: Executing Jobs from a Terminal Window (Kitchen)

Day 4
Scheduling

      • Lesson 1: Setting up the Scheduler
      • Lesson 2: Monitoring Scheduled Tasks
      • Exploring Data Integration Repositories
      • Exploring Data Integration
      • Lesson 1: The Pentaho Data Integration Repository
      • Exercise 12: Using the Pentaho Enterprise Repository

Detailed Logging

      • Lesson 1: Detailed Logging throughout Execution

Your Trainer

Our international certified trainers are highly experienced Pentaho practitioners who have real-world expertise.

Key Information

I – All course material including a copy of Pentaho Data Integration Beginner’s Guide Book will be provided to all delegates.

II – Laptops will be provided for all delegates with pre-installed Pentaho Data Integration
<!—
III – Lunches and refreshments are provided inclusive of the cost. Wi-fi and access to spaces to take private calls are also available.
<!—
III – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of place on the course)

For more information on our training, please enquire use the form above or call 07035368449

Your Name (required)

Company Name

Phone Number

Your Email (required)

Courses

Your Message

Pentaho Course

₦220,000per course