Mercado de Datos para la Gestión de Indicadores de la empresa “Campismo Popular de Villa Clara
Date
2014-06-24
Authors
Moreira Rodríguez, Ernesto
Journal Title
Journal ISSN
Volume Title
Publisher
Universidad Central "Marta Abreu" de la Villas
Abstract
La presente investigación se desarrolla en la empresa “Campismo Popular de Villa Clara”, proponiendo el diseño e implementación de un Mercado de Datos para el proceso de gestión de indicadores de la entidad. Para ello se examinan los antecedentes de los sistemas de información o aplicaciones presentes en la empresa y se analiza y clasifica la nueva propuesta de solución. Además se realizó una investigación exhaustiva con el fin de obtener todos los requisitos de la entidad, las funcionalidades de las aplicaciones que actualmente utilizan y los procesos que se pudieran automatizar con la nueva propuesta. El hecho de cómo utilizar la información histórica de la empresa para que la misma deje de ser pasiva y ayude a la toma de decisiones de la misma, es la principal problemática que se plantea. Teniendo presente la diversidad de formatos, tipos y fuentes de datos en los cuales se puede encontrar dicha información, se hace imprescindible contar con procesos de extracción, transformación, limpieza, carga (ETL) y métodos de integración de datos que permitan una vista unificada con la mayor calidad posible. Para el desarrollo de la solución se utilizaron herramientas de la Suite de Pentaho, además del Sistema Gestor de Base de Datos PostgreSQL. Finalmente se hizo una comprobación del Mercado de Datos utilizando datos reales, tomados de la empresa “Campismo Popular de Villa Clara”.
The present research is developed in the company "Campismo Popular of Villa Clara", proposing the design and implementation of a Data Mart for the process of indicators administration of the entity. For that, the information systems antecedents and present applications in the company are examined and the new solution proposal is analyzed and classified. It was also carried out an exhaustive research with the purpose of obtaining all the requirements of the company, the functionalities of the applications that are used at the moment and the processes that could be automated with the new proposal. The fact of how to use the historical information of the company so that the same one stops to be passive and help to the taking of decisions of the company, it is the main one problematic that this thesis manages. Having present the diversity of formats, types and sources of data in which can be this information, it is become in indispensable to have extraction processes, transformation, cleaning, loads (ETL) and methods of integration of data that allow a view unified with the biggest possible quality. For the development of the solution were used tools of the Suite of Pentaho, besides the Data Base Management System PostgreSQL. Finally a validation of the Data Mark was made using real data, taken of the company "Campismo Popular of Villa Clara."
The present research is developed in the company "Campismo Popular of Villa Clara", proposing the design and implementation of a Data Mart for the process of indicators administration of the entity. For that, the information systems antecedents and present applications in the company are examined and the new solution proposal is analyzed and classified. It was also carried out an exhaustive research with the purpose of obtaining all the requirements of the company, the functionalities of the applications that are used at the moment and the processes that could be automated with the new proposal. The fact of how to use the historical information of the company so that the same one stops to be passive and help to the taking of decisions of the company, it is the main one problematic that this thesis manages. Having present the diversity of formats, types and sources of data in which can be this information, it is become in indispensable to have extraction processes, transformation, cleaning, loads (ETL) and methods of integration of data that allow a view unified with the biggest possible quality. For the development of the solution were used tools of the Suite of Pentaho, besides the Data Base Management System PostgreSQL. Finally a validation of the Data Mark was made using real data, taken of the company "Campismo Popular of Villa Clara."
Description
Keywords
Mercado de Datos, Gestión de Indicadores, Sistemas de Información