Data Warehouse design and ETL pipeline for hardware market sales data using Python and SQL Server. This project implements a Data Warehouse for hardware market sales data.
Assignment 0 Design of the data warehouse schema using SQL Server.
Assignment 1 Splitting the fact dataset into three product-specific fact tables using Python.
Assignment 2 Implementation of a Python ETL pipeline to populate the database.
Python SQL Server pyodbc CSV processing