Friday, November 9, 2012

Market Basket

Slowly working through some Tableau Table Calculations to see if I can visualize market basket phenomena without a self-join. Along the way, I keep coming up with these wacko viz types... stay tuned.

Friday, August 31, 2012

USA Un-insured rates and statistics

The map below is of course an interactive viz. The rest of the tabs are web pages from the census website which describe the sampling methods, the field names, etc.

Relatively depressing information, overall...

Tuesday, August 28, 2012

Summer Olympics 2012 Medal Search

Thursday, August 9, 2012

Seattle 911 Calls 2011-2012

Step 1: Enter a Seattle address to see 911 calls near that address

Over two years ago I created a thematic map of Seattle Crime data, here. Well, a lot has changed since then. The details of 911 police calls and sometimes incident reports are available from the Seattle Police Department directly, so I decided to create a full blown interactive map to explore the data. Since the department does not report on postal codes or anything other than their district data, I had to implement a google address lookup using javascript. The result is that you can your address and see 911 calls with NNN miles of your specified location.

When you drill into a particular 911 call, look for the blue link in the tooltip to the incident report. This will take you to a Seattle Police website where once registered, you can pull up the incident report. If you get "no report available" it means no report was filed for the 911 call - this is a very normal result.

View source on this page to see the code I used to trigger the call to the Tableau viz. On the sending end, I used the google maps API to retrieve the latitude and longitude given a street address. On the receiving end inside of Tableau, we have parameters for latitude and longitude which can receive input from the URL. Finally, we have a mercator equation which allows you to specify a desired distance from your original address (download the workbook to see that calc).

Thursday, July 12, 2012

Adobe Kular Project

I'm basically colour-blind, or pretty close to it, so I was pleasantly amused when I found out about the adobe "kuler" project. Combined with the fact that Tableau supports custom colour palettes - both discrete and sequential - I was able to put together the workbook shown below. Enjoy!

Tuesday, July 3, 2012


Aaaaaaannnd, we're back!

I took so much time off from Tableau stuff that I had to go back and bone up on my table calc-ing. I've put together a collection of "statistics" type calculations. Some of these are Tableau classics, some of them are mundane, some are newish, and some of them are downright stupid and not recommended (which is of course why I created them)