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,

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.

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.
Dr. Aju K Samuel

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.

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 (Download Requires Membership)
File Type: xls dashboard_200.xls (27.5 KB, 1355 views)
File Type: xls dashboard_886.xls (27.5 KB, 842 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...

From India , Mumbai

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply →

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 Cite.Co™

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server