How to create Dendrogram Chart in Tableau| Single Level Drill down| Decision Tree Part I
Вставка
- Опубліковано 8 лип 2024
- Dandrogram chart is also known as Treemap Chart and is commonly used to provide a hierarchical view of data and makes it easy to spot patterns. There are many different ways to visualise data and in this tutorial we will talk about how to create a treemap in tableau.
Link to Dashboard: public.tableau.com/profile/gu...
Link to multi Level Dendrogram chart : • Multi Level Dendrogram...
--------------------------------------------
📚 Recommended Books
--------------------------------------------
📚 DATA VISUALISATION & STORYTELLING
Storytelling with Data: A Data Visualisation Guide for Business Professionals amzn.to/3q9ygPw
Data Visualisation: A Handbook for Data Driven Design amzn.to/3qfb1na
The Big Book of Dashboards amzn.to/3q4i3eG
Data Visualization: A Practical Introduction amzn.to/44KYrel
Storytelling with Data : Lets Practice amzn.to/44O7WcL
Tableau Desktop Specialist Certification: amzn.to/44Ocy2P
Tableau Desktop Certified Associate: amzn.to/3Kk2YfV
📚 SQL
SQL for Data Analytics: amzn.to/3rROkGj
SQL 3 books in 1 : amzn.to/3KklUuY
Learning SQL: Generate, Manipulate and Retrieve Data : amzn.to/3Kn34mN
SQL Quick Start Guide: amzn.to/3KInOpx
📚 DATA ENGINEERING
Data Engineering with Python : amzn.to/3YelH1Y
Data Engineering with AWS: amzn.to/3YgXoAL
Fundamentals of Data Engineering: amzn.to/3OAUVxy
Software Architecture: amzn.to/3KmNffX
System Design Interview: amzn.to/3Yhfy5q
Ace Data Science Interview: amzn.to/3rOxcBl
System Design Interview: amzn.to/3OAw8d7
Designing Machine Learning Systems: amzn.to/3YbGxiB
📚 SOFTWARE ENGINEERING
Clean Code amzn.to/47aBnr4
Clean Architecture amzn.to/3OA8VaP
The Programmatic Programmer: amzn.to/4793k2C
-----------------------------------------
👇 CHECK THIS OUT! 👇
-----------------------------------------
🏪 AMAZON STOREFRONT
www.amazon.com/shop/datavizca...
All my recommendations for books, gadgets and gear are also available at my
Amazon storefront. Check it out!
👕 LIKE THE "DATA RELATED GIFTS" WITH CREATIVE, FUNNY & HUMOROUS QUOTES FOR ANYONE WHO LIKE TO LAUGH ?
You can purchase one here: www.datavizcanvas.com/shop/#!/
--------------------------------------------------------------------------------
😍 📧 REACH OUT TO ME ON SOCIAL MEDIA 😍
--------------------------------------------------------------------------------
Instagram: / datavizcanvas
Twitter: / datavizcanvas
Facebook profile.php?...
Linkedin: / gurpreetsingh515
Tableau public public.tableau.com/app/profil...
Website : www.datavizcanvas.com/
-------------------
GEAR I USE
-------------------
📷 Video
Canon EOS RP amzn.to/3QkOpfU
Canon RF 35mm amzn.to/3rNIh5E
Canon RF 14-35mm amzn.to/44JQw0Y
🎙️ Audio
Rode NT-USB Versatile Studio amzn.to/3DCbxyY
Rode PSA1 Professional Studio Arm amzn.to/3ObseWN
⏱ TIMESTAMPS
‼️ DISCLAIMERS
Links included in this description may be affiliate links. When you buy a product or service with these links, I may receive a small commission. However, there is no additional cost to you :) I genuinely appreciate you supporting my channel so I can continue to provide you with awesome content for free!
Thanks for being a part of this channel and all your support! 💪 🙏
Fantastic video. Really liked the fact that you did this step by step and I was able to follow and pause. Great video. Moving onto part 2 now.
Thanks for your feedback Pritesh. Glad that it was helpful. :-)
Very helpful! Thank you!!
You are welcome Nicole. Thanks for supporting our channel 🙏
amazing video thank you!
Thanks Wendy 🙏
Thank you
Great one
Thanks 🙏
thanks for the work
You are welcome 🙏
wonderfull
Thank you! Cheers!
Power BI supports this feature natively
Easy to follow step by step but not easy to remember all steps and calculations :)
Thanks for y our feedback. Yes, its hard to remember all steps but you can refer to this tutorial when you are building this chart. With practice you will be able to do that.
if you notice, in the last part when you add sheet 3 there is a higher value than the original sum of sales plz confirmed it
great video, one question though, should we use a new calculation field of sales/2 for sheet 2 and 3 since I thought the numbers are duplicated when we were using the original sales field, thanks
Yes you are correct. That seems to be an error in the video. Due to data densification, we need to divide sales by 2 . Thanks for pointing that out :-)
any idea of how to adjust the display when applying filters? even using containers, the dendrogran lines don't appear centralized as the sub-total is..
and great job on the video my dear!!
Hi Gustavo, Do you mean that the alignment of the dendrogram lines doesn't align with the total sales value.
In that case you can use custom alignment in text mark and make adjustments there for both sheets.
Please feel free to reach out if you need more info and would appreciate if you can share your dashboard link as it will help to investigate your issues.
Cheers!
What if I want to display only the top 10 sub-categories in the dendrogram based on the sales values, only top 10, not all of sub categories? How can I do it?
You could use a filter.
Example: Use Categories in the filter shelf.
Then edit the filter and you will see 4 tabs in the pop up window i.e. General, Wildcard, Condition & Top
Select the Top one
Then select the radio button for "By Field"
Then select top 10 (Or. what ever is your requirement)
Then select "sales" measure and aggregation of "Sum"
then click ok
All done :-)
do this in all the levels to achieve desired result
I like it
Glad you liked it. Cheers!
What if I want to show only the top 10 values in the dendrogram, not all values? I used a filter and a parameter but it didn't work
You could use a filter.
Example: Use Categories in the filter shelf.
Then edit the filter and you will see 4 tabs in the pop up window i.e. General, Wildcard, Condition & Top
Select the Top one
Then select the radio button for "By Field"
Then select top 10 (Or. what ever is your requirement)
Then select "sales" measure and aggregation of "Sum"
then click ok
All done :-)
do this in all the levels to achieve desired result
Well explained video, sir. Can you share the dataset for the practice purposes?
Yes, sure. Its the inbuilt sample superstore dataset in tableau desktop. or you can download the workbook from my tableau public profile
public.tableau.com/app/profile/gurpreet.singh2669
Hope that helps
Awesome video! Just wondering how to sort by category in a specific order (pipeline) vs by total sales by category. I can't seem to do it with custom sorting.
You can do that by sorting in tableau calculation in a particular order. You can also do that by bringing calculated field in the table calculation. Please try that and let me know incase of any issue.
While doing an exercise for creating this chart, I found the below error under Y Axis Table Calculation
"COUNT is being called with (numerical bin), did you mean (table)? "
Hi Zabiyoddin,
Y axis table calculation is computed using specific calculation of Sub Category. You could download the dashboard from tables public using below link
public.tableau.com/profile/gurpreet.singh2669#!/vizhome/TreeDiagram_15855417594610/TreeChart
@@DataVizCanvas On the Table Calculation step of @Y I also got the same error:
"An error occurred while communicating with data source 'Sample - Superstore'
Error Code: 19841555
COUNT is being called with (numerical bin), did you mean (table)?"
When I checked the comments after getting this error, I saw that I was not alone in this error :). When I download your workbook, it looks fine, but do you have any idea why we might have encountered this error at this step? Version difference?
btw Thanks a billion for your magic!
@@MehmetSezer7 This issue was caused due to the use of "bin" with data relationship.
Upgrading to tableau desktop to 2021.2 or more will solve this.
Alternatively please use data join instead of data relationship.
Hope that helps.
Cheers!
Gurpreet
Hi, I was wondering if Sales that you are showing is not multiplied *2 - because of adding those rowspath on the beginning, isint this multiplied?
Hi , In this chart we are using data densification techinque to artificially create points. for that we have used "path" field with two values . In between these two values we are artificially creating points using bin. So each row gets duplicated when we join it with Path. Thats why the Sales number gets doubled. Inorder to avoid that , we divided it by 2. Hope that helps 🙂
Please feel free to reach out if you need more information.
I did it.. Thanks alot, I think you are a litle bit too fast :) Thanks again. Let me try part 2
Thanks for your feedback.
I will try to keep my pace a bit slow in future videos.
Cheers!
Gurpreet
Hi! Great great video, done it perfectly, but only problem is my data is duplicated, so my results are wrong, as my total number of sales is double the correct one. How can I solve that? Thank you!
Thanks for your feedback.
When you use data densification using path values and do cartesian join, it will create 2 values for each value in your dataset.
In order to avoid double the value, you need to divide total sales by 2 as shown in the video (4:27)
Hope that helps 🙂
Hi, i need to create Dandogram for 3 levels. Could you please help me for that, i have searched and tried everything but not worked.
Hi Sandeep, please try watching tutorial in below playlist where I have shared different ways of drill down at multiple level using dendrogram chart
ua-cam.com/play/PLMbGQrGl-0EuBew3uS85ZitX_Evc8oJp2.html
Is it possible to create this chart by "Tableau public". I could not able to paste the clipboard.
Hi Joneesh,
Please copy the data in excel file and use that as data source rather than paste as clipboard. Please try that and feel free to reach out in case of any issues 😊
Is there anyway to build this without using a join to the path data? I'm using a published data source so cannot join to it
There is an another way using calculated field and parameter. Check out below blog post from Flerage brothers www.flerlagetwins.com/2019/05/intro-to-data-densification.html
Hope that helps
At 13:41 I'm getting Circles on the chart. and how to convert them into Bars. can you please help
Check your Percentage Adjusted calculation. You might have used Windows Sum instead of Windows Max
Great video, I do not see step where you create profit bin
Hi Venkata,
Profit bin was already created in the superstore data set by default. If you want to create any new bins then you can do it by right clicking on a measure field and select bin. hope that helps.
Cheers!
Gurpreet
Can we do this chart with multiple layers? A multi level dendrogram?
cargouvu : Yes we can create this chart with multiple layers with few additional calculations. Will share the tutorial on that soon. Please stay tuned 😊
@@DataVizCanvas thanks. Right now, I am doing it using Jeff Schaffers method. This way is easier
@@DataVizCanvas When will you share it?
@@lama7559 Please see the latest tutorial on multi level dendrogram chart. :-)
ua-cam.com/video/1FVwBj6pHxg/v-deo.html
@@DataVizCanvas thanks a lot
my Y axis did not came in the center
I'm going to go pick up the pieces of my head now.
I know some of these tricks can be difficult to understand. Please feel free to reach out if you need more information or clarification. Thanks!
I really didn't understand why we divide by 2 for also the @Total Sales field
Hi , In this chart we are using data densification techinque to artificially create points. for that we have used "path" field with two values . In between these two values we are artificially creating points using bin. So each row gets duplicated when we join it with Path. Thats why the Sales number gets doubled. Inorder to avoid that , we divided it by 2. Hope that helps 🙂
Please feel free to reach out if you need more information.
Can you please share the dataset?
It’s sample superstore dataset available on tableau desktop or you can download my tableau public workbook . Hope that helps 😊
@@DataVizCanvas Thanks for your reply. Sure
It would be great if you explain every step,means why are you taking exp() function Like this....thank you
Thanks for your feedback and supporting my channel. It means a lot. Thanks
Intro nearly burst my eardrums, other than that good video.
Thanks for the feedback. Will see what I can do in future videos 😊
Tableau claims that it is very easy. But frankly speaking unless someone show process step by step, we don't even get clue to start such graphs.
Thanks for your feedback. Hope this video helped you with step by step process to create dendrogram chart. Please feel free to reach out if you have any questions 😊
Bhai, "डेटा" hota hai not "डाटा"..baki achha hai
Thanks for your feedback. :-)
Please Share data !
You can download the dashboard form my tableau public profile and play with the dataset. Thanks 🙂
to much background music - info is useful but hard to concentrate because of background music
Thanks for your feedback. Will try to make a better experience in the future tutorials.
You can say step by step like why we need to do those things and what are the trying to implement you just simply saying and I don't understand what are you trying to say
I love Tableau and this was a great video. But its a total waste of time. How about just using a bar chart and color by category? It takes 5 seconds and you get the same information. Probably most people here want to see a multi-level dendogram or process flow chart.
Thanks for your feedback.
Yes there are lots of other ways of visualising data and as a designer we need to make sure that we get all the question answered in the dashboard and make is easy to use , looks inviting and beautiful and helps the business in decision making.
Can you give any resource to understand what's going on for the X part
Hello, I just had to visit my high school math ;) No other resource apart from my tutorial.
Please let me know which part you didnt understand and i will try to provide more details.