Databases Reference
In-Depth Information
Figure 9-25
KPI Creation
Consider the following scenario: The Adventure Works sales management
team wants to monitor the sales revenue for the new fiscal year. Sales reven-
ue for prior fiscal years is available in the Adventure Works cube. The man-
agement team has identified the goal of 15% growth for sales revenue year
over year. If current sales revenue is over 95% of the goal, sales revenue per-
formance is satisfactory. If, however, the sales revenue is within 85% to 95%
of the goal, management must be alerted. If the sales revenue drops under
85% of the goal, management must take immediate action to change the
trend. These alerts and calls to action are commonly associated with the use
of KPIs. The management team is interested in the trends associated with
sales revenue; if the sales revenue is 20% higher than expected, the sales
revenue status is great news and should be surfaced as well — it's not all
doom and gloom.
Use the following steps to design the KPIs for the sales management team:
1. Open the Adventure Works DW sample project located at
C:\Program Files\Microsoft SQL Serv-
er\90\Tools\Samples\AdventureWorks Analysis Services Pro-
ject\Enterprise.
2. Double-click the Adventure Works cube in Solution Explorer to open
the Cube Designer.
Search WWH ::
Custom Search