Get Posts by E-mail

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.

5 Responses to “My Annual Report 2012”

  1. on 04 Jan 2013 at 8:02 pmAudrey

    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. […] apparently a math teacher thing, too, because Dan also likes data for data’s […]

  3. on 05 Jan 2013 at 9:26 pmJeff Layman

    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?

  4. on 09 Jan 2013 at 4:22 pmTina C

    Thanks for the push to go big, I could only get 17 months of data from AT&T but it was enough to be interesting.
    I assign a mini version of this as a project where students only collect data for the days they are on winter break.
    My report:

  5. on 26 Jan 2013 at 8:24 pmBethany

    I’m guessing you’ve seen this before, but in case you haven’t…
    A tool for those people wishing to track and quantify life’s many interactions and tasks. This might be a useful tool for you.