Amazon Order Leakage Analysis with Python, MySQL and Power BIAmazon Order Leakage Analysis with Python, MySQL and Power BI
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
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).
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started