The challenge
Hillel Yaffe Medical Center in Hadera provides comprehensive, high-level medical services across a broad range of specialties, and employs about 2,000 people in many professions.
The hospital faced many lawsuits, mainly claiming that emergency physicians weren't available for urgent cases at night. The hospital's Business Application Manager came to us for a quick solution: the manual, outdated physician scheduling process was hurting efficiency and productivity, and made it hard to make the best use of the hospital's most valuable resource, its medical staff.
The solution
Together we built a state-of-the-art solution to track and manage all the data about the availability of critical people: doctors, nurses, laboratory assistants, technicians, paramedics, maintenance and service staff, and administrative staff. It's all built on Microsoft 365, and went live after 12 weeks of work.
The solution is built on Microsoft 365, which the organisation already uses every day. Data can be copied and pasted from Excel for bulk operations, the system alerts about early or late dates, supports SAP's regional hierarchy structure, and saves data entry and maintenance time.
What we built
-
Microsoft Power Apps An app to manage the data
We built a Power Apps app with SharePoint as the back end, to collect and store the information, including user management and data about all staff.
Details An app to manage the data -
Microsoft Power BI A real-time view
A Power BI dashboard shows graphs and key indicators on cases, contacts and follow-ups in real time, and gives a quick view of the whole hospital's inventory.
Details A real-time view -
Microsoft Power Automate Automatic updates
Power Automate flows keep every user up to date at all times, and report the current status of nursing staff and equipment in use. The whole process is automated, updates as soon as anything changes, and every user can search and filter the data according to their permissions.
Details Automatic updates
The results
The hospital saves millions of dollars a year, pays its medical staff according to actual need, and prevents lawsuits from disappointed patients.
