8 Comments

Summary:

A new open source tool called RAW makes it remarkably easy to visualize any data that you can copy and paste from a table. Football on my mind, I chose to look at the performance of NFL quarterbacks so far this season.

QBs bubble copy

There’s a new web tool called Raw that makes it really easy to do some advanced visualizations on data in just a few minutes. (Hat tip to Nathan Yau of FlowingData for pointing it out.) The way it works is pretty simple: You paste data from a table (this can be a spreadsheet or even a web page), choose from a handful of visualization types (Raw explains what each one is best for) and then drag the variables you want to analyze into the predefined mapping categories (as you can see below, it’s really self-explanatory). Then you download it as a vector, PNG or JSON file and do with it what you will.

raw screen

The only drawbacks I found are that the charts can get a little crowded, data points cross the outer border and get cut off, and if there’s a way to label the axes, I can’t figure it out. But, hey, it’s an early version of an open source project (from the DensityDesign lab of the design department at Politecnico di Milano), so there are still kinks to be worked out.

Anyhow, I have football on my mind for some reason (even though I’m not that big a fan), so I thought I’d visualize some NFL quarterback data. I initially copied and pasted the statistics from a webpage showing them — and it worked just fine — but then I realized I also wanted to sort players by division, so I pasted the data into into Excel, added a column and then repasted into Raw.

Here’s one chart I came up with. The X axis is passer rating, the Y axis is touchdowns, the colors represent the division the quarterback plays in, and the size of each bubble is proportional to the number of interceptions.

QBs(1) copy

Peyton Manning is good; his brother is not (at least this season).

In this chart, I organized the bubbles by division, then compared within each one. The size is proportional to touchdowns, while the color is proportional to interceptions (generally speaking, red and brown are excellent, green is really good and purple is bad). I could have used metrics like passer rating or passing yards here, but there are too many distinct numbers all clustered close together, and they’d each get their own color.

QBs bubble copy

Finally, for good measure, here’s a non-bubble chart. This probably isn’t the ideal use for what’s called a “dendrogram,” but it actually does result in a nice, simple visualization of passer rating broken down by each division.

QBs rating copyAs someone who likes to experiment with datasets I find and incorporate visualizations into stories even though we have about .00001 percent the statistics and visualization budget of a publication like the New York Times, I’m pretty stoked to have another tool in my arsenal.

  1. Perfect BloggersTech Tuesday, October 8, 2013
    Share
  2. Nifty… although Blaine Gabbert’s dot is too big. Trust me, I’m a Jags fan.

    Share
    1. LOL from a fellow Jags fan!

      Share
  3. Our visualization process is in Seconds ;-)

    Share
  4. Reblogged this on I Au Matu and commented:
    Niiice!!!

    Share
  5. Reblogged this on BI Tools and Technology and commented:
    Need to play around with this tool some more, but from what I can tell, it looks to be very interesting. A nice, quick way to be able to vizualize the data you already have on hand

    Share
  6. This is almost more confusing than just looking at things on Excel. Maybe because I don’t have too much data to work with?

    Share

Comments have been disabled for this post