Objective

Create an interactive management-level sales dashboard.

KPIs

• Total Sales
• Total Orders
• Total Quantity
• Average Order Value
• Top Product
• Top Salesperson

Charts

1. Monthly Sales Trend
2. Region-wise Sales
3. Product-wise Sales
4. Salesperson Performance
5. Category-wise Sales

Interactive Features

• Slicers
• PivotCharts
• Timeline
• Dynamic Titles
• Conditional Formatting

Example Dynamic Title

=”Sales Dashboard – “&B2

Final Layout

┌─────────────────────────────────────────────┐

│              SALES DASHBOARD                │

├─────────┬─────────┬─────────┬──────────────┤

│ Sales   │ Orders  │ Qty     │ Avg Order    │

├─────────┴─────────┴─────────┴──────────────┤

│                SLICERS                      │

├──────────────────────┬──────────────────────┤

│ Monthly Sales Trend  │ Region-wise Sales    │

├──────────────────────┼──────────────────────┤

│ Product Analysis     │ Employee Performance │

└──────────────────────┴──────────────────────┘