Data mining using Excel (8)----Shopping basket analysis

After you configure your environment, you can use Excel for data mining.

Environment configuration issues can be found in:

http://blog.csdn.net/xinxing__8185/article/details/46445435

Sample dmaddins_sampledata.xlsx

Files:http://download.csdn.net/detail/xinxing__8185/8780481

In the Data table, select Table Analysis Tools Sample , which is the user's information statistics, including marital status, gender, income, children, education level, occupation, whether there is a house, number of cars, living area, age, whether purchased bicycles, etc.

Click on the data in the table and the tab will be one more

The shopping basket analysis tool simplifies the cross-selling analysis process. You can apply the tool to a table that contains transactions. The tool identifies the group of items that should appear at the same time and identifies the rules that can be used in the recommendation. If the table contains a value column that is associated with each item in each transaction, the tool can also calculate the promotion for each group and for each rule. Elevation is a measure that represents the increase in the value of the corresponding item or group in the context of the pattern that the tool identifies.

Select Table Associate

Click Shopping basket Analysis

Will generate two reports

One is a shopping basket bundle selling goods

One is the shopping basket recommendation

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Data mining using Excel (8)----Shopping basket analysis