Pentaho(PDI) Fundamentals and DWH Concepts

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

4.30 (255 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
2,098
students
7.5 hours
content
Oct 2020
last update
$54.99
regular price

What you will 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

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..!!!

Content

Overview of Data Warehousing

Overview of OLTP
Data Warehousing Concepts
Benefits and Limitations of Data Warehouse
ETL in Data Warehousing
ETL vs ELT

Overview of Dimensional Modeling

Dimensional Modeling Overview
Star Schema,Snowflake Schema and Galaxy Schema
Dimensional Modeling Design Steps
Slowly Changing Dimensions

Pentaho Data Integration Input and Output Steps

Pentaho Data Integration Tool Installation Guide
Install Mysql and Connect to Pentaho
Pentaho Data Integration Components
PDI Input and Output Steps Part 01
PDI Input and Output Steps Part 02
PDI Input and Output Steps Part 03

Pentaho Data Integration Transformation Steps

Transformation Steps Part-01
Transformation Steps Part-02
Transformation Steps Part-03
Transformation Steps Part-04
Transformation Steps Part-05
Transformation Steps Part-06
Transformation Steps Part-07

Pentaho Data Integration Flow Transformation Steps

Flow Transformation Steps Part-01
Flow Transformation Steps Part-02
Flow Transformation Steps Part-03

Pentaho Data Integration Join Steps

Inner Join
Cartesian Product
Outer Joins
Pentaho Joins Steps Part-01
Pentaho Joins Steps Part-02

Pentaho Data Integration Transformation Steps Advanced Level

Stream Lookup Step in Pentaho
Database Lookup Step in Pentaho
Database Join Step in Pentaho
Data Validation Step in Pentaho

Pentaho Data Integration Jobs

Overview of Jobs in Pentaho
Job Steps Part-02
Parameters and Variables in Pentaho
Parameter within Scope

Screenshots

Pentaho(PDI) Fundamentals and DWH Concepts - Screenshot_01Pentaho(PDI) Fundamentals and DWH Concepts - Screenshot_02Pentaho(PDI) Fundamentals and DWH Concepts - Screenshot_03Pentaho(PDI) Fundamentals and DWH Concepts - Screenshot_04

Reviews

Mrs
February 24, 2023
It is a good introduction to penthao with good content. Sometimes it's hard to follow because he switches quickly between jobs and transformation.
Prudhvidhar
January 23, 2022
Instructor has very good knowledge on the Pentaho and covered most of the basics/fundamentals of Pentaho PDI. Good for beginners. Would have rated 5 stars, if the instructor has covered the tutorial "43. Job Steps Part-02" with one example for all the transformations instead of skipping by just giving a fast overview on those topics. JNDI, Pan & Kitchen topics with examples should have been covered. Looking forward for these topics including the looping concepts in the future videos. Thank you
Kiki
April 26, 2021
Covers most important stuff. I liked the introduction on DWH etc. However, some things could be explained more clearly. Sometimes the teacher comes across errors that he fixes, but he does not explain how. Also, storyline is missing occasionally, making the explanation just a summation of stuff without any further comprehension.
Joe
April 23, 2021
Very applicable exercises and examples used. Very relevant material and overview of steps for both transformation and jobs that will be useful. Suggestion: Have examples ready ahead of time.
Tosaporn
February 8, 2021
all good ,except last 2 sections that What a combination of Job and meta injection rather combine all things you would separate likes transformation sections more better but overview good
Peter
January 6, 2021
The pacing is realy slow and somewhat boring. I do it at 2x speed to just get an overview of Pentaho, but it tells nothing about the fundamentals and practical use cases.
lolcode
August 30, 2020
Currently rating on the theoretical section on dimensional modelling. There were no interesting examples given. EG when a conflict between two questions indicates a change of grain. I will update the rating after going through the practical section.
Steve
July 9, 2020
Some more 'real world' example on use of the steps would be helpful. Presenter is not using an activated version of MS office, which is kind of unprofessional. While the material is generally good, it is not well rehearsed, meaning he spends a fair amount of time finding and correcting small mistakes he is making along the way. There are several resource files, but he never mentions or refers to them, just leaves that to us to figure out. And, very oddly, halfway through the course, he randomly changes databases; no need for that!
Juan
May 28, 2020
Hasta ahora un poco decepcionado, no se ve seguridad en los temas, los archivos adjuntos no tienen los mismos nombres, ni la misma información
Francisco
May 5, 2020
O curso de fato me ajudou a atingir um nível adequado de conhecimento de modo que eu pudesse usar o conhecimento rapidamente no meu dia a dia. No entanto notei que eu em algumas aulas o tempo investido em jobs ou transformações não estava fazenso sentido, muito tempo em itens fáceis de entender e repetições extremas. Nos itens mais complicados de entender, que exigiam conceituação sobre que tipo de informação deve ser coletada e aonde ela deve ser inserida, ficaram vagos, tal qual o "Abort" por exemplo. No geral o curso é bom, apoia no desenvolvimento e recomendo fazê-lo para quem é iniciante na tecnologia ou não sabe nada de Pentaho.
Suhas
April 25, 2020
The topics covered were ok however metadata injection was covered in a rush, also some more examples and transformation templates can be added for reference.
Christos
April 7, 2020
With 6 years experience with ODI, Data warehouse builder and SSIS , I find this course very very basic. I was waiting for more advanced stuff and a real case study.
Jaume
April 7, 2020
I found it monotonous and no so much engaging. Difficulties to set up the required environment when you are not using Windows.
Aswcap
April 5, 2020
Overall, it was good but i recommend to focus on job Schedule because this is a really importante part when we créate ETL's processes. Thanks
mpsreddy
March 2, 2020
Thanks sir for providing the basic information about each steps and job components.can you please update the content with real time examples like incremental loading ,Dimension loading , fact loading,Slowlychanging dimensions and some other useful contents.

Coupons

DateDiscountStatus
6/6/202095% OFF
expired

Charts

Price

Pentaho(PDI) Fundamentals and DWH Concepts - Price chart

Rating

Pentaho(PDI) Fundamentals and DWH Concepts - Ratings chart

Enrollment distribution

Pentaho(PDI) Fundamentals and DWH Concepts - Distribution chart
2465436
udemy ID
7/18/2019
course created date
9/15/2019
course indexed date
Bot
course submited by