Coffee Sales Dashboard with Power BI: Daily Trends, Top Flavors, and Peak Hours Analysis
In the competitive coffee business, understanding sales trends is essential for improving marketing strategies, optimizing inventory, and maximizing profits. In this project, I built a Coffee Sales Dashboard in Power BI to help a coffee shop analyze its performance through interactive visuals and actionable insights. The dashboard answers key business questions: 📅 How do sales change by day ? 📈 What is the average daily sales for the year ? ☕ Which are the most popular coffee flavors ? 🕐 What is the busiest time of the day for sales? The dataset contains the following columns: Date – Date of the transaction Time – Time of the sale Product – Coffee flavor or type Quantity – Units sold Sales – Total revenue per transaction I imported the data into Power BI and performed initial cleaning using Power Query , including: Removing duplicates and nulls Converting Date and Time to proper formats Extracting Day , Month , and Hour from date/t...