Microsoft® SQL Server® 2012 Bible

1287

Chapter 57: Data Mining with Analysis Services

57

FIGURE 57-2

Verifying accuracy with the accuracy chart tool.

The profi t chart extends the lift chart and aids in calculating the maximum return from

efforts such as marketing campaigns. Select the Profi t Chart from the Chart Type drop-

down, and press the Settings button to specify the number of prospects, the fi xed and

per-case cost, and the expected return from a successfully identifi ed case. The resulting

chart describes profi t versus Population percent included. This is useful in deciding how

much of the population to include in the effort either by maximizing profi t or by locating a

point of diminishing returns.

Classification Matrix

The simplest view of model accuracy is offered by the Classifi cation Matrix tab, which cre-

ates one table for each model, with predicted outcomes listed down the left side of the

table and actual values across the top, similar to the example shown in Table 57-1. This is

not available for continuous outcomes.

TABLE 57-1 Example Classifi cation Matrix

Predicted Red (Actual) Blue (Actual)

Red 95 21

Blue 37 104

c57.indd 1287c57.indd 1287 7/31/2012 10:35:02 AM7/31/2012 10:35:02 AM

http://www.it-ebooks.info