Case Study: 2.5-Year Global Retail Sales & Insights (20232025)
- Client Challenge: Unorganized sales records with no clear metrics on regional growth, product returns, or promotional ROI.
- My Solution:
- Cleaned and structured 1,500+ transactional sales records.
- Built an Interactive Executive Dashboard tracking Net Sales ($4.34M total), YoY Growth (~4.4%), and Regional Share.
- Performed Product Return Rate Analysis (identifying high return rates in Laptops & Chairs).
- Business Impact: Delivered actionable strategic recommendations for leadership to optimize quality control and promotional campaigns.