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

Source: Internet
Author: User

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

Environment configuration issues can be found in:

Sample dmaddins_sampledata.xlsx


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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.