Open Hamilton: Google Fusion Tables Workshop

Register here: http://openhamilton1.eventbrite.com

Want to create open data? Want to be a data visualization superstar? Want to learn new efficient ways of managing data?

Join Open Hamilton for our first workshop:

“Using Google Fusion to understand data”

The timing for the course is:

Wednesday May 25
7pm – 9pm
Think|haus
25 Dundurn St N, Hamilton

The workshop will teach how to take a City of Hamilton financial spreadsheet and create visualizations of the financial figures.

The dataset for is the City Council expense spreadsheets for 2008 and 2009. (The 2010 figures are not yet available

The data provided by the city is in their “raw” ledger format which includes Excel macros and formatting.

Learn how to take this data and visualize it as open dta.

The steps being taught are:

1) Conversion of data from Excel into a machine readable CSV
2) Cleaning of financial categories using Google Refine
3) Modification of the spreadsheet into lines of data using tools provided Stanford University’s data visualization lab
4) Importing into Google Fusion Tables
5) Visualization using Fusion Tables
6) Uploading into a cloud server for use by others via API

Registration for the course will be limited to 20 people and there is no cost for attendance.