What We Faced
Challenge
A wholesale power provider desired more streamlined access to timely ERCOT data and the ability to create power activity dashboards for the ERCOT system.
Challenges included:
- Inefficient manual processes for ERCOT data management
- Reporting practices lagged behind industry benchmarks
- Outdated data access protocols
Implemented Technologies
Azure function apps
.net
data warehouse
What We Did
Solution
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.
What We Delivered
Results
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