Blog

On April 28th, 2025, Spain experienced a nationwide blackout lasting over 8 to 10 hours, highlighting the country's dependency on electricity and sparking discussions on the management of the electrical grid. In response, a real-time analytics project was developed to monitor Spain's electricity system, utilizing Tinybird as the analytics engine, Python for data tracking, and Grafana for visualization. The project involves collecting data from the ESIOS API, ingesting it into Tinybird, and materializing it for efficient querying to display on Grafana dashboards. Insights from the project reveal the diverse nature of Spain's electricity production, with solar energy playing a significant role during sunny days, and the country's status as a net exporter since 2021. While the exact cause of the blackout remains uncertain, it is suspected to be a combination of events, including a sudden drop in solar production and disrupted international exchanges. The project serves as a model for understanding and leveraging real-time data to enhance the monitoring and management of critical infrastructure.