Microsoft® SQL Server® 2012 Bible

(Ben Green) #1

1295


Chapter 57: Data Mining with Analysis Services


57


the parent row is the transaction (for example, Order) and the nested table contains the
individual items. Three viewers provide insight into a trained model:

■ (^) Itemsets: Displays the list of itemsets discovered in the training data with the
number of items in the set and number of training cases in which this set appears.
Several controls for fi ltering the list are provided, including the Filter Itemset text
box, which searches for any string entered and displays only itemsets that include
that string.
■ Rules: Similar in layout and controls to Itemsets but lists rules instead of itemsets.
Each rule has the form A, B ≥ C, meaning that cases that contain A and B are likely
to contain C; for example people who bought pasta and sauce also bought cheese.
Each rule is listed with its probability and importance (usefulness in performing
predictions).
■ (^) Dependency Network: Similar to the Dependency Network used for other algo-
rithms, with nodes representing items in the market basket analysis. Nodes have
a tendency to predict each other (displayed with dual-headed arrows). The slider
hides the less probable (not the less important) associations. Selecting a node high-
lights related nodes.
FIGURE 57-6
Naive Bayes dependency viewer is shown here.
c57.indd 1295c57.indd 1295 7/31/2012 10:35:03 AM7/31/2012 10:35:03 AM
http://www.it-ebooks.info

Free download pdf