THE CHALLENGE
Management reporting around patient admin data had become cumbersome and slow, and led to poor and often inaccurate reporting. Resource was often spent fixing current problems, rather than finding new solutions and previous attempts at building an in-house data warehouse had failed. The Trust needed a single source of reliable and accurate data that they could gain real insight from.
Â
Â
Â
THE SOLUTION
CACI’s InView data warehouse provides a single source of information from across PAS, radiology, pathology and EPR modules, with data extraction and loading fully automated, and reports produced daily using SAP BusinessObjects. Qlik  dashboards are also being used in A&E, offering a live view and analysis of patient data with predictive capabilities.
Â
Â
Â
THE RESULTS
The role of data has completely changed. Time is now spent analysing results and developing innovative approaches to data handling to drive real-time insights. A&E can predict patient attendance, likely arrival modes and emergency admissions numbers, per weekday and hour. The self-serve model
has helped greater engagement and understanding from all departments.
Â
Â
Â