Project Overview

I developed an interactive data visualization tool to support the decision-making processes in ISO New England's control center, a high-tech environment resembling a NASA launch room, equipped with numerous monitors displaying critical information about grid management. This tool focuses on capacity deviation, providing actionable insights to control room operators managing the power grid.

ISO New England Control Room

The ISO New England Control Room, where operators monitor and manage the power grid in real-time

Note: The graph below is interactive - you can hover over data points, zoom, and pan. While this demo uses simulated data, the actual implementation processes real-time grid metrics every 5 minutes.

Last Updated: Loading...

Key Features

  • Interactive Graphs: Operators can toggle between different visualizations and hover over specific data points to reveal granular details, enabling precise analysis.
  • Data Integration: The visualization leverages six optimized SQL queries to collect and organize real-time data about grid capacity and performance.
  • Scheduled Data Updates: An R script, running as a scheduled task every five minutes, processes the data and writes it to a file. This file is dynamically fetched and displayed by JavaScript on the control room monitors.
  • Custom Security-Driven Workflow: Due to strict security protocols in the control room, a traditional dynamic JavaScript data-fetching solution was not viable. Instead, this workaround ensures compliance with these requirements while maintaining real-time accuracy.

Technical Implementation

SQL R JavaScript Chart.js HTML/CSS

Impact

This project bridges technical constraints and user needs, providing a critical tool for real-time monitoring and decision-making in a secure, high-stakes environment. The visualization has streamlined capacity management, enabling operators to respond proactively to grid fluctuations.