This project is a Power BI dashboard analyzing café sales data for a fictional café called Caffeine Collective. It highlights key business metrics such as total sales, transaction patterns, top-selling drinks, and payment method trends. The dashboard was designed with a café-owner and their employees in mind, focusing on clarity, storytelling, and interactivity.
-
Track overall sales performance (daily, weekly, monthly).
-
Identify the most popular drinks and purchasing trends.
-
Compare payment behaviour (cash vs card payment).
-
Provide café owner and café employees with an interactive tool to filter sales by drink type, date, and payment method.
-
KPI cards such as Total Sales, Transactions, Average Sale Value, and Top-Selling Drink.
-
Slicers (Dropdown Filters) where user can filter by Drink Type, Payment Type, and Day of Week.
-
Bar chart which visualizes sales by drink type.
-
Donut chart which displays payment type distribution (cash vs card).
-
Line chart detailing transaction trends over time.
-
Power BI Desktop (report building & visualization)
-
Kaggle Dataset: Cafe Sales Data by Ayesha Imran
-
Cafe_Sales_Dashboard.pbix → Power BI file
-
coffee_sales.csv → Dataset (sourced from Kaggle, credit: Ayesha Imran)
-
Dashboard screenshots (preview of the report)
-
The café’s top seller was consistently the Americano w/ Milk.
-
Card payments dominated transactions compared to cash.
-
Weekday vs weekend trends revealed higher sales during weekday mornings.
Dataset by Ayesha Imran on Kaggle .
Built and designed in Power BI.