End-to-end analysis of 3,900 retail transactions using Python, MySQL, and Power BI.
Python (Pandas) · MySQL · Power BI
- Python — Data cleaning, median imputation, feature engineering, loaded to MySQL
- MySQL — 10 business queries (segmentation, revenue analysis, discount behavior, product rankings)
- Power BI — Interactive dashboard with KPI cards and filters
- 2,518 repeat buyers are unsubscribed → biggest retention opportunity
- Young Adults drive the highest revenue ($62,143)
- Hats & Sneakers have ~50% discount rates → margin concern
- 80% of customers are Loyal, but only 27% are subscribed
Boost subscriptions · Loyalty programs · Review discount policy · Targeted marketing toward Young Adults
Nishant Pareek · [www.linkedin.com/in/nishant-pareek-3a4612330] · [nishantwork102@gmail.com]