Lesson 3: Building a Market Basket Scenario (Intermediate Data Mining Tutorial)
Applies To: SQL Server 2016 Preview
The marketing department of Adventure Works Cycles wants to improve the company Web site to promote cross-selling. As part of the site update, they would like the ability to predict products that a customer might want to purchase, based on the other products that are already in the customer's online shopping basket. The marketing department also wants to understand customer purchasing behavior better, so that they can design the Web site so that the items that tend to be purchased together appear together. They have learned that data mining is especially useful for this kind of market basket analysis and have asked you to develop a data mining model.
After you complete the tasks in this lesson, you will have a mining model that shows groups of items from historical customer transactions. Additionally, you can use the mining model to predict additional items that a customer may want to purchase.
To complete the tasks in this lesson, you will use the solution and data source that you created in the first lesson of the Intermediate Data Mining Tutorial (Analysis Services - Data Mining). You will modify this solution by adding a data source view that contains tables about the customer, including a nested table of customer purchases. You will then build a mining model that uses the Microsoft Association Rules algorithm, which is suited to market basket scenarios.
This lesson contains the following topics: