Tableau Word Cloud is useful to visualize the text data. For example, If you are looking for Top trending Hashtags in Twitter or Most commonly used Tags in WordPress or any other CMS, then you see few words with a brighter color, some with light color and there will be a significant change in Font Size. It is possible by using the Word Cloud in Tableau.
In this article, we will show you How to Create a Tableau Word Cloud with an example. For this Tableau demo, 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.
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 a 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
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, Tableau 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 the remaining states because the Sales Amount is higher than other states.
Add Colors to Word Cloud
Let us add color to the Word Cloud in Tableau. We can do this by dragging the Sales Amount to the Colors field in Marks Shelf as shown below
After the completion, the below screenshot will display. The word or State name with Maximum Sales fills with Dark Green and Least Sales Amount with light green
We 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
