ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Tables
2
 'Assigned Tasks' Table has a list of assigned tasks to all task owners.
3
 'Dispositions Master' table has the meaning of all dispositions
4
 'Task Master' Table has the meaning of all tasks
5
6
7
Context
8
A Task owner is assigned a lot of tasks for any action date.
He/She has to call a customer (related to order ID), & perform a task within deadline.
He/she then marks one of the available dispositions in the dropdown & closes the task.
9
10
Question
11
Create an Excel dashboard for the head of Task owner. The head wants an overall picture of how well are assigned tasks performed.
There should be 5-10 graphs/metrics in the dashboard.

You can include the following in the dashboard:
Numbers
Tables
Graphs

Sample dashboard shown on the right.
12
13
Submission
14
Create a copy of this sheet, play around & create your dashboard.
15
On LinkedIn -- Share screeenshot of the dashboard as an image & attach the google sheets link.
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100