~Get Your Files Here !

  1 - Introduction

   1 - Welcome to the course.mp4

   Pentaho for ETL & Data Integration Masterclass 2022

    Data

     Customer Data

      CustomerData_DataGrid.xlsx

      CustomerData_South.zip

      CustomerData_West

       CustomerData_West_California.csv

       CustomerData_West_Others.csv

       customerdummy.csv

      LookupForStates.xlsx

     CustomerComplete.csv

     Metadata Injection

      injector.ktr

      template.ktr

     Outputs

     Product Data

      ProductDataasJSON.js

     ProductComplete.csv

     ProductforXML.csv

     Sales Data

      SalesforSQL.csv

     SalesComplete.csv

     emailing

     scheduling

    Other

     CustomerTransformation.ktr

     Demonstration

      Dashboard

      DemoTransformation.ktr

      Sales

      demoJob.kjb

     ProductTransformation.ktr

     SalesTransformation.ktr

     job.kjb

    Presentation

  10 - Merging Data Streams

   27 - Concepts Merging Data Streams.mp4

   28 - Sorted Merge Step Merging customer data.mp4

   29 - Merging product data.mp4

   30 - Append data stream merging sales data.mp4

  11 - Data Cleansing

   31 - Introduction to Data Cleansing.mp4

   32 - Value Mapper Step.mp4

   33 - Replace in String Step.mp4

   34 - Fuzzy Match concepts.mp4

   35 - Fuzzy Match Step in PDI.mp4

   36 - Fuzzy Match Algorithms.mp4

   37 - Formula Step and changing data format.mp4

   38 - Common Data Cleaning Steps.mp4

  12 - Data Validation

   39 - Introduction to Data validation.mp4

   40 - Datavalidation 1 StringtoInt and integer range validations.mp4

   41 - Data validation 2 Checking Reference Values using stream lookup.mp4

   42 - Data validation 3 Order date shipping date using calculator step.mp4

   43 - Common Data Validation steps.mp4

  13 - Error Handling

   44 - Correcting the errors and merging with main stream.mp4

   45 - Writing the errors to the log.mp4

   46 - Writing the errors to a separate file.mp4

  14 - Transformation and Analytics steps

   47 - Concatenating Address Fields.mp4

   48 - Data Aggregation using Groupby.mp4

   49 - Normalization and Denormalization.mp4

   50 - Number Range Step.mp4

  15 - PDI SQL Connection

   51 - Introduction to PDI SQL connection.mp4

   52 - Reading and filtering data from DB into PDI.mp4

   53 - Updating and Inserting data into DB from PDI.mp4

   54 - Deleting data from SQL DB using PDI.mp4

  16 - Conceptual understanding for Loading Data

   55 - Facts and Dimensions tables.mp4

   56 - Surrogate Keys in Dimension tables.mp4

   57 - Type 1 2 Slowly Changing Dimensions.mp4

   58 - Schemas.mp4

  17 - Loading the data into a Data Mart

   59 - Creating tables in DB.mp4

   60 - Loading Customer Data using combination lookup update step.mp4

   61 - Loading product data using dimension lookup step.mp4

   62 - Loading sales data after database lookup steps.mp4

  18 - Running Java and Javascript

   63 - Scripting Steps.mp4

  19 - PDI Jobs

   64 - PDI Jobs vs Transformation.mp4

   65 - Controlling the flow of execution.mp4

   66 - Setting variables using set variables step.mp4

   67 - File and Folder Management.mp4

   68 - Sending Email Step.mp4

   69 - Abort Job Step.mp4

  2 - Pentaho Data Integration PDI Installation and Setup

   3 - Setting up environment and installing PDI.mp4

   4 - This is a milestone.mp4

   5 - Opening Spoon The Graphical UI.mp4

  20 - Scheduling a job for production environment

   70 - Running using command prompt and scheduling.mp4

  21 - Metadata injection

   71 - Metadata injection.mp4

  22 - Regex Notation

   72 - Regular Expressions for advanced String Matching.mp4

  23 - Congratulations and about your certificate

   74 - The final milestone English.srt

   75 - Bonus Lecture.html

  3 - A Simple ETL Demonstration

   6 - The example problem statement.mp4

   7 - Demonstration of a PDI transformation.mp4

   8 - Demonstration of a PDI Job.mp4

  4 - Basic concepts Theory for foundational understanding

   10 - Data Warehouse Ops Database and Data mart.mp4

   11 - Inmon vs Kimball Architecture.mp4

   12 - ETL vs ELT.mp4

   9 - What is ETL.mp4

  5 - The ETL process The practical part begins here

   13 - Data and the ETL process.mp4

  6 - DATA EXTRACTION Extracting tabular data

   14 - Manually entering data into PDI.mp4

   15 - Inputting Data from a TXT text file.mp4

   16 - Input from multiple CSV files at the same time.mp4

   17 - Inputting Data from an Excel file.mp4

   18 - Extracting Data from Zipped files.mp4

  7 - DATA EXTRACTION Extracting nontabular data

   19 - Extracting from XML.mp4

   20 - Extracting from JSON.mp4

  8 - Extracting from an SQL table

   21 - Plan for importing sales data.mp4

   22 - Installing PostgreSQL and pgAdmin in your PC English.srt

   22 - Installing-PostgreSQL-on-Mac.pdf

   23 - Creating Sales table in SQL.mp4

   24 - Extracting from an SQL table.mp4

  9 - Storing and Retrieving Data from Cloud storage

   25 - Storing Data on AWS S3.mp4

   26 - Reading data from AWS S3.mp4

  Bonus Resources.txt