/Work/Leading American Healthcare Company

Empoweringahealthcarecompany'sdatamanagementwithaunifieddashboard

This case study details how Codal partnered with a leading American healthcare company to modernize their data management, creating a powerful COB Advisor Dashboard that streamlines operations and enhances decision-making.

CENTRALIZED DATA

one dashboard

REAL-TIME INSIGHTS

at every decision point

ENHANCED USABILITY

for all users

Laptop displaying a modern business intelligence dashboard with data visualizations and tables, representing data management.

Challenge

Solution

Result

This prominent American healthcare organization is a leading integrated provider in the US, combining a vast network with insurance services and a range of healthcare solutions.

The challenge

While the healthcare company's existing data management infrastructure capably supported their operations, they recognized a significant opportunity to enhance their coordination processes through greater data unification and accessibility.

The previous distribution of vital information across numerous business units presented several key areas for improvement. The decentralized structure led to inconsistencies in data management, impacting the reliability of insights crucial for strategic decisions.

Additionally, the fragmented data landscape limited the ability to identify key trends and provide the real-time information necessary for advanced initiatives like machine learning-driven automation. Inefficient reporting cycles and manual processes further slowed down decision-making. Operationally, the need for manual data lookups contributed to customer service delays, and a less-than-intuitive existing dashboard hindered effective data analysis.

Ultimately, the healthcare company sought a new solution that would accomplish the following: centralize their data, implement real-time dashboards with predictive analytics, automate reporting, improve data sorting, enhance dashboard usability, and enable richer data storytelling.

Healthcare professional reviewing a digital data dashboard with patient information and insurance filters.

The solution

The healthcare company selected Codal as their partner for this important initiative. The decision was based on our successful history of delivering impactful solutions for the company in previous projects, as well as our demonstrated expertise in design and workflow optimization. The opportunity to build a centralized data dashboard as a proof of concept (POC) really excited our team as we envisioned it becoming the foundation for a deeper, long-term partnership.

Laptop showcasing a COB Advisor dashboard with data visualizations, charts, and metrics for healthcare performance.

Building a unified, user-centric dashboard on Google Cloud

Recognizing the complexities of the healthcare organization’s challenges and existing data ecosystem, our team kicked off the engagement with an in-depth discovery workshop. This collaborative session was paramount for establishing clear project goals, brainstorming potential features, and carefully gathering the specific requirements of the COB team. We also took a deep dive into their existing architectural landscape to identify both the strengths and limitations of their existing systems. Following the comprehensive review, we presented our initial proposal, outlining how a modern solution could address their key challenges.

"A particular highlight of the project was being able to hold a discovery workshop where we collaborated directly with the client to truly understand their business goals and the needs of the platform's users,” Nathan, Codal Senior Designer, recalls. “This insight was invaluable, as it helped to shape our final design decisions and ensured the designs were feasible from an implementation standpoint while also meeting the client's specific requirements."

Based on the insights gained during the discovery phase, we identified Google Cloud as the ideal solution for the new system. Leveraging the robust data warehousing capabilities of BigQuery and the dynamic, user-friendly front-end framework of NextJS, we architected a tailored solution: the COB Advisor Dashboard. This centralized platform was specifically designed to streamline the dissemination of critical COB data to empower informed decision-making across all of the organization’s LOBs.

Digital table showing member data, insurance details, and validation status in a healthcare dashboard.

Intuitive dashboard design and development

Next, Codal designed and developed an intuitive, user-friendly dashboard that consolidated COB data from various sources. Key features include:

Robust filtering capabilities for efficient retrieval of performance and operational metrics.

Real-time data accessibility across different sources, ensuring up-to-date information.

Enhanced data clarity through detailed context (sources, providers, plan sponsors).

Comprehensive data views, including “Performance and Opportunities” displays for both aggregate and granular data.

Improved data clarity with clearer tips and widgets for better understanding of data points.

Distinct delineation of aggregate LOB data.

Ability to display data trends over time.

Granular data access, including the ability to drill down into specific member claims data.

“A key part of building this dashboard involved the componentization of UI elements and integrating them into a component playground,” Josh, Software Engineer at Codal, explains. “This playground served as a visual reference and testing environment, making the QA process smoother and more efficient for our team and the client. I then used these components to build out larger page sections, ensuring design consistency and improving overall development efficiency. We also hooked up API data within these sections, integrating dynamic content and ensuring real-time data was displayed correctly.”

The healthcare organization’s new tech stack is a blend of BigQuery, NextJs, ShadCN, Rechart, and Tailwind, enabling a powerful, scalable, and future-proof solution.

Two digital dashboards showing 'Performance' and 'Opportunities' views for healthcare data analysis.

Collaborative development and agile implementation

Throughout the duration of the project, our team adopted a collaborative approach, working closely with the organization’s team. This involved:

A discovery workshop to establish project goals, ideate features, gather requirements, review architecture, and present proposals.

Agile sprint ceremonies, including regular project standups, requirements gathering sessions, and sprint demos.

Consistent communication through Microsoft Teams to ensure alignment and timely resolution of issues.

Frontend development methodology/guidance that enabled better design systems and a component driven architecture.

“Working on this project was a significant learning opportunity,” Codal Senior Software Engineer Nisharg, recalls. “We successfully navigated the complexities of integrating tools like TanStack Query and TanStack Table with TypeScript, ensuring robust type safety. A notable challenge was implementing a custom workaround for bar chart visualizations to ensure very small values were clearly visible, a solution that required creative thinking and rigorous testing.”

Integrating different technologies and coordinating development with the organization’s team within their environment presented a few speed bumps along the way. However, our agile approach and clear communication enabled us to effectively manage these aspects and ensure on-time delivery.

Digital dashboard showing healthcare data, including avoidance opportunities and Medicare trend graphs.

The result

A powerful tool for data-driven decision making

The successful launch of the COB Advisor Dashboard marks a significant milestone in the healthcare organization’s data management journey. The dashboard provides a centralized, user-friendly platform that enhances data insights and operational efficiency.

While performance metrics are still being gathered, initial client feedback has been overwhelmingly positive. The dashboard's improved UX, informative data displays, and rebuilt graphs have significantly enhanced the user experience. Additionally, the design elements are being considered for use across other applications.

This project demonstrates Codal's ability to deliver complex enterprise solutions through collaborative partnerships and innovative technology. The COB Advisor Dashboard empowers the organization to make data-driven decisions, leading to improved operational efficiency and enhanced customer service. We look forward to continuing our partnership with the second largest healthcare organization in the US on future impactful initiatives.

From the outset, [the Codal] team demonstrated a collaborative spirit that made our partnership seamless. They took the time to understand our unique needs and worked closely with us to ensure that every aspect of the application was tailored. The Codal team was not only responsive but also proactive in suggesting solutions that enhanced the project’s outcome.
- Chris D. , PM

Industry

Capability

Related case studies

Case study

Life sciences & pharmaceuticals

Cost Plus Drugs homepage displayed on an iPhone

Revamping the backend system for Cost Plus Drugs to streamline operations & boost prescription fulfillment

Case study

Healthcare

Transforming cpap.com's digital experience with Shopify & AI-powered prescription processing

Case study

Healthcare

Woman browsing ExpressMed website laptop

Powering growth with smarter eCommerce & product data management

Case study

Healthcare

Redesigning a website to amplify epilepsy awareness

Case study

Healthcare

Architecting custom microservices to store & analyze massive amounts of medical device data

Case study

Experience design

Optimizing storage operations with intelligent workflows

Case study

Financial services

Establishing a superior online presence for an innovative brand in the mobile banking space

Case study

Healthcare

Centralized accreditation hub for medical boards

Curious about what’s possible?

If this case study sparked ideas, let’s talk. From strategy and experience design to unified commerce and product engineering, Codal helps ambitious brands turn vision into reality.

By submitting this form, you agree to be added to Codal's marketing database, where you can opt out at any time.