Re: KPI
- From: Deepak Puri <deepak_puri@xxxxxxxxxxxxxxx>
- Date: Thu, 18 Jan 2007 08:29:40 -0800
"Do any of the presentation tools support this slice and
dice functionality?" - Excel 2007 would be one option:
http://blogs.msdn.com/excel/archive/2006/01/10/511487.aspx
...
In Excel 12, KPIs are listed in the field list in a special KPIs folder.
Here is an example of a KPI for Profit Margin.
Each KPI component can be added to the PivotTable Values area by
checking the checkbox just like any other field. Let?s take a look at
an example, specifically, and example of adding Value, Goal, Status, and
Trend to a report on our Products and Product Categories. Here is what
the report looks like when I add those four components.
As you can see, Value and Goal are presented as numbers. Status and
Trend, on the other hand, are nice graphical representations ? they can
be used to get a very quick visual overview of your business as it is
easy to pick out outliers etc. As I mentioned, Status and Trend are
normalized values between -1.0 and 1.0. Since these sorts of numerical
values are not very interesting to show in a report, we have worked with
the SQL Server Analysis Services 2005 team to develop a set of images to
represent the Status and Trend for any KPI. The images to be used are
defined in the Analysis Services model, so everyone that looks at the
Status or Trend in Excel sees the same graphic. Those of you that
remember the conditional formatting post I wrote on Icon Sets have
probably already figured out we are using that capability in Excel 12 as
part of this KPI feature.
Even better, since this is a PivotTable, as I expand/collapse items in
the PivotTable or perform other operations, the KPI components will
automatically be calculated in the new context. For example, if I
expand ?Touring Bikes?, the PivotTable will show the values of the KPI
components and update the Status and Trend graphics accordingly.
...
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.developersdex.com ***
.
- Prev by Date: Aggregation Design Wizard
- Next by Date: Excel pivot tables from Analysis Services - Question on deployment to end users
- Previous by thread: Aggregation Design Wizard
- Next by thread: Excel pivot tables from Analysis Services - Question on deployment to end users
- Index(es):
Relevant Pages
|
Loading
