Get to know Pentaho Kettle PDI - Introduction

Great start for you to understand what is PDI
Rating: 4.4 out of 5 (315 ratings)
3,933 students
Get to know Pentaho Kettle PDI - Introduction
Rating: 4.4 out of 5 (315 ratings)
3,933 students
Install PDI
Demo of simple ETL between tables
Connect to data source with PDI
Introduce Sakila case study and goals
PDI environment
demo of simple file to tables
simple null handling

Requirements

  • Basic SQL knowlege
Description

This course is about the foundation of PDI - Pentaho data integration.

What am I going to get from this introduction?

  • understand PDI environment

  • learn what are jobs and transformations

  • learn basic table input output

  • understand the scope of the large course: "learn ETL with Pentaho kettle PDI "

This is a good overview on the subject,
it is not by any means a full course on the subject, you will need to take another course
to become expert by doing a lot of hands on your self.


Who this course is for:
  • SQL developers
  • ETL developers
  • code developers (Python,PHP...)
  • Automation developers
  • BI developers
  • software project managers
  • anyone who like to understand what is ETL
Course content
7 sections • 22 lectures • 2h 4m total length
  • Welcome to the course
    03:50
  • Your first ETL example - table to table
    06:39
  • Your first ETL explained
    06:22
  • Second ETL explained - file to table
    09:03
  • Installation Intro
    01:36
  • Links to download softwares
    00:05
  • Install PDI
    04:08
  • Install Java
    03:37
  • Install MySql
    04:09
  • Install Dbeaver
    04:39
  • Install JDBC and connection
    05:28
  • Install Notepad ++
    01:03
  • PDI Environment
    11:20
  • PDI Jobs
    07:52
  • The Project
    06:06
  • Dim Date intro
    02:24
  • table output step
    09:48
  • DIm film intro
    07:27
  • Null Handling step
    06:10
  • Lookup step
    10:14
  • Main Job
    11:29
  • Goodbye ?
    00:39

Instructor
MBA in the field of IT, Master of ETL
Itamar Steinberg (inflow systems)
  • 4.4 Instructor Rating
  • 408 Reviews
  • 7,142 Students
  • 4 Courses

My name is Steinberg itamar,

I am in the field of information technology is for more than 15 years now,
I have a Master's degree (MBA) in information technology is an management.
My BA is also in the area of information technology from the University of Manchester.

During those years I was serving as manager and information technology expert
especially in the field of business intelligence and data integration.
all that time i used Pentaho kettle as the leading Data integration tool.

I started as a developer through team manager of development, head of the application department - responsible for all software, business processes and implementations,
also as project manager, my last role as an employee I was the CIO of the large company.

I was dealing with ERP, CRM business intelligence of course from all aspects of running a business. sales, transportation, customer service, imports, inventory, suppliers and manufacturing.

All of these areas gave me a unique perspective on business processes and how to analyze a company by looking at one large picture – that is the BI.
Of course that in order to combine all of those systems together you'll need data integration.

I have more than eight years working with pentaho kettle.
Six years ago I decided to start my own company - inflow systems and focus myself to business intelligence and data integration.
On those six years I, as CEO, was leading large business intelligence projects.
I hired several employees, very gifted, specific oriented to data integration and business intelligence. We have developed tens of projects from scratch at large companies like Alcatel Lucent (embedded solution), online gaming, binary options (stock market) and traditional businesses like food supplementary and organic food.

Today, I want to give from my knowledge to you because I believe that to share is the right way to go, during my learning phase I was reading a lot of books, struggling with the technology and I think I can make your life easier.