Analyzed 1,500 product sales transactions (Jan 2023–Jun 2025) across 5 regions and 7 product categories to uncover revenue trends, return-rate issues, and product performance gaps.
Excel (Pivot Tables, Data Cleaning, KPI Dashboards)
- North region led all regions with $967,958 in revenue (+16.9% vs South)
- Printer had the highest average order value ($3,243.54)
- Chair had the highest return rate (28.2%) — flagged for quality review
- Overall return rate: 24.8% | Average delivery time: 6.0 days
Quality audits on Chair returns, expand North region inventory, promote online payments, upsell premium products like Printers.