The fun continues: Spatial Analytics, Table Calcs, Presentation Skills and Advanced Mapping

by Pablo Sáenz de Tejada

Our week number 5 in the Data School has just finished and it was a very complete one. As I wrote in a previous post, we started the week with a beginner level training in Spatial Analytics with Alteryx and Tableau, completed on Tuesday with advanced training in the same topic, both realized by Chris Love. During these two days we also started to work in our projects for this week: Use data from the Moves App (an app that tracks are your movements, steps, location, etc) to create a viz based on what we learned from these Spatial Analytics sessions.
Also during Tuesday, Tom Brown (founder of The Information Lab) gave us a master class to improve our productivity both in our work and personal lifes. And the day ended with all the school attending the first Tableau Public Meetup realized in London, where Andy, Niccolo and myself presented some visualizations that we made during the last weeks (thanks again to Sophie for giving us the opportunity to present our work!).

During Wednesday we received an amazing class from Carl Allchin about table calcs that continue during Thursday with two classes focused on making good visualization skills (also by Carl) and effective presentations skills (by Brian Prestidge). The week ended with Tableau Zen Master Craig Bloodworth teaching us about Advanced Mapping in Tableau (Custom Geocoding, background images, etc.) and he also explained us some awesome tools to improve Tableau’s Mapping capabilities.

And finally, the week ended with our project presentations. In comparison with my second week project, this time I decided to keep it simple in Alteryx:

As you can see in the image above, the workflow starts with some formula tools to prepare the data from the Moves .kml file (if you use this app, you can download your on data here), some text to columns tools to divide the information, additional calculations to have all the time information in minutes and add a duration calculation between each points, and finally splitting all the lines to points and get the latitude and longitude data. Once I got the Tableau extract file, it was time to start with the dashboard:

Moves Dashboard 01

In the dashboard, you can select a day in the calendar to see all my movements in the map and the daily activity information updated. Also, if you select a concrete type of activity in the bottom right table (with some table calcs measures to give additional information, like steps per km, or steps per minute), it will filter the map so you only see that concrete activity during the day selected. I add a “distance traveled” bar chart at the top right, that it’s highlighted when you select one day in the calendar, with the percentage of running total in the background. And finally, in the map, I use the hour of the day to add colour to the route, so it’s easier to see my location during the different hours of the day.

To complete the project, I make another dashboard with some data of my FitBit Surge. Using the service IFTTT during the last month, I save my daily summary of my activity to Google Drive, and connect that data to Tableau to blend both databases by date so I can combine the number of steps from my Moves data with the calories burned and sleep hours of my FitBit and create two scattered plots:

Moves Dashboard 02
As in the previous dashboard, you can select any day (point in the scatterd plot) to see in the map that days route. Both scattered plot are highlighted, so if you select one day in one of them, the same day will be highlight in the other one. Last but not least, I coloured the days by the number of very active minutes (data also available in my FitBit daily summary) and use the total distance covered that day in size.

You can see the complete and dynamic visualization in my Tableau Public Profile. I hope you like it!