City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 1

Visualizing Open Data with

Manjot Gill Business Solutions Analyst

Open City & Innovation

ace@edmonton.cahttp://ace.edmonton.ca

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 2

ObjectiveLearn how to use Tableau Public to create engaging open data visualizations

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 3

High-Level Agenda

➢Tableau Public Overview

➢Case Study

○ 2016 Municipal Census Data

○ Edmonton Neighbourhood Boundaries

○ EPS Crime Data

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 4

Tableau Public Overview

➢Software tool for creating interactive, sharable visualizations from a variety of data

➢Quick

➢Easy

➢Sharable

➢Free! (with some restrictions)

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 5

Tableau Public Overview

➢Web-based platform for sharing visualizations created with Tableau

Public software

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 6

Tableau Public vs Tableau Desktop

Tableau Desktop Tableau Public

Platform Desktop (Windows/Mac) Desktop (Windows/Mac)

Pricing $999 USD for Personal

$1999 USD for Professional

Free

Features Save locally or publish to the web

Connect to: Google Sheets, Excel, CSV,

oData, most databases

No data source size limits

Publish to the web only. Workbooks and data

are freely accessible to the world.

Connect to: Google Sheets, Excel, CSV, OData,

Data sources have limit of 1 millions rows.

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 7

ActivityCreate a Tableau Public Accounthttps://public.tableau.com/

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 8

ActivityDownload and open an existing workbookhttp://public.tableau.com/profile/city.of.edmonton#!/vizhome/EdmontonStrathconaSt_AlbertSchoolExplorer/SchoolExplorer

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 9

The Tableau Workspace

Marks card

Measures shelf

Pages shelf

Colour legend

Dimensions shelf

Pills

Columns shelf

Rows shelf

Data window

Worksheet

Filter

Size legend

Filters shelf

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 10

Anatomy of a Tableau Workbook

Story (contains a sequence of worksheets or dashboards)

Dashboard (contains one or more worksheets) Dashboard (contains one or more worksheets) Dashboard (displays one or more worksheets)

Worksheet(where you create visualizations)

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 11

Case Study▷ EPS Crime Data

▷ Edmonton Neighbourhood Boundaries

▷ 2016 Municipal Census Data

For each step

1. You’ll be shown how to do it

2. You’ll have additional time to complete the work yourself

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 12

Key Concepts

➢Connecting to text files and oData

➢Text tables, bar graphs

➢Mapping co-ordinates and polygons

➢Data blending

➢Subtotals

➢Number format

➢Calculated Fields

➢Filters

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 13

Case Study Manual:

http://bit.ly/iods2017

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 14

Case Study - Step A

Connecting to a text file

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 15

Case Study - Step B

Creating a text table

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 16

Case Study - Step C

Adding subtotals

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 17

Case Study - Step D

Creating a bar graph

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 18

Case Study - Step E

Adding a filter

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 19

Case Study - Step F

Displaying a value by colour

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 20

Case Study - Step G

Connecting to a text file

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 21

Case Study - Step H

Mapping coordinates

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 22

Case Study - Step I

Mapping polygons

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 23

Case Study - Step J

Blending data

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 24

Case Study - Step K

Displaying a value by colour

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 25

Case Study - Step L

Connecting to oData

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 26

Case Study - Step M

Creating a calculated field

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 27

Case Study - Step N

Blending data

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 28

Case Study - Step O

Creating a calculated field

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 29

Case Study - Step P

Displaying a value by colour

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 30

Case Study - Step Q

Adding a filter

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 31

Case Study - Step R

Creating dashboards

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 32

Case Study - Step S

Publishing to Tableau Public

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 33

Q & AUse this time to ask questions and further explore the data

City of Edmonton | Financial and Corporate Services | Open City and Innovation Branch 34

Thanks!More questions?

Reach our team at ace@edmonton.ca

Check out our work at http://ace.edmonton.ca