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
If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com
Get More Tutorials and Support Us -->> https://FreeCourseWeb.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~Get Your Files Here !/1 - Introduction/1 - Welcome to the course English.srt
4.6 KB
~Get Your Files Here !/1 - Introduction/1 - Welcome to the course.mp4
13.7 MB
~Get Your Files Here !/1 - Introduction/2 - Course resources.html
117 B
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Customer Data/CustomerData_Central.txt
14.7 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Customer Data/CustomerData_DataGrid.xlsx
8.9 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Customer Data/CustomerData_East.xlsx
22.2 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Customer Data/CustomerData_South.zip
3.6 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Customer Data/CustomerData_West/CustomerData_West_Arizono.csv
1.4 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Customer Data/CustomerData_West/CustomerData_West_California.csv
13.3 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Customer Data/CustomerData_West/CustomerData_West_Colorado.csv
1.8 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Customer Data/CustomerData_West/CustomerData_West_Others.csv
1.2 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Customer Data/CustomerData_West/CustomerData_West_Washington.csv
2.7 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Customer Data/CustomerData_West/customerdummy.csv
5 B
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Customer Data/LookupForStates.xlsx
9.1 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/CustomerComplete.csv
63.9 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/emailing/Sales Dates Incorrect.xls.xls
13.5 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Metadata Injection/final.ktr
14.6 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Metadata Injection/injector.ktr
16.1 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Metadata Injection/metadata injection.xlsx
76.1 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Metadata Injection/template.ktr
14.4 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Outputs/Sales Dates Incorrect.xls.xls
13.5 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Product Data/ProductDataasJSON.js
53 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Product Data/ProductDataAsXML.xml.xml
277.3 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Product Data/ProductLookupForSales.csv
100.2 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/ProductComplete.csv
140.3 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/ProductforJSON.csv
29.9 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/ProductforXML.csv
110.6 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Sales Data/SalesforAWSandHadoop.csv
751.7 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/Sales Data/SalesforSQL.csv
194.8 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/SalesComplete.csv
944.8 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Data/scheduling/schedulingjob.bat
145 B
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Other/00 Debugging PostgreSQL installation issues.pdf
253.4 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Other/CustomerTransformation.ktr
64.6 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Other/Demonstration/Dashboard/completefile.csv
889 B
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Other/Demonstration/demoJob.kjb
11.8 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Other/Demonstration/DemoTransformation.ktr
23.3 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Other/Demonstration/incomplete file.xls.xls
13.5 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Other/Demonstration/Sales/FurnitureSales.csv
1 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Other/job.kjb
18.1 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Other/ProductTransformation.ktr
26.3 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Other/SalesTransformation.ktr
60.9 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Other/Spoon - Shortcut.lnk
1.2 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Other/SQL-PDI.ktr
15.1 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Other/udje.ktr
13.1 KB
~Get Your Files Here !/1 - Introduction/Pentaho for ETL & Data Integration Masterclass 2022/Presentation/Course material.pdf
1.6 MB
~Get Your Files Here !/10 - Merging Data Streams/27 - Concepts Merging Data Streams English.srt
10.7 KB
~Get Your Files Here !/10 - Merging Data Streams/27 - Concepts Merging Data Streams.mp4
19.8 MB
~Get Your Files Here !/10 - Merging Data Streams/28 - Sorted Merge Step Merging customer data English.srt
21.3 KB
~Get Your Files Here !/10 - Merging Data Streams/28 - Sorted Merge Step Merging customer data.mp4
99.8 MB
~Get Your Files Here !/10 - Merging Data Streams/29 - Merging product data English.srt
12.4 KB
~Get Your Files Here !/10 - Merging Data Streams/29 - Merging product data.mp4
65.6 MB
~Get Your Files Here !/10 - Merging Data Streams/30 - Append data stream merging sales data English.srt
15.4 KB
~Get Your Files Here !/10 - Merging Data Streams/30 - Append data stream merging sales data.mp4
131.2 MB
~Get Your Files Here !/11 - Data Cleansing/31 - Introduction to Data Cleansing English.srt
9.6 KB
~Get Your Files Here !/11 - Data Cleansing/31 - Introduction to Data Cleansing.mp4
21.4 MB
~Get Your Files Here !/11 - Data Cleansing/32 - Value Mapper Step English.srt
7.9 KB
~Get Your Files Here !/11 - Data Cleansing/32 - Value Mapper Step.mp4
46.6 MB
~Get Your Files Here !/11 - Data Cleansing/33 - Replace in String Step English.srt
7.7 KB
~Get Your Files Here !/11 - Data Cleansing/33 - Replace in String Step.mp4
36 MB
~Get Your Files Here !/11 - Data Cleansing/34 - Fuzzy Match concepts English.srt
4.4 KB
~Get Your Files Here !/11 - Data Cleansing/34 - Fuzzy Match concepts.mp4
9.1 MB
~Get Your Files Here !/11 - Data Cleansing/35 - Fuzzy Match Step in PDI English.srt
14.3 KB
~Get Your Files Here !/11 - Data Cleansing/35 - Fuzzy Match Step in PDI.mp4
104.5 MB
~Get Your Files Here !/11 - Data Cleansing/36 - Fuzzy Match Algorithms English.srt
11.8 KB
~Get Your Files Here !/11 - Data Cleansing/36 - Fuzzy Match Algorithms.mp4
45.5 MB
~Get Your Files Here !/11 - Data Cleansing/37 - Formula Step and changing data format English.srt
12.9 KB
~Get Your Files Here !/11 - Data Cleansing/37 - Formula Step and changing data format.mp4
56.8 MB
~Get Your Files Here !/11 - Data Cleansing/38 - Common Data Cleaning Steps English.srt
5.2 KB
~Get Your Files Here !/11 - Data Cleansing/38 - Common Data Cleaning Steps.mp4
13 MB
~Get Your Files Here !/12 - Data Validation/39 - Introduction to Data validation English.srt
7.3 KB
~Get Your Files Here !/12 - Data Validation/39 - Introduction to Data validation.mp4
19.8 MB
~Get Your Files Here !/12 - Data Validation/40 - Datavalidation 1 StringtoInt and integer range validations English.srt
14.6 KB
~Get Your Files Here !/12 - Data Validation/40 - Datavalidation 1 StringtoInt and integer range validations.mp4
152 MB
~Get Your Files Here !/12 - Data Validation/41 - Data validation 2 Checking Reference Values using stream lookup English.srt
11.1 KB
~Get Your Files Here !/12 - Data Validation/41 - Data validation 2 Checking Reference Values using stream lookup.mp4
88.9 MB
~Get Your Files Here !/12 - Data Validation/42 - Data validation 3 Order date shipping date using calculator step English.srt
7.3 KB
~Get Your Files Here !/12 - Data Validation/42 - Data validation 3 Order date shipping date using calculator step.mp4
43.1 MB
~Get Your Files Here !/12 - Data Validation/43 - Common Data Validation steps English.srt
5.9 KB
~Get Your Files Here !/12 - Data Validation/43 - Common Data Validation steps.mp4
14 MB
~Get Your Files Here !/13 - Error Handling/44 - Correcting the errors and merging with main stream English.srt
15.2 KB
~Get Your Files Here !/13 - Error Handling/44 - Correcting the errors and merging with main stream.mp4
109.3 MB
~Get Your Files Here !/13 - Error Handling/45 - Writing the errors to the log English.srt
4.5 KB
~Get Your Files Here !/13 - Error Handling/45 - Writing the errors to the log.mp4
19 MB
~Get Your Files Here !/13 - Error Handling/46 - Writing the errors to a separate file English.srt
7.5 KB
~Get Your Files Here !/13 - Error Handling/46 - Writing the errors to a separate file.mp4
56.3 MB
~Get Your Files Here !/14 - Transformation and Analytics steps/47 - Concatenating Address Fields English.srt
7.5 KB
~Get Your Files Here !/14 - Transformation and Analytics steps/47 - Concatenating Address Fields.mp4
40.8 MB
~Get Your Files Here !/14 - Transformation and Analytics steps/48 - Data Aggregation using Groupby English.srt
10.3 KB
~Get Your Files Here !/14 - Transformation and Analytics steps/48 - Data Aggregation using Groupby.mp4
56.6 MB
~Get Your Files Here !/14 - Transformation and Analytics steps/49 - Normalization and Denormalization English.srt
9 KB
~Get Your Files Here !/14 - Transformation and Analytics steps/49 - Normalization and Denormalization.mp4
30.3 MB
~Get Your Files Here !/14 - Transformation and Analytics steps/50 - Number Range Step English.srt
6 KB
~Get Your Files Here !/14 - Transformation and Analytics steps/50 - Number Range Step.mp4
25.3 MB
~Get Your Files Here !/15 - PDI SQL Connection/51 - Introduction to PDI SQL connection English.srt
8 KB
~Get Your Files Here !/15 - PDI SQL Connection/51 - Introduction to PDI SQL connection.mp4
21.4 MB
~Get Your Files Here !/15 - PDI SQL Connection/52 - Reading and filtering data from DB into PDI English.srt
6.8 KB
~Get Your Files Here !/15 - PDI SQL Connection/52 - Reading and filtering data from DB into PDI.mp4
16.1 MB
~Get Your Files Here !/15 - PDI SQL Connection/53 - Updating and Inserting data into DB from PDI English.srt