Exercise 1: Department-wise Sales Achievement
Requirement
Create a report showing total Sales Target and Sales Achieved for each Department.
Exercise 2: Employee Performance Report
Requirement
Show total Sales Achieved by each Employee.
Exercise 3: Attendance Summary
Requirement
Count how many employees are Present and Absent.
Exercise 4: Department-wise Productivity
Requirement
Find average Productivity for each Department.
Exercise 5: Task Analysis
Requirement
Find total Tasks Assigned and Tasks Completed by Department.
Exercise 6: Monthly Work Hours Report
Requirement
Find total Work Hours worked by employees.
Exercise 7: Late Minutes Analysis
Requirement
Find which employee has the highest Late Minutes.
Exercise 8: Product Sales Report
Requirement
Show total Products Sold by each Employee.
Exercise 9: Customer Handling Report
Requirement
Find total Customers Handled by each Department.
Exercise 10: Complete Employee Dashboard
Requirement
Create a complete performance dashboard.
Pivot Layout
| Area | Field |
|---|---|
| Rows | Employee Name |
| Filters | Department |
| Values | Sum of Sales_Achieved |
| Values | Sum of Products_Sold |
| Values | Average of Productivity |
| Values | Sum of Work_Hours |
Add
- Slicer for Department
- Slicer for Attendance
- Pivot Chart (Column Chart)
