Vjcoolguy
Student
Deenag.dasari
Consultant
Harish_3012
Employed
Ajuksam
Consultant
+1 Other

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
Hi all,
I am doing my internship. As part of it, I have to evaluate the business processes of my department and have to create an operations dashboard.
As of now, I have finalised on the KPI's I would be using and how to measure them.
Now I want to know how to create the dashboard. Are there any tools available for this.
Any help/advice on this matter would be appreciated.
Thank you,
Nag

From India , Mumbai
Hi Nag,
Since you have already defined the KPI. It is just that you have set a point scale like for eg. agents who achieved 100% production on a average will be highlighted by green bars with a score of between 4-5 (assuming 5 as the maximum score) and if he / she is not good on quality - derive a point scale of 5 on quality.
Dashboard would be the average of all KPI - Production, Quality, Attendance, Domain expertise. All you need to do is put a bar graph and side by side put a point scale. Classify these graphs for different levels - Agent level Metrics, Team Leader Metrics, Supervisor Metrics and then Manager Metrics. This is what Operational Dashboard is all about.
Hope this will give you some clarity to come up with Dashboard.
Regards,
Soundar.

From India , Raipur
Hi Nag,
There are many ways you can create a dashboard. One of the easier tools to use would be an Excel sheet, however it comes with its own challenges and you have to be very careful with data. Excel can also be a bit cumbersome and the formulae used has to be verified before finalising the whole thing.
Regards
Dr. Aju K Samuel
Consultant


Hello,
As fellow member Nag said, the bar diagram with relevant benchmarks could be derived/designed in an excel with a simple VB script or using MS Graphs. The same could be hyperlinked to your KPI report/document.
Harish

From India , Madras
Hi Nag, I have attached a format of Dash board that i use for weekly review. I hope this helps..


Attached Files
File Type: xls dashboard_200.xls (27.5 KB, 1286 views)
File Type: xls dashboard_886.xls (27.5 KB, 776 views)

Hi ,
I think the kpi 's which you have made are of SMART in nature..they should be measureable ...you should have drilled down to bare minimum..based on this attribute create a scale of 10.. and use three colours red ,green and amber to demonstrate some which is ok with green ,critical red,and can be acheived with amber...
i am just giving you basic ,you can buid on this...
regards,
kris.

From India , Mumbai
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™