Market basket analysis / Clustering using excel


What's the goal of this project ?

i have raw transactions data from an ecommerce website and i want to identify patterns.

I will use this information in order to create 3 or 5 packs of products which will match customer needs avoiding them to pick each product manually.

Please see the xls file attached for a sample of the dataset.

If you're thinking about applying for this job please send me your summary and references of similar jobs accomplished in the past.

Let me know which approach you plan to use for this analysis and which results will you provide.

The final work should be delivered as an excel file

Skills: Data Mining, Excel, Machine Learning, Matlab and Mathematica, Statistics

See more: market basket analysis excel, market basket analysis using excel, basket analysis excel, market basket analysis dataset, dataset market basket analysis, market basket analysis clustering, market basket excel, market basket analysis xls, excel market basket analysis, clustering market basket analysis, clustering using excel, market basket dataset xls, market basket analysis project, market basket analysis using clustering, clustering excel, market basket analysis dataset xls, market basket dataset excel, excel basket, market analysis xls, clustering analysis excel, market basket analysis sample excel, xls market basket analysis, market basket dataset excel file, data use market basket analysis, market basket using excel

About the Employer:
( 18 reviews ) claix, Switzerland

Project ID: #1157524

Awarded to:


Bonjour, je peux vous aider sur ce projet, voyez s'il vous plaît mon message privé.

$120 USD in 5 days
(3 Reviews)

6 freelancers are bidding on average $129 for this job


Hello, Excel VBA expert here. Please check PM for details. Thanks!

$200 USD in 7 days
(57 Reviews)

Check PM Pls

$80 USD in 1 day
(1 Review)

I will provide a detailed report showing what percent of the orders that include certain products. For example, the report would look like: 30% of orders include at least following products (1, 2, 3). 35% of orders More

$150 USD in 2 days
(0 Reviews)

I intend to write a macro that would test all 56 possible 3-sets and all 56 possible 5-sets. After getting percentages, I would sort each combination for 3-sets and 5-sets in order of most commonly bought to least com More

$100 USD in 5 days
(0 Reviews)

We would be happy to have a long term association with you. Please see pm for more details

$125 USD in 3 days
(0 Reviews)