Skip to main content

Hide the Table

Search This Blog

Story: My 2021 Twitter Stats (Post Redirects to Tableau Public)

on January 15, 2022

Get link
Facebook
X
Pinterest
Email
Other Apps

Story

Get link
Facebook
X
Pinterest
Email
Other Apps

Popular Posts

How to Create a Dendrogram in Tableau - My Way

A dendrogram, also known as a phylogenetic tree, shows the evolutionary interrelations of a group of organisms derived from a common ancestral form. The ancestor is in the tree “trunk”; organisms that have arisen from it are placed at the ends of tree “branches.” The distance of one group from the other groups indicates the degree of relationship; i.e., closely related groups are located on branches close to one another. Phylogenetic trees, although speculative, provide a convenient method for studying phylogenetic relationships. A dendrogram can be generated by coding using libraries like scipy , Matlab , and plotly . However, how do you create one on Tableau? Using an image of a dendrogram from Matlab, I will demonstrate how. Step 1: Draw the Dendrogram Using Any Software or Pen and Paper (image from Matlab) Step 2: Mark the Lines for Each to Look Like a Full Bar Chart Step 3: Label the Rows with Numbers Step 4: Label Columns with Numbers Step 5: Enter the Numbers in...

How to Create Nested Circles (Onion Chart) in Tableau - My Way

Initially, I decided to save this for when the theme will be Food because this is about the Onion Chart. However, I came across the above in one of the pages of The Truthful Art. To know what an Onion chart is, you can read the Wikipedia article, Onion diagram . The tutorials that I have come across so far are Calculated Fields based. You can find them below: Vizzing Data Sons of Hierarchies Toan Hoang Viz Art Pandey This tutorial uses the same technique with shapes here by Flerlage Twins. Step 1: Download the Following Picture File You can create your own using any software you are comfortable with. It is basically a black circle in a transparent square where the circle is above the centerline of the transparent square. Step 2: Insert the Circle into Shape Read about inserting custom shapes into Tableau here if you are new to custom shapes. Step 3: Build Your Chart Create "0" for Columns and Rows. Go to Shape and choose the file you have downloaded and saved in the above 2...

How to Create an Organisation Chart on Tableau - My Way

There may be better ways to create an org chart, but here is my way to making it on Tableau. Steps 1-8: Follow My Way in Creating a Dendrogram Click on the above link to find out how to create the lines needed for this chart This tutorial uses these 2 tables from 2 separate Excel sheets but only uses the sheet named "Line" for the first 8 steps Do not start from 0 on the axes as the bar chart border will appear Step 9: Import the Sheet Named "Node" and Create a Relationship Using "Height" and "Place" Step 10: Drag Pills into Places Make the pills Continous Dimension Make the axes "Dual Axis" Synchronise the axes Have the pill "Place (Node)" be in front of "Place" Change the Marks Card to "Square" Adjust the Size to wrap around the words Step 11: Make it a Dashboard Create a new dashboard Drag the sheet over Bring a floating blank title to cover the lines at the bottom Step 12: Publish Your Org Chart!

How to Create a 9-Box Employee Rating on Tableau - My Way

What is a 9-Box Employee Rating? The 9-box grid is a well-known talent management tool in which employees are divided into nine groups, based on their performance (represented by the horizontal axis) and potential (represented by the vertical axis). Can I create a 9-Box Employee Rating on Tableau? Yes, you can. This has already been done by Decisive Data. Check out their version here . So why do we need this tutorial? There are still posts on the Tableau forum asking how it can be replicated and there are no proper tutorials to answer. First, ask by Beth in 2014 . Then again by Arihant Jain in 2020 . Finally, another time by Ittikorn Sriratanarungrueng in 2020 . Unfortunately, the answers were either lacking or short. Hence, I have decided to give this a shot partly inspired by Nasheed Sabree's replies on the first and second forum posts that write, " This is definitely possible in Tableau. Simply assign a number to each combination (9 combinations) and use this field as a f...

How to Create an Icicle Chart on Tableau - My Way

This post is on my method to create an icicle chart on Tableau. I have used this in my submission for #vizforsocialgood for Foundation Follereau Luxembourg . Click here to see the viz submission. Initially, I have thought that I am innovating a new chart type, but I have realised that it is an existing chart called icicle chart after publishing. You can see Adam E McCann's Tableau version here . Step 1: Create First Bar Chart Drag the value to Columns (first picture below). Drag the pill that you will like to split the chart by into Colour as Discrete, in this case, it is "Year". Right-click on the chart and click Format. Click on the "paint tub". Click on the field beside Worksheet and choose "None" to make the background transparent (second picture below). Step 2: Create the Second and the Other Bar Charts Duplicate the Sheet. Drag the value to Columns. Drag the pill ("Year") from the first bar chart as Discrete into Column and Colour. ...

Powered by Blogger