Can anyone help me to explain the Market basket Analysis?
Currently I am using a self-joining method to create a market basket analysis in Tableau. But I have a little bit difficult to interpret the results. For example, one result shows "Sub_category: A ; Sub_category: B; Number of records: 2000". How this 2000 is calculated?
I created a sample worksheet below.
Based on the data above, we know the AB pairs occurs 4 times, but why in the Tableau, when it calculates, the number of records shows 11?
Can anyone help me to clarify my doubt? Thanks.
1. Re: Can anyone help me to explain the Market basket Analysis?
Can you attach the sample workbook that you have created above????
2. Re: Can anyone help me to explain the Market basket Analysis?
I think you might not need to use self joins but it depends on what you need and how complex it is.
3. Re: Can anyone help me to explain the Market basket Analysis?
Here it is. I want to know by using two different ID as selfing join, how should we interpret the result? And what information we can get from those result? Thanks.
4. Re: Can anyone help me to explain the Market basket Analysis?
Thanks for your reply. Can you explain to me the meaning of those two results? Thanks.
5. Re: Can anyone help me to explain the Market basket Analysis?
6. Re: Can anyone help me to explain the Market basket Analysis?
7. Re: Can anyone help me to explain the Market basket Analysis?
We basically use market basket analysis to know the buying behaviour of the customers. For eg. If company has a Shaving Razor as a product then does they also by products related to Razors like Shaving cream, Foam, Blades etc. Further you can detailed analysis for the preferences. If you have shaving cream and Shving foam. Question can be which one does customer like. Next level of analysis can be done is which flavour of the cream of foam is prefered by the customer? It can be Mint, Lime etc. You can also go for the analysis which product quantity is most prefered by customer. Eg. 50gms, 250 gms, 500gms etc. So it depends what exactly you want to know.
Please find the below link. It has the marketbasket in the intermidiate section. You can downnload the solution for the same. Author has given his detailed comments in the caption section of chart which can really help you to understand better.
8. Re: Can anyone help me to explain the Market basket Analysis?
You should always be ignoring the combinations of A-A, B-B. This can be achieved with the help of self join and category not equal to each other. its a good attempt. Try fixing the products with same association.
9. Re: Can anyone help me to explain the Market basket Analysis?
10. Re: Can anyone help me to explain the Market basket Analysis?
The table shows how many customers bought items in both categories or how many such orders there were. I think that's what you were looking for.