Tableau is a powerful data visualization tool, in heavy use among both laypeople and data professionals.
Tableau Public is the free version of this tool. There are several things to be aware of with regard to Tableau Public. It’s free to download and use, but, aside from screenshots, the only way to share Tableau Public visualizations is to publish them to the Tableau Public website. That means they will be freely available on the web, and you will need to create a Tableau account in order to do this. In addition, when you share a Tableau Public visualization, any viewer will be able to download the underlying data, unless you purchase a “premium” Tableau Public subscription.
However, you do not need to create an account in order to use Tableau Public on your own computer. We will use it today to make two charts, which we’ll combine into a dashboard. Here is a preview of what we’ll make. At the end of this tutorial, you’ll find information on how to publish it to the web. For this exercise, you will need the Iowa Arts Council Grants data CSV file, which you can download at this link.
After opening Tableau, you’re presented with a list of file types you can choose to work with (“connect”). Even though our Iowa Arts Council Grants file opens in Excel, it’s saved as a CSV. To Tableau, a CSV is a text file. So select Text file. Then navigate to the file you downloaded earlier and double-click to open it.
Tableau will open your file. It should look pretty familiar! In Tableau, you begin visualizing data by creating a Sheet. Do that by clicking on the orange Sheet button in the lower left-hand corner.
Tableau divides your content types (that is, your columns) into dimensions and measures. Measures consist of numeric information: values that can be added up. Everything else is a dimension. Tableau will often provide recommendations based on these data types.
Get started by clicking on Applicant Arts Discipline and drag it into the main section of the sheet (the canvas). It’s not hugely exciting; you just see a list of arts disciplines.
There’s a reason for that: Tableau doesn’t know what you want it to count.
We want Tableau to create a chart that visualizes the number of grants awarded per arts discipline. As we did when we used Excel to create a Pivot table, we want Tableau to summarize the values.
Luckily, Tableau has done this for us. Scroll to the bottom of the Data column, and look at the measure types that are in italics. You’ll see that they contain the word generated next to them in parentheses. This means that these are numbers that Tableau has calculated for you.
You’ll notice a measure called Number of Records. Since each record corresponds to a grant, that’s the one we want. Click on this measure and drag it to the table on your canvas. Drop it in the second column of the table, where the values are currently represented as “Abc.”
Once you’ve dropped the “Number of Records” measure, you’ll see that they’re nicely summarized for you in the table you created. You’ll also notice that highlighted options appear in the palette of chart types on the right-hand side of your window. (This palette of charts is called the Show Me window, in Tableau’s parlance.) Now that you have measures, you have some chart options! Click on the bar chart.
You created a visualization! Now, let’s see if we can create a stacked bar chart, the way we did with Excel. We’ll compare Application Instition Type with Application Arts Discipline.
Luckily, this is easy. Just drag the Application Institution Type measure onto the bar chart you’ve already created.
Now, let’s switch to a stacked bar chart, so we can see the distinctions among institution types more clearly. You’ll notice that as you hover over each segment, a tooltip gives you more information.
Click on your chart’s title (it currently reads Sheet 1) to give it a more descriptive name.
Now let’s make our second chart. Click on the New worksheet button (circled below) to begin our new visualization.
Tableau has automatically geocoded our geographic dimensions. You can tell because a tiny globe appears next to them. Drag County into the main canvas area, and give Tableau a moment to work.
Now that you’ve done a map, let’s add a measure to it. Drag Number of Records into the main canvas area, on top of your map.
Now the circles on your map grow larger as the number of grants awarded to that county increases. You can fine-tune the look of your map by altering the options in the Marks window. Give your new map a title, as you did for your chart.
Now we’ll combine our charts to create a dashboard — a snapshot of multiple visualizations. Do that by clicking on the Dashboard button, circled below.
From the left-hand side of your dashboard’s window, click on each of your sheets in turn and drag them into your main canvas. Very nice!
As I’ve mentioned, in order to make your visualization web-accessible, you will need to create a Tableau account and publish to Tableau’s site. From there, you can embed your visualizations in other web pages. To begin this process, select Save to Tableau Public As… from the File menu. You will be prompted to begin the process of creating an account, logging in, and publishing to the web.
There’s a ton more you can do with Tableau. You can begin learning about its other features here. I also recommend Lynda’s Tableau Essential Training (you will need to log in with your LAPL account) and the book Communicating Data with Tableau, which is available to UCLA people as an online ebook.
17. Finished? Here’s what to do next.
If you’ve finished this tutorial, good job! You’re ready to make visualizations. Remember, don’t think of your visualizations as final, presentation-ready graphics at this point — you’re still figuring out what’s in your dataset.
Please take a look around the room to see if anyone wants a hand. As always, we’re not done until everyone crosses the finish line! If you’re satisfied that everyone has the help they need, experiment with this list of additional data visualization tools. Which do you like best? Which will you use for your project?