Rediseño e implementación de ETL Open Source para datamart de cartera.
No hay miniatura disponible
Fecha
2015-08-24
Título de la revista
ISSN de la revista
Título del volumen
Editor
Universidad de Guayaquil. Facultad de Ingeniería Industrial. Carrera de Licenciatura en Sistemas de Información.
Resumen
El presente plan de titulación tiene como objetivo principal, proveer a la compañía Ecuaquímica una solución tecnológica que procese de manera mensual sus transacciones, su principal gestor de procesamiento es un ETL de código abierto que genera información estructurada. La información podrá ser visualizada en el datamart de cartera construido en la herramienta OBIEE 11g, disminuyendo así los tiempos de análisis y mejora en áreas, como: ventas y cobranzas. Haciendo uso de la observación científica y el método de Investigación Descriptivo se realizó el análisis del enfoque actual del negocio, así como de las necesidades del área contable para mejorar sus análisis crediticios dentro del mercado de clientes actual. Los tiempos de respuesta alcanzados por la solución implementada abarcan hasta un 98.33% de mejoría, comparativa realizada en base al proceso que la compañía manejaba anteriormente. El diseño y presentación de informes para la gestión de toma de decisiones se vuelve muy dinámico con las interfaces del OBIEE lo cual genera un valor agregado al análisis que se quiera realizar y presentar. Esta óptima fuente dará un soporte para la resolución de fallas en áreas específicas.
The present plan has as a main objective to provide to Ecuaquímica Company a technological solution that processes its transactions on a monthly basis, its main processing promoter is an open source ETL that generates structured information. The information will be visualized in the datamart portfolio built in the tool OBIEE 11g, thus reducing the time of analysis and improvement in areas such as: sales and collections. By making use of the scientific observation and the descriptive research method, the analysis of the current business focus was performed, as well as the accounting department needs to improve its credit analysis within the market of current clients. The response times achieved by the implemented solution include up to 98.33% improvement, comparative based to the process that the company operated before. The design and reporting for management decision-making becomes very dynamic with OBIEE interfaces which generates an added value to the analysis that it wants to perform and present. This optimal source will give a support for resolving failures in specific areas.
The present plan has as a main objective to provide to Ecuaquímica Company a technological solution that processes its transactions on a monthly basis, its main processing promoter is an open source ETL that generates structured information. The information will be visualized in the datamart portfolio built in the tool OBIEE 11g, thus reducing the time of analysis and improvement in areas such as: sales and collections. By making use of the scientific observation and the descriptive research method, the analysis of the current business focus was performed, as well as the accounting department needs to improve its credit analysis within the market of current clients. The response times achieved by the implemented solution include up to 98.33% improvement, comparative based to the process that the company operated before. The design and reporting for management decision-making becomes very dynamic with OBIEE interfaces which generates an added value to the analysis that it wants to perform and present. This optimal source will give a support for resolving failures in specific areas.
Descripción
Este documento contiene archivo en PDF.
Palabras clave
SISTEMAS DE INFORMACIÓN, DISEÑO DE HERRAMIENTA OPEN SOURCE, SOLUCIONES TECNOLÓGICAS