Executive Information System to Analyze the Child Nutritional Situation in Bolivia.
DOI:
https://doi.org/10.52428/20758944.v16i49.357Keywords:
Data mart, Executive information system, Health and nutrition surveys, Multidimensional analysisAbstract
Executive information systems (EIS) are easy to use and useful tools to visualize and analyze information for making decisions at different levels. The objective of this study was to propose the design of an EIS linked to a data mart, to support the analysis of children's nutritional status and its determinants based on the national health and nutrition surveys carried out in Bolivia in the last 30 years. This process was made using different technologies, such as MySQL, as the database manager; Pentaho Data Integration, for the elaboration of data extraction, transformation and loading processes, PHP as a web based programming language and libraries such as PivotTable.js for multidimensional data analysis. The solution presents a tool that could be applied in distinct levels by different actors, institutions or organizations related to the health sector, as it is capable of meeting information needs related to child nutrition.
Downloads
References
Aguilar, A., Zamora, A., & Barrientos, A. (2012). Obesidad infantil en Bolivia. Revista Sociedad Boliviana Pediatria; 51 (1): 3 - 11.
Bernabeu, R. (2018). Hefesto v3 Data Warehousing, Guia completa de aplicación teórico-práctica; metodología Data Warehouse.
INE. (2019). Estudio temático de nutrición de la niñez y de las mujeres en Bolivia, Encuestas de Demografía y Salud 2008 y 2016.
INE. (2017). Informe de resultados. Encuesta de Demografía y Salud 2016. Recuperado de: https://www.ine.gob.bo/index.php/banco/base-de-datos-sociales
OMS. (2019). WHO Anthro Survey Analyzer, Quick Guide. Recuperado de: https://www.who.int/nutgrowthdb/about/anthro-survey-analyser-quickguide.pdf?ua=1
Pentaho Data Integration (2020), Pentaho Data Integration, Recuperado de: https://sites.google.com/site/pentahobisuite/home/caracteristicas/pentaho-dashboards/pentaho-data-integration.
PivotTable.js (2020), Javascript Pivot Table, Recuperado de: https://pivottable.js.org/.
The Demographic and Health Surveys (2020). Guide to DHS Statistics, Recuperado de: https://dhsprogram.com/Data/Guide-to-DHS-Statistics/index.cfm.
UDAPE. (2015). Octavo Informe de progreso de los Objetivos de Desarrollo del Milenio en Bolivia, La Paz, Bolivia.
UDAPE. (2014). Informe de resultados. Encuesta de Evaluación de Salud y Nutrición 2012. La Paz, Bolivia.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2020 Alejandro Gonzalo Barrientos Aramayo
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License 4.0 that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
