+1 Other

Thread Started by #deenag.dasari

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,
2nd May 2007 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.
22nd October 2007 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
24th November 2007
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.
5th December 2007 From India , Madras
Hi Nag, I have attached a format of Dash board that i use for weekly review. I hope this helps..
13th February 2008

Attached Files
Membership is required for download. Create An Account First
File Type: xls dashboard_200.xls (27.5 KB, 1200 views)
File Type: xls dashboard_886.xls (27.5 KB, 697 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...
10th January 2009 From India , Mumbai
Reply (Add What You Know) Start New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses from top institutes like IIM / XLRI direct to device (online digital learning)

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™