Skip to content

ETL process using Pentaho Data Integration (Kettle), for Sales and Purchases Datamarts from Adventureworks, as the final project from the Data Management course from the Big Data & Analytics Masters @ EAE class of 2021

Notifications You must be signed in to change notification settings

joseph-higaki/etl_adventureworks_sales_purchases_datamart

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Adventureworks_sales_purchases_datamart

This is the final assignment from the Data Management course from the Big Data & Analytics Masters @ EAE class of 2021. This project:

Professors:

Team:

Architecture

Architecture

Highlights

Star Schema

Star Schema

Product Dimension Transformation

Implementation of SCD (Slowly Changing Dimension) type 2: add new row on history-worth-keeping attribute changes. Star Schema

Sales Fact Transformation

Use SCD type 2 appropriate version, for Product, Customer and Vendor Dimensions Sales Order Fact

Summary

Summary and presentation material

About

ETL process using Pentaho Data Integration (Kettle), for Sales and Purchases Datamarts from Adventureworks, as the final project from the Data Management course from the Big Data & Analytics Masters @ EAE class of 2021

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages