Case study
COVID health tracking dashboard
Replaced weekly per-facility spreadsheets with one live dashboard covering every facility.
Industry
Healthcare
Key result
Real-time
Dashboard updates
Timeline
Weeks
Services
Healthcare
The Challenge
The Challenge
COVID moved fast, and Fidelity Healthcare Group ran multiple facilities at once. Every day, the situation inside one facility could change the staffing plan for three others. Each facility tracked its patient data differently: some worked in spreadsheets, some in internal systems, and none of those systems talked to each other. There was no shared view of patients, staff capacity or resources across the group — only separate spreadsheets per facility, each maintained on its own terms, with no way to line them up against one another.
Leadership needed to see everything — all facilities, all regions — in one place, and needed it updated in real time rather than at the end of the week. As it stood, the numbers moved once a week, there was no geographic view, and leadership was effectively flying blind. The cost of a wrong call was high: understaffing a facility that was about to see a surge, or sending resources somewhere that did not need them. The stakes were high and the data systems were not ready.
The Solution
The Solution
We built a centralized Tableau dashboard that pulled live data from every facility and updated itself automatically, so no one had to export anything. The engagement was an analytics dashboard build on Tableau, focused on multi-facility COVID data aggregation. Three pieces made it work: automated data pipelines feeding the dashboard, geographic heat maps covering every location, and aggregation that rolled the individual facilities up into one view. Leadership got one live dashboard for all facilities rather than a set of files that had to be reconciled by hand.
The data feeds were built as connectors into each facility's existing systems, rather than asking facilities to change how they already worked. Data flowed in on a scheduled basis — every few hours at first, then in near real time. That removed the manual exports and the copy-paste step entirely, and it removed the weekly cadence with it: the dashboard reflected what was happening now instead of what had been true at the last reporting cycle.
Each facility was mapped by location so the dashboard could be read geographically. As patient counts and resource levels changed, the colors on the map shifted with them — a red region meant pressure, a green region meant capacity. That gave leadership the whole picture at a glance instead of a per-building readout, and made it possible to see where pressure was building and where there was still capacity to draw on.
Multi-facility aggregation meant rolling all the individual facility numbers up into one view: total patients, total staff capacity and total resource levels across the whole organization, not just one building at a time. Combined with the automated feeds and the heat maps, that turned the daily question — where is pressure building, and where is there room — into something leadership could answer from a single screen in real time rather than assemble by hand at the end of the week.
Results
Results
Real-time
Dashboard updates
Multi-Facility
Data aggregation
Auto
Data pipeline feeds
Geographic
Heat map coverage
Tableau
Dashboard platform
None
Manual data exports
Before & after
Before and after
Before
Separate spreadsheets per facility
One live dashboard for all facilities
Data updated once a week
Data updated automatically
No geographic view
Interactive heat maps
Leadership flying blind
Real-time decision support
Common questions
Common questions
More case studies
Get started
Ready to see what AI
can do for your business?
Book a free 60-minute consultation. No sales pitch — just honest answers about where AI fits.