Tableau Basic Visuals
Let's create some Data visuals using the 3 datasets that we have worked on in MySQL.
The below plots are most frequently used in all Visualisation Reports and Dashboards.
With Tableau, we just have to drag and drop the columns in the plot area and Tableau can provide us with amazing visuals with minimum or no alterations required.
Go through the Tableau Visuals: Basic Set-up Page for information on basic alteration and adjustments for a more finished look.
You will also find a link at the bottom of this page, to access the Tableau Public worksheets that are published on the Tableau page for your reference.
1.Stacked bar chart
The below Stacked bar chart reflects the distribution of Commission between each Department across Employee Locations.
​
Bangalore has the highest employee commission for Sales as well as Collection whereas, Toronto have less Commission for Sales Employees and Hampshair for Collection.
2.Treemap
The below Treemap reflects the hierarchically comparative view of Total Outstanding Amount in respective customer Country.
Here the darker colour area represents high values and as the value decreases, the colour gets lighter (Palate reflecting at the left side of the page) also the size of the category area varies as per the value.
​
India has the highest outstanding amount to be collected followed by UK, Canada and so on.
3.Maps
The below plot reflects the distribution of Total Sale Amount across the Country.
Whenever data have country or state names as categorical data, it automatically created Latitude and Longitude fields. We just have to plot the Longitude in the Columns section and Latitude in the Rows section and Tableau will display the world map accordingly.
Drag and drop the figures in the Label section and Country in Color section to display different colours for each location in a particular column. You will need a good internet connection for this plot.
​
India has highest sale value followed by UK, Australia, USA and so on.
4.Bubble Chart
The below bubble chart interprets the comparative view of Total sales across Customer Cities.
Drag and drop the Customer City in Columns section and Total Sales in Rows section.
Select 'Packed-bubbles' chart from the 'Show me' tab at the top right side of the worksheet.
The size of the bubble varies as per the total sales of each category (City). Tableau automatically selects the most suitable colour palette for the plot. You can however change it from the palate list at the right side of the page (From the drop-down select Edit colour and choose your palette).
​
London have highest sales amount followed by Chennai, Brisban and so on.
5. Pie Chart
The below Pie chart represents the respective employee's contribution to the total collection value across Customer countries.
In order to reflect % contribution of a numeric column, just go to the drop-down Lable of that field, select 'Qucik Table Calculation' and click on 'Percent of Total'.
Note: The below Pie chart have colour segregation of cust.country only, but I have also added Employee Name as 2nd Categorical lable for further segregation.
​
Anderson has the highest % of collection from USA followed by Alex with 10.21% collection from India and so on.
Global Sales & Collection Dashboard
After all the visuals created in the worksheet, click on the New Dashboard option at the bottom of the page (Besides Worksheet names) and add each of the relevant visuals to Dashboard pane.
Add Dashboard title relevant to your visuals and purpose.
This is an interactive dashboard, which is currently published and live over Tableau Portal.
