Diseño e implementación del data warehouse dw y tableros de inteligencia de negocio BI, para análisis de indicadores de rendimiento en el área de desarrollo y ventas de una empresa que brinda servicios tecnológicos de software para operadores de turismo.

Abstract

This degree project aims to apply business intelligence in a technology company that provides software services to tour operators. The project focuses on answering the most important questions that software development, sales and marketing areas have, as well as analyzing users, end customers and the company's chatbot. For this, all the points in the implementation of tools for business intelligence are addressed, such as: the selection, analysis and implementation of the most appropriate methodology, the analysis of the most convenient Open Source software tools to carry out the project, the creation of the Data Marts for each area of study, the application of artificial intelligence models to generate knowledge from the company's data and, of course, the visualization of the information in a dashboard that seeks to answer the different questions of the business. Finally, the results of this project showed that an advantageous tool for the company was generated and adds a lot of value when making intelligent decisions.