You are here: Home » Skills » Monitoring & Evaluation »
Using Tableau Public to visualise data

Using Tableau Public to visualise data

Download Tableau Public Do you ever wish you could send your donor a cool interactive map showing the results of your project, rather than just a boring report or PowerPoint presentation? Well, now you can. Tableau Public is a free tool that allows anyone to create interactive charts and maps (referred to as a “data …

Review Overview

Functionality - 9
Ease of Use - 8
Value for Money - 10

9

Summary : Tableau Public is a free tool that allows anyone to create interactive chats and maps.

9

Do you ever wish you could send your donor a cool interactive map showing the results of your project, rather than just a boring report or PowerPoint presentation? Well, now you can.

Tableau Public is a free tool that allows anyone to create interactive charts and maps (referred to as a “data visualisation” or “viz”). To see some examples of what’s possible check out the Tableau Public Gallery and Viz of the Day.

How does it work?

The process is very simple. You start by downloading and installing the software on your computer. Then you open your data set from an Excel or text file.

Once your data set is open you simply drag and drop things to create different types of interactive charts. The program comes pre-loaded with maps of most countries, so you can also combine data with maps. Here’s an example where I’m creating a map of poverty rates in Cambodia:

Tableau Public screen shot 1

Finally, you can combine multiple charts into a “dashboard” that includes buttons for the user to filter the data. For example, the dashboard may allow the user to select a particular province in Cambodia so that only the result for that province will be shown.

What is it like to use in practice?

I’ve used Tableau Public to liven up presentations and to report program results to stakeholders. If you’re able to use pivot tables in Excel then with a bit of trial and error you should be able to use Tableau Public quite easily.

If you aren’t very familiar with pivot tables then you should start by watching the training videos available on the Tableau Public website. They even run live introductory webinars for absolute beginners.

Here is an example of a visualisation I created to report the results of an endline survey to stakeholders (click here to see the interactive version):

SECLO viz

I setup the dashboard so that the results could be filtered using the buttons on the right. This allowed users to see results for particular NGOs, particular activities, or particular target areas that they were interested in. Here’s what it looks like showing only the results for the NGO partner BWAP:

SECLO viz 2

What are the limitations?

Tableau Public has an excellent range of features. Almost any type of chart you could imagine (and many that you couldn’t imagine) are available. However, it does have one very serious limitation for people working in international development – it needs the internet.

When you use the free version of Tableau Public all your visualisations are saved online. They can’t be saved to your desktop. In developing countries where the internet is unreliable this can be a serious problem. I’ve spent hours tinkering with visualisations to make them perfect, only to have all my work lost because the internet dropped out and I couldn’t save it.

The free version also requires that all your visualisations can be seen by anyone online. This can be a problem if you’re working with sensitive data. There are also other limitations, such as not allowing data sets with more than 1 million rows.

All these problems can be overcome if you’re willing to pay for Tableau Personal Edition, but with a price tag of $999 it’s beyond the budget of most smaller and/or local NGOs.

Note: Tableau Software offers one-year free trials to students through their academic program.

The bottom line

Tableau Public is a an excellent tool that allows you to view data in a more interactive and interesting way.

Tableau Public is useful when:

  • You want to create interactive maps, charts and visualisations from raw data.
  • Your data set is available in Excel or a text file.
  • You have a reliable internet connection.
  • You want to share your results publicly.

Tableau Public is NOT useful when:

  • You don’t have a reliable internet connection.
  • Your target audience doesn’t have a reliable internet connection.
  • You are working with sensitive or confidential data.

Photo by Jon Gosier

About Piroska Bisits Bullen

Piroska Bisits Bullen
Piroska has worked on a range of international development programs involving local NGOs, international NGOs, UN agencies and government. She holds a Ph.D. in public health, has published articles in several journals, and was a speaker at TEDx Phnom Penh. Piroska is passionate about using scientific evidence and creativity to design programs that work.
Scroll To Top