The use of Business Intelligence systems has been increased over the last fifteen years. Small and medium enterprises have seen the importance of this type of systems in supporting decision-making process. However, there is no consensus about standards that supports activities associated to the development process of this type of systems, namely, ETL design, Datawarehouse design, OLAP cubes design, and others. Hence, this paper focuses on presenting a literature review about the proposed techniques for modeling the ETL process, in order to identify trends, to provide to the practitioners an overview of the field enabling them to make decisions to choose an alternative, and finally, to show to the researchers in the field of business intelligence in particular, and software engineering researchers in general, the need to work on the construction of standards to help reduce the blur found in the design activities.

Un enfoque aplicado y orientado a resultados de aprendizaje

Resumen El artículo presenta el diseño y construcción de una infraestructura para el desarrollo ágil de soluciones de inteligencia de negocios, donde se escogieron prácticas de dos metodologías ágiles, entre las existentes con mayor renombre y con enfoques diferentes, como Programación Extrema (XP), enfocada en la forma de programar, y Scrum, enfocada en la forma de organizar el proyecto. Las prácticas seleccionadas se implementaron mediante herramientas de software libre compatibles con el entorno de desarrollo Microsoft SQL Server 2008 r2 en una máquina virtual. Con esta infraestructura los desarrolladores tienen a la mano las herramientas necesarias para crear e implementar soluciones de inteligencia de negocios. Palabras Clave: Inteligencia de Negocios, Metodologías Ágiles, Programación Extrema, Scrum.   Abstract The paper presents the design and construction of an infrastructure for agile development of business intelligence solutions, where two selected practices among existing agile methodologies, where two were selected Agile practices among the most renowned existing and different approaches, as Extreme Programming (XP), focused in the form of programming, and Scrum, focusing on how to organize the project. Selected practices were implemented through open source tools compatible with the development environment Microsoft SQL Server 2008 R2 in a virtual machine. With this infrastructure developers have at hand the necessary tools to create and deploy business intelligence solutions. Keywords: Business Intelligence, Agile Methodologies, Extreme Programming, Scrum