Implementar una solución informática basada en paneles de inteligencia empresarial, para la evaluación, seguimiento y control de proyectos de ingeniería civil, vial y servicios petroleros.

Abstract

The project will consist of implementing a Business Intelligence (BI) based IT solution to enhance the Data Management of the Army Corps of Engineers (C.E.E.), responsible for military operations and construction. Manual data extraction and analysis will be carried out, proposing visual dashboards and strategic metrics. Its primary objective is to optimize data interpretation and enable efficient decision-making to achieve optimal project control and evaluation. The methodology employed will involve the ETL process with Oracle SQL Developer to feed the Data Warehouse, evaluating cost efficiency, income-expenses, and project progress. Machine Learning techniques, specifically linear regression, will be used to analyze historical C.E.E. data and predict future revenues with greater accuracy. The project will culminate in Management presentations on the web using Power BI, improving decision-making at the C.E.E. through the implementation of BI and revenue projection with Machine Learning based on historical C.E.E. income and expenditure data. This comprehensive and technological approach will enable more effective data management and deeper analysis for C.E.E.'s strategic decision-making