This project is an interactive sales dashboard built for 365 Coffee Cafe, a coffee shop chain with three locations across New York City. The main goal of this dashboard is to take over 100,000 raw transaction records and turn them into simple, clear visuals that show exactly how the business is performing.
Instead of looking at confusing rows of numbers, this dashboard lets anyone see what items are selling the most and what times of day are the busiest.
- Total Revenue: Shows the total money made by the shops ($698,812.33).
- Products Sold: Tracks the total number of items bought by customers (149,116 items).
- Coffees Served: Specifically highlights the total number of coffee drinks made (58,416 coffees).
A simple bar chart that breaks down sales across main categories:
- Bakery
- Coffee (The clear top seller)
- Drinking Chocolate
- Tea
A line chart that tracks revenue hour-by-hour from 7:00 AM to 5:00 PM (17:00). It shows a massive spike in sales early in the morning between 8:00 AM and 10:00 AM, which tells the business exactly when they need the most staff on the floor to handle the morning rush.
Includes a direct preview of the raw dataset table (showing transaction IDs, dates, and times) so you can see the clean structure behind the visual charts.