How Could I Create A Dashboard To Evaluate Processes

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
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.
Regards,
Soundar.
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.
Regards
Dr. Aju K Samuel
Consultant
24th November 2007

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
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

dashboard_200.xls (27.5 KB, 1181 views)

dashboard_886.xls (27.5 KB, 679 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.
10th January 2009 From India , Mumbai