SQL ETL STEPS FOR EXPENSE SYSTEM
STEP 1 - Create the table structures needed for the interim steps and the final table.
STEP 2 - Import the raw data files and aggregate it into interim tables for each card.
STEP 3 - REMOVE TRANSACTIONS THAT ARE NOT RELEVANT - THIS DIFFERS BY CARD
STEP 4 - COMBINE CLEANED TABLES.
STEP 5 - CATEGORISE TRANSACTIONS BASED ON TRANSACTION DESCRIPTION
STEP 6 - MASTER SCRIPT THAT RUNS THE PROCEDURES AND BUILDS FINAL TABLE FOR VISUALS