Fortune 500 Healthcare System
Legacy app migration, automated clinical staffing analytics, and embedded BI enablement across 188 hospitals
50%
File Size Reduction
188
Facilities Covered
5 wk
Migration
Overview
One of the nation's largest healthcare systems — 186 hospitals and approximately 2,000 sites of care across 21 states — was carrying legacy analytics debt. A 9-year-old workforce analytics application had accumulated massive technical bloat. Clinical imaging staffing decisions for 188 facilities were being made manually in Excel. And the development team needed enablement on modern embedding practices. Three distinct engagements over 12 months, each building on the last.
The Situation
The organization maintained a 9-year-old workforce analytics application that had accumulated significant technical debt — island tables, unused data fields, and a file size measured in gigabytes. Meanwhile, the Director of Clinical Imaging Strategy was spending hours manually importing and transforming quarterly historical data into Excel to make staffing decisions for 188 facilities across the US. The legacy process required an analyst to manually update SQL queries, load data, send results to the director, who would then import into Excel, group facilities by zone, and calculate staffing requirements. Additionally, the internal development team wanted to embed analytics into their own web applications but lacked the knowledge to do it effectively.
Our Approach
- 1
Phase 1 — Legacy App Migration (5 weeks): Migrated the 9-year-old workforce analytics application, eliminating technical debt through data model optimization. Removed island tables, unused fields, and redundant data structures — cutting the application's footprint in half.
- 2
Phase 2 — Clinical Imaging Dashboard (3 months): Built a net-new analytics application replacing the manual Excel staffing process entirely. Automated data ingestion from the enterprise data warehouse with daily refreshes. Delivered interactive staffing models covering all 188 facilities with user-adjustable variables and 30-second zone mapping reloads.
- 3
Phase 3 — Embedded Analytics Enablement (2 weeks): Transferred embedding knowledge to the internal development team, enabling them to integrate analytics directly into their web applications using modern APIs. The team immediately began building embedded applications independently.
Results
- 50% file size reduction and 44% RAM reduction on the legacy workforce analytics application
- Island tables reduced from 6 to 1, data fields cut by 50%, table count reduced by 56%
- Automated clinical staffing analytics covering 188 facilities with 2+ years of historical data
- Manual hours-long Excel process replaced with on-demand interactive dashboards
- 30-second zone mapping reloads for real-time staffing scenario analysis
- Internal development team enabled and building embedded analytics applications independently within days
What This Made Possible
What started as a single legacy app cleanup evolved into a relationship that transformed how the organization consumes analytics. Clinical leaders now make staffing decisions with interactive dashboards instead of waiting for Excel reports. The development team embeds analytics directly into internal applications. And the legacy migration proved the ROI pattern — diagnose the technical debt, clean it up, and unlock performance the organization didn't know it was leaving on the table.
Facing a Similar Challenge?
Let's talk about what's in your analytics portfolio — and what it would take to get it where it needs to be.