Mercado de datos para el Departamento de Cuadros de la UCLV
Fecha
2014-06-26
Autores
Ramos Díaz, Yudith
Alonso Quintanilla, Karel
Título de la revista
ISSN de la revista
Título del volumen
Editor
Universidad Central “Marta Abreu” de Las Villas
Resumen
El Departamento de Cuadros de la UCLV es un órgano rector metodológico que dirige y controla los procesos que se corresponden con el sistema de trabajo de los cuadros y las reservas en dicho centro. Para el almacenamiento de la información se dispone de un sistema transaccional que no permite el tratamiento histórico necesario en el análisis sistemático de tendencias y comportamiento de los datos, útiles para apoyar el proceso de dirección.
Data Warehouse (DWH), es una tecnología para el manejo de la información, que soporta el procesamiento informático y provee una plataforma sólida que permite realizar análisis a partir de datos históricos y actuales. En el presente trabajo se diseñó e implementó un Mercado de Datos (MD) que tomó como fuente de datos el sistema operacional ya existente en el Departamento de Cuadros, contribuyendo a la accesibilidad, disponibilidad de la información y apoyo a la toma de decisiones.
Se utilizó la herramienta de inteligencia de negocio Pentaho 5.0.1 para la visualización y análisis de los datos. Para la validación de los resultados se utilizaron datos reales de dicho departamento.
The Department of Cuadros of the UCLV is a methodological rector organ that manages and controls the processes that correspond with the system of work of the cuadros and the reserves in this center. For the storage of the information they have a transactional system that doesn't allow the necessary historical treatment in the systematic analysis of tendencies and behavior of the data, useful to support the manage process. Data Warehousing is a technology for the handling of the information that supports the computer processing and it provides a solid platform that allows achieving analysis starting from historical and current data. In the present work a Data Mart, that took as data source the operational system already existent in the Department of Cuadros, was designed and implemented, contributing to the accessibility, readiness of the information and support to the decision making problems. For the visualization and data analysis it was used Pentaho 5.0.1 a business intelligence tool. For the validation of the results it was used real data of this department.
The Department of Cuadros of the UCLV is a methodological rector organ that manages and controls the processes that correspond with the system of work of the cuadros and the reserves in this center. For the storage of the information they have a transactional system that doesn't allow the necessary historical treatment in the systematic analysis of tendencies and behavior of the data, useful to support the manage process. Data Warehousing is a technology for the handling of the information that supports the computer processing and it provides a solid platform that allows achieving analysis starting from historical and current data. In the present work a Data Mart, that took as data source the operational system already existent in the Department of Cuadros, was designed and implemented, contributing to the accessibility, readiness of the information and support to the decision making problems. For the visualization and data analysis it was used Pentaho 5.0.1 a business intelligence tool. For the validation of the results it was used real data of this department.
Descripción
Palabras clave
Data Warehouse (DWH), Mercado de Datos (MD), Pentaho 5.0.1, Departamento de Cuadros, Universidad Central Marta Abreu de Las Villas (UCLV)