Event simulation model for an NHS Foundation Trust
Our client, a high performing NHS Foundation Trust, was building a new ward block and needed to understand its current bed usage.
Using patient admission and treatment data and ward size and use constraints we built a discrete event simulation to model the varying demand for the different wards. Capturing the natural variability in emergency patient admissions helped demonstrate the delicate balance between optimising activity and maintaining spare capacity.
Our client adopted our solution which helped them with planning for the significant increase in admissions expected during winter.
Dashboards for improving patient care in the NHS
Our client wanted us to assess its possible capital requirements over the next five years and consider the capital impact of several key strategic options.
It had been suffering from an ageing data warehouse, fed by hundreds of separate clinical systems. The bulk of internal reporting has been confined to circulating large Microsoft® Excel® spreadsheets via email.
Our client wanted to enable its data users to analyse often large, complex datasets, where it was convenient for them – at their desk, in clinic or on the move. It needed to change its internal reporting process to become faster, more flexible and mobile-friendly.
PwC supported the client’s objectives by implementing a trust-wide QlikView reporting system, with an integrated suite of user-friendly dashboards. These dashboards substantially improved the user’s access to information, including via mobile devices, and provided more up to date reporting, including automated data refreshes.
