Energy Data Analyzer System

Abstract

Analyzing the electrical energy load and pricing data is important to make informed decisions about energy needs and regulations. Data from over a decade are publicly available online for many Independent System Operators (ISOs). To analyze such a vast data collection demands efficiency, automation, and querying capabilities. The Energy Data Analyzer System is a Graphical User Interface (GUI)-based application program specific to the New York ISO (NYISO). The analyzer downloads the data files from NYISO’s website and stores their contents in MySQL database tables for querying. The analyzer can also dynamically create certain custom queries to extract information from the database tables based on a user’s selection. The Energy Data Analyzer System, thus, facilitates the study of electricity markets by empowering users with the ability to query data and to analyze data longitudinally.