Paint Sticky Data (Please)

I'm into info. I want it accurate, relevant and clear.

On the radio, we try to paint clear, understandable, and journalistically-sound images of the mind -- the vivid mental pictures you see while listening to good storytelling.

Actual images can tell rich stories, too. The best photojournalism certainly does. Some pictures hit you in the chest.

But images drawn from data -- infographics, or visualizations -- rarely tell a story so well.

And they almost never hit me in the chest.

Why not? With all of the technology available, why can't we create really good visualizations that project understanding, timeliness, utility and ... dare I say ... stories?

I'm on the lookout. And I'm defining what I want to see.

For that definition, I've made a checklist based on one of my all-time favorite books, Made to Stick, by Chip Heath & Dan Heath (Random House, 2007). The initial words come from their Six Principles of Sticky Ideas; the rest is my application of their concepts.

For me, the best information images are ...
Simple: Non-geeks can absorb it within a few seconds
Unexpected: It fills a gap in our knowledge
Concrete: It takes advantage of our senses and understandings
Credible: It is journalistically sound, from a trusted source, without bias
Emotional: It hits you in the chest, you feel the data
Story: It tells one
And I'll add one more:
Relevant: It is timely, current and useful
Got examples that ring all seven bells? Maybe even four? Share them in the comments here or email me: john (at) designAgitator.com.

-----

The map detail above is from my favorite example at the moment, which is on Slate. Jump over there, take a look, and then run it through the checklist:

Simple? Once you know that blue is jobs gained and red is jobs lost, you're set. Just press play.
Unexpected? Seriously so. The speed of change is amazing.
Concrete? The familiar map orients me at a glance; I respond quickly to the circle sizes, colors and densities.
Credible? Bureau of Labor Statistics, Slate.
Emotional? Oh yeah. I saw someone actually shiver while watching it.
Story? Definitely.
Relevant? Yup.
Rings my bell.

Rapid News Visualizations: Prototype 1

In my quest for timely, interesting, understandable info-graphics, I've set up a prototyping challenge for myself: Upon finding news data, turn it into something visual, compelling and useful ... as fast as possible.

I'm prepared to fail quickly and often.

In this case, "as fast as possible" was three days to make, another two to find time to post it. The result is not wholly useful. And you can't absorb it quickly. And it's a little misleading.

But it's a start.

Here is what I made. It's a visual representation of the attendance rates for every public school in New York City on Thursday, May 21, 2009. The New York City Department of Education started posting this data the previous day as the Swine Flu/H1N1 outbreak was causing kids to stay home.

It tells me two things off the bat:
1) Queens and Brooklyn schools had much lower attendance rates than Manhattan and Staten Island schools.

2) Teens skip school on nice May days.
No. 2 is apparent because almost every red square is a high school, which have notoriously low rates this time of year. For a better indication of potentially flu-related absences, I'd chart the difference between these absentee rates and a typical May day at each school ... which is info I don't have. Yet.

Initially I published this in Google Maps, which was interactive and allowed you to click on schools for specific info. But Google Maps only plotted about 100 or so schools, and there are more than 1,000 here. Instead, I did it in Google Earth on my own computer and took a snapshot. Here's another.

Kinda cool. Was fun to do.

Next!

----------

Anatomy of the process:

Daily absentee data from the school system is here.
An Excel spreadsheet with general data on each school is here.
I crossed these two data sets in Access to match school numbers with addresses.
I got the latitude and longitude for each address, in 500-line batches, here.
I spent a lot of time learning about KML files, writing them, failing, trying again.
I made colored icons in Photoshop, and used Excel to assign each school the correct icon.
I put all of the relevant data into one spreadsheet and fed it to this little helper ...
Which gave me this KML file ...
Which I fed to Google Earth, running on my Mac.

Feeling Information

Information and raw data are piling up faster than our ability to absorb it. And the tools available to access, understand, visualize and feel that information are woefully inadequate.

I believe journalism, design thinking and information technology can be wielded to express these stories in ways never before considered. And I'm part of a small posse poised to do just that.

If this interests you, or if you'd like to join our rag-tag group, write me: john (at) designAgitator.com.

In the meantime, assume some of the gaps in designAgitator postings mean we're hard at work helping to explain the world(!)