Dots on A Map

Deploying an interactive point map.

Branden DuPont

Data Analyst

Medical College of Wisconsin

Institute for Health Equity

Who I am. What I Do.

• Data Analyst
• Law Clerk
• Expertise: analytics in criminal/civil justice with a spatial emphasis
• Tools I use: Postgres, SQL, QGIS, Python, and Tableau

Overview of  Presentation and Workshop

• Why Tableau
  • General overview
  • Examples
• Geocoding
  • Geocoding process and considerations
  • Tidying data
  • Using a bulk geocoder
• Create a Point Map in Tableau
  • Import data
  • Dots on a Map
  • Add Mapbox map
• Cartography Notes

Tableau

Brief Intro

• Drag and drop data visualization tool
• Connect to almost any database/data type
• Easily build 80% of visualizations needed
• Deploy online quickly

Examples

• Simple choropleth map
• Bivariate Choropleth map
• General Point Map (LSL)
• Advanced point map
• Simple point map

Why Tableau

• price
• learning curve (Arc, Coding)
• power
• customization (80-20)
• data migration
• collaborative
• mobile friendly
• Use in academia and industry (CDC, Local Health Department, CDC again)
  • avg pay analysts 70k, developer: $56 hour, 108k)

What Tableau Isn't

• Not for high-level statistics e.g. spatial autocorrelation, ML
• Not for geo-processing e.g. distance calculations or spatial joins
• Not great for static viz or maps

Create a Point Map

Items Needed

- Tableau Downloaded

- Tableau Public Account

- Mapbox Account

- Geocodio Account

- Spreadsheet: Excel, Google Docs, Libre Office

- City of Milwaukee Open Data Portal

Visualize Vacant Buildings in the City of Milwaukee

Housing = Key Social Determinant of Health

• Get data
• Clean and structure data
• Geocode addresses
• Import data
• Visualize in Tableau
• Add a basemap

City of Milwaukee Data Portal

 

Geocoding for Viz Basics

- Get coordinates for street addresses

- Juan Shishido general geocoding process:

- identify purpose

- choose geocoder

- preprocess data

- geocode

- verfiy output

- import to viz tool

Import and Visualize in Tableau

Mapbox Basemap and Publish Results

Cartography Notes

Design Elements

• Use brand guidelines if they exist
• Use color consistently, search for color guides
• More than 2 colors use a light or dark basemap
• Stick to 5 colors max
• Consider icons