Pentaho for ETL & Data Integration Masterclass 2024 - PDI 9

[dkmdkm]

Free Download Pentaho for ETL & Data Integration Masterclass 2024 - PDI 9
Last updated 1/2024
Duration: 9h23m | Video: .MP4, 1920x1080 30 fps | Audio: AAC, 44.1kHz, 2ch | Size: 3.46 GB
Genre: eLearning | Language: English
Use Pentaho Data Integration tool for ETL & Data warehousing. Do ETL development using PDI 9.0 without coding background

What you'll learn
Understanding of the entire data integration process using PDI
Extracting data from all popular data sources including Excel, JSON, Zipped files, TXT files and even cloud storage
Cleaning the data using Pentaho Data Integration
Applying business rules on the data in PDI
Different types of Data transformations
Loading the data into different formats
Managing SQL database using PDI
Metadata Injection - a powerful tool offered by PDI
Understanding of the concepts of data marts and data warehouse
Requirements
Basic understanding of the data storage concepts will be helpful. Coding background is NOT required for this course
Description
What is ETL?
The ETL (extract, transform, load) process is the most popular method of collecting data from multiple sources and loading it into a centralized data warehouse. ETL is an essential component of data warehousing and analytics.
Why Pentaho for ETL?
Pentaho has phenomenal ETL, data analysis, metadata management and reporting capabilities. Pentaho is
faster
than other ETL tools (including Talend). Pentaho has a user-friendly GUI which is
easier
and takes less time to learn. Pentaho is
great for beginners
. Also, Pentaho Data Integration (PDI) is an important skill in data analytics field.
How much can I earn?
In the US, median salary of an ETL developer is $74,835 and in India average salary is Rs. 7,06,902 per year. Accenture, Tata Consultancy Services,
Cognizant Technology Solutions, Capgemini, IBM, Infosys etc. are major recruiters for people skilled in ETL tools; Pentaho ETL is one of the most sought-after skills that recruiters look for. Demand for Pentaho Data Integration (PDI) techniques is increasing day after day.
What makes us qualified to teach you?
The course is taught by Abhishek and Pukhraj.
Homepage

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

No Password - Links are Interchangeable

 

[0dayddl]

​

Download Free Download : Pentaho for ETL & Data Integration Masterclass 2024
mp4 | Video: h264,1920X1080 | Audio: AAC, 44.1 KHz
Genre:eLearning | Language: English | Size:3.46 GB
​

Files Included :

Spoiler

1 - Welcome to the course.mp4 (13.68 MB)
MP4
CustomerData South.zip (3.55 KB)
ZIP
27 - Concepts Merging Data Streams.mp4 (19.84 MB)
MP4
28 - Sorted Merge Step Merging customer data.mp4 (99.77 MB)
MP4
29 - Merging product data.mp4 (65.63 MB)
MP4
30 - Append data stream merging sales data.mp4 (131.25 MB)
MP4
31 - Introduction to Data Cleansing.mp4 (21.38 MB)
MP4
32 - Value Mapper Step.mp4 (46.61 MB)
MP4
33 - Replace in String Step.mp4 (36.01 MB)
MP4
34 - Fuzzy Match concepts.mp4 (9.12 MB)
MP4
35 - Fuzzy Match Step in PDI.mp4 (104.49 MB)
MP4
36 - Fuzzy Match Algorithms.mp4 (45.53 MB)
MP4
37 - Formula Step and changing data format.mp4 (56.77 MB)
MP4
38 - Common Data Cleaning Steps.mp4 (13.04 MB)
MP4
39 - Introduction to Data validation.mp4 (19.77 MB)
MP4
40 - Datavalidation 1 StringtoInt and integer range validations.mp4 (152.03 MB)
MP4
41 - Data validation 2 Checking Reference Values using stream lookup.mp4 (88.86 MB)
MP4
42 - Data validation 3 Order date shipping date using calculator step.mp4 (43.14 MB)
MP4
43 - Common Data Validation steps.mp4 (14.04 MB)
MP4
44 - Correcting the errors and merging with main stream.mp4 (109.34 MB)
MP4
45 - Writing the errors to the log.mp4 (19.03 MB)
MP4
46 - Writing the errors to a separate file.mp4 (56.28 MB)
MP4
47 - Concatenating Address Fields.mp4 (40.8 MB)
MP4
48 - Data Aggregation using Groupby.mp4 (56.6 MB)
MP4
49 - Normalization and Denormalization.mp4 (30.28 MB)
MP4
50 - Number Range Step.mp4 (25.29 MB)
MP4
51 - Introduction to PDI SQL connection.mp4 (21.45 MB)
MP4
52 - Reading and filtering data from DB into PDI.mp4 (16.11 MB)
MP4
53 - Updating and Inserting data into DB from PDI.mp4 (33.37 MB)
MP4
54 - Deleting data from SQL DB using PDI.mp4 (19.34 MB)
MP4
55 - Facts and Dimensions tables.mp4 (13.1 MB)
MP4
56 - Surrogate Keys in Dimension tables.mp4 (12.92 MB)
MP4
57 - Type 1 2 Slowly Changing Dimensions.mp4 (9.61 MB)
MP4
58 - Schemas.mp4 (9.94 MB)
MP4
59 - Creating tables in DB.mp4 (29.25 MB)
MP4
60 - Loading Customer Data using combination lookup update step.mp4 (87.85 MB)
MP4
61 - Loading product data using dimension lookup step.mp4 (74.81 MB)
MP4
62 - Loading sales data after database lookup steps.mp4 (92.23 MB)
MP4
63 - Scripting Steps.mp4 (26.43 MB)
MP4
64 - PDI Jobs vs Transformation.mp4 (8.2 MB)
MP4
65 - Controlling the flow of execution.mp4 (16.83 MB)
MP4
66 - Setting variables using set variables step.mp4 (41.84 MB)
MP4
67 - File and Folder Management.mp4 (27.01 MB)
MP4
68 - Sending Email Step.mp4 (39.31 MB)
MP4
69 - Abort Job Step.mp4 (13.1 MB)
MP4
3 - Setting up environment and installing PDI.mp4 (33.43 MB)
MP4
4 - This is a milestone.mp4 (26.14 MB)
MP4
5 - Opening Spoon The Graphical UI.mp4 (34.19 MB)
MP4
70 - Running using command prompt and scheduling.mp4 (40.88 MB)
MP4
71 - Metadata injection.mp4 (90.05 MB)
MP4
72 - Regular Expressions for advanced String Matching.mp4 (112.05 MB)
MP4
74 - The final milestone.mp4 (8.36 MB)
MP4
6 - The example problem statement.mp4 (29.85 MB)
MP4
7 - Demonstration of a PDI transformation.mp4 (178.92 MB)
MP4
8 - Demonstration of a PDI Job.mp4 (115.2 MB)
MP4
10 - Data Warehouse Ops Database and Data mart.mp4 (17.81 MB)
MP4
11 - Inmon vs Kimball Architecture.mp4 (13.59 MB)
MP4
12 - ETL vs ELT.mp4 (8.73 MB)
MP4
9 - What is ETL.mp4 (11.35 MB)
MP4
13 - Data and the ETL process.mp4 (105.31 MB)
MP4
14 - Manually entering data into PDI.mp4 (88.28 MB)
MP4
15 - Inputting Data from a TXT text file.mp4 (115.5 MB)
MP4
16 - Input from multiple CSV files at the same time.mp4 (109.22 MB)
MP4
17 - Inputting Data from an Excel file.mp4 (34.43 MB)
MP4
18 - Extracting Data from Zipped files.mp4 (30.62 MB)
MP4
19 - Extracting from XML.mp4 (68.26 MB)
MP4
20 - Extracting from JSON.mp4 (62.83 MB)
MP4
21 - Plan for importing sales data.mp4 (7.76 MB)
MP4
22 - Installing PostgreSQL and pgAdmin in your PC.mp4 (68.31 MB)
MP4
23 - Creating Sales table in SQL.mp4 (53.2 MB)
MP4
24 - Extracting from an SQL table.mp4 (28.51 MB)
MP4
25 - Storing Data on AWS S3.mp4 (66.95 MB)
MP4
26 - Reading data from AWS S3.mp4 (69.26 MB)
MP4

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

Free search engine download: Pentaho for ETL & Data Integration Masterclass 2024