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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.