Dashboard walking challenge

This morning I got involved with #100daysofwalking in twitter because of a tweet from my friend Máirín Murray.

The challenge by Dr Ciara Kelly

And suddenly I was using Power BI to analyse my walking data that I have been collecting since August 2015 with my apple watch.

I used the app Health Export to get the data form Apple Health into a CSV.

After importing it in Power BI it needed some transformations:

  • Power BI needed to have the right local settings to make sure the numbers and delimiters where read right.
  • I only want to keep walks longer than 30 minutes and more than 1 km, so I used a filter
  • When I was visualising, I noticed some doubles in the beginning, that was because at that time I would use two apps to track 1 walk to find out which app I wanted to use. So, I extracted the date and the hour out of the starting moments to use Power BI to remove the doubles
  • When I wanted to show the number of steps, it was not giving me the thousands separator so I went back to Power Query Editor to change it from a whole number to a decimal number and I got the right visualisation.

I kept the dashboard basic. Just showing a slicer from my first recorded walk (September 11, 2015) up to the end of 2020. And 3 cards that are showing the number of walks, distance walked and a step count. In the bottom there is a line chart that shows by Date the walked distance.

I published it on my Power Bi side:

Now the next challenge: how to build this in Tableau.

While importing the data I need to change the text file properties. Field separator from the automatic generated space option into a comma and the locale needs to be changed into English. And I need to tell Tableau the field names are in the first row.

The columns that I do not need, need to be removed. I can’t find delete, I do find an option called hide, will that be the same. I notice that in Power BI I removed a column more, also one that the not have values at all, this on is not loaded in Tableau.

The type needs to be filtered on Outdoor Walks,

Filter walks longer than 30 minutes. The column Duration is Date & Time all with the date 30-12-1899, so this needs to be in the filter. The Duration needs to have a minimum that is equal or bigger than 30-12-1899 00:30:00.

Filter walks longer than 1 km

Remove the double entries, noop I have no idea yet how to do this, so I have 36 entries too much and those will effect my visualisation.

Step count is already a number.

Question to me being used to Power BI, how can I recall the steps I took to prepare my data, in Power BI I can read that step by step back in the query editor.

Get 3 cards for number of walks, distance walked and step count

The filter being used is the start date and needs to be used for all using this data source

After I had the sheets, I made a dashboard, was not easy to give me the 3 cards and the filter on top, needed to choose for float.

Overtime I will learn more of Tableau dashboarding and it will become better looking

Go to my public Tableau to have a view of this dashboard.