Cafe Sales Analysis

Total Sales by Item (Excluding Invalid Dates)

Item total_sales
Salad 14890.00
Sandwich 11680.00
Smoothie 11608.00
Juice 9108.00
Cake 9009.00
Unknown 7231.50
Coffee 6210.00
Tea 4179.00
Cookie 2775.00

Average Spend by Payment Method

Payment Method avg_spend
Cash 9.06
Credit Card 8.98
Digital Wallet 8.94
Unknown 8.76

Monthly Sales Trend

month total_sales transaction_count
2023-01 6452.50 729
2023-02 6055.00 660
2023-03 6482.00 749
2023-04 6485.50 699
2023-05 6191.00 694
2023-06 6678.00 739
2023-07 6366.50 718
2023-08 6453.00 732
2023-09 6209.50 711
2023-10 6512.00 741
2023-11 6418.00 718
2023-12 6387.50 706

Top 3 Items by Location

Location Item total_sales sales_rank
In-Store Salad 4795.00 1
In-Store Sandwich 3884.00 2
In-Store Smoothie 3344.00 3
Takeaway Salad 4590.00 1
Takeaway Sandwich 3440.00 2
Takeaway Smoothie 3216.00 3

Percentage of Sales by Item per Location

Location Item item_sales sales_percentage
In-Store Salad 4795.00 20.47
In-Store Sandwich 3884.00 16.58
In-Store Smoothie 3344.00 14.27
In-Store Juice 2970.00 12.68
In-Store Cake 2559.00 10.92
In-Store Unknown 2110.50 9.01
In-Store Coffee 1670.00 7.13
In-Store Tea 1266.00 5.40
In-Store Cookie 830.00 3.54
Takeaway Salad 4590.00 20.14
Takeaway Sandwich 3440.00 15.10
Takeaway Smoothie 3216.00 14.11
Takeaway Cake 2661.00 11.68
Takeaway Juice 2484.00 10.90
Takeaway Unknown 2279.00 10.00
Takeaway Coffee 1878.00 8.24
Takeaway Tea 1290.00 5.66
Takeaway Cookie 949.00 4.16