Showing posts with label exercise. Show all posts
September 18, 2017
Makeover Monday: A Day at the Races
exercise
,
Makeover Monday
,
map
,
Mapbox
,
marathon
,
running
5 comments
Given there's also the #FitData17 challenge we thought we'd give everyone some data to play with.
I'm going to be making over my results from Strava.
What works well?
- Of course no run is good without a map.
- Including a breakdown of my pace for each mile
- Showing a timeline along the bottom and allowing me to customize the metrics
What could be improved?
- There are no markers on the map to show me where I started, ended nor any mile markers along the way.
- The table shows me my pace, but it doesn't add any value because I can't see all of the miles at the same time making spotting trends impossible.
- The line chart has three separate metrics showing, yet only one axis. It doesn't make sense to overlap three metrics.
What I wanted to learn?
- Is my 3:25 goal for Frankfurt achievable?
- Is there anything interesting in the heart rate data?
- I want to be able to compare the key metrics across the two races.
- Is hitting "the wall" avoidable?
I must admit that I need to dig into this data further in order to be able to answer these questions. However, time is running out on the day and I won't have time to look at it more tomorrow, so I'm starting with a viz that does some simple comparisons. It'll have to do for now and it certainly improves upon the original.
Click on the image for the interactive version.
Click on the image for the interactive version.
| Click on the image for the interactive version |
May 29, 2015
Dear Data Two | Week 6: Physical Contact
Alteryx
,
Dear Data Two
,
elevation
,
exercise
,
map
,
physical contact
,
routes
,
steps
,
strava
,
workflow
No comments
What an amazing week for me for Dear Data Two! The topic for week 6 physical contact and I've been learning Alteryx. The first thing I thought of was physical activity, not physical contact, so I emailed Jeffrey and asked him if he was ok with me taking such liberty on the topic. Fortunately Jeffrey was ok with my idea, but then I decided I could stick to the original contact by extending my thinking a bit.
I'm a huge quantified self data collector, which you'll likely see throughout my Dear Data Two work. I wanted to see how I could use Alteryx to help me get the data into Tableau for analysis before creating my analogue version because I feel like the best way to learn a new tool is to find a practical application. This is the first workflow I built on my own in Alteryx. It might not be the most elegant or most efficient, but I sure did learn a lot along the way. You can download this workflow here.
One of the things I have started to like the most about Alteryx is that I can push all of the complicated row level calculations that I used to do in Tableau to Alteryx, which in the end makes Tableau much faster. For example, I used to multi-row tool to calculate the distance between two geographic points recorded by my watch.
From there, I created the dashboard below to explore the data. In particular I wanted to view the maps and see the summary stats. One thing I learned is that I need to figure out a way to account for times that I paused my watch; that data doesn't appear in the GPX files.
Exploring the data Tableau helped me quantify my runs for the week, but that didn't account for all of my physical activity for the week. To capture ALL of my activity:
That resulted in this draft, which is sort of like a dot matrix:
I'm a huge quantified self data collector, which you'll likely see throughout my Dear Data Two work. I wanted to see how I could use Alteryx to help me get the data into Tableau for analysis before creating my analogue version because I feel like the best way to learn a new tool is to find a practical application. This is the first workflow I built on my own in Alteryx. It might not be the most elegant or most efficient, but I sure did learn a lot along the way. You can download this workflow here.
One of the things I have started to like the most about Alteryx is that I can push all of the complicated row level calculations that I used to do in Tableau to Alteryx, which in the end makes Tableau much faster. For example, I used to multi-row tool to calculate the distance between two geographic points recorded by my watch.
From there, I created the dashboard below to explore the data. In particular I wanted to view the maps and see the summary stats. One thing I learned is that I need to figure out a way to account for times that I paused my watch; that data doesn't appear in the GPX files.
Exploring the data Tableau helped me quantify my runs for the week, but that didn't account for all of my physical activity for the week. To capture ALL of my activity:
- I noted my total daily steps from Fitbit.
- I calculated the number of steps for my runs by taking my stride rate of 184 strides per minute from TomTom and multiplying by the minutes I ran in Strava.
- I subtracted my running steps from the total steps to get my walking steps.
- I used the time of day that I ran and roughly calculated the proportion of walking steps before and after each run each day.
That resulted in this draft, which is sort of like a dot matrix:
For the final version, I colored the dots: Blue dots represents 200 steps walking and red dots indicate 200 steps running. I rounded the numbers for drawing purposes.
You can view the images in the Tableau dashboard above as well, but note that as you're exploring the dashboard, when you click on the tabs that contain images, they will take several seconds to load. I've reported this bug to Tableau.
I really learned a ton this week thanks to Dear Data Two because I found a great use case for Alteryx. Not only did I learned a bunch of Alteryx tools I hadn't learned in the training I took at Inspire15, but I also learned how to do row-level calculations in Alteryx and how those can help Tableau performance.
March 31, 2015
Makeover Monday: What is Montreal’s Best Gym?
3D
,
bar chart
,
exercise
,
gym
,
infogram
,
Makeover Monday
,
Montreal
,
pie chart
,
workout
1 comment
In the comments to last week’s makeover, reader jorgeluis500 pointed me to this 3D pie chart that needed a quick makeover:
There are a few obvious flaws:
Here’s my makeover, a boring bar chart, done with infogram:
- It’s a pie chart.
- It’s 3D.
- The “Other” category is sorted first, when it should be last.
- Sorting “Other” first takes away from the focus of the story.
- There are way too many colors/slices.
- The amounts are repeated in both the pie and the legend.
Here’s my makeover, a boring bar chart, done with infogram:
January 23, 2014
The Victors & the Quitters: Who completed the 30-day pushup challenge?
During the first week of December, I posted a question on Facebook asking who might want to do a 30-day pushup challenge. I didn’t expect very many takers, however 33 people took on the challenge. The challenge seemed simple: 100 pushups per day for 30 days. But it wasn’t as easy as it seemed. Only 3 of 33 completed the challenge.
How did everyone do? Check out the viz below to find out.
October 31, 2012
Has you wife accused you of putting on a few pounds? Find the exercises that are right for you.
diet
,
exercise
,
facebook
,
interactive
,
sports
,
tableau
,
weight
2 comments
Earlier this week, my wife was having a conversation on Facebook about our move to California when she suddenly said “he has gained weight from the cafeteria.”
She’s was being funny. If you ever meet her, you’ll know what an angel she is quite quickly, especially for putting up with me.
Unfortunately she’s not exactly wrong. I pretended to be offended of course.
Many of us are familiar with the “freshman 15” from college. At Facebook, there’s the “Facebook 15”. Same idea. I can use the unbelievably tasty, free food and unlimited snacks as an excuse (moderation is a challenge), but I really haven’t gained much weight, maybe five pounds.
I exercise, not often enough however. I decided that I needed some help, so I build this viz to help me find the right activities for me.
Subscribe to:
Posts
(
Atom
)
