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 this article, we will show you How to Create a Tableau Word Cloud. For this Word Cloud demo, we write SQL Query.
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 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
See the available State names in Tableau report
Next, Drop the Sales Amount from Measures Region to Size Field in Marks Shelf
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
Once you changed, Tableau Word Cloud display with State Name as Text field and Sum of Sales Amount as the text size. See 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.
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
What will happen If we replace the State Name with English Product name?. As you see, English Product Name with Maximum Sales with Dark Green and Least Sales Amount with light green.
