Coffe shop Sales

Project Using Excel & Power BI About Coffe Shop Sales

1️⃣ Report Overview

This report was developed using Power BI to analyze the sales performance of a coffee shop during May 2023. It provides a comprehensive view of overall performance, order trends, best-selling products, and peak sales periods to support data-driven decision-making.

2️⃣ Key Report Components

Total Sales

Total sales reached $156.73K in May.

A 31.8% decrease compared to the previous month, indicating a need to analyze the reasons behind the decline (such as demand fluctuations, competition, or promotional changes).

Total Orders

A total of 33,527 orders were processed during the period, reflecting a 32.3% decline from the previous month.

The trend line shows a steady drop in orders, highlighting the need for strategies to boost sales.

Total Quantity Sold

A total of 48,233 units were sold, marking a 32.3% decrease from the prior month.

This could be due to a drop in customer demand or a decline in product popularity.

3️⃣ Sales Trends Analysis

Daily Sales Trend

The average daily sales stand at 5,055 units.

Sales fluctuate between 4.7K – 5.7K on most days, with some decline towards the end of the week.

Sales by Weekday vs. Weekend

Weekday Sales: 116.63K

Weekend Sales: 40.10K

Data indicates that sales are significantly higher on weekdays than on weekends.

Sales by Hours

Peak sales occur between 10:00 AM – 12:00 PM, suggesting that most customers prefer morning purchases.

A noticeable decline in sales occurs after 6:00 PM.

4️⃣ Product and Location Analysis

Sales by Product Category

Coffee: 60K

Tea: 45K

Bakery: 19K

Other Beverages: 16K

Coffee Beans: 9K

Top 10 Best-Selling Products

Barista Espresso: 20K

Brewed Coffee: 17K

Hot Chocolate: 16K

Gourmet Coffee: 16K

Premium Tea: 9K

Organic Coffee: 8K

Scone (Bakery): 8K

Drip Coffee: 7K

Sales by Store Location

Hell’s Kitchen Branch: 53K

Astoria Branch: 52K

Lower Manhattan Branch: 52K

Sales performance is fairly consistent across locations, with Hell’s Kitchen slightly leading.

5️⃣ Recommendations and Improvements

Strategies to Boost Or Increase Sales:

️ Identify reasons behind the sales decline – Is it due to competition, price changes, or seasonal demand?

️ Increase promotions during weekends to boost sales.

️ Capitalize on peak morning hours by offering special discounts from 10:00 AM – 12:00 PM.

️ Expand top-performing product offerings such as specialty coffee and hot chocolate to attract more customers.

️ Enhance inventory management to ensure high-demand products are always available and minimize underperforming stock