Mapping Canadian Postal Codes in Tableau

A recent training attendee asked for assistance with mapping Canadian customers by Postal Code. Tableau can do this, but you must complete two steps before mapping data at the Canadian Postal Code level.

1) You will need a data file with location details by Postal Code. Specifically, you will need a list of Postal Codes by latitude and longitude. It should look similar to this detailed custom geocoding example:

Country (ISO 3166-2),Country (Name),PostalCode,CityName,CityType,ProvinceName,ProvinceAbbr,Latitude,Longitude
CA,Canada,E3A 1A4,Fredericton,D,New Brunswick,NB,45.97771,-66.67843

At a minimum, you will want the data to contain:
PostalCode,Latitude,Longitude
E3A 1A4,45.97771,-66.67843

If you already have Postal Code data in your organization, you simply need to save it as a well formatted CSV file. Here is a sample I built using data from ZipCodeDownload , which sells detailed zip code data files. I used their sample in my example .CSV file. The full data is $100. Note, Freakalytics receives no compensation from this zip code company nor have we verified the accuracy of their data. There are many competitors selling similar data that you should review before selecting the best data provider for your needs.

2) Once you have the location details CSV file, place it in a Windows file directory for all of your custom geocoding files used in Tableau. Open Tableau, connect to a data source and then import the custom geocoding CSV file (Data -> Geocoding -> Import Custom Geocoding).

Once the import is completed, you can now use any data source with Postal Codes, simply associate the data item with the custom ceodcoding by right-clicking the data item from the Dimensions pane, select Geographic Role -> Postal Code. Data items at the Postal Code level is now available for mapping! You can download my sample workbook from Tableau Public below. Note that packaged workbooks contain the imported custom geocoding created by you.

Powered by Tableau

Share the power of R shiny apps across the entire team with YakData
The team at Freakalytics has built YakData brightRserver, our new cloud platform.

Securely share R shiny apps
Develop R shiny apps
All on one dedicated, secure and powerful platform.

Subscribe and keep in touch with us!