+ Reply to Thread
Results 1 to 2 of 2

Non Numeric data representation in a dashboard

  1. #1
    Registered User
    Join Date
    06-14-2018
    Location
    Auckland, NZ
    MS-Off Ver
    2010, 2016
    Posts
    1

    Non Numeric data representation in a dashboard

    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!

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Non Numeric data representation in a dashboard



    To attach an Excel file to your post,
    • desensitize data
    • remeber that your example should reflect structure and type of data and contain the result what you want to achieve (manually created if necessary)
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply

    After that you should see attachment in your post

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need Help in plotting the data into graphical representation
    By abhradipchoudhuri in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-12-2017, 09:47 AM
  2. Graphical representation of multi-level data (pie of pie of pie)
    By dsynadinos in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-16-2014, 01:45 PM
  3. Changing data representation in excel (partial transpose)
    By c.vaibhav in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-08-2013, 03:00 AM
  4. split the excel worksheet in 2 equal parts
    By Pigggy in forum Excel General
    Replies: 1
    Last Post: 01-29-2012, 08:05 PM
  5. Representation of Survey Data
    By abhishek.therock in forum Excel General
    Replies: 1
    Last Post: 09-21-2010, 07:20 AM
  6. Trend Data Representation: which chart?
    By babarorhum in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-21-2008, 01:52 PM
  7. Scatter Graph Data representation
    By Songoku in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-16-2005, 09:56 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1