logo

Tableau Public: Connecting to Open Data

This tutorial outlines how to use data from Edmonton’s Open Data Portal (http://data.edmonton.ca) with the free visualization tool, Tableau Public.

1Ensure you have installed Tableau Public on your computer. You can download it for free from http://public.tableau.com
2Using your web browser, navigate to http://data.edmonton.ca:
3For this example, we will be using the Spray Parks dataset. Type “spray parks” into the search box and hit enter. The first item in the results list should be the Spray Parks dataset:
4Click on the dataset name to load the page in your web browser and then click on the export button to view all export options for this dataset:
5Under the export options (on the lefthand side of the window), click OData and copy the URL that is displayed there:
6Open the Tableau Public app and click OData in the Connect options:connecting to open data 5
7Paste the URL you copied from the Open Data Portal in step 5, and click OK:connecting to open data 6
8Tableau Public will load the data and show you an overview. Click the Sheet 1 tab to go to your worksheet:connecting to open data 7
9When the worksheet loads you’ll see your data fields on the lefthand side, separated into┬áDimensions and Measures:connecting to open data 8
10Drag Latitude from Measures to the Rows shelf:connecting to open data 9
11Drag Longitude from Measures to the Columns shelf. You should now see a single map point centered around the Edmonton area.connecting to open data 10
12Drag Name from Dimensions to the Detail shelf. This will create a point for each unique spray park name:connecting to open data 11
13Drag Name from Dimensions to the Label shelf. This will label each point with a name:connecting to open data 12
14Finally, drag Type from Dimensions to the Color shelf. This will colour each point based on whether it is a Spray Deck or Spray Park:connecting to open data 13
15You’re done! In just a few short minutes you’ve successfully connected to a dataset, mapped it, labelled it, and added colour to differentiate data characteristics!