I've been wanting to do this for sometime and today I finally got around to figuring it all out. I've never talked about where I exactly work on my blog because I've never felt the need to share that much and if I talk about it, it'll show up in everyone's Google alerts at work and then my blog will not be my little secret anymore, but that is about to change.
I work for Tableau Software and ever since I started, I've been wanting to use our free software, Tableau Public to visualize my training data from BeginnerTriathlete.com. As athletes, we all love our data and numbers and Tableau is an easy way to make cool charts and graphs and quickly analyze your data. Has my run pace decreased over the past year? What are my biggest mileage months? What is my average heart rate on the bike? These are all questions you can answer if one, you have the data and two, you use Tableau.
So I figured out how to pull all my training history out of BeginnerTriathlete.com since I began using it in March of 2010. Then I connected Tableau Public to my data and started to play around. I'm not a super-star when it comes to using the software yet, but it doesn't mean my simple line charts don't mean anything to me.
Here is a dashboard I made that shows my run pace over the past year or so and also swim/bike/run mileage over that same time period. I added in trend lines and it looks like I need to get my running on a little more to get that trending up! You can click on various points to see the exact mileage.
So I think it would be fun to revisit these every few months to see how my training numbers are looking. If you'd like to play around with your training data for free - check out www.tableausoftware.com/public and download the software.
Very cool! I am a graph-freak. I will have to check out Tableau!
ReplyDeleteCool! I am an uber numbers nerd and this is great! I log all of my stuff via google docs now. Do you know if it is possible to port a google docs spreadsheet to tableau?
ReplyDeleteAnd congrats on decreasing your run pace. That is good news! Noticed this via your awesome graph.
So something interesting I am noticing here and someone posted about this on your last post regarding your IT band. Weaker glutes can cause the IT band pain. Biking strengthens the muscles supporting the IT band, right? Is it fair to say that a decrease in biking with an increase in running might be the culprit for the IT band pain? I may be grasping at straws here....
And thanks for the link about suffering. Good article!
This looks awesome! I use daily mile, but I'm sure I could figure out a way to put it all together. Numbers don't mean nearly as much to me as seeing everything graphed out over time this way. So cool! I'm eager to hear about the implications for your training -- what, if anything, will change?
ReplyDeleteVery cool!
ReplyDeleteThat is NICE! That's the exact reason (graphing purposes) that I log all my miles in an Excel sheet. It's nice to look at things over time, isn't it?
ReplyDelete