Sint-Rembert hospital works smarter with better reporting
If you have to go to hospital for treatment, you want to how long you’ll be staying and how much it will cost, so that you can prepare yourself mentally and take care of all your practical arrangements. The hospital wants this information too, so it can work out what resources, scheduling and financial planning are required. That’s why Sint-Rembert hospital in Torhout is now working with a more intelligent and better reporting system, also so it can rule out any unpleasant surprises.
The aim is to read in various types of data file (with medical diagnoses, medicines, number of bed days, admission and discharge details), as well as plan staffing requirements. This enables the hospital to check which teams will need extra support in busy periods, calculate the cost-price for patient interventions, group activities together by health insurance codes, work out the total cost of treatment, assess the ratio between bed days and personnel planning, etc.
Together with an analyst and the hospital’s IT team, we set up a proof-of-concept reporting system for MS Power BI. The hospital already generates a whole series of reports, but they still require hours of manual work and are difficult to share with all hospital employees. These lost hours are becoming a thing of the past, however, thanks to MS Power BI.
