Business Intelligence for the Programs of the Secretaries of Health, Education and Planning in a Territorial Entity
Territorial entities in Colombia are bound by the law to register and report to different instances the control information of the government programs they administer. However, so much information is distributed on various state and owned platforms that the result is processed and generated in diffe...
| Main Authors: | , , , , , |
|---|---|
| Format: | Online |
| Language: | eng |
| Published: |
Universidad Pedagógica y Tecnológica de Colombia
2021
|
| Subjects: | |
| Online Access: | https://revistas.uptc.edu.co/index.php/ingenieria/article/view/13826 |
| _version_ | 1801706094516502528 |
|---|---|
| author | Varona-Taborda, Maria-Alejandra Mosquera-Ramírez, Jorge-Cesar Medina-Moreno, César-Augusto Lemus-Muñoz, Diego-Fernando Muñoz-Hernandez, Carlos-Julián Arias-Iragorri, Christian-Gustavo |
| author_facet | Varona-Taborda, Maria-Alejandra Mosquera-Ramírez, Jorge-Cesar Medina-Moreno, César-Augusto Lemus-Muñoz, Diego-Fernando Muñoz-Hernandez, Carlos-Julián Arias-Iragorri, Christian-Gustavo |
| author_sort | Varona-Taborda, Maria-Alejandra |
| collection | OJS |
| description | Territorial entities in Colombia are bound by the law to register and report to different instances the control information of the government programs they administer. However, so much information is distributed on various state and owned platforms that the result is processed and generated in different formats. This situation makes the comprehensive management of territorial data difficult, since, although the information exists, it is isolated, and its analysis is carried out independently by each party responsible for the process. The objective of this research is the Implementation of a business intelligence model that allows integration and analysis of data from the programs of the Health, Education, and Planning ministries for a Territorial Entity. Ralph Kimball's methodology was used, implementing a star topology model in the Datamart using MySQL as a database manager, an ETL system was built with the Pentaho tool which allows the extraction, transformation, and loading of the data in the Datamart. The cubes, reports and Dashboard are obtained with the management of tools such as Pentaho and Power BI, thus it is possible to make a correct interpretation of the resulting information. After applying Business Intelligence, it is possible to generate an adequate analysis of the information, allowing decision-making and application of new strategies to solve specific problems using control panels, visualization of indicators and generation of reports. |
| format | Online |
| id | oai:oai.revistas.uptc.edu.co:article-13826 |
| institution | Revista Facultad de Ingeniería |
| language | eng |
| publishDate | 2021 |
| publisher | Universidad Pedagógica y Tecnológica de Colombia |
| record_format | ojs |
| spelling | oai:oai.revistas.uptc.edu.co:article-138262023-05-31T16:25:20Z Business Intelligence for the Programs of the Secretaries of Health, Education and Planning in a Territorial Entity Inteligencia de negocios para los programas de las secretarías de salud, educación y planeación en un ente territorial Varona-Taborda, Maria-Alejandra Mosquera-Ramírez, Jorge-Cesar Medina-Moreno, César-Augusto Lemus-Muñoz, Diego-Fernando Muñoz-Hernandez, Carlos-Julián Arias-Iragorri, Christian-Gustavo business intelligence datamart etl Kimball methodology territorial entity datamart ente territorial ETL inteligencia de negocios metodología Kimball Territorial entities in Colombia are bound by the law to register and report to different instances the control information of the government programs they administer. However, so much information is distributed on various state and owned platforms that the result is processed and generated in different formats. This situation makes the comprehensive management of territorial data difficult, since, although the information exists, it is isolated, and its analysis is carried out independently by each party responsible for the process. The objective of this research is the Implementation of a business intelligence model that allows integration and analysis of data from the programs of the Health, Education, and Planning ministries for a Territorial Entity. Ralph Kimball's methodology was used, implementing a star topology model in the Datamart using MySQL as a database manager, an ETL system was built with the Pentaho tool which allows the extraction, transformation, and loading of the data in the Datamart. The cubes, reports and Dashboard are obtained with the management of tools such as Pentaho and Power BI, thus it is possible to make a correct interpretation of the resulting information. After applying Business Intelligence, it is possible to generate an adequate analysis of the information, allowing decision-making and application of new strategies to solve specific problems using control panels, visualization of indicators and generation of reports. Los entes territoriales en Colombia por ley deben registrar y reportar a diferentes instancias la información de control de los programas gubernamentales que administran. Sin embargo, es tanta la información distribuida en diversas plataformas estatales y propias, que el resultado es procesado y generado en diferentes formatos. Esta situación dificulta el manejo integral de los datos territoriales, pues, aunque la información existe, se encuentra aislada y su análisis se realiza de manera independiente por cada parte responsable del proceso. El objetivo de esta investigación es la Implementación de un modelo de inteligencia de negocios que permite integración y análisis de los datos de los programas de las secretarías de Salud, Educación y Planeación para un Ente Territorial. Se empleó la metodología de Ralph Kimball implementando un modelo de topología estrella en el Datamart; utilizando como gestor de base de datos MySQL se construye un sistema ETL con la herramienta Pentaho que permite la extracción, transformación y carga de los datos en el Datamart. Se obtienen los cubos, reportes y Dashboard con el manejo de herramientas como Pentaho y Power BI y de este modo es posible realizar una correcta interpretación de la información resultante. Después de aplicar Inteligencia de Negocios se logra generar un adecuado análisis de la información, permitiendo la toma de decisiones y aplicación de nuevas estrategias para dar solución a problemas específicos mediante la utilización de tableros de control, visualización de indicadores y generación de reportes. Universidad Pedagógica y Tecnológica de Colombia 2021-12-11 info:eu-repo/semantics/article info:eu-repo/semantics/publishedVersion application/pdf text/xml https://revistas.uptc.edu.co/index.php/ingenieria/article/view/13826 10.19053/01211129.v30.n58.2021.13826 Revista Facultad de Ingeniería; Vol. 30 No. 58 (2021): October-December 2021 (Continuous Publication); e13826 Revista Facultad de Ingeniería; Vol. 30 Núm. 58 (2021): Octubre-Diciembre 2021 (Publicación Continua) ; e13826 2357-5328 0121-1129 eng https://revistas.uptc.edu.co/index.php/ingenieria/article/view/13826/11269 https://revistas.uptc.edu.co/index.php/ingenieria/article/view/13826/11305 Copyright (c) 2021 Maria-Alejandra Varona-Taborda, Jorge-Cesar Mosquera-Ramírez, César-Augusto Medina-Moreno, Diego-Fernando Lemus-Muñoz, Carlos-Julián Muñoz-Hernandez, Christian-Gustavo Arias-Iragorri http://creativecommons.org/licenses/by/4.0 |
| spellingShingle | business intelligence datamart etl Kimball methodology territorial entity datamart ente territorial ETL inteligencia de negocios metodología Kimball Varona-Taborda, Maria-Alejandra Mosquera-Ramírez, Jorge-Cesar Medina-Moreno, César-Augusto Lemus-Muñoz, Diego-Fernando Muñoz-Hernandez, Carlos-Julián Arias-Iragorri, Christian-Gustavo Business Intelligence for the Programs of the Secretaries of Health, Education and Planning in a Territorial Entity |
| title | Business Intelligence for the Programs of the Secretaries of Health, Education and Planning in a Territorial Entity |
| title_alt | Inteligencia de negocios para los programas de las secretarías de salud, educación y planeación en un ente territorial |
| title_full | Business Intelligence for the Programs of the Secretaries of Health, Education and Planning in a Territorial Entity |
| title_fullStr | Business Intelligence for the Programs of the Secretaries of Health, Education and Planning in a Territorial Entity |
| title_full_unstemmed | Business Intelligence for the Programs of the Secretaries of Health, Education and Planning in a Territorial Entity |
| title_short | Business Intelligence for the Programs of the Secretaries of Health, Education and Planning in a Territorial Entity |
| title_sort | business intelligence for the programs of the secretaries of health education and planning in a territorial entity |
| topic | business intelligence datamart etl Kimball methodology territorial entity datamart ente territorial ETL inteligencia de negocios metodología Kimball |
| topic_facet | business intelligence datamart etl Kimball methodology territorial entity datamart ente territorial ETL inteligencia de negocios metodología Kimball |
| url | https://revistas.uptc.edu.co/index.php/ingenieria/article/view/13826 |
| work_keys_str_mv | AT varonatabordamariaalejandra businessintelligencefortheprogramsofthesecretariesofhealtheducationandplanninginaterritorialentity AT mosqueraramirezjorgecesar businessintelligencefortheprogramsofthesecretariesofhealtheducationandplanninginaterritorialentity AT medinamorenocesaraugusto businessintelligencefortheprogramsofthesecretariesofhealtheducationandplanninginaterritorialentity AT lemusmunozdiegofernando businessintelligencefortheprogramsofthesecretariesofhealtheducationandplanninginaterritorialentity AT munozhernandezcarlosjulian businessintelligencefortheprogramsofthesecretariesofhealtheducationandplanninginaterritorialentity AT ariasiragorrichristiangustavo businessintelligencefortheprogramsofthesecretariesofhealtheducationandplanninginaterritorialentity AT varonatabordamariaalejandra inteligenciadenegociosparalosprogramasdelassecretariasdesaludeducacionyplaneacionenunenteterritorial AT mosqueraramirezjorgecesar inteligenciadenegociosparalosprogramasdelassecretariasdesaludeducacionyplaneacionenunenteterritorial AT medinamorenocesaraugusto inteligenciadenegociosparalosprogramasdelassecretariasdesaludeducacionyplaneacionenunenteterritorial AT lemusmunozdiegofernando inteligenciadenegociosparalosprogramasdelassecretariasdesaludeducacionyplaneacionenunenteterritorial AT munozhernandezcarlosjulian inteligenciadenegociosparalosprogramasdelassecretariasdesaludeducacionyplaneacionenunenteterritorial AT ariasiragorrichristiangustavo inteligenciadenegociosparalosprogramasdelassecretariasdesaludeducacionyplaneacionenunenteterritorial |
