📌 Objective

Analyze supermarket sales data to uncover profitability gaps and identify high-performing markets.

🧠 Business Problem

High sales do not always translate into high profit. This project highlights cities that generate revenue but reduce overall business value.

📊 Key Insights

Loss-Making Cities: Philadelphia, Houston, Chicago

→ High sales but negative profitability

Top Profit Cities: New York City, San Francisco

→ Strong balance of revenue and profit

Growth Potential: Springfield, Los Angeles

→ Opportunity for expansion

📸 Analysis Snapshots

City vs Profit Analysis

Final Profit Table

Loss Making Products

Total Sales Trend

🚀 Recommendations

• Reduce aggressive discounting in loss-making cities
• Focus on high-profit regions
• Improve pricing strategies
• Expand in growth markets

🛠️ Tools Used

Python, Pandas, Matplotlib, Google Colab