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
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
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
Leave a Reply