Overview of Solution

We have three different stages to our experimental design: 1. Data Extraction 2. Visualization 3. Analysis

1. Data Extraction

• Data Sources: Apple Health & Oura Ring (includes life events)

• Goal: Automate execution of code for daily data extraction and parsing

• Our Solution: Google Cloud Functions

  • 1. Requires token number for Oura and “Health Auto Export” for Apple Health

    2. Executes once per 24 hours

2. Visualization

• Data Storage: Google Drive 

• Goal: Visualize extracted data 

• Our Solution: Tableau

  • Free for students

  • Can load live data sources 

  • Create marvelous visualizations 

  • Assist in the identification of trends and correlations

3. Analysis

• Data Visualization Platform: Online Dashboard (GitHub)

• Goal: Embedding Tableau visualizations in an accessible online dashboard

• Our solution:

  • View multiple graphs that display several variables over a period of time

  • Deliver a user-friendly, reliable platform to illustrate a complete picture of a patient's health journey

Below you can find many of the visualizations we were able to create using real patient health data from Oura Rings and Apple Health. The data from the health sources were obtained using Google Cloud Functions, and the data was visualized using Tableau. You can take a look at our linked Dashboard to further see what we created. 

Credit: Seongjin Park, Sakeef Sayeed, Samhita Kadali, Varshini Sathish