You can download here a table calculating combinations of items appearing frequently on the same orders.
It can be very useful to know, that customer, buying product A, is likely to buy product B – so you can successfully propose it to him.

Model uses Power Query and Power Pivot.
You can use it without deep understanding – just replace the sample data with yours and refresh.
This model is quite demanding on computer performance. If you had some idea how to make it more effective, please let me know.
Files to download:

2 Comments

  1. Hi,

    Thanks for sharing the .xls file.
    Is there a way to also find the combinations of 3, 4, 5, … articles in the same basket?

    regards,

  2. In this case I´d recommend already prepared R-packages and run it in R.

Leave a Reply

Your email address will not be published.

*

clear formPost comment