Share via

Power BI 12 Days of Dashboards - Day 8 - Fitbit Dashboard

  • Article

Fitbit Power BI Dashboard

Day #8 - Fitbit Activity Dashboard

As part of my Power BI 12 Days of Dashboards series, day #8 showcases a customized Fitbit dashboard. This could easily be extended to build a dashboard for Garmin, Microsoft Band, or any other activity tracker that allows for data export.

Here is an example of the dashboard showing my yearly metrics. You can build this with your own Fitbit data by following the steps below.

The first step to creating this dashboard is to export your Fitbit stats from https://www.fitbit.com/.

  1. Navigate to https://www.fitbit.com/
  2. Click on “View Settings" (gear icon), then "Settings" on the top ribbon
  3. On the left, click on "Data Export"
  4. This next part is quite manual due to the Fitbit limitation of only allowing you to export 31 days at a time. Export your monthly stats for your desired time frame into a dedicated folder. This folder path will be the input parameter for the dashboard, so only place your exported .csv files in this path. I exported all 12 months in building this. TIP: Only select Activity in the data type selections.

Next, download the Power BI Template from here and continue with the following steps:

  1. Download and open the attached FitbitTemplate.pbit file and open it in Power BI Desktop
  2. A popup box appears asking for the full path of the folder of your exported .csv files from the above steps. Provide the full path to the folder on your computer and click the "Load" button in the bottom right. Leave the first parameter as it is, just fill in the second parameter containing the folder path.

Please leave a comment if you've enjoyed the dashboard or if you have any additional suggestions to improve it.

Thanks,
Sam Lester (MSFT)

Comments

  • Anonymous
    December 19, 2016
    Are there any Power BI templates that you know of for the other Fitbit exports of "Body", "Foods" and more importantly (for me) "sleep"?Also, would you know of any pointers towards performing some 'trend analysis' for 'Activities' (and the others)?
    • Anonymous
      December 19, 2016
      Hi George, I'm not aware of any other activity templates. I whipped this one up before work this morning for the blog series and only included steps since that's the only data I track (and thus had available). If you want to send me an email and include your exported sleep stats, I can spend a few minutes on a sleep tracker for you and share out the dashboard in a future blog post. In terms of trend analysis, check out the forecasting feature that I believe was initially released in September and included in the PBI service last month. https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-feature-summary/#forecasting With some of the visuals, you can use the Analytics tab to add trend lines in the same way I added max, min, and 10k lines in the steps/day visual above.Thanks,Sam
  • Anonymous
    December 19, 2016
    The comment has been removed
    • Anonymous
      December 19, 2016
      George, thanks again for the feedback and assistance with this dashboard. I've had several challenges with international formats since my machines are all in US-based formats, but I live (and frequently share solutions) in Europe. In the Goodreads dashboard, I had to change the File Origin of the .csv file during import from "1252: Western European" to "65001: Unicode (UTF-8)" to properly display some of the international characters in author names, book titles, etc. After this project wraps up I am thinking about doing a deeper dive blog entry into the different international format considerations in Power BI since I seem to be encountering them a lot lately.
  • Anonymous
    January 14, 2017
    You could automate the data pull using the fitbit APIs to get historical data. I am currently trying to accomplish this.https://dev.fitbit.com/docs/body/#body-time-series
    • Anonymous
      January 16, 2017
      Hi Jon, great suggestion. I noticed that Fitbit provides an API, but I tried to keep the dashboards in this series fairly basic and based on standard export capabilities. There are also a couple projects on GitHub that export stats over a data range so you don't have to perform the built-in export 12 times (one for each month).Thanks,Sam
    • Anonymous
      June 20, 2018
      Hello Jon Culp,Were you able to do this? automating data pull via Fitbit APIs.I am trying to pull data to a central DB from multiple Fitbit users within a group. I will be glad to hear how you went about it.
  • Anonymous
    June 20, 2018
    I am also trying to use the FItbit API to pull data from multiple users, please anyone done this before?