Hi Excel'ers
I have been asked to create a KPI dashboard and have immediately hit a road block.
Context: I work in a contact center, my TL would like a dashboard that presents the following information:
Five areas of monitoring (Underwriting, Phone communication, written communication etc.)
Within the five areas there are eight categories that will have a YES, NO or N/A answer. For example for the written communication area:
1. Has the consultant used the clients name: Yes, no or N/a
2. Has the consultant used correct spelling: Yes, no or N/a
etc.
Data
I will have a data worksheet that will display a score card. My TL will enter a 1 for Yes or 0 for No (if this is the best way)
Issues
My question to you, is how do I represent non numeric data on a dashboard? Would I assign an value for Yes and 0 for No and then total the values up and use these in the formulas? E.g. 5 Yes's and 3 No's means a total of 5 points out of potential 8. Is there another way that is better?
Also, she would like to have some sort of SWOT analysis built into the DB, is this even possible based on the data?
Are there any other issues you can see?
Thanks in advance!
Bookmarks