🔗 Live Project: https://vyomvy.github.io/superstore-analysis/
This project analyzes supermarket sales data to uncover hidden patterns in profitability across cities, with the goal of identifying loss-making regions and growth opportunities.
High sales do not always translate into high profit.
This project answers:
- Which cities are driving losses?
- Which markets are truly profitable?
- Where should the business invest or cut back?
- Superstore Sales Dataset
- Includes: Orders, Sales, Profit, Cities, Categories
- Python 🐍
- Pandas
- Google Colab
- City-level profit analysis
- Revenue vs Profit comparison
- Identification of high-loss regions
- Market efficiency evaluation
- Philadelphia
- Houston
- Chicago
👉 These cities generate strong revenue but destroy value due to poor profit margins.
- New York City
- San Francisco
👉 These cities maintain strong balance between sales and profitability.
- Springfield
- Los Angeles
👉 These markets show potential and can be scaled with better strategies.
The business shows a clear imbalance between volume and profitability.
- High sales ≠ High profit
- Discounting and pricing strategy may be hurting margins
- Strategic focus should shift toward profit efficiency
- Reduce aggressive discounting in loss-making cities
- Invest more in high-performing markets
- Optimize pricing strategy
- Expand operations in growth-potential regions
This project demonstrates:
- Real-world business thinking
- Data-driven decision making
- Ability to convert raw data → actionable insights
- Add visualizations (Power BI / Matplotlib)
- Build interactive dashboard
- Predict profit using ML