This work aims to evaluate the provision of energy services in noninterconnected zones (NIZ) between 2018 and 2019 using open data from the Colombian government and business intelligence methodology. The analysis is approached from the ETL (Extract, Transform, Load). It focuses on the variables obtained from the National Monitoring Centre (CNM) for monitoring the operation of these zones, where there is a Telemetry System that provides monthly information on location variables, energy variables, such as active and reactive energy maximum power, maximum power per day, and hours of service delivery. We concluded that in the years, 2018-2019 energy consumption in NIZ has remained stable with a variation of 0.19%. On the other hand, the NIZ include 56% of Colombia's states, and the energy consumption is concentrated in 6 of the 93 municipalities with 80% of national consumption. The challenges in these areas Ramón Fernando Colmenares-Quintero ABOUT THE AUTHORS Ramón Fernando Colmenares-Quintero is currently the national head of research in engineering and Professor Dr. at UCC with research focus on energy generation/distribution, simulation and modelling in the energy field. Gina Maestre-Góngora. Received a PhD degree in systems engineering and computation. Her research interests: Smart Cities, IT Management, Data Analysis, EA, and IT Project Management. Lina Judith Pacheco Moreno She is a student of Software Engineering Program at the UCC. Member of BERSTIC research seedbed participating in projects related to business intelligence applied to energy. Natalia Rojas has a degree in Civil Engineering and an MSc in Marine Renewables, works for Aquatera bringing knowledge and expertise in energy engineering. Kim E. Stansfield got a PhD in Composites from Kingston University. He was sustainable energy systems transformation planner at the UK ETI. Joined Warwick WMG in 2016. Prof. Dr. Juan Carlos Colmenares-Quintero is the leader of the research group CatSEE from the IPC/PAS in Poland. His interests range from materials science/nanotechnology to photocatalysis and water/air purification.
PUBLIC INTEREST STATEMENTThis work aims to evaluate the provision of energy services in non-interconnected zones (NIZ) between 2018 and 2019 using open data from the Colombian government and business intelligence approach. The NIZ include 56% of Colombia's states. Their challenges are associated not only with the quality and provision of energy services but also with the environmental challenges that mean that most of these areas obtain their energy supply from fossil fuels, being protected areas such as ecological reserves, the biosphere or the jungle.