Maven Roasters Coffee Shop Sales Dashboard

PROJECT INTRODUCTION

Maven Roasters, a coffee shop chain with three branches in New York City, aims to enhance its understanding of customer purchasing behavior and optimize operational efficiency. The objective is to analyze coffee shop data to identify trends, patterns, and provide actionable recommendations for improvement.

KEY INSIGHTS

· All three locations contribute equally on average to the total revenue, indicating a balanced performance across Lower Manhattan, Astoria, and Hell's Kitchen.

· Mondays, Thursdays, and Fridays emerge as the busiest days overall.

· Lower Manhattan experiences peak business on Mondays, aligning with the trend in Astoria. However, Hell's Kitchen has a unique pattern with Tuesdays and Fridays being its busiest days.

· Sales tend to peak during the hours of 7 am to 10 am, indicating a strong breakfast and morning rush.

· Notably, Hell's Kitchen sees a significant drop in sales after 7 pm, while Lower Manhattan experiences a decline after 6 pm.

· The top three products driving revenue are Brewed Chai Tea, Espresso, and Gourmet Brewed Coffee. Espresso stands out as the highest revenue generator.

· Coffee and tea emerge as the top-performing product categories while packaged chocolate ranks as the lowest-performing category suggesting potential areas for improvement or diversification.

RECOMMENDATION

· Allocate staff and resources on Mondays, Thursdays, and Fridays to manage the increased demand, particularly during peak hours of 7 am to 10 am. Since the peak sales hours are in the morning, we should consider optimizing marketing efforts and promotions during this time to maximize revenue.

· Considering the sales decline trends, we should evaluate the feasibility of adjusting closing times, especially for Hell's Kitchen and Lower Manhattan, to optimize resource utilization.

· Capitalize on the popularity of Brewed chai tea, Espresso, and Gourmet brewed coffee by implementing promotions or special offers to boost sales further. While packaged chocolate currently ranks lowest, we should explore ways to enhance the chocolate offerings to potentially increase sales in this category.

· We should also optimize our inventory management, ensuring that the most popular products are well-stocked during peak hours and days.