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
  • R


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.