The World Bank: Leveraging Data for Equality — Visualizing and Analyzing Geospatial Shapefiles

Winter 2021

Develop for Good is an intercollegiate 501(c)3 nonprofit organization that pairs, trains and supports student volunteers as they develop technical product solutions for nonprofits. Some of our most notable partners include UNICEF, the World Bank, and the World Health Organization. Learn more at https://www.developforgood.org/!

Project Summary
This project visualized and analyzed multiple historical survey data sets and geospatial shapefiles in Tableau. The end goal was for our users (governmental institutions, economists, statisticians, etc.) to have a tool that could visualize poverty using as much relevant data as possible to make decisions regarding public policy.*

The Challenge
This project helps take multiple datasets and layers them into one tool for end users. The aim is to support clients in decision-making by both analyzing and visualizing historical datasets. Our team had several types of data to work with: spatial shapefiles, survey data, time series data, and much more. We had to find a way to combine them all into one single comprehensive tool (per city) that could help institutions design economic policy.

Our Solution
Our team initially cleaned the data in Python before utilizing Tableau to visualize the data. We chose Tableau over ArcGIS or qGIS for the Python/R integration and filtering capabilities it provided. Furthermore, Tableau was much more intuitive from an analytical standpoint. We wanted to create a tool that could easily filter data by year while simultaneously providing context about what was being visualized.

Our Impact
We hope that our data dashboards will make designing economic policy in developing countries a bit easier for end users now that multiple spatial and survey datasets are available for analysis and are layered into one tool.

The Team

Emily Xu (PM) — UC Berkeley ‘21

Ankur Jain — UC Berkeley ‘21

Mina Sultana Mahmood — Stanford ‘21

Tina Wong — Stony Brook ‘22

Xinyu Hu — Stanford ‘22

Zain Asghar — Brown ‘22

*We are unfortunately unable to share project screenshots and more information about this project due to the project’s sensitivity and privacy.

--

--

--

Volunteer students and recent graduates creating digital tools for nonprofit organizations.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Chartjunk to better UX

Predicting Flight Delay

Simulation

Everything we need to know about Testing of Hypothesis Part -II

Data Science Disciplines!

READ/DOWNLOAD=& Chemistry: A Molecular Approach (4

The five WHY’s

Termite Part 4: Assessing Data Collection, Information Sharing, and Changes to Policies

2020 NBA Offseason Analysis with Python — Houston Rockets — Pt.1

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Develop for Good

Develop for Good

Volunteer students and recent graduates creating digital tools for nonprofit organizations.

More from Medium

Rethinking Housing Models in Honduras

Reflection On “We Live In Public”

Josh Harris

A Simple Analysis on the Design of Hardware Abstraction Library

Consumer and B2B Audio: What’s The Difference?