👥 Total Users: – 🟢 Online Now: –
Home › Dashboard › Energy and Gas Prices Tracker Dashboard

Energy data • Power BI

Energy and Gas Prices Tracker Dashboard for Power BI: Oil, Gasoline, Natural Gas and Renewables

✉ Ask a question

What are you paying for energy, and is it going up or down? Crude oil, gasoline, diesel, natural gas and electricity are reported by different sources at different speeds, some daily, some weekly and some monthly, which makes them hard to compare.

This one-page dashboard puts them side by side. It shows the latest price and the change from a year ago for six energy prices, how much of the pump price is the cost of crude oil, and a renewable energy section that shows which countries get the most electricity from renewables. The data is read live from the FRED API and World Bank Open Data.

What is inside

1. Price tiles and key insight

Six tiles across the top show the latest reading for WTI crude, Brent crude, regular gasoline, diesel, natural gas and residential electricity. Each tile shows the change from a year ago with an arrow, in a warm colour when the price is up and green when it is down, and a small trend line. Under the tiles, a key insight sentence rewrites itself from the data: it states the current gasoline and crude prices and names the price that rose the most and the least over the past year. Two cards show the pump price over crude and the crude share of the pump price.

Energy and gas prices tracker dashboard price tiles in Power BI
Price tiles: six latest readings, year-over-year change and a key insight.

2. Trends and the price monitor

Six charts show monthly average prices for crude oil, pump fuels, natural gas and residential electricity, the gap between the pump price and crude, and a comparison of which prices moved the most. A period selector switches between 1, 3, 5 and 10 years or the full history, and a view selector switches between change from a year ago and an index that starts at 100. At the bottom, a price monitor table lists every series with its latest reading, year-over-year change, one-year high and low and five-year average.

Energy price trends and price monitor table in Power BI
Trends: monthly charts, period and view selectors and a price monitor.

3. Renewable energy: who is switching?

A second section uses World Bank data. Three cards show the US renewable share of electricity, the world share and the number of countries that get more than half of their electricity from renewables. A line chart follows the countries you pick, a bar chart ranks the 12 largest economies, and a bubble chart compares each country's renewable share of electricity with its share of total energy, with bubble size showing the size of its economy.

Renewable energy by country section in Power BI
Renewables: US, world and country comparisons.

Three selectors at the top control the page: the time period, the view (change from a year ago or an index) and the countries used in the renewable trend chart. Choose up to eight countries to draw the trend lines.

Where the data comes from

US energy prices come from the FRED API of the Federal Reserve Bank of St. Louis. The series are WTI and Brent crude oil (daily), regular gasoline and diesel retail prices (weekly), Henry Hub natural gas (daily) and the average residential electricity price (monthly). They originate with the U.S. Energy Information Administration and the Bureau of Labor Statistics, and the history starts in 2010.

Renewable energy and GDP data come from World Bank Open Data, from 2000 onwards, with each country grouped by region and income group. Because the sources update at different speeds, gasoline and diesel change weekly, electricity monthly and the renewable statistics once a year, so the latest renewable year is usually behind the price data. The page shows the date of the latest price reading.

How the data model is organised

The report sits on a small model with two data tables, two matching lookup tables and two selector tables that drive the period and view choices.

TableTypeWhat it holds
EnergyFactOne row per date per price series: the date, the value, the series and the month it belongs to
EnergySeriesDimensionThe six price series with their name, group (oil, pump fuels, natural gas, electricity), unit, update frequency and display order
RenewablesFactOne row per country per year for three World Bank indicators: renewable share of electricity, renewable share of final energy use and GDP
DimCountryDimensionCountries and regional totals with region and income group, plus a flag that separates real countries from totals such as the world
Range and ViewModeSelector tablesHold the choices behind the period selector and the view selector

Measures you can use

MeasureMeaning
Latest valueThe most recent reading of each price series
Year-over-year changeLatest reading compared with the reading a year earlier
One-year high and lowHighest and lowest reading over the last twelve months
Five-year averageAverage reading over the last five years, and how far the latest reading is above or below it
Pump price over crudeRegular gasoline price times 42 gallons, minus the WTI crude price per barrel
Crude share of pump priceThe crude cost per gallon (WTI price divided by 42) as a share of the gasoline price
Index (start = 100)Monthly average price relative to the first month of the selected period, which equals 100
Renewable share of electricityRenewables as a percentage of electricity output, for the latest year available
Largest economiesRanks countries by GDP so the bar chart can show the 12 largest
Countries above 50 percentNumber of countries that get more than half of their electricity from renewables

The tiles always show the latest reading, while the charts use monthly averages so that daily, weekly and monthly series can be compared on the same axis.

How to read the numbers

  • Colours show direction, not good or bad: a warm arrow means the price is higher than a year ago and a green arrow means it is lower.
  • Pump price over crude: a barrel holds 42 gallons, so gasoline price times 42 minus the crude price shows what is added between the oil well and the pump. That covers refining, distribution, marketing and taxes, not only refining margins.
  • Natural gas is a wholesale price: Henry Hub is the benchmark price paid between traders, not what a household pays on a bill.
  • Different update speeds: crude oil and natural gas are daily, gasoline and diesel weekly, electricity monthly and renewable energy yearly.
  • Regional totals: the world figure is a World Bank aggregate and is kept separate from individual countries in the charts.

Who it is for

  • Drivers and households who want to follow fuel and electricity prices in one place.
  • Students and journalists who need clear charts of energy price trends.
  • Transport, logistics and small business owners who watch fuel costs.
  • Power BI developers who want an example of combining two public APIs in one model.

Related dashboards

Frequently asked questions

Where does the data come from?

US energy prices come from the FRED API of the Federal Reserve Bank of St. Louis, and renewable energy and GDP figures come from World Bank Open Data.

How often is it updated?

Crude oil and natural gas prices are daily, gasoline and diesel weekly, electricity monthly and renewable energy yearly, so the dashboard is refreshed regularly and each tile shows its own latest date.

What is the pump price over crude?

It is the gasoline price for a full barrel of 42 gallons minus the price of a barrel of WTI crude. It shows how much is added by refining, distribution, marketing and taxes.

What do the arrows and colours on the tiles mean?

An arrow up in a warm colour means the price is higher than a year ago, and an arrow down in green means it is lower.

Is the dashboard free to use?

Yes. You can explore it on this page without signing up.

Questions or ideas for this dashboard?

Tell us which fuels, regions or indicators you would like to see added.

✉ Ask a question

Data notice: This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis. Renewable energy and GDP data come from World Bank Open Data, licensed under CC BY 4.0.

A note on interpretation: This dashboard is a reporting and learning tool built on public data. It is not financial, investment, legal or policy advice, and any figures you rely on for decisions should be checked against the original source.

Explore Free Online PDF & Image Tools by Docynx