Skip to main content
NCBI home page
Elsevier - PMC COVID-19 Collection logoLink to Elsevier - PMC COVID-19 Collection
. 2022 Oct 26;55(10):3124–3129. doi: 10.1016/j.ifacol.2022.10.209

Tracing and measuring the COVID-19 Colombian vaccination network

Trujillo-Diaz Johanna *, Amaya Ciro ⁎⁎, González-Uribe Catalina *, Hernandez Estefania ⁎⁎⁎, Herrera Andrea ⁎⁎, Velasco Nubia ⁎⁎⁎
PMCID: PMC9605722  PMID: 38620812

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: vaccination, COVID-19, dashboard, visualization, metrics, logistics

REFERENCES

  1. BAE J., SUKUMARAN R., SHANKAR S., SHARMA A., SINGH I., NAZIR H., KANG C., SRIVASTAVA S., PATWA P., SINGH A. Mobile Apps Prioritizing Privacy, Efficiency and Equity: A Decentralized Approach to COVID-19 Vaccination Coordination. arXiv preprint arXiv. 2021:09372. [Google Scholar]
  2. BERRY I., O'NEILL M., STURROCK S.L., WRIGHT J.E., ACHARYA K., BRANKSTON G., HARISH V., KORNAS K., MAANI N., NAGANATHAN T. A sub-national real-time epidemiological and vaccination database for the COVID-19 pandemic in Canada. Scientific Data. 2021;8:1–10. doi: 10.1038/s41597-021-00955-2. [DOI] [PMC free article] [PubMed] [Google Scholar]
  3. COLEV . Grupo COLEV-Universidad de Los Andes. El espectador; 2021. Colombia necesita varios ajustes en el sistema de información de vacunas. August 22nd. [Google Scholar]
  4. COVIDA . 2021. Vacunación gratuita en tres localidades de Bogotá.https://uniandes.edu.co/es/noticias/salud-y-medicina/vacunacion-gratuita-en-tres-localidades-de-bogota [Online]. Available. [Accessed October 1st 2021] [Google Scholar]
  5. DANE. 2018. Proyecciones de población. Proyecciones y retroproyecciones de población departamental para el periodo 1985-2017 y 2018-2050 con base en el CNPV 2018 [Online]. Available: https://www.dane.gov.co/index.php/estadisticas-por-tema/demografia-y-poblacion/proyecciones-de-poblacion [Accessed February 3 2021].
  6. DE MOURA PEREIRA D.A., DOS SANTOS M., DE OLIVEIRA COSTA D. Análise da distribuição de vacinas contra o covid-19 no Cariri Paraibano a partir do desenvolvimento de um dashboard em power BI. Archives of Health. 2021;2:430–441. [Google Scholar]
  7. 7.DÍAZ-PIRAQUIVE, F. N., DE JESÚS MURIEL-PEREA, Y. & ORDOÑEZ-DÍAZ, M. S. Implementation of the Management System of Knowledge for the Process Management of a Sterilization Central. In:UDEN, L., TING, I. H. & WANG, K., eds. Knowledge Management in Organizations, 2021//2021 Cham. Springer International Publishing, 280-291.
  8. GAUS D. COVID-19: vacunas. Práctica Familiar Rural. 2021;6:1–5. [Google Scholar]
  9. 9.GCDL Global Change Data Lab, Coronavirus (COVID-19) Vaccinations. Daily. 2020 Global Change Data Lab. [Google Scholar]
  10. HOLMSTRÖM, J., KETOKIVI, M. & HAMERI, A. P. J. D. S. 2009. Bridging practice and theory: A design science approach. 40,65-87.
  11. LEVENE, M. & LOIZOU, G. J. I. S. 2003. Why is the snowflake schema a good data warehouse design? 28,225-240.
  12. MATHIEU E., RITCHIE H., ORTIZ-OSPINA E., ROSER M., HASELL J., APPEL C., GIATTINO C., RODÉS-GUIRAO L. A global database of COVID-19 vaccinations. Nature human behaviour. 2021;5:1–7. doi: 10.1038/s41562-021-01122-8. [DOI] [PubMed] [Google Scholar]
  13. MENTZER, J. T., DEWITT, W., KEEBLER, J. S., MIN, S., NIX, N. W., SMITH, C. D. & ZACHARIA, Z. G. J. J. O. B. L. 2001. Defining supply chain management. 22,1-25.
  14. MITRA A., SOMAN B., SINGH G. An Interactive Dashboard for Real-Time Analytics and Monitoring of COVID-19 Outbreak in India: A proof of Concept. arXiv preprint arXiv. 2021:09937. [Google Scholar]
  15. MSPS. 2021 a. Asignación de dosis de vacuna contra COVID-19 [Online]. Available: https://www.datos.gov.co/Salud-y-Protecci-n-Social/Asignaci-n-de-dosis-de-vacuna-contra-COVID-19/sdvb-4x4j [Accessed December 31st 2020].
  16. MSPS . Ministerio de Salud y Protección Social; 2021. Infografía Plan Nacional de Vacunación (PNV) contra COVID-19 [Online]https://www.minsalud.gov.co/salud/publica/Vacunacion/Paginas/Vacunacion-covid-19.aspx b. Available. [Accessed August 30th, 2021 2021] [Google Scholar]
  17. MSPS . Ministerio de Salud y de Protección Social; 2021. Llegadas de vacunas por laboratorio y dosis aplicadas por entidad territorial [Online]https://docs.google.com/spreadsheets/d/1N4V-qqp6q8exuYAZgZ79GT9GazsSCHUK/edit#gid=625217412 c. Available. [Accessed December 31st 2021] [Google Scholar]
  18. MSPS . 2021. Ministerio de Salud y Protección Social. Cantidad de prestadores con puntos de vacunación - Registro especial de prestadores de servicios de salud – REPS - Ministerio de Salud y Protección Social.https://minsalud.maps.arcgis.com/apps/dashboards/e12f9e426dba423cab76c981af7a5791 d. [Online]. Available. [Accessed July 17th 2021] [Google Scholar]
  19. MSPS. 2021 e. Normativa resoluciones - Año: 2021 [Online]. Bogotá D.C. (Colombia). Available: https://www.minsalud.gov.co/Paginas/Norm_Resoluciones.aspx [Accessed August 29th 2021].
  20. MSPS. 2021 f. Rezago en el registro de dosis aplicadas contra COVID-19 en PAIWEB [Online]. Available: https://app.powerbi.com/view?r=eyJrIjoiNThmZTJmZWYtOWFhMy00OGE1LWFiNDAtMTJmYjM0NDA5NGY2IiwidCI6ImJmYjdlMTNhLTdmYjctNDAxNi04MzBjLWQzNzE2ZThkZDhiOCJ9 [Accessed December 31st 2021].
  21. PESTANA M., PEREIRA R., MORO S. Improving Health Care Management in Hospitals Through a Productivity Dashboard. J Med Syst. 2020;44:87. doi: 10.1007/s10916-020-01546-1. [DOI] [PubMed] [Google Scholar]
  22. PILATI F., TRONCONI R., NOLLO G., HERAGU S.S., ZERZER F. Digital Twin of COVID-19 Mass Vaccination Centers. Sustainability. 2021;13:7396. [Google Scholar]
  23. REPÚBLICA DE COLOMBIA 1991. Constitución Política de Colombia [Const]. Art. 20 y 74. (Colombia). Colombia.
  24. SHAHEEN A.W., CIESCO E., JOHNSON K., KUHNEN G., PAOLINI C., GARTNER G. Interactive, on-line visualization tools to measure and drive equity in COVID-19 vaccine administrations. Journal of the American Medical Informatics Association. 2021 doi: 10.1093/jamia/ocab180. [DOI] [PMC free article] [PubMed] [Google Scholar]
  25. SHROTRI M., SWINNEN T., KAMPMANN B., PARKER E.P. An interactive website tracking COVID-19 vaccine development. The Lancet Global Health. 2021;9:e590–e592. doi: 10.1016/S2214-109X(21)00043-7. [DOI] [PMC free article] [PubMed] [Google Scholar]
  26. UAEMC Estatuto temporal de protección - Estatuto Temporal de Protección - Prerregistros. Monthly. Unidad Administrativa Especial Migración Colombia (UAEMC) - Migración Colombia. 2020 [Google Scholar]
  27. UAEMC Flujos migratorios - 2020 Monthly. Unidad Administrativa Especial Migración Colombia (UAEMC) - Migración Colombia. 2020 [Google Scholar]
  28. WANG, Z. 2021. Equitable Distribution of Covid-19 Vaccines: Can Data Visualization and Optimization Help?
  29. XUE M. Høgskolen i Molde-Vitenskapelig høgskole i logistikk; 2021. Visualization of the distribution of COVID-19 vaccines in Norway. [Google Scholar]

Articles from Ifac-Papersonline are provided here courtesy of Elsevier

RESOURCES