Industry
Healthcare, Research, Clinical Anesthesiology
Company
Public, State Hospital
Requirements
- Analyze operating room case data
- Compare and Analyze Scheduling Data
- Determine how efficiency and effectiveness of scheduling clinicians to operating rooms
- How busy was each clinician?
- How many cases concurrent?
- How much down time?
- What are the busiest times/days?
- How hard are the clinicians working?
- Create an application interface to graphically view data
Solution
This was a perfect opportunity for MongoDB’s aggregation toolset. We started by processing the raw case information from the medical record and broke down every clinician’s work on a case to the minute. We had a row for every minute worked or not.
With that, we used Mongo’s aggregation engine to see when when I clinician was idle, or working on one or more cases.
We created an interface that could be access by clinician or case. The administration could graphically see how busy their staff was on any given day, hour, or minute. This enabled them to evaluate clinician effort, scheduling deficiencies, and assignment issues.
Technologies
- MongoDB
- Angular
- NodeJS (ActionheroJS)
- Epic
- Redis
- Azure