Diseño de un Dashboard para el manejo y análisis de los datos de casos positivos del covid-19 en Colombia utilizando herramientas de inteligencia de negocios y de analítica de datos
Cargando...
Fecha
2021
Autores
Barrios Pérez, Andrés Felipe
De la Cruz Padilla, Roberto José
Pabón Granados, Pedro Pablo
Ruiz Otero, Nilson Rafael
Título de la revista
ISSN de la revista
Título del volumen
Editor
Ediciones Universidad Simón Bolívar
Facultad de Ingenierías
Facultad de Ingenierías
Resumen
La pandemia de covid-19 ha tenido una gran impacto en Colombia afectando varios aspectos en nuestro país, de esta se generan una basta cantidad de datos para la producción de reportes y gráficos estadísticos para que informen a las personas, donde cada día se recibe información, a través de diversos medios, de los nuevos casos positivos, muertos, contagiados y demás datos sobre el covid-19. A pesar de que cada día se recibe esta información, no se ha encontrado una plataforma o sitio que evidencie de forma visual y gráfica datos detallados y completos sobre los casos positivos de covid-19. El objetivo de este proyecto de investigación está en generar un análisis sobre covid 19 en Colombia, ya que la pandemia genera un gran cantidad de datos que son almacenados en archivos CVS, Planos, XML entre otros. Estos son utilizados para generar reportes estadísticos y realizar análisis de: contagios, recuperados, muertos e importados. Estos datos son procesados por distintas ciencias del saber, los cuales son adjuntados a un documento, pero la manera en que se presentan no siempre es clara y fácil de interpretar, por parte de personas sin esos conocimientos. Por lo anterior se toma la determinación de llevar a cabo un proyecto de implementar una data Warehouse, una herramienta rápida y confiable para el análisis y búsqueda de datos, lo que permitirá un manejo eficiente de la información. En conclusión la investigación ayudará en gran medida a las personas a entender y estar informado, para poder tomar decisiones acertadas en cuanto a los datos empleados en la investigación.
The covid-19 pandemic has had a great impact in Colombia affecting several aspects in our country, from this a large amount of data is generated for the production of statistical reports and graphs to inform people, where every day information is received through various media, new positive cases, deaths, infected and other data on covid-19. Although this information is received every day, no platform or site has been found that visually and graphically shows detailed and complete data on positive cases of covid-19. The objective of this research project is to generate an analysis of covid 19 in Colombia, since the pandemic generates a large amount of data that are stored in CVS, Plans, XML files, among others. These are used to generate statistical reports and perform analysis of: infections, recovered, dead and imported. These data are processed by different sciences of knowledge, which are attached to a document, but the way they are presented is not always clear and easy to interpret by people without such knowledge. Therefore, it was decided to carry out a project to implement a data warehouse, a fast and reliable tool for the analysis and search of data, which will allow an efficient management of the information. In conclusion, the research will greatly help people to understand and be informed, in order to be able to make the right decisions regarding the data used in the research.
The covid-19 pandemic has had a great impact in Colombia affecting several aspects in our country, from this a large amount of data is generated for the production of statistical reports and graphs to inform people, where every day information is received through various media, new positive cases, deaths, infected and other data on covid-19. Although this information is received every day, no platform or site has been found that visually and graphically shows detailed and complete data on positive cases of covid-19. The objective of this research project is to generate an analysis of covid 19 in Colombia, since the pandemic generates a large amount of data that are stored in CVS, Plans, XML files, among others. These are used to generate statistical reports and perform analysis of: infections, recovered, dead and imported. These data are processed by different sciences of knowledge, which are attached to a document, but the way they are presented is not always clear and easy to interpret by people without such knowledge. Therefore, it was decided to carry out a project to implement a data warehouse, a fast and reliable tool for the analysis and search of data, which will allow an efficient management of the information. In conclusion, the research will greatly help people to understand and be informed, in order to be able to make the right decisions regarding the data used in the research.
Descripción
Palabras clave
Herramientas de inteligencia de Negocios, DataWareHouse, Bases de datos, ETL, Covid 19, Colombia, Datos, Business intelligence tools, Databases, Data
