6.6 Polygon Map with Tableau Public
by Jack Dougherty last updated Monday January 27, 2020
Tableau Public is freely-available software that contains powerful tools to quickly create interactive polygon maps for common boundaries (such as US States, or World Nations.) If you need to create customized maps for less-common boundaries, see our chapter on Leaflet Maps with Google Sheets in this volume.
Important: Tableau Public is designed to publicly display your data, which makes this free tool very appropriate for educators, journalists, non-profit organizations, or other users who wish to openly share their map. If you desire a private tool to restrict your data, Tableau offers other tools that require payment.
See also the Tableau Public support page https://www.tableau.com/support/public for additional resources, including video tutorials.
Download and install the free Tableau Public tool, available for Mac or Windows, at https://public.tableau.com/en-us/s/download. Do not confuse with other Tableau products that require payment. Installation may require up to 5-10 minutes.
Click this link and Save to download to your computer: us-sample-data in CSV format. CSV means comma-separated values, a generic spreadsheet format that most tools can easily open. For help with downloading, see this short video tutorial.
Open the us-sample-data.csv file with any spreadsheet tool to view its contents.
Launch Tableau Public. In the Connect column of the first screen, click “Text file” to connect to the CSV file you downloaded above. (If you had an Excel file in .xlsx format, you would click that instead.) Navigate to select the us-sample.data.csv file on your computer.
At first, Tableau Public does NOT recognize the names of US areas, which initially appear simply as “text” values (with the “Abc” symbol). Click and hold down the mouse directly on the “Abc” symbol, and use the drop-down menu to convert to Geographic role > State/Province. A tiny globe symbol will appear to show that Tableau Public now recognizes this column as geographic data, which is essential in order to make a map.
- Go to the Worksheet view, by clicking on “Sheet 1” in the bottom-left corner. The goal is to build a polygon map, based on the dimensions and variables provided by Tableau Public.
Step A - Drag the “Area” dimension to the middle of the worksheet to create the geographic areas
Step B - In the “Marks” panel, change the drop-down menu from “Automatic” to “Map”
Step C - Drag the “Type” dimension into the “Color” box of the Marks panel to show polygon colors according to type
Optional: Add more items, such as “Abbreviation” dimension to “Label” box to display state abbreviations, or “Area” dimension to “tooltips” to display on mouseover.
To display your map online, click “Dashboard” tab in the bottom-left corner.
Drag “Sheet 1” (the default name of your map) into your dashboard. Also, drag the map legend from the corner into the lower body of the map (or choose other legend options).
To publish your map online, go to File > Save to Tableau Public As… This will require you to create a free Tableau Public Account.
Modify your final online product as desired, and see options to embed elsewhere on the web.