Tableau Word Cloud

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 color, some with light color and there will be a significant change in Font Size. This can be achieved using the Tableau Word Cloud

In this article we will show you, How to Create Tableau Word Cloud with 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 report is:

T-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]

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, following screenshot will be displayed. By default, Tableau Desktop is displaying Tree Map

In order to change the Default Tree Map to Word Cloud, we have to change the default Automatic option in the Marks Shelf. Please expand the drop down list and change the Automatic to Text as shown below

Once you changed, Word Cloud will be displayed 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.

Adding Colors to Tableau Word Cloud

Let us add color to the Word Cloud by dragging the Sales Amount to Colors field in Marks Shelf as shown below

Once you are done, following screenshot will be displayed. Word or State name with Maximum Sales will be filled with Dark Green and Least Sales Amount with light green

We just replaced the Sales Amount in Color with Sum of Profits. Now, Word Cloud will display the state names with 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