Articles
Business intelligence solutions in practice: support for decision-making in educational projects for vulnerable children in the Colombian Caribbean
Published 2011-12-15
Keywords
- Business Intelligence,
- data warehouse,
- OLAP
How to Cite
Bustamante Martínez, A. A., Galvis Lista, E. A., González Zabala, M. P., García Avendaño, A. A., & Benavides Fawcett, L. F. (2011). Business intelligence solutions in practice: support for decision-making in educational projects for vulnerable children in the Colombian Caribbean. Revista UIS Ingenierías, 10(2), 123–135. Retrieved from https://revistas.uis.edu.co/index.php/revistauisingenierias/article/view/125-135
Abstract
Business intelligence is used to bring answers to problems related to access, availability and utility of information. This paper presents the process and results obtained in the construction of a business intelligence solution to support decision making in educational projects to vulnerable childhood population in the Colombian Caribbean region. The application context is the execution of a project named “Learning Circles", educational model operated by University of Magdalena since 2006, whose fundamental objective is to bring back to school to refugee and vulnerable children. To develop the solution we used as methodological guidelines Moss and Atre's model and the agile method named Extreme Programming. The main practical implication of this work is to show the usefulness of these technologies in different context to business.
Downloads
Download data is not yet available.
References
- Ministerio de Educación Nacional, «CVN - MÁS EDUCACION PARA LA POBLACIÓN DESPLAZADA». [Online]. Available: http://www.mineducacion.gov.co/cvn/1665/ article-100922.html. [Accessed: 15-feb-2012].
- Ministerio de Educación Nacional, «Lineamientos de política para la atención educativa a la población afectada porla violencia». .
- Ministerio de Educación Nacional, «PLAN NACIONAL DE DESARROLLO EDUCATIVOINFORME DE GESTIÓN». jun- 2008.
- «Población Vulnerable - Fundación Escuela Nueva». [Online]. Available: http:// w w w. e s c u e l a n u e v a . o r g / p a g i n a / i n d e x . php?codmenu=554&idioma=1. [Accessed: 15- feb-2012].
- Universidad del Magdalena, «Objetivo - Circulos de Aprendizaje». [Online]. Available: http:// circulos.unimagdalena.edu.co/. [Accessed: 15- feb-2012].
- Cardona. Sonia, «La Inteligencia de negocios y su aplicación en algunas empresas del área metropolitana de Medellín». Universidad EAFIT, 2005.
- «The Gartner Fellows: Howard Dresner’s Biography». [Online]. Available: http://www. gartner.com/research/fellows/asset_79427_1175. jsp. [Accessed: 15-sep-2011].
- W. W. Eckerson, Performance Dashboards: Measuring, Monitoring, and Managing Your Business, 2.a ed. Wiley, 2010.
- R. Kimball, M. Ross, B. Becker, J. Mundy, y W. Thornthwaite, Kimball’s Data Warehouse Toolkit Classics: The Data Warehouse Toolkit, 2nd Edition; The Data Warehouse Lifecycle, 2nd Edition; The Data Warehouse ETL Toolk, 2.a ed. Wiley, 2009.
- R. Kimball, The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. John Wiley & Sons, 1996.
- L. T. Moss y S. Atre, Business Intelligence Roadmap: The Complete Project Lifecycle for Decision-Support Applications. Addison-Wesley Professional, 2003.
- W. H. Inmon, Building the Data Warehouse, 4.a ed. Wiley, 2005.
- R. Kimball y J. Caserta, The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin, 1.a ed. Wiley, 2004.
- Edgar Codd, «Providing OLAP to user-analysts: An IT mandate». E F Codd and Associates, 1993.
- U. M. Fayyad, G. Piatetsky-Shapiro, P. Smyth, y R. Uthurusamy, Advances in Knowledge Discovery and Data Mining. AAAI Press, 1996.
- R. Kimball, M. Ross, W. Thornthwaite, J. Mundy, y B. Becker, The Data Warehouse Lifecycle Toolkit, 2.a ed. Wiley, 2008.
- «White Paper DSDM and Data Warehousing – DSDM Atern». [Online]. Available: http:// www.dsdm.org/dsdm-atern/dsdm-v4-2-whitepapers/white-paper-dsdm-and-data-warehousing. [Accessed: 14-sep-2011].
- «Data Warehousing y metodología Hefesto | Dataprix». [Online]. Available: http://www. dataprix.com/es/data-warehousing-hefesto. [Accessed: 14-sep-2011].
- S. Luján-Mora y J. Trujillo, «A Data Warehouse Engineering Process», in Advances in Information Systems, vol. 3261, T. Yakhno, Ed. Berlin, Heidelberg: Springer Berlin Heidelberg, 2004, pp. 14–23.
- «MBD 1.0 - METODOLOGÍA DE DESARROLLO DE BODEGAS DE DATOS PARA MICRO, PEQUEÑAS Y MEDIANAS EMPRESAS», 27- oct-2010. [Online]. Available: http://revistas.uis. edu.co/index.php/revistauisingenierias/article/ view/1059. [Accessed: 14-sep-2011].
- «SAS | SEMMA». [Online]. Available: http:// www.sas.com/offices/europe/uk/technologies/ analytics/datamining/miner/semma.html. [Accessed: 14-sep-2011].
- «Metodología CRISP-DM para minería de datos | Dataprix». [Online]. Available: http://www. dataprix.com/modelo_crisp-dm. [Accessed: 14- sep-2011].
- E. Herrera, «“Metodología para el desarrollo de un sistema de inteligencia de negocios basada en el proceso unificado”», Universidad Nacional De Colombia, Bogotá, 2011.
- Martínez Jaime, «La inteligencia de negocios como herramienta para la toma de decisiones estratégicas en las empresas. Análisis de su aplicabilidad en el contexto corporativo colombiano.», Universidad Nacional De Colombia, Bogota, 2010.
- «Agile BI -- TDWI -The Data Warehousing Institute». [Online]. Available: http://tdwi.org/ portals/agile-bi.aspx. [Accessed: 14-sep-2011].
- K. Beck y C. Andres, Extreme Programming Explained: Embrace Change, 2.a ed. AddisonWesley Professional, 2004.
- N. Roodyn, eXtreme .NET: Introducing eXtreme Programming Techniques to .NET Developers. Addison-Wesley Professional, 2004.
- R. Jeffries, Extreme Programming Adventures in C#, 1.a ed. Microsoft Press, 2009.
- L. Benavides, A. Bustamante, y A. García, «Desarrollo de una solución de Inteligencia De Negocios para apoyar a la toma de decisiones en el Proyecto Círculos De Aprendizaje», Universidad del Magdalena, Magdalena, Colombia, 2009.