dataviz to analyse the Grants given by the Bill & Melinda Gates Foundation and previous foundations of the Gates family (William H. Gates Foundation, Gates Library Foundation, and Gates Learning Foundation) from 1994 onward.

Link to interactive infographic - Decomposition Tree

Link to interactive infographic - Bar Charts

Link to interactive infographic - Purpose Word Cloud

Reference:

Dataviz using data from Gates Foundation - Committed grants page, where a downloadable database (CSV file) is provided detailing the grants.

Inspired by an interview of Bill Gates by Chris Anderson, where Bill discussed their philanthropic efforts over the years.

Summary

This project presents a series of interactive dashboard pages to help analyse and understand the $87BN given since 1994. The page navigation control is at the centre-bottom, e.g. < 1 of 3 >. Click the centre of that control for a menu of the pages.

On every page, slicer controls allow the selection of range of grant dates. There are also slicers to filter by Division, Region Served, Topic, Grantee location, even individual Grantees and Grants. Combined with visuals on each page that segment and compare the data, many different analyses are possible. Each visual element e.g. bar of a bar chart can be selected, when it will act as a "cross-filter" to filter every other visual on that page.

On every page, a detailed table at the bottom lists the individual Grants within the scope of the current slicer settings. The Grant Id column in the table has a hyperlink to the Grant Details page on the Gates Foundation website. The Grantee column has a hyperlink to the Grantee website, where provided in the data. The table can be resorted by clicking any column header, and the Focus mode button (which appears at the top-right corner of the table on hover) will expand the table to fill the browser window.

The page: Purpose Word Cloud presents a word cloud analysis of the contents of the Purpose column (a free text description of each Grant). Each word is sized relative to the $ Amount Committed for Grants that mention that word.

There is a hidden page using the Key Influencers visual, which is a very powerful no-code, AI-powered analysis engine for understanding the relationships within the data. After every interactive filter you choose, the engine re-runs it's analysis to explore which factors are the Key Influencers for a variable - in this project $ Amount Committed. That visual is not supported by this publishing method, but you can install the free Power BI Desktop tool, download the .PBIX file from this project and open it to explore that page.

]

The data visualisation engine is Power BI, featuring the Custom Visual: Word Cloud.