Tag Archives: Visualization

Tableau Public for Data Visualizations

Tableau Public is free software that can help users publish interactive data visualizations to the internet. This software is another great option for data visualization along with GIS Cloud or CartoDB. It has powerful charting and graphing tools, and also allows you to map data and display that data against several online datasets and basemaps.

No plug-ins or programming skills are required, just a browser with JavaScript enabled. Tableau Public uses a simple drag and drop process that anyone can learn. You can work with either the free Tableau Desktop app, or Tableau Online the free cloud based server. Either way you can save your work to the Tableau Public Web servers, which are accessible by everyone on the Internet. One important note about this is that any data you publish is accessible to everyone on the internet.

People see and understand data, reports and dashboards faster with visual analytics technology, which can help uncover key trends, relationships, patterns, and outliers that might otherwise be a challenge to find. Tableau Public can be used to pare down information to its simplest form by stripping away the less important data.

The software can connect to Microsoft Excel, Microsoft Access, and multiple text file formats. It has a limit of 1,000,000 rows of data allowed in any single file. Your organization may use up to 50 megabytes of space.

Tableau Public projects can be shared by emailing a link or by embedding the work in a blog, wiki, or website. Clicking on an emailed link will open a browser page with the view loaded. If embedded onto a page, anyone who visits the page will see the live interactive view.  The following shows the use of Tableau Public in two health related studies.

Public Health Case Studies

To visualize the specific social problem of teen pregnancy over time, Tableau Public was used by the Wisconsin Council on Children and Families to show the decline in births to teen mothers in Wisconsin over recent years. The data depicts racial disparities in teen births in Wisconsin as well as differences in birth rates between older and younger teens. The online link to the data visualizations created with Tableau Public for this study can be found here: http://tblsft.com/public/gallery/teen-pregnancy-declines

The figure below is a screenshot of one of the data visualizations from this study. Data visualizations are interactive. Here the white popup window is showing data from a specific place on the line graph.

Teen Pregnancy Data Visualization

Teen Pregnancy Data Visualization

Such visualizations may help communities address and manage such issues as health problems associated with prematurity and poor academic performance of children of teen parents.

Data can also be mapped by geographic coordinates, city, state, county, and zip code. The visualization below deals with Medicare Costs and combines a map with a chart showing trends in the data.

Tableau Public Desktop - Medicare Cost Data Visualization

Tableau Public Desktop – Medicare Cost Data Visualization

Other data visualization examples created with Tableau Public can be found in the Gallery:


Other Tableau Public Resources can be found here:




Using CartoDB for Beautiful Online Maps

CartoDB is an online cloud based platform for storing and visualizing spatial data. It is the perfect tool for the third part of the workflow (outlined in the Introduction). You can sign up for a free account, which gives you 50Mb of storage space. Data can be collected with a smart phone or tablet with iForm, and brought directly into CartoDB.  It is a very intuitive platform. You can literally drag and drop a spreadsheet onto the CartoDB page and have the data upload to your account.  It will accept the most common geospatial file formats including: spreadsheets and comma delimited text files with addresses or coordinates, KML/KMZ, GPX, and shapefiles. Below is an example of a spreadsheet of Baltimore Dialysis Centers in CartoDB. This shows the spreadsheet in Data View .

CartoDB Data View

CartoDB Data View

After telling CartoDB which columns contain the latitude and longitude values, the data can be viewed in Map View (below). Here the default Positron basemap is being used. There are a variety of basemaps to choose from including imagery, Stamen maps and Nokia maps.

CartoDB Map View

CartoDB Map View

Once multiple data layers have been uploaded you can create a visualization. Below is a map focusing on Balitmore Diabetes. It includes Baltimore neighborhoods classified by the number of diabetics, food deserts and dialysis centers.  CartoDB provides wizards and other tools for styling your data. The dynamic map can be accessed here: http://cdb.io/1G4xP7j

CartoDB Visualization

CartoDB Visualization

Visualizations can be shared via hyperlinks and embedded into webpages.  CartoDB also has great documentation including:

Sign up for a free account and take it for a spin. On a related note Community Health Maps is almost done with a complete curriculum for community health mapping. It consists of six labs. The final lab shows you how to work with CartoDB from setting up an account to sharing a visualization. Stay tuned!