Pentaho(Pdi) Fundamentals And Dwh Concepts
Last updated 10/2020
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.39 GB | Duration: 7h 16m

This Pentaho(PDI) course covers the Pentaho fundamentals and Data Warehouse Concepts
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..!!!
Overview
Section 1: Overview of Data Warehousing
Lecture 1 Overview of OLTP
Lecture 2 Data Warehousing Concepts
Lecture 3 Benefits and Limitations of Data Warehouse
Lecture 4 ETL in Data Warehousing
Lecture 5 ETL vs ELT
Section 2: Overview of Dimensional Modeling
Lecture 6 Dimensional Modeling Overview
Lecture 7 Star Schema,Snowflake Schema and Galaxy Schema
Lecture 8 Dimensional Modeling Design Steps
Section 3: Pentaho Data Integration Input and Output Steps
Lecture 9 Pentaho Data Integration Tool Installation Guide
Lecture 10 Install Mysql and Connect to Pentaho
Lecture 11 Pentaho Data Integration Components
Lecture 12 PDI Input and Output Steps Part 01
Lecture 13 PDI Input and Output Steps Part 02
Lecture 14 PDI Input and Output Steps Part 03
Section 4: Pentaho Data Integration Transformation Steps
Lecture 15 Transformation Steps Part-01
Lecture 16 Transformation Steps Part-02
Lecture 17 Transformation Steps Part-03
Lecture 18 Transformation Steps Part-04
Lecture 19 Transformation Steps Part-05
Lecture 20 Transformation Steps Part-06
Lecture 21 Transformation Steps Part-07
Section 5: Pentaho Data Integration Flow Transformation Steps
Lecture 22 Flow Transformation Steps Part-01
Lecture 23 Flow Transformation Steps Part-02
Lecture 24 Flow Transformation Steps Part-03
Section 6: Pentaho Data Integration Join Steps
Lecture 25 Inner Join
Lecture 26 Cartesian Product
Lecture 27 Outer Joins
Lecture 28 Pentaho Joins Steps Part-01
Lecture 29 Pentaho Joins Steps Part-02
Section 7: Pentaho Data Integration Transformation Steps Advanced Level
Lecture 30 Stream Lookup Step in Pentaho
Lecture 31 Database Lookup Step in Pentaho
Lecture 32 Database Join Step in Pentaho
Lecture 33 Data Validation Step in Pentaho
Section 8: Web Services
Lecture 34 Consuming REST Service in Pentaho
Lecture 35 Consuming SOAP Service in Pentaho
Section 9: SCD & CDC Implementation in Pentaho
Lecture 36 Slowly Changing Dimensions
Lecture 37 SCD Type 1 Implementation
Lecture 38 SCD Type 2 Implementation
Lecture 39 Change Data Capture(CDC) Implementation
Lecture 40 Change Data Capture - Method 2 Part-01
Lecture 41 Change Data Capture - Method 2 Part-02
Section 10: Pentaho Data Integration Jobs
Lecture 42 Overview of Jobs in Pentaho
Lecture 43 Job Steps Part-02
Lecture 44 Parameters and Variables in Pentaho
Lecture 45 Parameter within Scope
Section 11: Metadata ETL Injection Step Example
Lecture 46 Pentaho Metadata Injection Part-01
Lecture 47 Pentaho Metadata Injection Part-02
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
Screenshots