☕ Coffee Sales Dashboard – Power BI Project

This Power BI project provides an interactive dashboard for analyzing coffee sales data. It allows stakeholders to gain insights into sales performance across various product types, sizes, time periods, and store locations.

📸 Dashboard Preview

---

📊 Key Features

• 📈 Total Sales & Transaction Count Overview
• 🍵 Sales by Product Category & Detail
• 🧊 Sales Volume by Size (Small, Regular, Large, etc.)
• 📅 Time-based Trends: Day of Week, Month Name
• 🌍 Store-wise Analysis (Location & ID)

Tools Used

• Power BI
• DAX (Data Analysis Expressions)
• Excel / CSV (if applicable for data source)

🧠 DAX Measures Used

Total Quantity Sold = SUM(Transactions[transaction_qty])

Average Items per Transaction = 
    [Total Quantity Sold] / [Count of Transactions]

💡 Key Insights

• Coffee is the top-performing product category.
• June recorded the highest monthly sales.
• Regular-sized drinks made up the largest share of quantity sold.
• Most transactions occurred on Fridays and weekends.

🙋‍♀️ About Me

I'm an aspiring data analyst skilled in Power BI, Excel, and SQL. This project demonstrates my ability to build interactive dashboards and extract actionable insights from raw data.

🔗 Connect with me on LinkedIn (https://www.linkedin.com/in/esha-ambekar-4b4313246/)