Streamlining Sensitive Care Data with AWS Quicksight

See how D3Clarity built a secure portal and dashboard for data collection and reporting in healthcare—powered by AWS and Amazon QuickSight.

CASE STUDY

5-MINUTE READ

Secure portal and dashboard solution for healthcare program data collection and reporting

The Challenge at Hand

Modernizing Data Collection in a Security-Sensitive Landscape

A non-profit healthcare quality organization—referred to here as HealthMetrics Collaborative for privacy reasons—provides the only national, unified specialty palliative care data registry. Each year, they conduct a comprehensive program-level survey to gather operational statistics from over 300 hospital and community-based palliative care programs across the country. These data points include program type, geographic setting, and patient volumes. While the data is sensitive, it does not qualify as protected health information (PHI), making it an ideal starting point for a broader data modernization initiative.

HealthMetrics Collaborative was previously using a platform that lacked the user-friendliness and automation capabilities needed to support a growing network of contributors. As the organization planned to expand into collecting patient-level data in the future, they needed to build a secure, scalable infrastructure as a foundation.

Key challenges included:

Replacing an outdated data entry system with a more user-friendly, modern platform.
Ensuring data security and privacy for sensitive program-level data.
Automating data aggregation and visualization for more than 300 annual survey submissions.
Providing users with a streamlined, secure way to input, save, and later submit complex, multi-hour surveys.
Creating a user access model that supports differentiated access based on hospital or community program types.

In short, HealthMetrics Collaborative needed more than a survey tool—they needed an integrated, secure member portal with built-in analytics and the flexibility to grow with their future data needs.

Innovative Solutions Unleashed

An Integrated Member Portal with Amazon QuickSight and AWS

To address the organization’s goals, D3Clarity designed and delivered two key sets of deliverables: a modern Data Collection Portal and embedded Amazon QuickSight Dashboards tailored for hospital and community programs.

1. A Secure, Branded Member Portal

Built on AWS infrastructure using AWS Amplify, the custom HealthMetrics Collaborative portal was developed to provide:

Role-based access control: Users could access only the forms and dashboards tied to their specific program(s), ensuring data security and access integrity.
Form auto-save and resume: Given the length of the survey (often requiring several hours), users could save their progress at any time and return later without losing input.
Static templates with contextual logic: The survey forms remained consistent across users but included conditional display logic to show or hide questions depending on responses.
HMC-branded design: The portal’s look and feel was aligned with the organization's visual identity.
Secure credential management: Users validated their accounts via email verification and password creation. Support for self-service password resets was also included.
DynamoDB integration: All form data was stored securely in AWS DynamoDB and tagged to the appropriate program/member account.
Reusable infrastructure: The foundational portal was intentionally developed with future projects in mind—including the eventual move into patient-level data collection.

2. Automated Dashboards with Amazon QuickSight

D3Clarity developed two QuickSight dashboards—one for community programs and one for hospital programs. These dashboards dynamically pulled data from the program-level survey dataset and were accessible through the same member portal.

Key features included:

Historical reporting views: Members could visualize trends over time for their specific programs.
Embedded dashboards: Rather than redirecting to a separate platform, the dashboards were integrated directly into the portal for a seamless user experience.
Cost-efficient access model: By using custom URLs, the project kept QuickSight costs minimal while still offering robust functionality.

Project Execution

To maximize efficiency and reduce costs, D3Clarity staggered development by beginning with the shorter hospital survey before replicating shared elements for the community survey. Weekly demos and open checkpoints ensured the client had full visibility into progress and the opportunity to adjust design preferences midstream.

The collaborative nature of the project ensured that HealthMetrics Collaborative subject matter experts could contribute directly to layout and user experience design—particularly for the dashboards.

Transformative Results Achieved

From Manual Workflows to Scalable Automation

The project delivered tangible results that significantly improved both the internal operations of HealthMetrics Collaborative and the user experience for its members.

Major Outcomes:

All deliverables were successfully completed within scope.
The organization now has a secure, user-friendly data collection portal that can serve as the foundation for future initiatives.
Manual processes were eliminated—the QuickSight integration removed the need to download, clean, and visualize over 300 survey datasets each year.
Members can now submit complex data securely, with the ability to save and return as needed—making long-form submissions more manageable.
The user model ensures that only authorized individuals can input or view specific data, minimizing the risk of accidental disclosure.
Dashboards provide near real-time visibility into trends, helping programs benchmark their operations and identify areas for quality improvement.

This transformation positioned the organization to handle increasing data demands while maintaining compliance, security, and member trust.

Why This Matters for the Industry

The healthcare industry faces mounting pressure to modernize data infrastructure while complying with rigorous data privacy standards. For palliative care organizations and beyond, the need to collect large amounts of sensitive (though not always PHI) data calls for systems that are secure, scalable, and easy to use.

Some key statistics about healthcare data management that underscore the urgency:

Around 35% of healthcare workers reported only manually entering data in 2022 (Source: Healthcare IT Today)
59% of healthcare executives consider consumer expectations for stronger data privacy and cybersecurity as the most significant factors influencing their digital transformation initiatives. (KPMG)
By 2027, the worldwide healthcare analytics market is projected to reach over $93 billion, showing a sharp upward trend in data-dependent decision making. (KBV Research)

This project stands as a model for how organizations can incrementally modernize their data environments while maintaining control over access, usability, and future scalability.

If you're managing sensitive healthcare data and need a better way to collect, store, and visualize it—D3Clarity is ready to help. Whether you're looking to modernize legacy systems, embed advanced dashboards, or simply make your data easier to manage and share, our secure, cloud-based solutions are designed with your needs in mind.

Contact D3Clarity to learn how we can help your organization transform its data capabilities—starting today.

35%

of healthcare workers reported only manually entering data

59%

of healthcare executives consider consumer expectations for stronger data privacy and cybersecurity as the most significant factors influencing their digital transformation initiatives

$93 billion

the projected worldwide healthcare analytics market by 2027

Meet the team

Earin Persson

VP of Channel Sales & Service Delivery Operations

Let's talk

Preston Gregg

Cloud & AI Expert, General Manager

Let's talk

Streamlining Sensitive Care Data with AWS Quicksight

Modernizing Data Collection in a Security-Sensitive Landscape

Key challenges included: