Decision-making support system to improve educational management. Secondary Education of the district management 02d03 – Guaranda
Abstract
We are currently surrounded by large volumes of data, which are generated daily as a result of different processes; The proper processing of this data can mark the success or lack of processing can lead to the failure of an institution, organization or company. It is for this reason that several visits were first made to the District Education Directorate of the Guaranda canton, Bolívar Province; where it was concluded that in this educational unit there is a high risk of loss of information, because the majority of the data source is in physical format and very few in digital format; In addition, there is no centralized data warehouse that has historical, normalized data, with high levels of security and that can be extracted for analysis and decision-making support. There is also a high level of ignorance about the state of academic performance of private, fiscal and missionary educational institutions; which makes it difficult to take improvement actions for the benefit of education. Historically, no one has cared about processing existing data to generate relevant information that supports decision making. It is for these main reasons that a data analysis system called “Decision Support System” (DSS) was built and implemented, which is characterized by being developed with Open Source tools from the Pentaho Suite; which will allow us to know the state of the academic performance of educational institutions of different modalities and supports; through analytical activities such as ad hoc reporting and OLAP analysis.
Downloads
References
(1) «sinnexus.com,» sinnexus, 25 Julio 2016. (En línea). Available: http://www.sinnexus.com/business_intelligence/index.aspx. (Último acceso: 15 12 2017).
(2) L. Laudon, Sistemas de Información Gerencia, México: Pearson, 2008.
(3) M. Mauricio, 15 10 2016. (En línea). Available: http://ingmmurillo-dwh-bi.blogspot.com. (Último acceso: 15 12 2017).
(4) B. Imon, Exploration Warehousing: Turning Business Information into Business Opportunity, Addison-Wesley, 2000.
(5) K. Weihrich, Administración una Pespectiva Global, México: McGrawHill, 2007.
(6) S. P. Robbins, Comportamiento Organizacional, Mexico: Pearson, 2007.
(7) L. Helgueros, Antología de Enfoques administrativos aplicados a la gestión escolar, Mexico: Prentice, 2004.
(8) P. Drucker, Gestion del Conocimiento en las Organizaciones., Madrid: Deusto, 2011.
(9) K. V. B. Stein, «.gestiopolis.com,» 18 02 2006. (En línea). Available: http://www.gestiopolis.com/implementacion-incremental-para-data-warehouse/. (Último acceso: 15 12 2017).
(10) V. Dertiano, «Mirai,» 09 03 2015. (En línea). Available: http://blog.mirai-advisory.com/arquitectura-bi-parte-ii-el-enfoque-de-william-h-inmon/. (Último acceso: 15 12 2017).
(11) V. Dertiano, «Mirai,» 04 06 2015. (En línea). Available: http://blog.mirai-advisory.com/arquitectura-bi-parte-iii-el-enfoque-de-ralph-kimball/. (Último acceso: 15 12 2017).
(12) R. Bouman, Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQ, Estados Unidos: WILEY, 2009.
(13) T. Lockhart., «Manual del usuario de PostgreSQL,» 1 Mayo 2010. (En línea). Available: http://palomo.usach.cl/Docs/postgres/Postgres-Tutorial.pdf. (Último acceso: 15 12 2017).
Copyright (c) 2018 Ciencias de la Ingeniería y Aplicadas
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
The authors who publish in this journal agree to the following terms:
- Creative Commons Attribution-NonCommercial-NoDerivatives License allows others to share the work with acknowledgment of authorship of the work and initial publication in this journal.
- Authors may separately establish additional agreements for the non-exclusive distribution of the version of the work published in the journal (for example, placing it in an institutional repository or publishing it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to disseminate their work electronically (for example, in institutional repositories or on their own website) before and during the submission process, as it can lead to productive exchanges, as well as further citation. earliest and largest of published works (See The Effect of Open Access) (in English).
