Case Study
How a large US healthcare provider delivered an emergency staffing & supplies application in 3 weeks.
Key Benefits
- A powerful application built by a small team of non-developers in a short space of time
- Rolled out to hundreds of healthcare facilities
- Allows healthcare facilities to track and manage data that wasn’t previously tracked
- Centers were able to meet the demand for staffing & supplies
- Aesthetically pleasing and intuitive.
“We needed to deliver an emergency COVID-19 application in as little time as possible. Squirrel helped us deliver that in a record time of just 3 weeks”
David Behr
VP of Business Intelligence
The Challenge : Deliver in 3 weeks
Covid-19 created an unprecedented need to manage dramatically increased staffing levels and the huge demand for PPE equipment, ventilators and medication. The healthcare provider had to act fast to make sure they could meet the supply and demand of both staffing and supplies.
Part of the challenge was finding a way to track data that previously was not captured. They urgently needed to track PPE and separate drugs for treating Covid patients at the healthcare facilities. They needed to monitor how many patients tested positive, how many nurses interacted with positive patients, and how many nurses were quarantined.
None of this information had been tracked before.
The business needed a solution to provide up-to-date numbers and to display this for different regions and markets with the ability to drill down to the facility level. With this data available, they could then transfer stock from one facility, that had an abundance, to another that was running short.
Critically, the solution needed to be immediately usable. There was no time to roll out user training programs; the system needed to be in use from the moment it arrived.
The Solution : Building an application
The healthcare provider was starting from scratch: not only did they need to build an application to track staffing and supplies, but they also had to put in place a mechanism to record the data that had not previously been captured. And, they had to deliver this in a format that could be easily used and understood by staff in hospitals and day centers.
Step one
First of all, they identified what data was needed; this was defined by the operational side of the business. Data from all healthcare facilities was identified and it took into consideration availability at different sites.
Step two
Having identified the data they needed, the teams had to consider how to capture this data. It was important to get the application up and running as quickly as possible, so they decided to use a system that the staff were already comfortable with. SharePoint forms were used to pull in the data from each center on a nightly basis; it relied on each center to input relevant data at the end of each day.
Step three
Step four
The Results : No more equipment shortages
The InfoBurst Squirrel application gets the key stats into the business at different levels in an easily consumable fashion. Data can be looked at by market, region and facility and can be drilled down even further. Data is also hidden when it’s not relevant to the individual user’s role.
Stats are included for PPE, staff, ventilators, gowns, gloves, sanitizing products, masks and Covid-specific drugs.
The application is a run-away success on many levels:
- Supply & demand of Covid-related staffing & supplies can be managed.
- The intuitive UI allows users to find what they need in just two or three clicks.
- Zero training was needed.
- The application was built with no code ensuring they met a deadline of just three weeks.
Watch the webinar
How USPI delivered an award winning emergency COVID-19 staffing & supplies application in just 3 weeks
InfoBurst Squirrel Developer License
From
$6,200
Annual subscription
