Retail Sales Analysis Dashboard
Retail Sales Analysis Dashboard
Mar 2026Analysed 3 years of sales data for a local retail chain to find why revenue dipped every monsoon quarter, and shipped a dashboard the owner now checks weekly.
- Cleaned 48,000 transaction rows — de-duplicated, fixed date formats, handled missing store codes
- Wrote 20+ SQL queries with joins and window functions for month-on-month growth
- Built a 4-page Power BI report with store, category and seasonality drill-downs
- Found that 38% of the dip came from two under-stocked categories
