Great video, simple, easy to follow and adapt to other datasets. I tried a few other sources for this and this was the best I found. Thanks for making this!
Thanks Michael for your feedback. I’m glad that you find this helpful. Please feel free to share this in your network so other members of the community can benefit form it as well. Cheers!
Around 3:37 you mis-speak about the relation you're making. You say 'unique key' when referring to Order ID, which is confusing. If Order ID was itself a unique key to the table, that would mean every record would have a unique value, and thus when you performed a self join, you would not introduce any new information into each row. This is very misleading, because if you did a correlation calculation with a join introducing no new information, then you would only be able to compare each subcategory to itself (due to the order of the vectors) and thus would get no meaningful correlation out. I just wanted to bring this up, as I was confused by this point when watching the video. And it is important to understand how a self join will behave when attempting to calculate correlations in the fashion you demonstrate. Thanks for the video regardless!
Sample Superstore is the data set used for this dashboard and is available on tableau desktop by default. alternatively you could download the dashboard from my public profile and export the data set. Please let me know in case of any issues. Cheers!
You can download the dashboard from tableau public and can download the data from the desktop version. public.tableau.com/app/profile/gurpreet.singh2669/viz/HowtovisualizePearsonCorrelationCoefficientinTableau/CorrelationCoefficient Hope that helps Cheers!
Great video, simple, easy to follow and adapt to other datasets. I tried a few other sources for this and this was the best I found. Thanks for making this!
Thanks Michael for your feedback. I’m glad that you find this helpful. Please feel free to share this in your network so other members of the community can benefit form it as well. Cheers!
Excellent tutorial, thankyou so much just what I was looking for!
I am glad you find it helpful. Thanks for supporting my channel and stay tuned for more such tutorials :-)
Around 3:37 you mis-speak about the relation you're making. You say 'unique key' when referring to Order ID, which is confusing. If Order ID was itself a unique key to the table, that would mean every record would have a unique value, and thus when you performed a self join, you would not introduce any new information into each row. This is very misleading, because if you did a correlation calculation with a join introducing no new information, then you would only be able to compare each subcategory to itself (due to the order of the vectors) and thus would get no meaningful correlation out.
I just wanted to bring this up, as I was confused by this point when watching the video. And it is important to understand how a self join will behave when attempting to calculate correlations in the fashion you demonstrate.
Thanks for the video regardless!
why you don't link the dataset ?
Sample Superstore is the data set used for this dashboard and is available on tableau desktop by default. alternatively you could download the dashboard from my public profile and export the data set. Please let me know in case of any issues. Cheers!
Hi, can i know how does the datasheet looks like? Is there any reference for it?
You can download the dashboard from tableau public and can download the data from the desktop version.
public.tableau.com/app/profile/gurpreet.singh2669/viz/HowtovisualizePearsonCorrelationCoefficientinTableau/CorrelationCoefficient
Hope that helps
Cheers!
at 5:11 my dashbaord does not create matrix rather diagonal line of Abc
Please provide more details and i can have a look
A+. Want likes? -> P r o m o s m!!!