O'Reilly logo

Mastering SQL Server 2014 Data Mining by Debarchan Sarkar, Amarpreet Singh Bassan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Microsoft Association algorithm

We all have been to a supermarket at some time or the other. One of the prime responsibilities of the manager of the supermarket is to sell the highest volume of products and to achieve this goal, knowledge of the purchasing patterns of the customers is required. When we know what or how our customers purchase certain products, we can suggest them products that they might be interested to buy and reorganize the store so that the items most frequently bought together are placed together. The algorithm that will help us in this endeavor is the Microsoft Association algorithm.

The input to the Microsoft Association algorithm is often in the form of a case table and a nested table. The case table consists of a unique ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required