Education for All Donation Report: Unlocking Donor Insights

INTRODUCTION

In the landscape of philanthropy, data is often an untapped resource. For organizations like Education for All, which strives to make learning accessible to underserved communities, understanding the nuances of donor behavior is critical. This understanding shapes the strategies that open hearts and wallets, driving the mission forward. My role in this narrative was not just to interpret a dataset but to weave a story from numbers that could galvanize potential benefactors into action.

The task was both a privilege and a challenge — a privilege because of the potential impact on educational accessibility, and a challenge because it required distilling a wealth of information into a clear, compelling narrative. The raw material was a rich dataset: a tapestry of figures and facts about the past year's donation activities. My objective? To transform this into insights that would resonate with stakeholders at an all-important investor meeting.

PROBLEM STATEMENT

Education for All, a charity organization wants to organize a fundraising event for the next year. The Head of the Fundraising team would like a report on donor insights and donation rates for the previous year, and how donation figures and frequencies can be increased.

TASK

As a Data Analyst, working for the Charity, write a report and create a dashboard as per the requirements provided by stakeholders. Also, give actionable insights about how to:

• Increase donors in the database.
• Increase donation frequency of donors, and
• Increase the value of donations in the database.

EXTRA NOTE

In two weeks, the team is having a fundraising strategy meeting for the following year, and I will need to present insights from donation data to inform my fundraising strategy and increase donations. Two tables have been provided for this exercise. When merged together, These tables contain 1,000 records and 15 fields:

List of fields in both tables.