Microsoft® SQL Server® 2012 Bible

(Ben Green) #1

1292


Part IX: Business Intelligence


FIGURE 57-4
This is a good example of the cluster profi le viewer.

After you gain a better understanding of the clusters for a given model, it is often useful
to rename each cluster to something more descriptive than the default “Cluster n.” From
within either the Diagram or Profi les Viewer, right-click a cluster, and choose Rename
Cluster to give it a new name.

Sequence Clustering
As the name implies, the sequence clustering algorithm still gathers cases together into
clusters, but based on a sequence of events or items rather than on case attributes. For
example, you can use the sequence of web pages visited during user sessions to defi ne the
most common paths through that website.

The nature of this algorithm requires input data with a nested table, whereby the parent
row is the session or order (for example, shopping cart ID), and the nested table contains
the sequence of events during that session (for example, order line items). In addition, you
must mark the nested table’s key column as a Key Sequence content type in the mining
structure.

After the model is trained, the same four cluster viewers previously described are available
to describe the characteristics of each. In addition, the State Transition Viewer displays

c57.indd 1292c57.indd 1292 7/31/2012 10:35:03 AM7/31/2012 10:35:03 AM


http://www.it-ebooks.info
Free download pdf