BlueGranite POWER BI sHOWCASE | ENERGY

WORLD ENERGY PRODUCTION CAPACITY

The report above explores the energy capacity of various countries and highlights a few ways to analyze data in Power BI along the way.

The report consists of four pages, with the first three largely showing contrasting views that ultimately help lead to better insights. The first page explores data visualization using raw numbers and demonstrates the shortcomings of analyzing country-level data with raw numbers. The second page approaches the same analysis with a percentage contribution, placing the focus on a country's share of various energy sources rather than raw capacity. The third page combines both measures into a single scatterplot. While losing some of the advantages of the data presented in small multiples, the scatterplot shows how some sources with large raw capacities may have small contribution to a country's overall capacity.There are additional key insights available when looking at the data in this format. Finally, the map on the last page shows detailed data by production facility. While in aggregate, the map looks like world population, viewing the map when filtered to individual energy sources shows unique distributions.

Click around and explore the above report! What insights can you discover?

rEPORT iNSIGHTS:

  • The report presents the same data in different ways and showcases the advantages and shortcomings of both measure and chart type selections.
  • Users will better understand how different country's balance their energy production.
  • Small multiples help viewers easily compare different energy sources. A scatterplot helps present an alternate view that places the focus on how each country's balance between production mix and raw capacity.
  • The Mapbox custom visual presents data in a heatmap that shifts to individual points as a user zooms in.
  • To get the full experience, view it in full-screen mode by clicking the double-sided arrow in the bottom right corner of the pane.

Have a question? CONTACT US BELOW!