Create a Thematic Mapping API prototype for metrics data
We have been offered help with prototyping new visualizations for our metrics data. Rachel Binx suggested trying out the Thematic Mapping API (http://thematicmapping.org/) which is based on the Google Earth Plug-In (http://www.google.com/intl/en/earth/explore/products/plugin.html) for displaying how many users we have per country.
Creating a Thematic Mapping API prototype is a multi-step process:
Create a prototype that displays the data of a single date from a Google spreadsheet.
Extend the prototype to display how usage changes over time by reading an extended spreadsheet that doesn't only have data for a single date, but for, say, one month or one year.
Extend the prototype to let users customize what part of the spreadsheet data to display (daily direct users, daily bridge users, ratio of Tor users to Internet users, etc.) by making the website dynamic.
Connect the prototype to the same database that the metrics website uses to feed it with live data.
I'm going to post a link with code for item 1 in that list once I have a Trac number; see comment below. I didn't start hacking on items 2 to 4 yet.