Yun is a

UX Researcher Data Analyst Data Scientist Story Teller

Supporting Long-term Healthcare Institute using Health Data

Background: This project was completed during my Internship with Jubo Health. Through this project I have gained a deeper understanding of how long-term care institutes operates and how I could make use of my skills to support them. I joined the project to develop a prototype for the enhancement of jubo’s Nursing Information System. The aim was to create a data visualization dashboard embedded in NIS that could represent clients’ current and past health status from multiple domains of input.

The project was separated into two phases:
- Cooperated with Jubo’s design team, customer success team, product team, data team to discuss the concept of what and how to be present in the dashboard. Conduct data analysis from MongoDB and implement the discussed concept through data visualization.
- Modified design concepts through user interviews (physician, nurse, nurse aide, nutritionist). Completed ETL process to hourly update the dashboard, and make the dashboard into a interactable web application.

My role(s): Developer, Researcher
Collaborator(s): Sean Chiang (Data Manager), Yahan Chou (designer)

Methods(s): Contextual Inquiry Questionnaire Usability Testing Focus Group Prototyping
Skill(s):
Python NoSQL BigQuery Airflow Tableau

Motivation: The existing system for healthcare professionals is imperfect, long-term care institutions are filled with paperwork, therefore, decreasing the efficacy in coworking with different functionalities. There is also a lack of complete system to track individual health history. This project aims to provide a solution to the existing issue.

Project Timeline

Development Process

22June
June

User Research

Designed questionnaire and conduct qualitative and quantitative analysis to define the needs from multiple healthcare professionals (n=21)

1Jul
July

Define

Discussed and validated dashboard design concept with UI/UX designers, clarifies data structure and produced data manipulation

8Jul
July

Develop

Implement design concept using Tableau, conduct weekly meeting with stakeholders to validate dashboard metric functionalities

3Aug
August

Testing

Conduct usability testing for 5 healthcare professionals to testify what their pain points are and whether the product is serving the purpose

12Aug
August

Deploy

Transferred the wrangled data into Google BigQuery and Airflow using python scripts to automate the data refresh process, developed through Git

Findings through Questionnaire

The top 5 most desirable features within an individual health monitor dashboard is:

How healthcare professionals plan to use the dashboard:

Feedbacks:

Elements

Retrived data from 25+ MongoDB collections, including Weights information, Nutrition Records, Mini-Nutrition Records, Blood Sugar Records, Insullin Records, Vital Signs, Regular Assessments(Barthel index, SPMSQ, IADL, EQ-5D...) and data related to personal health records.

Dashboard Modules

The presenting order of the dashbaord for busy care providers are essential. After discussion with stakeholders and conduct usability testing, we came up with two options.

Design Process

senario one image
Senario two image

Outcome

Intro
Vital Sign
Weight Dashboard
Blood Sugar Dashboard
Evaluation Dashboard
Assessment Dashboard

Designer Prototype after Usability Testing

Health dashboard 1
Health dashboard 2
Health dashboard 3
Yun Lee's LinkedIn Profile Yun Lee's Facebook Profile Yun Lee's instagram Page