Executive KPI Database & Tableau Dashboard

An end-to-end business intelligence solution transforming raw retail data into a structured relational database. I engineered a Star Schema model and authored over 15 advanced SQL queries (including CTEs, JOINs, and Stored Procedures) to automate executive KPIs. I then connected this database to an interactive Tableau dashboard, allowing leadership to dynamically filter product profitability and identify operational loss drivers.