Microsoft Fabric Updates Blog

Analyzing the UN’s Sustainable Development Goals at Gartner Data & Analytics Summit EMEA

• Power BI

• May 17, 2022 by Will Thompson (HE/HIM) 77 Views

As part of the Gartner Data and Analytics Summit EMEA in London, UK, Gartner invited Microsoft to participate in their bake-off event. This year’s topic was the UN’s Sustainable Development Goals, and we dug into data around access to electricity and CO₂ emissions.

The bake-off has been running for a number of years – the participating vendors are given a dataset and a script of which capabilities Gartner want to see demonstrated. The sections are very short, typically 3-4 minutes each, and we’re challenged to demo against each other on stage! Earlier in the year, Gartner named Power BI a Leader in the 2022 Gartner Magic Quadrant for Analytics and Business Intelligence Platforms.

Here’s a video of the demos that we showed:

Some of the key insights we found:

• Access to electricity has improved around the world in the last 20 years. At a global level the number of people without reliable access to electricity spiked in 2011. That year over 112 million people in India alone suddenly found themselves without a reliable power source.
• Some countries have seen significant improvements – particularly in rural areas. Afghanistan has gone from 7% of the rural population having good access to electricity in 2005 to 97% in 2019.
• There’s a high correlation between increasing access to electricity, GDP per capita, and CO₂ emissions.
• Developing nations see the highest correlation between decreasing CO₂ emissions and decreases in fertility rates and increases in literacy. More developed countries see decreases in poverty ratio having the highest link to decreasing emissions.

We’re planning a webinar that will dive into how we built this report, and cover some of the features shown in more detail. Stay tuned to this blog for that coming at a later date!

You can explore the report yourself here: https://aka.ms/pbico2 and download the PBIX file of the report from our Data Stories Gallery at https://community.powerbi.com/t5/Data-Stories-Gallery/Analyzing-the-UN-s-Sustainable-Development-Goals-at-Gartner-Data/td-p/2527235