Modernizing Healthcare in Challenging Environments: A Dataverse Success Story

There’s a unique kind of pressure that comes with working on technology meant for the front lines of critical care. You’re not just building for efficiency; you’re building for dignity, for care, and for hope. This was the weight and the privilege of leading the complete revamp of a Clinic Management System (CMS) for a non-profit organization providing essential medical services in refugee settings.

For years, dedicated medical staff had relied on a collection of Power Apps built on a SharePoint backend. This system was a testament to ingenuity, built to capture critical patient data and report to vital funding partners. But with time and increasing demand—each clinic seeing 40-60 patients daily—the foundation began to crack.

The architecture, which used duplicate applications and sites for each clinic and village, was buckling under the load. The client's IT team was trapped in a cycle of time-consuming administrative tasks, managing bugs, and access requests across this fragmented landscape. Their efforts had minimal impact on the real goal: empowering medical professionals to focus on patients, not software. A full revamp wasn't just an IT project; it was a necessity.

Understanding the Landscape: More Than Just Broken Code

We began by listening. I immersed myself in understanding not just how the old system was built, but why. I mapped the workflows of registration clerks, doctors, pharmacists, and nurses. The core issue became clear: duplication was the enemy. There wasn't one registration app; there were many, one for each location. There wasn't one doctor's app; there were several for different specialties, despite being 90% identical. This complexity was the source of every administrative headache.

Old applications - multiple copies of same application serving several different units

The vision was simple but ambitious: consolidate and simplify. We would replace this maze of apps with a single, robust application for each user role, powered by a unified, enterprise-grade database.

The Rescue Mission: Enter Microsoft Dataverse

The hero of our story is Microsoft Dataverse. Its sophisticated security model was the key that unlocked everything. We built a single, performant, and scalable database for all centers, using Business Units and row-level security to neatly and securely compartmentalize the data for each clinic and role. A doctor in one location could now seamlessly use the same app as a doctor in another, but only see their own patients. We baked in flexibility for the future, using configuration tables to manage clinics and medication lists, making future expansion or changes a matter of configuration, not code.

A new model-driven app used for back-office management and configurations

We built the new apps following industry-standard Application Lifecycle Management (ALM), with dedicated development, UAT, and production environments. We gave them a modern, sleek interface, but our primary design principle was reliability. In a clinic, a half-second delay isn't an inconvenience; it's time taken away from a patient.

Registration home - Old

Registration home - New

Search patients - Old

Search Patients - New

Doctor waiting list - Old

Doctor waiting list - New

The Million-Record Migration: A Triumph of Data Integrity

One of our most daunting challenges was history. We had to migrate over a million records of patient profiles, visits, prescriptions, and lab requests from non-relational SharePoint lists into our new, highly structured Dataverse model. Handling erratic lookups and multi-choice columns was a delicate operation.

Here, the power of Dataverse Dataflows and Power Query shone brightly. After meticulous cleaning and manipulation, we achieved what felt like a miracle: a 100% migration of all records with only minimal, pre-existing data errors. We preserved every piece of the story for every patient.

Supercharging Reporting: From 50 Minutes to 2 Minutes

The old reporting system mirrored the app problem: duplicate Power BI reports, each struggling to refresh from overwhelmed SharePoint lists, with refresh times ballooning to 40-50 minutes.

We obliterated the duplicates. We built a single, powerful Power BI App with one semantic model connected directly to Dataverse. Using row-level security, we ensured each center only saw its own data. The result? Refresh times plummeted from nearly an hour to under two minutes. The client's analytics team now had the agile, reliable reporting they needed to derive insights to improve care.

List of Power BI reports - Old

Power BI reports with a single semantic model - New

Old reports refresh times exceeding 40 minutes

New report refreshes within less than two minutes.

A Success Forged Through Collaboration

This technical transformation was ultimately a human story. None of this would have been possible without the profound collaboration of the entire team on the client's side—from leadership to IT to the medical professionals whose daily feedback was the true litmus test for our work.

This project was a powerful reminder that technology, when applied with empathy and deep collaboration, ceases to be just software. It becomes a force multiplier for compassion. It was an honor to play a part in supporting those who provide hope and healing every single day.

#MicrosoftDataverse #PowerPlatform #PowerApps #PowerBI #NonProfitTech #DigitalTransformation #HumanitarianTech #TechForGood #ProjectManagement #SharePoint #DataMigration