Use case: Financial & operations performance dashboard for Swiss hospitals
The dashboard was commissioned by a health service provider in August 2020 to support a restructuring mission of a swiss hospital and other missions.
The objective of this project was to develop a dashboard enabling its users to analyze real-time operations and financial performance of Swiss hospitals.
- Microsoft PowerBI
- Microsoft Access DB
The solution is a PowerBI dashboard integrating over 50 charts and tables in 15 sheets, enabling a peripheral view on live and past data of a wide variety of parameters such as admission type, origin of patients, departments, DRG data.
The dashboard also comprises a simulation tool enabling to optimize hospitals revenues using economic potential calculation.
The dashboard uses data from “OPALE” software, enabling regular refreshes and easy integration due to OFS standardized data.