This is a demo for transaction analysis using a kaggle dataset

ETL steps Extraction - getting tables using KaggleHub - dim tables are complete, fact tables are only getting last n days Translation - stripping of unneeded text, converting to required datatypes (dates, float etc) Loading - saving to SQL - dim tables are completely overwritten, fact tables are only updated for the latest data. Error handling in case there's a gap in dates