This project aims to analyze the coffee sales data across multiple cities, customers, and products to derive meaningful insights. By examining population, sales, revenue, customer segmentation, and market potential, the project provides actionable business intelligence for decision-making in the coffee industry.
The dataset used in this project is publicly available on Kaggle.
You can find the dataset here.
Estimated the number of coffee consumers in each city (25% of population) and calculated total revenue from coffee sales in Q4 2023. Results were ranked by city population and total sales.
Analyzed the number of units sold for each coffee product and identified the top-selling products in each city. Results were sorted by sales volume and ranked by popularity.
Counted unique coffee customers per city and compared estimated coffee consumers with actual buyers, identifying sales penetration and market reach.
Compared average sales per customer with estimated rent per customer across cities, offering insights into customer spending and market affordability.
Analyzed monthly sales growth and ranked cities based on sales, customer count, and market potential. Identified key cities for market expansion and resource allocation.
