<?xml version="1.0" encoding="ISO-8859-1"?><article xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<front>
<journal-meta>
<journal-id>0124-0064</journal-id>
<journal-title><![CDATA[Revista de Salud Pública]]></journal-title>
<abbrev-journal-title><![CDATA[Rev. salud pública]]></abbrev-journal-title>
<issn>0124-0064</issn>
<publisher>
<publisher-name><![CDATA[Instituto de Salud Publica, Facultad de Medicina - Universidad Nacional de Colombia]]></publisher-name>
</publisher>
</journal-meta>
<article-meta>
<article-id>S0124-00642020000200214</article-id>
<article-id pub-id-type="doi">10.15446/rsap.v22n2.87668</article-id>
<title-group>
<article-title xml:lang="en"><![CDATA[An interactive web-based dashboard to track COVID-19 in Colombia. Case study: five main cities]]></article-title>
<article-title xml:lang="es"><![CDATA[Aplicativo web para el seguimiento del COVID-19 en Colombia. Estudio de caso: cinco ciudades principales]]></article-title>
</title-group>
<contrib-group>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Aristizábal-Torres]]></surname>
<given-names><![CDATA[Daniel]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Peñuela-Meneses]]></surname>
<given-names><![CDATA[Cesar A.]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Barrera-Rodríguez]]></surname>
<given-names><![CDATA[Ana M.]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
</contrib-group>
<aff id="Af1">
<institution><![CDATA[,Universidad Libre  ]]></institution>
<addr-line><![CDATA[Pereira ]]></addr-line>
<country>Colombia</country>
</aff>
<aff id="Af2">
<institution><![CDATA[,Universidad Libre  ]]></institution>
<addr-line><![CDATA[Pereira ]]></addr-line>
<country>Colombia</country>
</aff>
<aff id="Af3">
<institution><![CDATA[,Universidad Libre  ]]></institution>
<addr-line><![CDATA[Pereira ]]></addr-line>
<country>Colombia</country>
</aff>
<pub-date pub-type="pub">
<day>00</day>
<month>04</month>
<year>2020</year>
</pub-date>
<pub-date pub-type="epub">
<day>00</day>
<month>04</month>
<year>2020</year>
</pub-date>
<volume>22</volume>
<numero>2</numero>
<fpage>214</fpage>
<lpage>219</lpage>
<copyright-statement/>
<copyright-year/>
<self-uri xlink:href="http://www.scielo.org.co/scielo.php?script=sci_arttext&amp;pid=S0124-00642020000200214&amp;lng=en&amp;nrm=iso"></self-uri><self-uri xlink:href="http://www.scielo.org.co/scielo.php?script=sci_abstract&amp;pid=S0124-00642020000200214&amp;lng=en&amp;nrm=iso"></self-uri><self-uri xlink:href="http://www.scielo.org.co/scielo.php?script=sci_pdf&amp;pid=S0124-00642020000200214&amp;lng=en&amp;nrm=iso"></self-uri><abstract abstract-type="short" xml:lang="en"><p><![CDATA[ABSTRACT  Objective Design and implement an interactive web-based dashboard to track COVID-19 in Colombia  Methods A tool was designed and implemented to analyze the data of Covid-19 positive cases in Colombia and published by the Instituto Nacional de Salud. The tool is based on the implementation of business intelligence methods with which you can understand the behavior of the pandemic in Colombia and generate structured data for decision-making by government levels. The tool displays, on a single screen, information on the number of cases, patient status, age ranges, city, location department, and gender. This information can be dynamically filtered and focus analyzes on the national, departmental, or municipal order. Additionally, methods are implemented for trend analysis, both on a linear and semi-log scale, as well as for calculating the case fatality rate in each of the municipalities.  Results A web-based data analysis dashboard is implemented for semi-continuous monitoring of the COVID-19 pandemic in Colombia. With the use of the tool, a situational analysis is carried out for five of the most important cities in Colombia.  Conclusions The application is effective, flexible, and easy to use. The situational analysis reflects that public policies for the control of the disease have been favorable for Medellín, but for Cartagena, Bogotá, Barranquilla, and Cali, complementary measures are required.]]></p></abstract>
<abstract abstract-type="short" xml:lang="es"><p><![CDATA[RESUMEN  Objetivo Diseñar e implementar una herramienta dinámica web para el seguimiento de la COVID-19 en Colombia.  Métodos Se diseña e implementa una herramienta para el análisis de los datos de los casos positivos de COVID-19 en Colombia y publicados por el Instituto Nacional de Salud. La herramienta se basa en la implementación de métodos de inteligencia empresarial con los que se pueda entender el comportamiento de la pandemia en Colombia y generar datos estructurados para la toma de decisiones por parte de los estamentos gubernamentales. La herramienta despliega, en una sola pantalla, información sobre número de casos, estado de los pacientes, rangos de edad, ciudad y departamento de ubicación y género. Esta información puede ser filtrada de forma dinámica y enfocar los análisis en el orden nacional, departamental o municipal. Adicionalmente, se implementan métodos para el análisis de tendencia, tanto en escala lineal como en escala semilogarítmica, así como para el cálculo de la tasa de letalidad en cada uno de los municipios.  Resultados Se implementó una herramienta de análisis de datos basado en la web para el seguimiento semicontinuo de la pandemia de la COVID-19 en Colombia. A partir de la herramienta se realiza un análisis situacional para cinco de las ciudades más importantes de Colombia.  Conclusiones El aplicativo es eficaz, flexible y de fácil manejo. El análisis situacional refleja que las políticas públicas para el control de la enfermedad han sido efectivas para Medellín, pero, para Cartagena, Bogotá, Barranquilla y Cali, se requieren medidas complementarias.]]></p></abstract>
<kwd-group>
<kwd lng="en"><![CDATA[Pandemics]]></kwd>
<kwd lng="en"><![CDATA[Colombia]]></kwd>
<kwd lng="en"><![CDATA[coronavirus infections (source: MeSH, NLM)]]></kwd>
<kwd lng="es"><![CDATA[Pandemia]]></kwd>
<kwd lng="es"><![CDATA[Colombia]]></kwd>
<kwd lng="es"><![CDATA[infecciones por coronavirus (fuente. DeCs, BIREME)]]></kwd>
</kwd-group>
</article-meta>
</front><back>
<ref-list>
<ref id="B1">
<label>1</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Dong]]></surname>
<given-names><![CDATA[E]]></given-names>
</name>
<name>
<surname><![CDATA[Du]]></surname>
<given-names><![CDATA[H]]></given-names>
</name>
<name>
<surname><![CDATA[Gardner]]></surname>
<given-names><![CDATA[L]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[An interactive web-based dashboard to track COVID-19 in real time]]></article-title>
<source><![CDATA[Lancet Infect Dis]]></source>
<year>2020</year>
<volume>20</volume>
<numero>5</numero>
<issue>5</issue>
<page-range>533-4</page-range></nlm-citation>
</ref>
<ref id="B2">
<label>2</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[González-Jaramillo]]></surname>
<given-names><![CDATA[Valentina]]></given-names>
</name>
<name>
<surname><![CDATA[González-Jaramillo]]></surname>
<given-names><![CDATA[N]]></given-names>
</name>
<name>
<surname><![CDATA[Gómez-Restrepo]]></surname>
<given-names><![CDATA[C]]></given-names>
</name>
<name>
<surname><![CDATA[Palacio-Acosta]]></surname>
<given-names><![CDATA[C]]></given-names>
</name>
<name>
<surname><![CDATA[Gómez-López]]></surname>
<given-names><![CDATA[A]]></given-names>
</name>
<name>
<surname><![CDATA[Franco]]></surname>
<given-names><![CDATA[O]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Proyecciones de impacto de la pandemia COVID-19 en la población colombiana, según medidas de mitigación. Datos preliminares de modelos epidemiológicos para el periodo del 18 de marzo al 18 de abril de 2020]]></article-title>
<source><![CDATA[Rev Salud Pública]]></source>
<year>2020</year>
<volume>22</volume>
<numero>2</numero>
<issue>2</issue>
<page-range>1-6</page-range><publisher-loc><![CDATA[Bogotá ]]></publisher-loc>
</nlm-citation>
</ref>
<ref id="B3">
<label>3</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Manrique-Abril]]></surname>
<given-names><![CDATA[FG]]></given-names>
</name>
<name>
<surname><![CDATA[Agudelo-Calderon]]></surname>
<given-names><![CDATA[CA]]></given-names>
</name>
<name>
<surname><![CDATA[González-Chordá]]></surname>
<given-names><![CDATA[VM]]></given-names>
</name>
<name>
<surname><![CDATA[Gutiérrez-Lesmes]]></surname>
<given-names><![CDATA[O]]></given-names>
</name>
<name>
<surname><![CDATA[Téllez-Piñerez]]></surname>
<given-names><![CDATA[CF]]></given-names>
</name>
<name>
<surname><![CDATA[Herrera-Amaya]]></surname>
<given-names><![CDATA[G]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Modelo SIR de la pandemia de Covid-19 en Colombia/SIR model of the COVID-19 pandemic in Colombia]]></article-title>
<source><![CDATA[Rev Salud Pública]]></source>
<year>2020</year>
<volume>22</volume>
<numero>2</numero>
<issue>2</issue>
<page-range>1-9</page-range><publisher-loc><![CDATA[Bogotá ]]></publisher-loc>
</nlm-citation>
</ref>
<ref id="B4">
<label>4</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Berry]]></surname>
<given-names><![CDATA[I]]></given-names>
</name>
<name>
<surname><![CDATA[Soucy]]></surname>
<given-names><![CDATA[JPR]]></given-names>
</name>
<name>
<surname><![CDATA[Tuite]]></surname>
<given-names><![CDATA[A]]></given-names>
</name>
<name>
<surname><![CDATA[Fisman]]></surname>
<given-names><![CDATA[D]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Open access epidemiologic data and an interactive dashboard to monitor the COVID-19 outbreak in Canad]]></article-title>
<source><![CDATA[Cmaj]]></source>
<year>2020</year>
<volume>192</volume>
<numero>15</numero>
<issue>15</issue>
</nlm-citation>
</ref>
<ref id="B5">
<label>5</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Kamel Boulos]]></surname>
<given-names><![CDATA[MN]]></given-names>
</name>
<name>
<surname><![CDATA[Geraghty]]></surname>
<given-names><![CDATA[EM]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Geographical tracking and mapping of coronavirus disease COVID-19/severe acute respiratory syndrome coronavirus 2 (SARS-CoV-2) epidemic and associated events around the world: How 21st century GIS technologies are supporting the global fight against outbreaks and epidemics]]></article-title>
<source><![CDATA[Int J Health Geogr]]></source>
<year>2020</year>
<volume>19</volume>
<numero>1</numero>
<issue>1</issue>
<page-range>1-12</page-range></nlm-citation>
</ref>
<ref id="B6">
<label>6</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Kamadjeu]]></surname>
<given-names><![CDATA[R]]></given-names>
</name>
<name>
<surname><![CDATA[Gathenji]]></surname>
<given-names><![CDATA[C]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Designing and implementing an electronic dashboard for disease outbreaks response - Case study of the 20132014 Somalia Polio outbreak response dashboard]]></article-title>
<source><![CDATA[Pan Afr Med J]]></source>
<year>2017</year>
<volume>27</volume>
<numero>^s3</numero>
<issue>^s3</issue>
<supplement>3</supplement>
<page-range>22</page-range></nlm-citation>
</ref>
<ref id="B7">
<label>7</label><nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Lachev]]></surname>
<given-names><![CDATA[T]]></given-names>
</name>
<name>
<surname><![CDATA[Price]]></surname>
<given-names><![CDATA[E]]></given-names>
</name>
</person-group>
<source><![CDATA[Applied Microsoft Power BI (3rd Edition): Bring Your Data to Life!]]></source>
<year>2018</year>
<edition>3</edition>
<publisher-name><![CDATA[Prologika Press]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B8">
<label>8</label><nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Knight D]]></surname>
<given-names><![CDATA[Pearson M]]></given-names>
</name>
<name>
<surname><![CDATA[Quintana]]></surname>
<given-names><![CDATA[M. Powell B]]></given-names>
</name>
</person-group>
<source><![CDATA[Microsoft Power BI Complete Reference]]></source>
<year>2018</year>
<publisher-loc><![CDATA[Birmingham ]]></publisher-loc>
<publisher-name><![CDATA[Packt Publishing]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B9">
<label>9</label><nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Russo]]></surname>
<given-names><![CDATA[M]]></given-names>
</name>
<name>
<surname><![CDATA[Ferrari]]></surname>
<given-names><![CDATA[A]]></given-names>
</name>
</person-group>
<source><![CDATA[The Definitive Guide to DAX: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel]]></source>
<year>2019</year>
<publisher-name><![CDATA[Pearson Education (Business Skills)]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B10">
<label>10</label><nlm-citation citation-type="book">
<collab>Portafolio</collab>
<source><![CDATA[Estas son las ciudades más pobladas del país]]></source>
<year>2019</year>
<publisher-name><![CDATA[Portafolio]]></publisher-name>
</nlm-citation>
</ref>
</ref-list>
</back>
</article>
