Figure 5-39 shows the dashboard at its default, with the Product
Category filter set to All Products. Notice that the AdvWorks-Objectives scorecard
shows an overall score of 60.8% with a very low Internet Gross Profit Margin. Also
note that the Quantity Sold report shows that the quantity of all products sold in the
third quarter of 2003 was nearly 50,000.
Assume that an end user now drops down the Product Category and chooses just
the Clothing category. Figure 5-40 shows the changes. First, the overall score of
the Objectives Demo scorecard is now 72.7%, thanks to a much higher margin on
Reseller Gross Profit Margins. Notice too that the Quantity Sold report now shows
that quantity of products sold in the third quarter of 2003 was now around 14,000.
This is because only 14,000 items of clothing were sold, as compared to 50,000 units
of all items combined.
Figure 5-39 The dashboard shows a scorecard and a report, both reporting on the totals
for all products, the default value for the filter.
136 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
Summary
The monitoring capabilities of PerformancePoint Server are rich and full-featured.
A single tool, the Dashboard Designer, allows developers to create KPIs, scorecards,
reports, indicators, filters, and dashboards. KPIs can contain an actual value and
one or more target values. Aggregations can be added that include trends, averages,
and more.
Pages:
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196