This Power BI project presents a comprehensive sales dashboard that provides interactive insights through dynamic filtering and year-to-date (YTD) calculations. It is designed to help stakeholders make data-driven decisions by analyzing sales performance, customer trends, and budget comparisons.
- Implemented YTD Month,Category,State and Quantity/Amount types of slicers.
- Added a Dynamic Filter Button to toggle filters on/off across the dashboard seamlessly.
- Last Refresh Date is shown to ensure data freshness and reliability.
The dashboard provides insights through the following KPIs and visuals:
- ✅ YTD Sales segmented by year
- 📈 YTD Growth compared to previous year
- 💰 YTD Profit
- 📊 Budget of Current Year
- 🔁 Current Year Sales vs Budget
- 🗂 Sales by Category
- 👥 Customer Count by Category
- 🧩 Sales by Sub-Category
- 📦 Orders by YTD Month
- 📉 Current Year YTD Sales vs Previous Year Total Sales
- Power BI Desktop
- DAX (Data Analysis Expressions)
- Power Query
- Interactive Slicers & Buttons
Ideal for sales managers, analysts, and decision-makers looking for real-time insights into sales performance across months, categories, and customer segments, with a focus on tracking against budget and year-on-year growth.