final project

• Designed and built a SQL Server star-schema data warehouse from raw retail data, covering ~270K sales transactions, 24

stores, ~10K customers, and ~1.5K products (1997–1998)

• Modeled fact and dimension tables and wrote SQL views and business queries to answer 18+ stakeholder questions on sales,

returns, and regional performance

• Built an interactive Power BI dashboard with DAX measures (YoY growth, return rate %, average order value) to track sales

trends, product performance, and regional profitability

• Delivered data-driven recommendations that identified an underperforming region/store and a weak loyalty tier, translating

analysis into concrete business actions