Embedded Files
Tags: SQL, Data Wrangling, Data Analysis
Domain: Nonprofit, Social Impact
PostgreSQL
● GOAL
● GOAL
To assess the effectiveness of GoodThought NGO's initiatives by analyzing funding patterns, donor engagement, and assignment outcomes using SQL queries.
● OVERVIEW
● OVERVIEW
GoodThought NGO has been a catalyst for positive change, focusing its efforts on education, healthcare, and sustainable development to make a significant difference in communities worldwide. With this mission, GoodThought has orchestrated an array of assignments aimed at uplifting underprivileged populations and fostering long-term growth.
This project explore how data-driven insights can direct and enhance these humanitarian efforts.
● DATA
● DATA
The GoodThought PostgreSQL database encapsulates detailed records of assignments, funding, impacts, and donor activities from 2010 to 2023. The dataset includes:
Assignments: Details about each project, including its name, duration (start and end dates), budget, geographical region, and the impact score.
Donations: Records of financial contriburions, linked to specific donors and assignments, highlighting how financial support is allocated and utilized.
Donors: Information on individuals and organizations that fund GoodThoughts projects, including donor type.
● TASKS
● TASKS
Top performing assignments by donation.
List the toop five assignments based on total donation value, categorized by donor type. This helped identify which initiatives attract the most financial support.
Top regional impact.
Identified the highest-impact assignments in each region, ensuring only projects with at least one donation were considered. This revealed where the NGO's efforts were most effective.
Founding trends over time.
Analyzed yearly donation trends by donor type to understand how funding evolved over time and which types of donors were most consistent.
Underperforming assignments
Detected projects with below-average impact scores that still received significant funding, offering insight into potential inefficiencies and opportunities for strategic realignment.
Donor engagement
Reanked donors by total contribution and number of distinct assignments supported. This highlighted the most involved supporters fand helped assess the breadth of donor commitment.
● KEY TAKEAWAYS
● KEY TAKEAWAYS
This project provided hands-on experience in using SQL to extract insights from relational data, identify trends, and evaluate project performance—all within a real-world nonprofit context. This case study demonstrates how data analysis can enhance transparency and effectiveness in humanitarian efforts. The insights generated could support decision-making around funding allocation, donor relations, and project strategy.
To see the code, please visit my GitHub.
Page updated
Google Sites
Report abuse