Your browser is not supported
Please use one of these options to improve your experience:
PIHOA Healthcare Worker Enumeration Dashboard
Overview
Objective
Client Background
Challenge
Solution
Implementation
Outcome
Next Step
Overview
Objective
Client Background
Challenge
Solution
Implementation
Outcome
Next Step
Overview
Established in 1986, the Pacific Island Health Officers Association (PIHOA) is dedicated to improving the health and well-being of US-Affiliated Pacific Island (USAPI). A critical challenge they faced was the fragmented and manual process of collecting and analyzing healthcare workforce data across the USAPI region.
To help PIHOA overcome this, DataHouse developed the Healthcare Worker Enumeration (HCW) Dashboard, leveraging AWS technologies to ensure scalability, reliability, and security throughout the data lifecycle.
Objective
The HCW Dashboard transforms raw data from healthcare organizations across the USAPI region into actionable insights. This enables USAPI jurisdictions to make informed decisions regarding their healthcare workforce – using AWS services to tackle complex public health challenges and improve the efficiency and effectiveness of health services.
Client Background
Industry
Non-Profit / Public Health
About the Organization
PIHOA acts as a collective voice for Pacific health advocacy, supports partnership engagement, provides technical assistance, strengthening health system capabilities and community resilience across the USAPI region.
Challenge
PIHOA identified critical issues in healthcare workforce management, including manual data collection, inconsistent job categorizations, and lack of resources for data management. These challenges hampered the efficiency and effectiveness of healthcare workforce management, affecting the delivery of healthcare services across the USAPI region.
Solution
DataHouse proposed developing a Human Resources for Health (HRH) Enumeration Framework to inform the design and implementation of the HCW Dashboard, addressing PIHOA’s challenges through:
Automated data collection and cleaning
AI/machine learning-driven programmatic mappings
Seamless consolidation of data into an organized database structure
Intuitive reporting tool to turn data into information
Natural language querying capabilities
Implementation
Deployment
The HCW Dashboard’s design incorporates key AWS services across its architecture:
Collection
AWS S3 is used for secure, scalable storage of raw data, coupled with AWS Simple Notification Service (SNS) for efficient, automated notifications and workflows. This setup ensures data integrity and accessibility while enabling real-time data collection processes.
Cleaning & Inspection
AWS SageMaker Studio Data Wrangler simplifies data preparation and analysis, AWS Lambda provides scalable, serverless data processing, and Amazon RDS offers a reliable relational database for storing processed data. This combination automates and accelerates the data cleaning and inspection phases.
Predictive Analytics
AWS SageMaker Studio Notebook facilitates the development and deployment of machine learning models for predictive analytics, with AWS S3 supporting data storage. This integration showcases AWS’s AI and machine learning capabilities in deriving insights from complex datasets.
Warehousing
The combination of AWS Lambda for processing and Amazon RDS for storage creates a robust data warehousing solution, ensuring the dashboard’s backend is efficient and scalable.
Output
AWS QuickSight provides dynamic, interactive visualizations and insights, enabling decision-makers to analyze healthcare workforce data effectively. QuickSight’s integration demonstrates AWS’s strength in business intelligence and data visualization.
Integration and Customization
The solution was carefully tailored to integrate seamlessly with existing systems and technologies, ensuring that it met PIHOA’s specific needs through customization.
Outcome
The deployment of the HCW Dashboard, powered by AWS services, marked a significant advancement in healthcare workforce management for the USAPI region. It enabled a unified view of healthcare worker information, enhanced decision-making, and showcased the scalability, reliability, and agility provided by AWS cloud technologies.
Next Step
The HCW Dashboard is the first phase in PIHOA’s Data Analytics Strategic Plan, with future enhancements and datasets planned to leverage AWS innovations further.
This ongoing partnership with AWS underscores a commitment to using cutting-edge technology to address public health challenges.
By showcasing the essential role of AWS services in the development and success of the HCW Dashboard, this case study highlights the transformative power of AWS cloud technology in solving complex public health challenges, paving the way for future innovations in the sector.
About DataHouse
DataHouse is Hawaii’s longest-standing IT consultancy since 1975, known for solving complex IT problems. Our expertise in leveraging AWS services and solutions shows our commitment to using cutting-edge technology to make a positive impact on local and global communities. As an AWS Standard Public Sector Partner, DataHouse continues to drive innovation in partnership with public and private organizations.
Contact Us
Our team would love to help you find the perfect fit of products and solutions.
Contact Us
Our team would love to help you find the perfect fit of products and solutions.
Join Our Team
We are always seeking people who share our values and take pride in their craft. We strive to inspire you to be the best version of you, by supporting you with a competitive salary, benefits, job security and personal and professional growth opportunities.
DataHouse is part of the ‘ike family of companies.