My Annual Report 2012

I’m still recording dozens of vital statistics like alcohol, coffee, and media consumption, geographical location, sleep habits, and some others that are no one else’s business, really. For the sake of time, I’m only visualizing one of them. The graph of my coffee consumption tells an interesting story about my 2012, the year my body decided it hated caffeine:


I spend about a minute each day recording statistics on my phone and an hour each month transcribing them to Excel. That takes time. But your devices are collecting a lot of those data passively all the time. If you’d like the excuse to learn data visualization and pivot tables in Excel, here’s your assignment:

Log into your wireless carrier’s web page and download your voice and messaging data for as long as you want but at least the last two years. Then prepare the data in Excel, getting your columns uniform and labeled. Then figure out the top five people you’ve a) called or b) messaged over those years. Do they change? For extra credit, are the people you call most and message most the same people? If not, what accounts for the disparity?

Leave your work in a comment once you’re done. We’re looking forward to it.

BTW. 2007, 2008, 2009 (my favorite), 2010, 2011.

I'm Dan and this is my blog. I'm a former high school math teacher and current head of teaching at Desmos. He / him. More here.


  1. Thanks for the inspiration for my year-end report. I wouldn’t have thought to look at AT&T data without looking at yours. From that — but no surprise really — I figured out my son was my most-frequently-texted. Missing from my preso: the ratio of me texting to him replying. :/

  2. Had I done this 3 years ago, my caffeine intake would have looked very similar. Out of curiosity, does caffeine trigger headaches/migraines for you too?