End-to-end e-commerce analytics project analyzing 99K orders worth R$16M revenue using MySQL, Python and Power BI.
- MySQL — 25 complex SQL queries
- Python — EDA with Pandas, Matplotlib, Seaborn
- Power BI — 5 page interactive dashboard
- Source: Olist Brazilian E-Commerce (Kaggle)
- Orders: 99,440
- Revenue: R$16,008,872
- Period: 2016 — 2018
- Top Category: Bed & Bath
- Peak Month: November 2017 (Black Friday)
- On Time Delivery: 91.89%
- Avg Review Score: 4.09/5
- Customer LTV: R$159.86
- Top Payment: Credit Card (78%)
- Top State: São Paulo
- Launch loyalty program — 99% one time buyers
- Double marketing budget for Black Friday
- Fix January delivery delays
- Improve delivery to RR state
- Focus inventory on Bed & Bath category
PRINCE
- LinkedIn:https://www.linkedin.com/in/prince-3b5a53275/)
- GitHub: github.com/Prince-kash
- Email: [email protected]