Browsing by Author "Escalante Andrade, Kevin Alejandro"

Filter results by typing the first few letters
Now showing 1 - 1 of 1
  • Thumbnail Image
    Item
    Business intelligence mediante herramientas full stack en la generación y análisis de informes gerenciales en el área comercial de la empresa Eléctrica Ambato S.A.
    (Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas Electrónica e Industrial. Carrera de Tecnologías de la Información., 2026-01) Escalante Andrade, Kevin Alejandro; Torres Valverde, Leonardo David; Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas Electrónica e Industrial. Carrera de Tecnologías de la Información.
    This research presents the design and implementation of a full-stack Business Intelligence platform aimed at consolidating, analyzing, and visualizing commercial information related to billing, revenue collection, and portfolio management at Empresa Eléctrica Ambato S.A. (EEASA). The initial assessment identified significant limitations in the existing operational model, including a high dependence on manual processes, fragmented data integration, and limited flexibility of reporting tools, which hindered timely and reliable access to information for institutional decision-making. Surveys conducted among operational staff and an interview with the Head of the IT Department highlighted issues such as delays in monthly report generation, high operational workload, and the absence of consolidated historical data. In response, a technological solution was developed using Angular for the user interface, Node.js and Express for the service layer, and Oracle Database 19c as the central data repository, supported by Business Intelligence tools for data processing and analysis. The implementation reduced report generation times from several days to a few minutes, improved data consistency through the consolidation of historical records, and optimized at least four key commercial processes: billing, revenue collection, portfolio management, and subsidy analysis. As a result, the platform enhanced operational efficiency and strengthened decision-making processes within EEASA’s Commercial Area.