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
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
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
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
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
2
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
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
Create The Why.ppt
Production processes.doc
