Use case: Financial & operations performance dashboard for Swiss hospitals

Context:

The dashboard was commissioned by a health service provider in August 2020 to support a restructuring mission of a swiss hospital and other missions.

Objective:

The objective of this project was to develop a dashboard enabling its users to analyze real-time operations and financial performance of Swiss hospitals.

Technologies:

  • Microsoft PowerBI
  • Microsoft Access DB
  • R

Solution:

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.

Newsletter

© 2021 Effixis SA. All rights reserved.