Analytics in Action

Creating Association Rules using the SQL Server Data Mining Addin for Excel

Association Rules are a quick and simple technique to identify groupings of products that are often sold together. This makes them useful for identifying products that could be grouped together in cross-sell campaigns.  Association rules are also known as Market Basket Analysis, as they used to analyse a virtual shopping baskets.

In this tutorial I will demonstrate how to create association rules with the Excel data mining addin that allows you to leverage the predictive modelling algorithms within SQL Server Analysis Services.

Sample files that allow you follow along with the tutorial are available from the link below.

Download file for Association Rules tutorial