Coffee Shop Sales Performance Analysis

Case Presentation:

This project is a comprehensive endeavor focused on enhancing our understanding of the coffee shop's sales dynamics across its three locations during the first semester of 2023.

The primary objectives include profiling and preparing raw data, exploring insights through Excel Pivot Tables, and constructing a dynamic dashboard. These steps are integral to gaining meaningful insights and fostering a deeper comprehension of the underlying trends and patterns within the business.

Sales Analysis Findings

• Consistent increase in sales throughout the semester across all locations.
• Peak days vary by location: Mondays, Thursdays, and Fridays in Astoria and Lower Manhattan; Tuesdays, Fridays, and Sundays in Hell's Kitchen.
• Decrease in sales on Saturdays.
• Peak hours between 7 and 10 in the morning.
• Low sales between 7 and 8 in the evening in Hell's Kitchen and Lower Manhattan.
• Primary product categories: Coffee, Tea, and Bakery.

Strategic Recommendations

• Inventory Optimization:

Adjust inventory based on sales trends.

• Promotions and Discounts:

Implement promotions on low-sales days, such as Saturdays.

• Staffing Schedule Adjustment:

Align staff with sales patterns, especially during peak hours.

• Focus on Star Products:

Improve quality and promote products in the primary categories.

• Customer Experience Enhancement:

Streamline service during peak hours.

Implement pre-ordering systems.

• Location Profitability Analysis:

Evaluate the profitability of each location and make adjustments as necessary.

Conclusions:

The effective implementation of these recommendations should optimize costs, improve profitability, and provide an enhanced experience for customers. Flexibility and continuous adaptation are essential for sustainable success.