Education for All is a charity organization that accepts donations to support education for underprivileged children. As a data analyst, I was asked by the head of fundraising to present donor insights and donation rates ahead of the annual fundraising strategy meeting.
Tools Used: SQL (SQLite) · Tableau · 5-Why Analysis
Dataset: 1,000 donors · $249K in total donations
Original article: Read on Medium ↗
The head of fundraising needed donor insights and donation rate data to inform the next year's fundraising strategy. Specifically:
Why do states with fewer donors have higher average donations?
Because donors in those states make higher individual donations than in other states.
Why are donors in those states making higher donations?
Because those states have higher average incomes.
Why do job fields with fewer donors have higher average donations?
Because the donation values in those fields are higher.