Since I was looking for comparing specific end models (and its associations with around 1.5k different devices/models), your subcategory chart wasnt adequate for me, I made a cool table instead... but hell you gave me a wonderful push at the start when I was really stuck to kick off... thank you really really much!!
any idea why after creating inner join, row and column are uneven? Which mean, the sub-categories in row are not the same as sub-categories in column? reason that it is not identically flip? thanks a lot
Hey Anthony! Can you please share why you selected order id to be a distinct count measure. Shouldn't we be using just the "count measure" to have a more accurate result in terms of sub-category co-relation?
heyy...i need urgent help , this method is not working when i have multiple tables in my data source joined with each other and when i join products table with itselfi am not getting desired results.
Is this possible when using tableau server as your data source? I searched length and breadth of the internet but I couldn't find a simple explanation to Market basket analysis like this, but can it be replicated using tableau server as data source (just one single tableau server for self join) ?
Market basket analysis- If customer boughjt Milk he also buy bread....combination of these two products get compant 100 $ per month and how does this can implemented in tableau ? and why have done subcategory < subcategory ?
Hello Anthony, Its quite simple & neat presentation. I would like to ask you one doubt. I have cleaned data from python in single table. So in thi case no chance of joining multiple tables. Please help me how can I do in such situation. it is urgent to submit my project in next4 days. I am expecting your earliest reply. Thanks in advance.
In this example I use Tableau to self join the table to itself. Import your table into Tableau and see if you can try a similar self join depending upon how your data is organized.
@@AnthonySmoak Boom Boom Boom ..... Thanks for the quick response. I heartily appreciate it. Actually, I have treated data into python for missing values & outliers. So now I have a single CSV. please suggest if it working in Tableau. one more doubt for plan B, can we clean & treat data in Tableau itself. Many Thanks.
@@vaidyaification A self join allows you to join a table to itself. It requires only 1 table. Import your .csv to Tableau and join it to ITSELF as I do in the video. Tableau can do limited transformations by itself, but a better option is to use Tableau Prep (has a cost) or Power BI desktop (free) or your favorite SQL tool (e.g., SQL Server Express) to perform data transformations.
![ทุกครั้งที่หลับตา (Lucid Dream) - AYLA's [ Official MV ]](http://i.ytimg.com/vi/4i1OBAQyv58/mqdefault.jpg)
Boom! What a quick, efficient tutorial. Well done
Since I was looking for comparing specific end models (and its associations with around 1.5k different devices/models), your subcategory chart wasnt adequate for me, I made a cool table instead... but hell you gave me a wonderful push at the start when I was really stuck to kick off... thank you really really much!!
This was a great tutorial! THANK YOU very much - was able to apply the concept immediately with my test datasets!
Glad this technique worked out for you!
thanks for this tutorial. self-join starts at 1:45
Love the join tip, Anthony!
Thank you, it was very helpful to me as Iam a begginer in tableau
any idea why after creating inner join, row and column are uneven?
Which mean, the sub-categories in row are not the same as sub-categories in column? reason that it is not identically flip?
thanks a lot
This was so helpful!!!!!!!! You just saved my final. Thank you!
Thank you Jessica, good luck in class!
Hi anthony, can you please show us how did you calculate profit ratio.
Really helpful tips !!
Very Helpful.. Thanks
Amazing! How can I do this in Power BI?
Why my join table shows nothing? When i put the sub category sub category 1 ? Would you help me please?
Hey Anthony! Can you please share why you selected order id to be a distinct count measure. Shouldn't we be using just the "count measure" to have a more accurate result in terms of sub-category co-relation?
You are genius!
Hi, great tutorial! Do you have the sample data that we can play around with? Thanks
Yes, just google Tableau Superstore dataset.
How you create Sub-Category (Orders1)1?
Can we show the above graph as a bar graph which shows the top 10 products sold together? I need it for my presentation
Maybe this helps. The results seem to differ a bit between approaches however: th-cam.com/video/rzLBsZcPWmc/w-d-xo.html
Great basic gudance
From.where I can download the dataset on top of which you have done analysis ?
Why My value for two combinations are not added together? It takes the max value and shows all the same. Pls help..
heyy...i need urgent help , this method is not working when i have multiple tables in my data source joined with each other and when i join products table with itselfi am not getting desired results.
Thanks
You're welcome
Is this possible when using tableau server as your data source? I searched length and breadth of the internet but I couldn't find a simple explanation to Market basket analysis like this, but can it be replicated using tableau server as data source (just one single tableau server for self join) ?
Give it a try and let us know!
thanks from singapore :)
Thanks from Atlanta!
Market basket analysis- If customer boughjt Milk he also buy bread....combination of these two products get compant 100 $ per month
and how does this can implemented in tableau ?
and why have done subcategory < subcategory ?
Can you suggest a way i can transform the tableau graph back to excel sheet?
Sample :-
Category 1 | Category 2 | Count
What happens when you export the viz as a crosstab?
@@AnthonySmoak issue resolved , right click -> summary
Hello Anthony, Its quite simple & neat presentation. I would like to ask you one doubt. I have cleaned data from python in single table. So in thi case no chance of joining multiple tables. Please help me how can I do in such situation. it is urgent to submit my project in next4 days. I am expecting your earliest reply.
Thanks in advance.
In this example I use Tableau to self join the table to itself. Import your table into Tableau and see if you can try a similar self join depending upon how your data is organized.
@@AnthonySmoak Boom Boom Boom ..... Thanks for the quick response. I heartily appreciate it. Actually, I have treated data into python for missing values & outliers. So now I have a single CSV. please suggest if it working in Tableau.
one more doubt for plan B, can we clean & treat data in Tableau itself.
Many Thanks.
@@vaidyaification A self join allows you to join a table to itself. It requires only 1 table. Import your .csv to Tableau and join it to ITSELF as I do in the video. Tableau can do limited transformations by itself, but a better option is to use Tableau Prep (has a cost) or Power BI desktop (free) or your favorite SQL tool (e.g., SQL Server Express) to perform data transformations.
@@AnthonySmoak Thanks alot.
beginning is 1:34