Abstract
Project Purpose To develop a quality dashboard tool for the Health Resources and Services Administration (HRSA) community health centers to examine health center characteristics associated with performance excellence and predict future healthcare cost.
Background HRSA is the primary federal agency for improving health care to people who are geographically isolated, economically or medically vulnerable. HRSA-funded health centers are required to upload to Uniform Data System (UDS). HRSA health data is rich; however, their website provides limited meaningful visualization and data-driven analysis.
Method The project reviewed data from Uniform Data System between 2017 and 2019. The data was cleaned using Excel. Visualization was displayed on Tableau, and the cost prediction modeling was completed using Python Machine Learning libraries. All the findings are available for public view on Weebly-hosted website.
Outcomes The Tableau dashboard showcases the effectiveness of the preventive intervention and chronic disease management initiatives over the years. This tool focuses on comparison between outcomes in health care programs and cost benefits in all states. The dashboard also uses the most fit Machine Learning model and the most important variables to predict the cost per patient of a health center.
Discussion The lack of similar performance comparison dashboards by HRSA suggests a need for HRSA Population Health Dashboard to understand the performances of HRSA-funded health centers or regions through times. It shows the ineffectiveness of the current healthcare programs in reducing disease growth and healthcare cost over the course of 3 years.
Next Steps/Opportunities The final dashboard will be available for public use and will continue to aggregate more real-time data using Application Programming Interface (API) to improve its accuracy of prediction model. The HRSA Population Health Dashboard will be beneficial to management at both HRSA federal- and health center-level to make valuable strategies.
Competing Interest Statement
The authors have declared no competing interest.
Funding Statement
This study did not receive any funding
Author Declarations
I confirm all relevant ethical guidelines have been followed, and any necessary IRB and/or ethics committee approvals have been obtained.
Yes
The details of the IRB/oversight body that provided approval or exemption for the research described are given below:
The study used (or will use) ONLY openly available human data that were originally located at: https://bphc.hrsa.gov/datareporting/reporting/index.html
I confirm that all necessary patient/participant consent has been obtained and the appropriate institutional forms have been archived, and that any patient/participant/sample identifiers included were not known to anyone (e.g., hospital staff, patients or participants themselves) outside the research group so cannot be used to identify individuals.
Yes
I understand that all clinical trials and any other prospective interventional studies must be registered with an ICMJE-approved registry, such as ClinicalTrials.gov. I confirm that any such study reported in the manuscript has been registered and the trial registration ID is provided (note: if posting a prospective study registered retrospectively, please provide a statement in the trial ID field explaining why the study was not registered in advance).
Yes
I have followed all appropriate research reporting guidelines, such as any relevant EQUATOR Network research reporting checklist(s) and other pertinent material, if applicable.
Yes
Data Availability
All data produced are available online at