A seller can have thousands of orders and still not keep the revenue. I analyzed 120,378 Amazon orders to find where it leaks and built a Power BI dashboard to show it.
Key findings: 14.2% of order lines were cancelled and total leakage reached 15.9%. Merchant-fulfilled orders cancelled more often than Amazon-fulfilled ones, and "Set" is both the top revenue category and the most cancelled.
Built with Python (cleaning), MySQL (analysis) and Power BI (interactive dashboard with INR/USD switch).
This project is an exploratory SQL analysis of 128,975 Amazon order lines, framed as a client question: where is the seller losing money? Using MySQL, I measure