#DearDuo 11 – Walk this Way!

#DearDuo 11 – Walk this Way!

Welcome to the 11th month of our Dear Duo project.  #DearDuo has been a fun way to get to know each other and to keep practicing visualizing foreign data sets, but we only have one more topic left before we complete this project.  We hope you are enjoying follow along as we have a little fun with each other’s data.


The Data

We are nearing the end of our #DearDuo journey, but before we walk off into the sunset, we thought we’d track how many steps we are taking each day. This was an idea we had a few months ago, but Pooja had an android phone and couldn’t find a good way to get the data from that thing.  THANK GOD she finally listened to her family’s suggestion of getting an iPhone. 🤦‍♀️

Adam – This month was another lazy month (this is happening a lot 🤔) because we didn’t have to track anything manually. We downloaded the Stepz app for iOS which gave us access to all the health data that is captured by the iOS Health app.  Our data actually starts from the time we activated our iPhone 7’s. Directly from the app, I emailed myself a csv file of the data, which is really nice and simple.  For each day, we got the total number of steps, distance in miles, active time walking in seconds, the number of floors climbed and the calories burned. I’m not sure how accurate the calories burned are since I didn’t ever fill out the body measurements in the Health app, which means I guarantee Pooja didn’t either. 🤦🤦‍♀️

Pooja – Lazy month again, find an app that lets us track without having to manually track stuff. Stepz app it was for iOS (now that I finally have one) we didn’t have to find an app thats supported by both iOS and Android. The little things in life, you see. Adam as usual got a head start on the data even BEFORE I sent the file to him because the over-ambitious man that he is, he used his OWN file to start vizzzing and just conveniently REPLACED the data source when I sent him my csv that he was supposed to viz. 🤦‍♀️. He also rightly assumed above in his summary that I didn’t fill out any body measurements in the health app but I still went ahead and used his calories burnt in my viz because I am funny like that.


The Design 

Adam – I actually started working on this dashboard before June was even over.  I downloaded my own data and built the dashboard off that source.  When Poo finally sent me her data, I just replaced the datasource.  The obvious choice in chart types was using a step chart to display the steps taken by week.  I also created a heat map by weekday and week number to analyze what days Poo was walking.  I wanted to make it so you could hover over any day or week and see her stats.  I has made a dynamic call out sheet for if Poo was above or below the daily target of 10,000 steps.

I also asked Pooja to send me a live photo of her walking from her iPhone.  I used the Motion Stills app to convert the live photo into a GIF.  I then opened the GIF in Photoshop and removed some frames and slowed the animation down.  I hosted the GIF on our site and brought in in as a web page object.  I floated four png shapes over the corners to give the appearance of rounded edges.  There is also a YouTube video floated behind the GIF that will autoplay a section of ‘Walk This Way’ by Aerosmith if you are on a laptop.  This is seemed like appropriate song choice for the data set.

Pooja – So to be honest, I finished this dashboard in about 20 mins. It’s another story though that I kept fiddling with fonts, colors, placement of Adam’s photo (which he kindly sent upon request). My main idea for this viz was to use a line chart of steps he walked over time and a status bar that updates based on dashboard actions to show stats like calories burnt, steps walked, floors climbed equivalent to steps walked.

The line chart uses the lower half of his photo as a background image so I could use dashboard actions because Tableau STILL does NOT support transparent sheets 🤦‍♀️

I wanted to use the top section to show Adam’s key stats. Days when he walked the most and the least. It so happens that the max numbers steps he took was during Alteryx Inspire on June 6th 2017. He said, he stayed in a different hotel from where the conference was help so he had to constantly walk back to his room to drop off his HUGE laptop so he could go to the bars drinking with data nerds. Well, at least he walked over 10,000 steps those 3 days he was in Vegas for the conference.


What did we learn?

Adam – Well, we learned a few things about Pooja this month.

1. She didn’t carry her phone around with her all the time.  Either that or we better call her doctor and schedule an appointment immediately for her.  Experts recommend a daily target of 10,000 steps per day and  POOJA AVERAGES ABOUT 7, 430 STEPS BELOW THIS GOAL. 

2. Only 9.2% and 9.8% (approximately) of Pooja’s steps occurred on Saturday and Sunday, respectively.  I think we might need to stage an intervention for Pooja…I’m kind of worried about her, aren’t you?

.@DrexelPooja, I’m worried about you! Please check out Philly walking trails via @acrahen http://www.mapmywalk.com/us/philadelphia-pa/

3. Even in a week where the data is collected automatically, Poo found a way to compromise the data quality. I mean she knew we were tracking this data right? I’m sure I told her…carry your phone with you…🤦🤦‍♀️

Pooja – Well, more than learning about Adam this month, I learnt a lot about myself.

  1. I need to go to the Doctor
  2. I need to carry my phone even in the bathroom, how does a man who works from home have more step counts than I do?
  3. I need to listen to instructions better

Jokes apart, Adam hasn’t reached the recommended goal of 10,000 steps EITHER on most days. He reached his goal of 10,000 steps ONLY in Vegas during the conference. June 5th through 7th this year, he averaged about 11,975 steps. He walked the least on November 29th (193 steps). Maybe he parked himself on the couch after all the thanksgiving festivities 😂

We should have tracked this data probably in Vegas during the conference this year. At least my stats wouldn’t have been so embarrassing 🤦‍♀️


Thank you for following along our quantified self journey.  One more to go!  Thank you for reading, until next month!

Here are our vizzes:

Leave a Reply