Featured projects
Retail · Profitability
Global Superstore: where profit is lost
$12.64M in sales but only $1.47M profit. 30% of orders lose money, and orders discounted over 30% run at a -51% margin. I built a 4-page Power BI report to show where and why.
Power BI · DAX · Power Query
Retail · Revenue
Vrinda Store: why revenue fell 20%
Revenue dropped from Rs.1.83M in March to Rs.1.46M by November. I traced most of the drop to female customers on Amazon and Myntra and estimated a Rs.2M recovery from a targeted campaign.
SQL · Excel · Power BI
E-commerce · Customer retention
Olist: why 97% of customers never buy again
I analysed 93,358 customers with SQL. Repeat buyers spend 92% more, and those who return take about 81 days, so I recommended a reactivation campaign around day 55 to 65.
MySQL · Python · Power BI
