Market Basket Analysis in Tableau (Alternate Approach)
Вставка
- Опубліковано 23 лип 2024
- In this version we'll use default Tableau Superstore data to show the relationship between sub-categories on an Order; all without using a self table join. The visualization and analysis is driven by a user selection parameter.
This video represents part two in my Market Basket Analysis series.
Website: anthonysmoak.com
Twitter: @AnthonySmoak
Thank you Anthony for this. I've used this demo to great effect to create workbook views at two different companies. I found converting this to a scatterplot a bit more useful than the bar graph for a quicker vis when displaying a large number of products and to easily Identify positive outliers. The x-axis is the customer count of each product id filtered by the parameter as you expertly demonstrate. The y-axis uses total count of customers who've purchased the product id, set by a calculation that fixes it at the total number and is not filtered by the parameter. Add in a power trend line, and the further to the left, away from the trend line, the higher the correlation. Can easily look through a basket match of 1000s of products in seconds to find the outliers. Also very compact for dashboards.
can you attach your dashboard here. i am very interested your vis. Thanks
@@sandrahu7122 Unfortunately, I can't share the dashboard in a public forum. Here is screenshot of the dashboardphotos.google.com/photo/AF1QipMEl63OYi_8kUgwDHyJgM_PBgDvIOIyIGOoOl5G The bottom grid is full of contact data for customers to create call lists based on results.
@@less_likely thank you so much for your quick response. i can't open the google photo. but i read your description repeatedly. Understand that all the rest is the same as the video. but X is COUNTD(CustomerID), and Y is {fixed(subcategory):countd(customerID}. i hope my understanding is correct. i had a screenshot too, but can't post it here.
@@sandrahu7122 Yes, but I used {fixed(additional order items):countd(customerID}. Might work either way though.
Thank you so much. I have been looking for a tutorial like this. Liked and Subscribed.
Thank you!
thank you so much ...well you deserve a subscription from my side
Hi Anthony, the setting in User Selection Orders, always by itself change to By Formula as SUM ([Matches Selection]) >= 1. After it drag to Filters pane, the chart disappeared. If possible for you, would appreciate if you could enlighten. Thanks
How to do it for 3 items ? Like two products types are user selection
Hii I have a question, does the visualization of the market analysis can be on a dashboard? I could do the calculations but when I put it on a dashboard it doesn't seem to work . Help please. Thanks in advance.
This is what I was looking for. However, can you tell me how to get the top 10 cross selling items as a bar graph. Like accessories and binders together sell the highest as compared to other combinations. Here we are checking manually in your videos. I want to create a sheet which checks all combinations and gives the top 10 results as a bar graph.
Feel free to experiment with Top N functionality. I'm sure you can figure it out. :)
@@AnthonySmoak okay sure will experiment using your approach first and build up on it. Thanks for your help.
No problem!