Hi all, welcome back to my Tableau tutorial series. This chapter is the last episode of the re-creates of all the charts that are recommended in the “Show me” card.

You can access previous episodes of this series here:

Tableau 101: How to remove “Show me” card in Tableau?

Tableau 202: How to remove “Show me” card in Tableau? (Part 2)

Scatter plot

This powerful chart is a great friend when you want to show the correlation or the relationship between 2 measures. Just drag 1 of your measure to rows, and 1 of your measures to columns, and Tableau will show you the relationship between those 2 variables. For example, I want to see the relationship between profit and sales for different sub-categories:

Histogram

Many people will think that histogram is very similar to a normal bar chart however, there is a difference. The histogram visualizes quantitative data (measures variables) while the bar chart displays categorical data. The interesting thing about this chart is that you need to treat your measure variable as a categorical one, (by using a bin set for those values). Then drag your count of measure value to rows, your bins to columns and there you have it! Example: Distribution of quantity in the dataset

And here is the bin param that I have created. You can create this by right click on Quantity, then Create -> Bins:

Box-and-whisper

A simple chart to represent statistical data such as quartiles, median along with the distribution of the data.  What you have to do is to drag your measure to rows, your categorical variable to columns, and then drag a box plot in the analytics tab to the chart. For example, let’s create a box plot of the Sum of sales by sub-category:

Gantt Chart

A type of bar chart that illustrates a project schedule, so, this chart will work well with DateTime. To build this chart, you have a very important step which is to create a calculated field for the duration between the start date and finish date of your project schedule. Then drag your start date variable to columns, drag your categorical variable to rows, and then drag your duration calculated field u have just created to the size symbol in the Marks window. For example, I want to show a schedule for processing an order for a specific customer (to not show so many values in the view):

Bullet Graph

Another variation of the bar chart is useful for comparing the performance of a primary measure to one or more other measures. Drag your primary measure to columns, your categorical variable to rows. Then drag another measure to the details and start setting up your reference line. In this example below, I will explain more about the reference line. The example is about comparing the sum of profit and the sum of sales by sub-category:

For the fourth step, drag the reference line to the view with the following configuration:

Packed Bubble

A visualization where the bubbles’ size and color are used to visualize different measures. First, change your mark to circle, then drag one 1 to the color symbol and another to the size symbol, also drag your dimensions to the Text symbol in the mark window. Let’s keep the last example of the day simple with profit and sales of different sub-categories.

And that’s all for this journey. Hope you guys enjoy the blog! Stay care, sleep tight and Tableau 404 is coming very soon!

 

 

The Data School
Author: The Data School