Create:
PivotTable_Sales_Dashboard.xlsx
Source Dataset
|
Order ID |
Date |
Employee |
City |
Product |
Category |
Qty |
Sales |
|
O101 |
01-Sep-26 |
Amit |
Sirsa |
Laptop |
Electronics |
2 |
120000 |
|
O102 |
02-Sep-26 |
Neha |
Hisar |
Mouse |
Accessories |
10 |
5000 |
|
O103 |
03-Sep-26 |
Rahul |
Sirsa |
Laptop |
Electronics |
3 |
180000 |
|
O104 |
04-Sep-26 |
Priya |
Fatehabad |
Keyboard |
Accessories |
8 |
6400 |
|
O105 |
05-Sep-26 |
Amit |
Sirsa |
Monitor |
Electronics |
4 |
34000 |
|
O106 |
06-Sep-26 |
Simran |
Hisar |
Webcam |
Accessories |
4 |
10000 |
|
O107 |
07-Sep-26 |
Rahul |
Sirsa |
Mouse |
Accessories |
15 |
7500 |
|
O108 |
08-Sep-26 |
Priya |
Fatehabad |
Laptop |
Electronics |
1 |
60000 |
|
O109 |
09-Sep-26 |
Amit |
Hisar |
Monitor |
Electronics |
2 |
17000 |
|
O110 |
10-Sep-26 |
Neha |
Sirsa |
Keyboard |
Accessories |
6 |
4800 |
Dashboard Tasks
PivotTable 1 — Product Analysis
- Rows → Product
- Values → Sum of Sales
- Values → Sum of Qty
PivotTable 2 — City Analysis
- Rows → City
- Values → Sum of Sales
PivotTable 3 — Employee Analysis
- Rows → Employee
- Values → Sum of Sales
- Values → Count of Order ID
PivotTable 4 — Monthly Analysis
- Rows → Date
- Group → Months
- Values → Sum of Sales
Add Slicers
- City
- Product
- Category
- Employee
Add Timeline
- Date
Add PivotCharts
- Product Sales — Column Chart
- City Sales — Bar Chart
- Monthly Sales — Line Chart
Final Dashboard
Create a professional dashboard containing:
Total Sales | Total Orders | Total Quantity | Top Product
plus PivotCharts, Slicers and Timeline.