December 25, 2012
Last night, Mark Sanchez turned the ball over five times, continuing a disturbing trend over the past two seasons. He now has a league-leading 24 turnovers this season (17 int, 7 fumbles lost) and 50 over the last two seasons combined. In his first two seasons, Sanchez turned the ball over just 37 times.
Corked followed this up by publishing this chart on Business Insider’s Sports Chart of the Day.
I thought “Wow, Sanchez really is terrible!” But I’m an Eagles fan, and we know terrible football. This got me thinking about Michael Vick. He was absolutely HORRIBLE turning the ball over the first few weeks of the season before he got a concussion and hasn’t played since.
In Cork’s chart, Vick is at #11, but he’s only played a full season in the NFL once. So far in 2012, Vick has 19 turnovers in 9 games, for a turnover rate of 2.1 per game. This puts Vick at #2 on the turnover rate ranking ahead of, you guessed it, Mark Sanchez.
What this should tell you, as it did to me, is that Cork’s chart isn’t normalized. Sanchez has played more games that Vick at a slightly lower turnover rate, so of course he’s going to have more turnovers.
I decided to look into this farther and gathered data through week 15 from Pro-Football-Reference.com and built this viz. (Download the data here.) BTW, if you ever need pro football data, this is by far the easiest place on the internet to find what you’re looking for.
I started with turnovers, as Cork did, and if you sort by Turnovers on the right, you see that Sanchez is now third on the list, granted he was benched for week 15.
Change the sort to Turnovers per Game and Sanchez is now sixth. Rex Grossman is first in turnover rate. No wonder he hasn’t played this year.
It was important to me to also look at win percentage to see how turnovers might correlate to winning. Change the sort to Win % and you can clearly see that those QBs at the top (the best winning percentages) have very low turnover rates, Andrew Luck being the exception, but he has seven game winning drives this year, which is a crazy number.
You can explore the relationship between turnovers and win % a bit deeper on the 2nd tab (Win % vs. Turnovers).
I chose to use a lollipop chart for these first three views. I could have chosen a dot plot, but I wanted to emphasize both the end point and the length of the bar, but I didn’t want to clutter the chart too much with a bar chart.
I then wanted to see how who has improved or regressed from last year. We do have one game less, so take that into consideration. This view confirms that Sanchez is worse this year from a turnovers perspective: 28 in 2011 in 16 games and 29 in 2012 in 14 games. Not good Mark!
For this view, I chose to use a bar chart for 2012 with 2011 as reference line. But it’s not really a reference line. It’s a dual axis chart with 2011 as a Gantt bar. For me, this view works because it gives me a quick comparison between the last two seasons.
I finish the viz off with a dot plot comparing fumbles and interceptions, each of which you can sort by on the right. Ryan Fitzpatrick threw 39 interceptions last year…39! That’s really hard to do.
I chose a dot plot for this view because I wanted an uncluttered view of two measures on the same chart, and I was only concerned about their relationship to each other, not their length.
There’s an immensely larger number of analyses you can perform on this data set. I’d be curious to see if anyone can find any hidden relationships. Give it a shot and post a comment if you find something useful.
December 14, 2012
Tufte says “Pie charts are bad and that the only thing worse than one pie chart is lots of them.” Well, I think pies inside donuts and lots of them is even worse.
In the spirit of thrashing incredibly crappy visualization, I thought I’d run a data viz contest. The goal is simple – redesign this visualization from the Guardian.
Download the data here. I have transcribed the numbers exactly from the Guardian’s “viz”, so don’t shoot the messenger if the numbers don’t seem to quite add up to 100% in some cases.
I hate rules, but it seems like this contest probably needs a few.
- Deadline: December 31, 2012 @ 11:59pm ET (assuming we all make it past December 21st)
- Email me your submission or a link to it here.
- One entry per person. Send me more than one and I’ll ignore your entries.
- I don’t care what tool you use. It’s your choice. Draw it on paper if that’s your preference. Using Tableau will NOT give you an advantage over others.
- Judging is based solely on my personal opinion of your design. If you’ve been following this blog, then you probably have a good feel for what I like, and maybe more importantly what I don’t like.
- The winner will receive an embroidered Facebook zip up hoodie. Retail value $750. Facebook swag is priceless so I may be over exaggerating a bit.
- The winner will be announced sometime in the first two weeks of January.
Good luck! Hopefully this doesn’t turn out to be a disaster (and don’t complain if you don’t win).
December 4, 2012
Namit Raisurana delivered an incredible presentation at TCC12 in San Diego. I may be biased as a Facebook employee, however, his session was, without a shadow of a doubt, THE BEST customer presentation I’ve seen in the three conferences I’ve attended.
Watch the full presentation below. Enjoy!
Video streaming by Ustream