Extreme Viz Makeover: Electric Power in the U.S.

Data

Extreme Viz Makeover: Electric Power in the U.S.

by Robert Rouse

There are people living in America today who did not have electricity in their home growing up. It cannot be overstated how much the power industry has changed since then. To understand and communicate those shifts, we turn to data. Some have done an outstanding job visualizing this information, particularly this map by NPR. Others could improve greatly by applying best practices to their visualizations. In this post, we’ll discuss one such example from the Energy Information Administration.

The Keepers of Power Data

The EIA is a government agency that collects industry data, analyzes trends and publishes forecasts through regular reports and online exploratory tools. Their electricity data browser is particularly useful to display changes over time at many levels of detail. It starts at a very high level and prompts for other categories or pre-defined views the user may want to explore.

Geopolitical comparisons in the U.S. Energy Mapping System take the opposite approach, overwhelming the viewer with details on every power plant in the United States all at once. There are options to view just one state at a time, but these don’t link back to trend lines and don’t allow visual comparisons of each state.

U.S. Energy Mapping System

Visually speaking, this map doesn’t communicate anything useful. Here are the reasons why:

  1. The layering makes it look as if over half of the country is powered entirely by natural gas.
  2. The viewer cannot separate major power sources from those that seldom run.
  3. It can’t filter by state without going to another web page.

Viz Makeover with Tableau

How do we rectify this situation? The dashboard below combines the high-level trend data with a map showing state-by-state rollups. When an interesting point leads to further questions, a more detailed map and breakdown of fuel types is one click away.

While I have experience in the utility industry, a few new insights stood out to me when exploring this dashboard:

  •  Behind hydroelectric and wind energy, wood-derived fuels rank third among renewable sources. Solar is near the bottom of the list.
  •  Florida tops the “Oil” and “Other” fuel categories. The state has also seen a sharp increase in power produced from natural gas.
  •  Illinois and Pennsylvania are heavily nuclear states. Pennsylvania has favored gas over coal in recent years while Illinois has remained steady across the board.

Further Insights

This analysis prompts deeper questions:

  • How do they compare on a per-capita basis?
  • What if we go further back in time?
  • How would current projections of new plants and retirements change things in the future?

You can shed light on these and other questions by downloading this Tableau Public workbook as a starting point, then blending it with other data sets from eia.gov or elsewhere. If you’re unsure how to get started, I suggest following our current Tableau Essentials blog series or grabbing Dan Murray’s guidebook, “Tableau Your Data!” Then, share your insights or questions below in the Comments section.

More About the Author

Robert Rouse

Analytics Consultant
Disney Data & Analytics Conference 2019 in Review At Disney World, every park has a theme. What you may not know is that their annual data and analytics conference has a theme, too. In ...
A Template for Date Calculations in Tableau The most common calculations I make in Tableau are date-related. I’ve made hundreds of them with variations for year-over-year, ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072