Pentaho(PDI) Fundamentals and DWH Concepts

Name: Pentaho(PDI) Fundamentals and DWH Concepts
Price: 54.99 USD
Rating: 3.6 (259 reviews)

This Pentaho(PDI) course covers the Pentaho fundamentals and Data Warehouse Concepts

(259 ratings)

2,104 students

Created by Saad Qureshi

Last updated 10/2020

English

English [Auto]

What you'll learn

Learn the Basic Overview of Data Warehouse
Learn the difference between Job and Transformation in Pentaho
Learn the different Transformation Steps in Pentaho
See the difference between Parameter and Variable.
Learn how to pass a variable and Parameter to Transformation Step
Learn the different types of Joins used in Pentaho
Learn how to apply If else Conditions in Pentaho
Lookup Steps in Pentaho

Requirements

All you need a Computer machine; windows, Mac, and Linux users are all welcome
Tools: MYSQL,Pentaho Data Integration ETL Tool
Very Basic Database/SQL concepts are required

Description

Brief Introduction:

Pentaho Data Integration (PDI) provides the Extract, Transform, and Load (ETL) capabilities.Through this process,data is captured,transformed and stored in a uniform format.

Some of the features of Pentaho data integration tool are mentioned below.

Data migration between different databases and applications.
Huge volume of data can be loaded from different heterogeneous sources.
Data Cleansing with steps ranging from very simple to very complex transformations.

Components of Pentaho:

Below are the components of Penatho data integration tool.

Spoon.bat----It is User Interface used to create Jobs and Transformation.
Pan.Bat------It is used to run transformation from the command line.
Kitchen.Bat---It is used to run Jobs from the command line.
Carte.Bat----Execute your Jobs and Transformation on Web Server.
Encr.Bat------Helps you to generate encrypted passwords.

Career Perspective:

If you want to pursue a career as an ETL developer,you should definitely consider taking this course.Most importantly,If you learn one ETL tool whether it's Pentaho or Informatica,learning other ETL tools won't be difficult.Also,the demand of ETL developer is keep on increasing as the data size is increasing.

After this Course:

Once you are done with the course,you will have maximum knowledge of all the transformation steps that are required to clean the data.Furthermore,you can apply all the attained knowledge in the industry.

Cheers..!!

Have a Great Learning..!!!

Who this course is for:

Professionals who want to learn new ETL tool to enhance their career.
Students who want to have a career in the field of Data warehouse/ETL developer

Featured review

Neha T.

30 courses

16 reviews

4 years ago

The instructor is knowledgable and delivers the required practices necessary to work with the PDI tool . (edited) Thanks for your reply saad , could you also provide the xml file and other files used as examples for practice , I appreciate it ..thank you! (edit 2) yes it is flyingdiva111@gmail.com could you add a tutorial on scd1 and 2 in pdi?

Saad Qureshi

Computer Scientist || Freelancer || Programmer

4.2 Instructor Rating
2,175 Reviews
13,863 Students
8 Courses

Background:

Computer Scientist with several years of industry experience. Other than this,I am passionate about teaching and guiding students learning programming languages.

Life Philosophy

1: He who is not courageous enough to take risks will accomplish nothing in life.

2: Do not dwell in the past,do not dream of the future,concentrate the mind on the present moment.

3: Service to others is the rent you pay for your room here on earth..