Peloton Tableau Connector (Home Page)
This is was a Tableau Web Data Connector for visualizing your personal Peloton cycling data inside of Tableau. Unfotunately if seems that Tableau Public no longer supports Web Data Connectors. Feel free to fork this repo if you'd like to run it yourself.
DISCLAIMER If you've come here looking for good, clean, idiomatic Go code, this is not the repo you are looking for. Move along ...
This has had been live and in use by several Peloton and Tableau enthusiasts since Jan 2021. No breaking changes have been introduced, nor are they currently contemplated.
Unfotunately if seems that Tableau Public no longer supports Web Data Connectors, so this is no longer available publicly. Feel free to fork this repo if you'd like to run it yourself.
This initial version is aimed only at cycling classes. I built the schema such that I could analyze my personal record ("PR") trends. For example, do I PR during certain times of day, or days of the week, or with certain instructors?
Therefore, there's only one table right now, called Workouts. It provides one row for each completed cycling workout. The raw schema can be viewed here.
As feedback rolls in, more fields and tables may be added.
At this time, the only way to run this locally is to build and run the lightweight Go executable. No storage is used, and this is completely stateless, meaning it can be shut down and started up at any time.
The instructions here are for Mac, tested using
go1.15.2andTableau Desktop 2020.3.
If you do not have Go, or have a version older than go1.11, get it or update it. As usual with Mac, the smoothest way is using Homebrew. However, you can also install from the official Go website.
brew install gogit clone https://github.com/weissleb/peloton-tableau-connector.git && cd peloton-tableau-connectorThis is a one-time task, unless you want to pull any updates using
git pullfrom inside the repo's directory.
Download the dependencies and build the executable.
go mod download && go build -o wdc github.com/weissleb/peloton-tableau-connectorThis is a one-time task, unless you'll pulled any updates from the repo using
git pull, and would like to build the connector with those changes.
Set the port (e.g. 8889) and start the connector.
>_ export PORT=8889 && ./wdc
____ __ __
/ __ \___ / /___ / /_____ ____
/ /_/ / _ \/ / __ \/ __/ __ \/ __ \
/ ____/ __/ / /_/ / /_/ /_/ / / / /
/_/ \___/_/\____/\__/\____/_/ /_/
connector is on port 8889
2021/01/14 21:50:32 authentication is on
2021/01/14 21:50:32 caching of workouts is offIf necessary, allow connections.
Install Tableau Desktop, if you haven't already.
Open Tableau, and use the Web Data Connector option. If you're running this locally, enter http://localhost:<port>/wdc (e.g http://localhost:8889/wdc). If you're connecting to the online version, enter https://www.mypelotondata.com/wdc.
Enter your Peloton credentials.
Extract your data by clicking Get Cycling Data link.
Build useful and beautiful reports and dashboards. This one can be found on Tableau Public here.
As noted above, the connector is stateless. Once you're done, and you've saved your Tableau workbook, feel free to shut it down. A simple ctrl+c in the terminal will do the trick.
When you want to pull new data from Peloton into your Tableau workbook, simply open a terminal window and start the connector (assuming the repo was cloned into $HOME and built as shown above).
>_ export PORT=8889 && $HOME/peloton-tableau-connector/wdc
____ __ __
/ __ \___ / /___ / /_____ ____
/ /_/ / _ \/ / __ \/ __/ __ \/ __ \
/ ____/ __/ / /_/ / /_/ /_/ / / / /
/_/ \___/_/\____/\__/\____/_/ /_/
connector is on port 8889
2021/01/14 21:50:32 authentication is on
2021/01/14 21:50:32 caching of workouts is off