How to Create Text Visualisation in Tableau

 

  1. f we load one of these files into Tableau (I'll stick with Don Quixote, but feel free to use whichever book you like best!), we get something that looks like:

  2. Let's pop over to a new sheet and see what we can do!

  3. If we drag the Words dimension onto the Text mark, we can view all the unique words in the book:

  4. ...well, almost. See how we only get partway through the As? There are too many unique words to fit! No problem, let's make a filter to show only those that appear at least 50 times:

  5. That's a little better:

  6. Let's see what happens if we try using Word Count to drive the Size mark:

    Ooh, sort of like a treemap!

  7. Let's switch from an Automatic mark type back to Text:

    Hey, that's starting to look like a word cloud! There's just one problem: now that we've mapped Word Count to Size, it's easy to see that the most frequently used words aren't actually very informative.

  8. That's okay, we can filter again! This time, let's bring in a second data source that contains the 100 most commonly used English words. Start by clicking the Add a New Data Source... icon next to the Save button and select "Text File":

  9. Now we'll connect to the common-words.csv file, which looks like this:

    Now when wego backto the sheet, we should also see the second data source.

  10. Before we'll be able to filter words in our book using words from this second file, we'll have to tell Tableau how to connect the two files. Start by selecting Edit Relationships... from the Data dropdown menu. In the following window, select the Custom radio button, and click Add...:

  11. The only field they have in common is the Word field, so we can click OK:

    which will tell Tableau to connect these two fields, which will be indicated by a red link icon next to the Word dimension:

  12. Now let's filter on Rank:

    Uh oh! That's just the opposite of what we wanted.

  13. Turns out that since the words we want to keep are the ones that don't appear in the common-words.csv file, we need to go back into our filter and tell Tableau to include null (or missing) values:

  14. Now if we selectShow Filter for each of our filters, we can adjust how many of the most frequently used words to exclude, as well as set the threshold for how often a word has to appear in the book to be displayed. Here I've excluded all 100 most frequently used English words, and I'm only showing words that appear at least 200 times:

  15. To make the larger words even more salient, we can use Color as a dual-encoding:

    16. We can see that the names of the main characters (Don Quixote and Sancho) appear quite frequently!

Comments

Post a Comment

Popular posts from this blog

How to Create Dashboard in Tableau Steps

Image
  How to Create a Dashboard in Tableau Understand the importance of creating dashboards and learn to build a simple Tableau dashboard by following a visual guide. May 2022  · 16 min read What is the Purpose of a Dashboard? A car dashboard provides real-time information about a car's speed, fuel volume, RPM, and other engine-related indicators. Similarly, a data dashboard provides information about company historical sales, key performance indicators (KPIs), sales growth, operational indicators, and customer feedback. This information is presented in a precise manner so that managers or executives can understand the situation and make appropriate decisions.  There are hundreds of moving parts in your business and a dashboard summarizes these events into an easy-to-understand, real-time data visualization. These visualizations and charts can be used to make fast and effective decisions. Dashboard by  Freepik  | edited by Author There are several benefits...
Read more

Tableau Charts Uses.

  Tableau Charts and What and Use .                                                                A Pareto chart 1. . A Pareto chart is a type of chart that graphically represents the relative frequency or size of different categories or factors. It is named after Wilfredo Pareto, an Italian economist who observed that 80% of the wealth in Italy was owned by 20% of the population. The Pareto chart is based on the Pareto principle, which states that roughly 80% of effects come from 20% of the causes. The chart consists of a bar graph and a line graph. The bars are arranged in descending order of frequency or size, and the line graph represents the cumulative percentage of the total. The chart helps to visually identify the most significant factors contributing to an outcome, and can be used for ...
Read more

How to Create Heat map in tableau

Image
   Heat Map – Make your First Heat Map With Us We offer you a brighter future with FREE online courses  Start Now!! In this  Tableau  tutorial , we are going to learn what is a heat map and what are the steps to create a Tableau Heat Map. You might be thinking, how and from where to start and what are the requirements to make this chart. I know, I know so many questions are there in your mind. Don’t worry we have answers to all your questions. All you have to do is first, open your Tableau software on your device and then follow the below steps with us. (Note: We are using Tableau Desktop to make the density heat map). But wait, before moving on to the steps, first understand the concept of heat map. What is Heat Map? A density heat map is used to analyze the areas in a plot where data points are dense or scattered. Heat maps are specifically used where there is a huge data set with overlapping data values. This helps analysts to see the areas with greater densi...
Read more