Electric Rates Analysis

Driver Description

The Electric Rates Analysis presents information on rates as reported by the Energy Information Administration between 2010 and as the EIA reports it. This includes both FERC-regulated and non-regulated utilities across the United States and can be narrowed by state, ownership structure, and year.

  • Industry: Electric
  • Sub-Industry: All
  • Data Timeline: Annual
  • Geography: US States

Data Sources

EIA Form 861

Usage

The Electric Rates Analysis visualizes the data from the EIA to easily compare rates on any utility across the country. The analysis is intended to help experts prepare for rate cases for electric utilities, assess how one company may stack up against another, and analyze historical trends in rates.

Main Screen

rates driver first step

This driver is relegated to a single screen, allowing for easy access to all the rate data in our database. The filters at the top of the screen will allow you to slice and dice the table as well as change what information is shown on the Rate Map at the bottom of the screen. For example, let’s filter this driver to focus on Louisiana in 2020. You can either filter to Louisiana via the drop down filter at the top of the screen, or you can click on a state on the map.

rates driver second step

We now see Louisiana highlighted on the map and the table listing utilities in the table. You can quickly view how rates differ between customer classes in the table, and cycle the map between rate types via the button filter in the middle-right of the screen. Let’s take a look at Entergy New Orleans. Click on that company in the table to drill down into a visualization of their rates over time. You may need to clear the year filter if you only see a few dots on the screen.

rates driver last step

 

We can now see the rates in a chart by customer class. In order to select a new company, click on the back arrow next to the title of the chart, and it will take you back to the table view. As a general rule of thumb, it is advised to filter to a particular Ownership Type or State first in order to keep the driver functioning seamlessly. There is a lot of data feeding into the driver and casting too-wide of a search criteria can slow down the experience.

Exporting Visuals and Data

There are several ways in which the driver can be exported. A visual export of the driver via PDF or PowerPoint can be generated via the export button () at the top-right corner of the driver. Data can be exported via each card on the driver. To export data, move your cursor over the card/table and another export () button will appear at the top-right of the card/table. The data will export into a csv file in a long-table format. An additional feature is the expand details icon on each card. Hovering your cursor over a card/table will show the expand details icon (). The expand details icon will give you a screen as seen below.

expand highlight-1
new rate screenshot

Once you click on the expand details icon, a screen will pop-up giving you a few options to interact with that particular card. You can click on the export button at the top-right of the pop-up to export the visualization either in a visual format or the data behind the visualization via CSV or Excel. Clicking the table icon at the top-right of the pop-up will show you the data feeding into the visualization.