Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
daveelliott
Luminary
Luminary

The challenge

Garmin have a great website, full of nice visualisations of activity and a mobile app where you can view tracked activity data.

That's great, right up to the point you want to compare two activities, here it falls down. Other than seeing high level stats side by side, you cant.The solution

Build my own analytics tool to allow me to compare not only statistical data, speed, stroke rate, distance, etc.. but look at the actual GPS trace of the route.

Using a 'free' desktop version of the platform we have adopted to form the front end to our Insights platform, Qlik Sense and activity data downloaded from Garmin Connect I wanted to see how I could visualise the data and build something which gave me what I wanted.

Read more detail here on my blog:  www.Analyticsandthings.com

Qlik Gallery - Activity Trackers.jpg

4 Comments
mvisconte
Contributor II
Contributor II

That's really neat.

Did you find a way to extract Stroke from the Kayaking data?  I imagine that it would be a ton of inertial data that needs to be reduced, and probably tied to GPS in order to sort out "resting/gliding" from "sitting in the sun relaxing stating at a turtle on a log" type of activity.

 

Inertial.  So much data, so much info.

1,491 Views
daveelliott
Luminary
Luminary

Unfortunately, Garmin don't provide stroke rate in any of the extracts from Garmin Connect.  There is a limited set of data available, only individual activities can be exported, no nice (free) hobbyist API like FitBit.  The best I can get is speed, which is tied to the GPS.  From that I can determine which points are relaxing / stationary activity vs actual 'paddle' time.

0 Likes
1,481 Views
Raptor69
Contributor
Contributor

Will you share app source code ? kind greetz Erik 

0 Likes
1,289 Views
ExperiaCare
Partner - Contributor II
Partner - Contributor II

Amazing stuff! I'm actually working on a similar project. I've got a Garmin watch and find the Garmin application a bit limited in terms of visualization. 

Would it be possible to share the qvf or the source code? 😍

 

412 Views