Data Management for the New SPP Marketplace

3 minutes, 45 seconds Read

We recently held a complimentary webinar discussing the upcoming changes to the Southwest Power Pool (SPP), the various data management challenges stemming from these changes, and how the ZEMA Suite is prepared to handle issues arising from the new Integrated Marketplace.

Marketplace Changes

On March 1st, 2014, the SPP is going live with their Integrated Marketplace, which will include a number of new features, such as a Day-Ahead market, a market for Transmission Congestion Rights (TCRs) and a single Balancing Authority. The Day-Ahead market will run alongside the existing real-time balancing market, and will ensure a more cost-effective and reliable allocation of energy. TCRs are financial instruments-similar to Congestion Revenue Rights or Financial Transmission Rights in other ISOs- used to hedge against the costly risks of congestion. Finally, the 16 existing balancing authorities will be consolidated into a single centralized authority in charge of balancing the region’s supply and demand for electricity, and facilitating unit commitment from market participants (

Data Challenges and the ZEMA Solution

Our webinar provided an in-depth examination of the data management challenges that these changes will create; for example, the SPP will soon be generating raw data from over 670 nodes every five minutes in XML, HTML and FTP formats, published from behind certificates and public sources like the Integrated Marketplace Portal ( Collecting, validating and connecting such a high volume of data with internal databases can be a daunting and time-consuming manual task, while analyzing and comparing data from different sources and with varying granularities can present added complications.

The ZEMA Suite is designed to help users manage these problems. By automating the collection and validation processes, ZEMA ensures that data is imported accurately, consistently and on time. ZEMA further allows users to manage the collection scheduling as well as the access entitlements to data, reports and software of the organization’s users.

ZEMA facilitates the analysis of data published from disparate sources with varying timescales or measurement units. Data can be aggregated, aligned and filtered in virtually any way to allow for historical and future analysis. Our webinar focused on a few of the options available in ZEMA, producing the following graphs.

Figure 1: The SPP’s Day Ahead LMP is filtered by peak and off-peak hours, compared to Real Time LMP.
Figure 2: Wind Speed from AccuWeather compared wind generation information from the SPP.
Figure 3: Wind Generation compared to natural gas generation with Day Ahead LMP for reference from the SPP.

We also touched on the integration possibilities of ZEMA, by demonstrating the Data Direct Add-in for Microsoft Excel; in addition, ZEMA is capable of integrating with many more downstream systems, including settlement systems, BI tools, Trade and Risk managers, and many more. Live data feeds can be pushed automatically to these systems to provide an efficient and cost-effective integration process.

ZE offers public webinars not only to provide attendees with a preview of the ZEMA Suite’s data management and analytical capabilities, but also to keep participants apprised of the most recent market trends and changes. If you are interested in attending any of our upcoming webinars, please visit our webinar calendar.

For more information on how the ZEMA Suite can help you prepare for SPP’s Integrated Marketplace, contact us to book a demonstration.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *