Worldwide Demographics & Statistics using Power Query and Power View

Updated: Mar 27, 2021

To show the breadth of possibilities with Power Query, we thought it would be fun to take a cue from Hans Rosling and build a macroeconomic and demographic mashup built using Power Query and Power View. We will be using data from GapMinder extensively in order to build our visualization.


The end result we are looking to build is a visualization that shows a time series scatter plot/bubble chart across the following dimensions:


  • Population by country, since 1980

  • Health by country (using Body Mass Index as a health indicator), since 1980

  • Wealth by country (using GDP Per Capita as a wealth indicator), since 1980


Ultimately, we are interested in building something like the visualization below that will allow us to view the progress of the various countries over time.


Ultimately, we are interested in building something like the visualization below that will allow us to view the progress of the various countries over time.


>> Read more...

17 views0 comments

Recent Posts

See All