ISO Analyzer and Reporting System
View/ Open
Abstract
This paper describes the development of a GUI-based application program called the ISO Analyzer and Reporting System. The Independent System Operator (ISO) Analyzer and Reporting System facilitates the study of electricity markets by empowering its users with the ability to query and to generate reports from market and operational data by allowing them to analyze data over a period of time, which is helpful to draw useful conclusions. The system downloads publicly available files on energy load and pricing data from an independent system operator’s website and stores data from the files in the form of SQL server database tables for querying and generating reports. In addition, ISO reports can dynamically create certain custom queries to extract information from a database, based on the user’s selection. ISO maintenance can clean the database as a regular activity. This system pertains to the New York Independent System Operator (NYISO).