Data Analysis Tools for Optimizing Energy Procurement: A comparative Study of the Mexican and Spanish Markets

Abstract

This thesis addresses the need for practical tools in energy procurement within the Mexican electricity market, where information is often dispersed and difficult to access, making it challenging for industrial users to verify and compare their energy costs. In contrast, the Spanish market—more mature and with greater availability of data and analyses—was considered only as a reference to identify similarities and differences, but no tool was developed for Spain. The main objective of this research is the development of a digital tool, specifically designed for industrial users in Mexico, that integrates and compiles key market information. The tool facilitates the understanding of cost structures, helps identify market exposure risks, and supports comparative analysis and budgeting processes. The methodology included an examination of the Mexican regulatory and operational framework, identification of the main components of an electricity bill, and a comparative review with the Spanish market. Based on these insights, a Python-based application with a Streamlit interface was developed, fed with real data such as spot prices and regulated costs retrieved directly from CENACE. This enables automated calculations and key visualizations. The tool proved useful in a case study by validating electricity bills, generating budget estimates, and assessing risks through visual outputs such as the 100 critical hours chart and heat maps. The thesis contributes both a synthesized comparative overview of the Spanish and Mexican markets and, more importantly, a pioneering application focused on the Mexican context. Future improvements may include greater automation and the integration of forecasting models, strengthening its value for industrial users and potential academic and commercial applications.

Date of Award	2025
Original language	English
Supervisor	Jürgen Dumpelnik (Supervisor)