Sustainable Development Goals PBI Report
Updated: Nov 11, 2022
You may have noticed this is not GitHub, but I promise the link to the real files is below.
My challenge teammates (Mattia and Benjamin) gave me the chance to use this opportunity for inviting you to check out this site named BIBB, which is focused on Business Intelligence with an emphasis on Design which my buddy Raziel and I are building with a lot of love. Please check out other posts!
This project was the entry of the #ByteMeIfYouCan team for the Power BI Swiss Championship organized by Microsoft and is based on the Sustainable Development Goals WHO and UN data.
The SDGs aim to end poverty and other deprivations, improve health and education, reduce inequality, and spur economic growth while tackling climate change and preserving our oceans and forests.
Data comes from four different sources: SDG API, Excel, World Bank, and Wikipedia for which we had to use three different Power Query connectors:
Web.Contents for the SDG data
Excel for a list of countries
Web.BrowserContents for the WB and Wikipedia data.
Most of the report's heavy lifting, which is getting all the data for all of the indicators, had to be done in a dataflow hosted in a Premium per user capacity.
The project was designed to have two views: an infographic view and a data view; each designed for different purposes; as the name suggests the infographic view contains pictures, infographics, and general information about the selected goal, while the data view contains "hard" numbers and more traditional data visualizations.
Navigation through the reports is done from the "goal" selector on the left side and through the view button on the top right, which allows us to change between views.
This view relies heavily on HTML elements for its display; HTML has the advantage that none of the pictures has to live within the PBI file (meaning no base64 juggling) but the disadvantage is that this can not be printed.
On the left side of this view, we will see an image representative of the goal as well as a flipping card (my favorite element) containing some KPIs of the goals and a link to the official goal's web page. On the right side, we have an infographic that can be switched and have access to a deeper explanation of the goal and its targets.
The left panel of the data view is thought to be like a book index, and the right part is the visuals that tell us the stories of these goals and their targets.
On the right part, we have access to four different visuals. The box plot that helps us see outliers, a more traditional but very handy table, a map, and the AI-powered Key Influencers visual (which doesn't work when the report is seen from "Publish to web".)
In the end, we were not among the three winners of the championship, this honor came to two other amazing reports; still, we are very thankful for being able to participate in this wonderful championship which gave us the chance to explore and test our knowledge and strain our limits; but above all, allowed us to meet other wonderful members of the Swiss Power BI community and their amazing work.
Thanks to Kristian and to all the Microsoft Switzerland team that organized this challenge and I hope to see you thereinn 2023!