Chapter 6Prediction Queries with Association and Sequence Clustering

This chapter contains yet more Prediction queries. The DMX queries this time are written against mining models based on two algorithms, Association and Sequence Clustering. Both algorithms appear in the same chapter as they share a lot of common characteristics. Although every mining algorithm has lots of uses, these two algorithms are typically used in market basket analysis. Market basket analysis is the focus of this chapter; there are quite a few Prediction queries devoted to identifying cross-selling opportunities. However, it’s important to realize they can be used in other applications—for example, Sequence Clustering can be used to analyze click-stream data on web ...

Get Practical DMX Queries for Microsoft SQL Server Analysis Services 2008 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.