Crowd sourcing a Runkeeper dashboard
Getting healthy, we all want it. Running can be a way to get in shape, but running alone is not enough. A lot of runners use their smart phone or wearables to get insight into what their running activities look like. But does this give you all insights you would need to improve?
I would like to explore this question with the Qlik Community. Who is in for a challenge?
Good. I was already hoping for that answer 😉
With this post I will provide a runkeeper dashboard application build in QlikView 11. What I want to ask you guys is to help me to develop all insights that runners would need to gain the insights they need. This is a screenshot of the dashboard. Have a look at it:
Now, what I would like from our community is some requirements for being able to come up with a really nice ‘crowd sourced’ solution. This could then be distributed to people who would like to really analyse their running data. And YES, I will credit all people who influenced the final design in our solution when we launch it.
But to be able to come up with some relevant requirements, I know you guys want to have a look at the table and field structure first. So here we go:
Table: Runs
Fields:
Run_ID: Is the unique ID of the run RunDate: Is the date of the run AveragePace: Is the average pace of the run AverageSpeed: Is the average speed of the run CaloriesBurned: How many calories were burned during the run Climb: What elevation was climbed Distance: The total distance of the run Duration: The duration of the run Type: Type of the activity (Running / Cycling / Etc.)
Table: RunDetails
This table gives the full details for a Run_ID from the ‘Runs’ table. Runkeeper measures an interval every few seconds. This is what is defined as a measurement in the following table.
Fields:
Run_ID: See Table 'Runs' Date_ID: Same as RunDate Distance: Distance for a measured interval between two GPS coordinates ElapsedMinutes: Accumulated minutes from the StartTime till current measurement ElapsedTime: Accumulated time from the StartTime till current measurement ele: Elevation for current measurement lat: Latitude coordinate for current measurement lon: Longitude coordinate for current measurement OrigTime: Current DateTime stamp Pace: Pace for the current measurement PreID: ID of the previous record PreLat: Latitude coordinate of the previous record PreLon: Longitude coordinate of the previous record PreTime: Accumulated time of the previous record RowID: ID of the measurement StartTime: Starttime of the run time: Recorded time of the measured interval
I think if you guys come up with some inspirational views, features and/or requirements, we could together create a wonderful app.
I’m looking forward for your comments / requirements on this post. QlikShow now has around 100 subscribers who will get notified of this post. I think we could at least come up with somewhere around 25 comments with requirements, right?
For people who want a more detailed ‘deep dive’ into the app, here it is.
Have fun helping me! 😉
Note: You could also load your own data. Just download your data from runkeeper into a folder ‘Export’ that should reside in the same directory as where you saved this application. Then reload it to see your own data. Consider it my Christmas gift from me to you! Oh and… Lots of work already went into this solution by Me and Michael Anthony. Just so u know…
Hi Patrick, I’ve done up a Qlik Sense application based on RunKeeper data, Garmin data and various Excel sheet formats to report activities I was tracking to prepare for an half Ironman.
I have stopped using RunKeeper but I really liked some of the reports that they provide after a run. For example, this is your 4th fastest 6 to 10 km run out of 210 runs… I had asked RunKeeper directly about getting more data points from them but they either didn’t understand me or simply refused. But as you already know, the information is summary data.
Also, as a runner, you need to classify your runs. Was this an ‘easy run’, ‘tempo run’, ‘interval/hill workout’ or race? Because you need to compare apples to apples. I like the look of your app. I’ve downloaded it to see if there is anything I can borrow for mine.
Feel free to contact me and I’ll share my Sense app with you.
Hi Peter- I have been currently trying to find the right tool to use to get better insights from my training as well. Garmin connect does a poor job. I’ve looked at Srava as well. I have been learning Qlikview and Qliksense I would be excited to see how you mending the various inputs into a dashboard.
Peter, Thanks for your response. I think those stats you mentioned are really nice indeed. There is a way of calculating those stats out of the data that you download from runkeeper.com.
You are right, that wasn’t a good example. Other things I like are seeing the individual lap times (kms or miles) associated to elevation change. Since we only get summarized information, we can’t break down the run. I noticed in your app that you had brought in the gpx data but hadn’t used it. Were you planning on building some maps? I’ve not had time to play with that data yet.
Peter, I have some apps on this data already, but in this version I kept it out on purpose. I just want to be able to see what other experts would like to have in an application with this runkeeper data. And sure I was planning to bring in some maps. I hope people will help me on this and post their requirements in this thread.
Maybe something with training/goals. Kind of budget and actuals ;-). You can file it with Excel or make a intro page with variables like ‘On a X times a week schedule’ or ‘X slow/fast runs’ or ‘X KM’s this week’?
It’s interesting to see how I do ‘fast runs’ through the year and my development on this matter. What do you think?
I think you have some nice additions for the app to progress on. Examples are welcome btw 😉
I am still hoping for more comments and requirements in the comments of this post btw… Come on guys, lets discuss this 😉
Hi Patrick. Yesterday I’ve downloaded the Runkeeper.qvw and I have to say: It definitely gives me a better insight in my runkeeper activities progressing.
The ‘Runs over Time’ gives although a little bit a misleading view of my fastest runs. For instance, I can’t see my fastest 10 runs with distances of more than 10 km. A slider will help by setting a minimum/maximum of running distances.
The ‘Latest 7 runs’ numbers gives a good insight in your progress as well. Yet the differences on the right for ‘Distance’ and ‘Avg. Dist.’ should be reversed (now I get a -0.2, while the distance was more).
Then I have some nice addition: 🙂
– Bringing some (google) maps would be a very nice addition in the dashboard. I would be pleased to see my favorite routes in a map (although that might be difficult to make!?
Thanks again for this article an keep going posting! 🙂
Hello Patrick
I’ve realized last week a runkeeper application for Qlikview.
I didn’t your post before!!!
You can see on qlikview community
see you
Love the app. Thinks I look for when analyzing training is comparing like runs (ie tempo runs, so having a descriptor of type of run would be a plus), weekly totals, snap shot of last run (pace, time, distance, hr)