Sales Data Warehousing & Analysis

This project was part of my IMT 577 course titled 'Business Intelligence Systems'. It consisted of creating a STAR schema data warehouse of sales data consisting of 250,000 transactions. Using Excel, SQL Server, and SSIS, I performed staging and loading STAR schema tables and performed ETL processes. Finally, I used Tableau to create dashboards providing business insights from the sales data.

The project files can be found here.