In order to bid correctly, Ameren traders need access to information from many different sources. Every five minutes, they receive data on the output of each of Ameren’s generation units and how that energy is dispatched. On an hourly basis, they receive information from every location on the MISO network, which they use to forecast demand. Ameren also receives award information. In the morning, it submits bids to MISO; later in the day, MISO tells Ameren what units it can run the next day.
Ameren began working with technology integration expert Avanade on two simultaneous projects: the first, an extraction, transformation, and loading (ETL) solution to pull data in from different sources, conform the data, and then load it into a data warehouse. As an adjunct to the warehouse solution, the team also began an analytic and reporting solution. The second project was a Windows-based interface to present data from the warehouse and other sources in an integrated, format.
With the help of Avanade, Ameren has been able to create a business intelligence solution that gives its traders a current real time trading status. The improved access to data also benefits other Ameren groups that support trading operations. Other advantages include: