A wholesale power provider desired more streamlined access to timely ERCOT data and the ability to create power activity dashboards for the ERCOT system.
- Inefficient manual processes for ERCOT data management
- Reporting practices lagged behind industry benchmarks
- Outdated data access protocols
Using .NET and Azure, design, MRE built an array of Azure Function Apps which consume the ERCOT forecasting data and enable data ingestion mechanisms into a data warehouse running using Azure SQL.
The delivered solution eliminated cumbersome practices related to ERCOT data and consolidated all reporting tools into an accessible location.
Key benefits included:
- Improved ERCOT forecasting in both speed and accuracy
- Reduced work hours resulting from manual processes through use of Azure Function Apps
- Flexible data solution using .NET