📊 Sales Dashboard | 2023

A dynamic and interactive Sales Dashboard built to analyze business performance across multiple dimensions. This dashboard provides comparative insights between the Current Year (CY) and Previous Year (PY), with the flexibility to select any year as the baseline.

🔗 Live Dashboard: View on Tableau Public

---

🚀 Features

1. Comparative Analysis

   • Automatically calculates PY metrics based on the selected CY.
   • Tracks growth percentages for Sales, Profit, and Quantity.

2. Filters for Deep Dive

   • Category
   • Sub-Category
   • Region
   • State
   • City

3. Navigation

   • One-click button to switch to the Customer Dashboard for customer-level insights.

---

📈 Key Metrics

1. Total Sales: ₹733K ▲20.36% vs PY
2. Min and Max values are calculated and visually highlighted in the line chart.
3. Total Profit: ₹286K ▲14.24% vs PY
4. Min and Max values are calculated and visually highlighted in the line chart.
5. Total Quantity: 37,873 ▲26.83% vs PY
6. Min and Max values are calculated and visually highlighted in the line chart.

---

🔑 Key Insights

1. Strong Growth: Sales, profit, and quantity all show double-digit growth compared to the previous year.
2. Category Performance: High contribution from Copiers, Chairs, and Phones in both sales and profit.
3. Some categories like Tables and Bookcases show weaker profitability despite sales volume.
4. Regional Trends: Filters allow identification of top-performing regions and states, helping spot geographic opportunities.
5. Weekly Fluctuations: Average weekly sales hover around ₹14K, with peaks highlighted in the chart.
6. Weekly profit averages ₹2K, with min/max points clearly marked.

---

🛠️ Tech Stack

1. Data Source: Business transaction dataset (structured by order date, category, region, etc.)
2. Visualization Tool: Power BI / Tableau
3. Interactivity: Filters, slicers, and navigation buttons for seamless exploration
4. Design Elements: Line charts with min/max markers, bar charts for category comparisons, and weekly trend analysis

---

📌 Use Cases

1. Performance Tracking: Monitor year-over-year growth in sales, profit, and quantity.
2. Category Analysis: Identify top-performing and underperforming sub-categories.
3. Regional Insights: Compare performance across regions, states, and cities.
4. Trend Monitoring: Spot seasonal or weekly fluctuations in demand and profitability.
5. Customer Analysis: Drill down into customer-level dashboards for detailed buying behavior.
6. Decision Support: Provide actionable insights for sales strategy, inventory planning, and marketing focus.