Monitoreo de indicadores clave de desempeño de gestión energética en un campus universitario aplicando ciencia de datos.

Abstract

Currently, university campuses are beginning to see utility in the data they generate daily. The trend is for these universities to implement technologies that allow them to be sustainable and create value with said data. This type of development is linked to the concept of Smart Campus. These universities around the world implement techniques and measures that allow them to increase the energy efficiency of their facilities. In an environment where everything is connected, such as a smart Campus, the rate of energy consumption tends to be high. Due to this, Information and Communication Technologies. TIC, Internet of Things, IoT and Business Intelligence (BI) tools acquire great importance, because they help to monitor and interpret the study data, thus allowing the making relevant decisions. However, to achieve energy efficiency, studies must first be carried out to understand the environment, behavior and the variables that intervene in energy consumption. For this, Key Performance Indicators. KPI are used to help measure and quantify the energy consumption of a university campus. The management of large amounts of data generated by an infrastructure of a university campus regarding energy consumption entails a difficulty in generating information for decision making, for this reason it is essential to implement a system that allows the monitoring of key management performance indicators. energetic. This technological proposal describes the development of a system that implements a control panel or Dashboard that allows the analysis of data related to energy management, generated by ABB M2M meters installed on a university campus. For the development of the system, the use of the SWIRL agile development methodology was chosen, which consists of the phases: Analysis, planning, modelling and finally the execution of the tool. The control panel was designed following the API REST architecture that allows the separation of client and server development, for the development of the Front-End the. AngularJS web development framework was used, which manages the Model View Controller design pattern, MVC, also makes use of libraries such as Plotly.js that allows to generate dynamic statistical graphs and jsPDF for the creation of reports. In addition, Grafana was used to generate real-time graphs of the data. The server in charge of managing client requests and providing the necessary data was implemented with the NodeJS and Express.js framework, making use of the layered architecture for its development. The data used for the execution of the system was acquired through the MQTT protocol of ABB M2M meters that feed a local server on the campus, these data were subjected to an extraction, transformation and loading. ETL process, to later upload them to a database. Of Relational Data such as PostgreSQL. For quality management, the ISO/IEC-9126 standard was used, making use of different free web tools, resulting in the system complying with all the quality metrics evaluated by said standard. In conclusion, the present work managed to develop a web system that allows monitoring of energy consumption KPIs with an efficient and scalable and easy-to-manage multiplatform interface.