Tracing and measuring the COVID-19 Colombian vaccination network

IFAC Pap OnLine. 2022;55(10):3124-3129. doi: 10.1016/j.ifacol.2022.10.209. Epub 2022 Oct 26.

Abstract

The COVID-19 vaccination process in Colombia has been a major challenge not only in terms of public health but also in terms of supply chain management and logistics processes. To support the monitoring of these processes and associated decision-making, a dashboard was designed in Google Data Studio focused on analyzing the progress of COVID-19 vaccination and its logistics efficiency. This article describes the design and implementation of the dashboard using a design science approach and discusses the main lessons learned. During its development, four major challenges were identified: the search for and availability of data sources, the definition and standardization of metrics, the extraction of data in different formats; and finally, the validation of the metrics. Despite these challenges, the dashboard became a source of information for different stakeholders in the Colombian COVID-19 vaccination network, facilitating the monitoring of key performance indicators (KPIs), supporting decision-making, and policy evaluation. This reaffirms the importance of having open information to generate knowledge for both public and private entities as well as for the public. The main contribution of this work is the definition and standardization of the KPIs and it is therefore expected that this experience will serve as an insightful input for designing mass vaccination strategies.

Keywords: COVID-19; dashboard; logistics; metrics; vaccination; visualization.