Energy Data
From raw I90 files to AI-ready market intelligence — we build the data infrastructure energy companies run on.
The problem
From Excel to data infrastructure
Energy companies drown in data they can't use. I90 files arrive daily in 30-sheet Excel workbooks. Billing calculations live in spreadsheets that one person understands. Market signals hide in CSVs that nobody has time to analyze.
We turn that raw data into queryable, automated, AI-ready infrastructure. Every tool we build works with your AI agent via MCP, or standalone via API and Python.
Enrichment
From codes to business context
I90 files only contain unit codes. We cross-reference REE and OMIE catalogs to add company name, technology, installed capacity, and market participant.
Real cases
What you can do with the data
Who benefits from RT3?
GROUP BY company_name reveals which companies concentrate the technical constraint costs.
SELECT company_name,
SUM(energy) AS total_mwh
FROM i90
WHERE program = 'RT3'
AND sign = 'Subir'
GROUP BY company_name
ORDER BY total_mwh DESC
LIMIT 5Practical cases
Built with real data
Spanish Energy Market Database (I90 Files)
Spanish energy market data arrives daily in I90 files — Excel workbooks with 30+ sheets detailing programming units, energy prices, and market operations. The Excel format made it nearly impossible to analyze trends or integrate with other systems.
We designed a relational database that transforms 30 sheets into a single queryable table. Our ETL pipeline runs daily, processing new I90 files automatically. The schema captures relationships between programming units, time periods, and prices.
Data scientists write SQL queries instead of wrestling with Excel. The system handles new file formats automatically. The same architecture powers AI-assisted analysis through MCP servers.
Energy Company Calculation Automation
An energy company performed daily tariff calculations, billing reconciliations, and regulatory reporting in Excel. Each calculation took hours, was error-prone, and depended on one person who understood the spreadsheet formulas.
See Energy Billing →Factory Energy Optimization System
A manufacturing facility with multiple energy assets — solar panels, batteries, grid connection, and variable production loads — needed to optimize energy consumption and costs in real-time.
Who this is for
Who this is for
Ready to turn your energy data into infrastructure?
Let's discuss your energy data challenges.