Coffee Sales Dashboard

From the provided screenshots of the Coffee Shop Sales Dashboard, here are some basic insights based on the visualizations and metrics:

1. Total Sales and Growth:

• Total Sales for June is $184,299, which represents a 5.69% increase compared to the previous month.
• This indicates consistent growth in sales performance, suggesting that the business is doing well in June.

2. Sales by Product Category:

• Coffee is the top-performing category with $65K in sales, representing a 6.13% increase from the previous month.
• Other significant categories include Tea ($46K) and Bakery ($29K), showing positive growth rates of 1.39% and 3.06%, respectively.
• Branded products show the highest growth in percentage, with a 32.81% increase, but relatively lower sales compared to top categories.

3. Sales by Month:

• There is a steady increase in sales from January through June.
• Notable months include May and June, where sales saw significant improvements. April was a weak month, with a 24.5% decline, but it rebounded strongly in May with 77.73% growth.

4. Top and Bottom Products:

• The Top 5 Products by sales include items like Cappuccino Lg and Sustainably Grown Organic Lg, with the highest percentage change being Cappuccino Lg at +80.57%.
• In contrast, the Bottom 5 Products include lower-selling items such as Serenity Green Tea and Dark Chocolate, although some of them still show positive growth percentages, indicating an opportunity for promotion or strategic focus.

5. Peak Sales Time:

• The heatmap for peak sales times shows morning hours (8 AM - 12 PM) as the most active sales times, with higher activity spread across the weekdays, especially Monday through Friday.
• Sundays show relatively lower activity in comparison to weekdays.

6. Store Performance:

• In the Sales by Store section, Astoria leads in both sales (34.02% of total) and quantity sold (34.02%).
• The other two stores, Hell’s Kitchen and Lower Manhattan, have almost equal performance, but there may be opportunities to increase sales through targeted promotions or improvements.

7. Product Category Performance:

• The Sales by Product Category chart shows that Coffee and Tea are the leading categories, with Coffee beans and Branded products showing strong growth despite lower sales figures.
• Packaged Chocolate has the lowest total sales but still shows a 3.93% increase from the previous month.

8. Sales by Day:

• Sales during June show a consistent upward trend, with higher sales towards the middle and end of the month.
• The Average Daily Sales for June is around $6,143, with no major fluctuations, suggesting stable performance throughout the month.

Insights and Opportunities:

• Strong Growth in Branded and Specialty Products: Despite lower sales figures, categories like Branded and Coffee beans are experiencing significant growth, indicating a rising demand for these products. These should be further promoted or expanded.
• Sales Recovery in May and June: The business faced a slump in April, but sales recovered strongly in May and June. It might be worth investigating the reasons for the April slump to prevent future declines.
• Peak Sales in Morning Hours: The 8 AM - 12 PM slot is clearly the busiest time for sales, which suggests an opportunity for morning promotions or targeting customers with breakfast or morning coffee offers.
• Product Focus: The top-selling products are dominated by coffee-related items. Continuing to innovate or offer promotions around coffee could boost sales further, as it remains the core category.