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 my website at
I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-analysts/?couponCode=ANALYTICS50%25OFF