Tableau Word Cloud is useful to visualize the text data. For example, If are looking for Top trending Hashtags in Twitter or Most commonly used Tags in WordPress or any other CMS then you will see few words with brighter colour, some with light colour and there will be a significant change in Font Size. This is possible by using the Word Cloud in Tableau.
In this article, we will show you, How to Create Tableau Word Cloud with an example. For this we are going to write the Custom SQL Query against the SQL Server Data Source. So, Please visit Connecting Tableau to SQL Server article to understand the configurations.
Custom SQL query we are going to use for this Tableau Word Cloud report is:
SELECT Geo.EnglishCountryRegionName,
Geo.StateProvinceName,
Geo.City,
Prod.EnglishProductName,
Prod.Color,
Fact.OrderQuantity,
Fact.TotalProductCost,
Fact.SalesAmount,
Fact.TaxAmt,
Fact.[Freight]
FROM DimProduct AS Prod
INNER JOIN FactInternetSales AS Fact
ON Prod.ProductKey = Fact.ProductKey
INNER JOIN DimSalesTerritory AS Terry
ON Terry.[SalesTerritoryKey] = Fact.[SalesTerritoryKey]
INNER JOIN DimGeography AS Geo
ON Geo.[SalesTerritoryKey] = Terry.[SalesTerritoryKey]How to create Tableau Word Cloud Example
In this example, we are going to create Tableau Word Cloud for State dimension against the Sales Amount size. First, Drag and Drop the State Dimension from Dimension Region to Text Field in Marks Shelf
From the below screenshot you can see the available State names in Tableau report
Next, Drag and Drop the Sales Amount from Measures Region to Size Field in Marks Shelf as shown below
Once you drag them, the following screenshot will be displayed. By default, Tableau Desktop is displaying Tree Map
In order to change the Default TreeMap to Word Cloud in Tableau. We have to change the default Automatic option on the Marks Shelf. Please expand the drop-down list and change the Automatic to Text as shown below
Once you changed, Word Cloud display with State Name as Text filed and Sum of Sales Amount as the text size.
From the below screenshot you can observe that Font Size of a California State is bigger than remaining states because the Sales Amount is higher than other states.
Add Colors to Tableau Word Cloud
Let us add colour to the Word Cloud in Tableau. This can be done by dragging the Sales Amount to Colors field in Marks Shelf as shown below
After the completion, the below screenshot will be displayed. The word or State name with Maximum Sales fills with Dark Green and Least Sales Amount with light green
We just replaced the Sales Amount in Color with Sum of Profits. Now, Tableau Word Cloud will display the state names with the highest Profits will be filled with Dark Green and Least Profits with light green
Let us see what will happen If we replace the State Name with English Product name.
From the below screenshot you can observe that, English Product Name with Maximum Sales with Dark Green and Least Sales Amount with light green
Thank You for Visiting Our Blog
