SpagoBI for PAGODA, the Open Lab Governance Dashboard

Based on OpenLis and SpagoBI suite, Pagoda is the Clinical Laboratory Governance Dashboard used by the local healthcare unit of Modena (Italy).

Pagoda enables the collection, integration and processing of data coming from one or more clinical laboratories. Data are collected and analysed to provide valuable information to monitor, check and optimize the overall process workflow.

Pagoda allows laboratory managers to easily and autonomously monitor historical and real-time data regarding the following domains:

  • volumes – amount of collected samples and distribution of incoming requests based on time, types of tests and involved healthcare units. This aims at assessing the laboratory efficiency by identifying any bottleneck, and optimize single-laboratory and multi-laboratory manufacturing and distribution processes;
  • activities – monitoring of the entire workflow by tracing samples and highlight anomalies (e.g. non compliances of samples) or critical situations (e.g. samples turnaround time). This aims at analysing workflows and their load distribution among the involved laboratories over time;
  • consumables – measuring the actual usage of consumables versus prices declared by providers when applying for calls, as well as the traceability of the consumables path along clinical activity, up to the patient’s identity. This aims at evaluating the actual production costs of clinical activity, thus favouring the correct management of consumables and devices;
  • appropriateness – predictive analysis of how applying a rule would impact a specific clinical context and monitoring of effects upon actual rule enforcement. This aims at supporting laboratory managers in decision making, by evaluating and balancing both the quality of healthcare service provisioning and the usage of consumables.
  • quality – extraction of data and key performance indicators, e.g. turnaround time, delay on agreed SLAs, extraction of non-compliant data;
  • epidemiology – self-service design of statistical analyses, either microbiological or of any other type, which investigate the impact of specific parameters on population subject to clinical treatments. This aims at discovering spreading patterns and drivers, as well as define possible relations between predisposing factors and clinical treatments.

Pagoda offers both graphical and tabular views on data at different levels of detail, ranging from macro-areas such as health care departments to single analytical activities. It offers different types of queries and is able to compare values over different intervals of time. It allows authorized users to view and build their own dashboards, including different types of analyses, reports and key performance indicators, which can also be exported using the most common file formats.

By integrating external databases or data sources, Pagoda analytical features and the potential domains of analysis can be further extended.