Coffee Shop Sales Performance Analysis
As a Data Analyst, I conducted a comprehensive analysis of the coffee shop’s sales data to evaluate key performance indicators (KPIs) and identify areas for business growth.
Overview:
Total Customers: 10,000
Total Sales: $141,380
Total Costs: $34,000
Total Quantity Sold: 30,000
Sales Performance by Category:
Sales were analyzed across different product categories (e.g., coffee, desserts, snacks, and beverages) to identify the best-performing sections and understand their contribution to overall revenue.
Sales Distribution by Gender:
Sales data was segmented by customer gender to reveal purchasing trends and preferences between male and female customers.
Regional Sales Concentration:
Analyzed geographic data to determine which locations generated the highest sales and where customer demand was most concentrated.
Top 5 Best-Selling Products:
Identified the five most popular items based on sales volume and revenue to optimize inventory management and marketing focus.
Top Customers Analysis:
Determined the most frequent and high-spending customers to design targeted promotions, loyalty programs, and personalized discounts to increase customer retention.