Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: Qlik Gallery is experiencing slow load times. We are investigating.
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,832 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,822 Views
Raptor69
Contributor
Contributor

Will you share app source code ? kind greetz Erik 

0 Likes
1,630 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? 😍

 

753 Views