Solved

Performance dashboard/Metric setup

Posted on 2014-09-27
3
93 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Originally published Entrepreneur.com Booming numbers of freelancing professionals are changing the face of work. In the United States alone last year, the number of workers freelancing grew from 700,000 to 54 million, according to a Freelancers’…
EE introduced a new rating method known as Level, which displays in your avatar as LVL. The new Level is a numeric ranking that is based on your Points. This article discusses the rationale behind the new method and provides the mathematical formula…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now