More importantly, weights were put in the different expenses and an overall score
per facility was established. This score was then used to rank the facilities from top
to bottom. A scorecard at Medical Non-Profit headquarters showed all the facilities
18 B u s i n e s s I n t e l l i g e n c e w i t h M i c r o s o f t O f f i c e P e r f o r m a n c e P o i n t S e r v e r 2 0 0 7
ranked in order, and a + sign next to each one could be clicked to display the detailed
expense items for each facility. At each facility, the director could see the overall
scores for each facility but only expand his or her facility to see the details. This
way, a facility director would know where his or her facility stood in relation to
others, and could call those doing well to determine what they were doing right and
the best practices that might be implemented at his or her facility.
The scorecard used at the time of this project was the first version of the
Microsoft Business Scorecard Manager. This product continues to be enhanced and
is in its third generation in PerformancePoint Server. The back end was an Analysis
Services 2000 cube built from data from the Navision accounting application among
other sources.
Where??™s the Time Going?
One organization??”which will be referred to as Where??™s My Time, Dude???”needed
to better analyze the hours being worked and the pay for those hours. This company
felt they were getting hit with too much overtime and but were faced with staffing
challenges at very inopportune times.
Pages:
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51