Skip to content

This project creates a WDC for Tableau to bring in data from the Microsoft Health API (e.g. data from a Microsoft Band fitness tracker). The data can then be analyzed and explored using Tableau.

License

Notifications You must be signed in to change notification settings

benlower/tableau-wdc-mshealth

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

tableau-wdc-mshealth

Tableau Web Data Connector for the Microsoft Health API. Allows importing data to Tableau for visualization and analysis.

Getting Started

  • Register your app with the Microsoft Account Developer Center. Details for this are in the MS Health API Docs
  • Create a file named config.js at the project root. It will contain config info for your app including client ID and secret you'll get in step 1. Config.js needs to look like the following:
module.exports = {
 'HOSTPATH': 'http://localhost',
 'PORT': 8080, 
 'MSHEALTH_CLIENT_ID': 'your_client_id', 
 'MSHEALTH_CLIENT_SECRET': 'your_client_secret', 
 'MSHEALTH_REDIRECT_URL': 'http://localhost:8080/redirect'
};

You can change host, port, and redirect URL. If you change these make sure you also change them in app.js.

  • Make sure you have Node.js installed
  • npm install
  • npm start
  • You can now use the WDC. Note: you'll only get data if you use the WDC's Simulator or Tableau Desktop

Current Limitations

Currently this WDC is only pulling some of the data from the MS Health API. See below for what's currently supported.

MS Health Object Supported?
User Profile No
Device No
Activity Partial
Summary No

Activity Support Currently this WDC is pulling in the following data for Run, Bike, and FreePlay activities:

Property Supported?
ID Yes
Calories Burned Yes
Total Distance Yes
Duration Yes
Start Time Yes
End Time Yes
Heart Rate - Average Yes
Heart Rate - Peak Yes
Heart Rate - Lowest Yes
Heart Rate - Ending Yes

About

This project creates a WDC for Tableau to bring in data from the Microsoft Health API (e.g. data from a Microsoft Band fitness tracker). The data can then be analyzed and explored using Tableau.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published