Data Analytics: Exploiting the Data Warehouse - Data Warehouse Systems: Design and Implementation - page 356

The query returns the following table:

Product Name $SUPPORT $PROBABILITY $ADJUSTEDPROBABILITY

Pavlova 242 0.1818 0.6445

Gnocchi di nonna Alice 352 0.0804 0.0772

Raclette Courdavault 319 0.0728 0.0702

The adjusted probability is used by Analysis Services to “penalize” popular
items during a prediction task. For example, given two items such that their
predicted probability is the same and such that one of them is much popular
than the other one (i.e., much more people buys the first one), we would like
to recommend the less popular one. In this case, the $AdjustedProbability lifts
the predicted probability. This is the case of product Pavlova in the example
above, whose probability is strongly lifted.

9.2 Key Performance Indicators

Traditionally, managers use reporting tools to display statistics in order to
monitor the performance of an organization. These reports, for example,
display the monthly sales by employee for the current year, the sales amount
by month also during the current year, the top ten orders or the top ten
employees (according to the sales figures achieved), and so on. However, note
that these reports lack a lot of crucial information. For example, how are sales
performing against expected figures? What are the sale goals for employees?
What is the sales trend? To obtain this information, business users must
define a collection of indicators and display them timely in order to alert
when things are getting out of the expected path. For example, they can
devise a sales indicator that shows the sales over the current analysis period
(e.g., quarter) and how these sales figures compare against an expected value
or company goal. Indicators of this kind are called key performance indicators
(KPIs).
KPIs are complex measurements used to estimate the effectiveness of an
organization in carrying out their activities and to monitor the performance
of their processes and business strategies. KPIs are traditionally defined with
respect to a business strategy and business objectives, delivering a global
overview of the company status. They are usually included in dashboards
and reports (which will be discussed below), providing a detailed view of
each specific area of the organization. Thus, business users can assess and
manage organizational performance using KPIs. To support decision making,
KPIs typically have a current value which is compared against a target
value, a threshold value, and a minimum value. All these values are usually
normalized, to facilitate interpretation.