This project analyzes sales data of a coffee business to identify the best cities in India for expansion. The analysis focuses on customer behavior, revenue trends, and market potential using SQL.
- SQL
- Relational Database Concepts
- Data Analysis Techniques
- Estimated coffee consumers based on population data
- Calculated total revenue and product-wise sales
- Identified top-selling products by city
- Analyzed customer distribution across cities
- Compared average sales and rent per customer
- Evaluated monthly sales growth trends
- Performed market potential analysis for expansion
- Pune shows highest revenue with low operational cost
- Delhi has the largest customer base and market size
- Jaipur offers strong growth potential with low rent
Based on data analysis, the top 3 cities for expansion are:
- Pune – High revenue and low rent
- Delhi – Large customer base and high demand
- Jaipur – Cost-efficient with strong sales potential
- SQL (JOIN, GROUP BY, Aggregations)
- Data Analysis & Business Insights
- Problem Solving with Real-world Dataset