User Led Organisations: Networks and Links

360Giving Data Visualisation Challenge

Visualising linkages between user led organisations and funders

Following on from my first submission, this visualisation aims to answer the second challenge question regarding user-led organisations DATA COLLECTION AND CLEANING The data was acquired from the Grant Nav database filtered from years 2008-2017, with user-led organisations filtered out using the 'user-led' search term. The data was subsequently cleaned using a custom script in R programming language to remove unnecessary columns (like additional redundant location info) and adapting formats of date The data was then filtered into themes according to keywords (note that initially a range of themes were tested to see how much data was included in each – four theme were chosen a) ‘elderly’, ‘older people’, ‘dementia’ would suggest the theme is elderly b) projects with ‘sports’, ‘fitness’ for sports theme c) projects with ‘science’ for science theme d) projects with 'environment' for environment theme The major challenge was to manually fill in location data for recipient organisations which did not have any location info on Grant Nav (a large proportion of these were universities). For this, a combination of websites were used to check the organisation locations like Find that Charity, Charity Base and the Charity Commission. The visualisation was built in D3js. I decided to display the data using a Sankey diagram and force directed network graph, both of which are good for viewing flow of information from funders to user led organisations as well as visualising how densely connected organisations are. For the Sankey diagram, I have only included funders who have donated at least £10000 and above to allow the visualisation to be deciphered easily. The force directed graph however does not have any such restriction and includes information about all funders and user led organisations for the specific year and theme. The liquid gauges indicate the number of each type of organisation in the whole dataset. There are a few components in the visualisation which may not work due to lack of time in building this but is still very addictive !

Ryan Nazareth

Data Scientist