Solved

Performance dashboard/Metric setup

Posted on 2014-09-27
3
95 Views
Last Modified: 2014-10-03
I am working on creating a performance dashboard and need some help with metric configuration.  I want to have the information drill-down the from institution to the metric level.  

I want to show performance based on:
- metrics %
- provider/metrics %
- department/metrics %
- institution/metrics %

Ie:
company
-department
--provider
--metric

Note:
- there are 18 (--metric) that role up to each provider as (%)
- 8 departments
- with ~ 50 providers

Application I am looking to use; excel, crystal dashboards , tableau.
0
Comment
Question by:Eric Love
  • 2
3 Comments
 
LVL 23

Accepted Solution

by:
Danny Child earned 500 total points
ID: 40348631
sounds like you're focusing on how to achieve the drill-down, is that right?

... and that sounds like a lot of data...
- there are 18 (--metric) that role up to each provider as (%)
- 8 departments
- with ~ 50 providers


You may want to also look at this from a different angle:
http://staceybarr.com/measure-up/21-measuring-for-collaboration-not-competition/
http://staceybarr.com/questions/howtogetstarted/

My perspective on this would be to start small, with a known-troublesome area, and allow the metrics to define the issue, and then to show improvements after fixes were applied.  Hopefully, that would allow the management to give further resources to the remedies, and for the staff to see that their jobs got easier and more satisfying.  

I think your top-down approach may have trouble gaining traction unless it's already very embedded as a practice.
0
 

Author Comment

by:Eric Love
ID: 40349178
DanCH99,

Thanks for your response. I think your correct about starting small and there is a lot of data to be considered.  This type of tracking is something new.  Would you have any insight on method to summarize the %'s across the groups or convert to somthing else?

Thanks.
0
 
LVL 23

Expert Comment

by:Danny Child
ID: 40359306
I'd start with Stacey's site above, and go from there.  
The biggest hurdle to cross is in people's heads - the key message to convey is that this is a) to help them get rid of the annoyances in their working lives, and b) to let them demonstrate that they're doing a good job (or at least getting better when dealing with tough jobs!).

There's a natural tendency to want a whizzy dashboard with overviews of everything, but I think it misses the point, especially in the early days.  

Let the metrics define the problem.  Let the users come up with solutions, and let the resulting metrics after that show the improvements.  But get as FEW as possible.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing is at the top of most security top 10 efforts you should be pursuing in 2016 and beyond. If you don't have phishing incorporated into your Security Awareness Program yet, now is the time. Phishers, and the scams they use, are only going to …
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question