Retail Sales Performance & Profitability Analysis
An end-to-end retail analytics solution β interactive Power BI dashboards analyzing $45M+ in operational sales data across stores, districts, and product categories.
- Designed a scalable star-schema model β Sales fact with Store, Item, District, and Time dimensions.
- Built advanced DAX measures: Total Sales, Sales Variance %, Gross Margin, Sales per Sq Ft, YoY KPIs.
- What-If analysis to simulate pricing changes and forecast revenue impact.