Health Resources Survey Case Study

health resources survey webiste developed by magnusminds

Case Study

Here's the Case-Study of some of our works we'd like you to see...

health resources survey case study image magnusminds


Developed a process to grab patient details from multiple files and Insert/Update details over the portal. Also implemented functionalities to generate Reports and created a Power BI Dashboard to check day-to-day activities.

Technology Stack

logo ssis magnusminds
SQL Server Integration Services
logo azure magnusminds
Azure SQL Database
logo sql magnusminds
SQL Server 2017
logo C# magnusminds
logo winrar magnusminds
logo ssrs magnusminds
logo power-bi magnusminds
Power BI

The Challenge

The client had a healthcare portal that supports care coordination by providing structure for supporting the day-to-day activities of a transitional care team as well as insight for management as to how those activities translate into outcomes. The client was manually filtering the details for the individual patient and posting that over that portal and he was also inserting/updating the patient details manually.

Here, the challenge was to have the patient details from the different files. They had multiple instances to manage, so providing an individual process for each instance according to their conditions and requirements was a complex task. As per their requirements, we need to make patients eligible to insert/update the portal. Also, they wanted to see those day-to-day activities in the reports or file like, how many patients are admitted or discharged from any particular location, etc.

case study challenge image magnusminds
case study solution image magnusminds

The Solution

First of all, we created an SSIS package to read all files and used the C# script to generate XML for the patient. Then, we used the REST API to send that XML of patient details on the portal. To make this process automated, we created batches to move files to the specific folders and to execute the SSIS packages using the dtexec tool. To execute those batch files, we used Task scheduler, and to view the activities-related information into reports, we implemented SSRS. We also created the Power BI Dashboard to view the details.

case study conclusion image magnusminds

MagnusMinds was victorious in providing them with the solution to automatically process all the files and pick the patient details and post it over the portal.