Charity Donation Analysis project
An analysis on a charity datasets using SQL and Tableau
Project overview
Assuming as a Data analyst at Education for All, a charity organization, I have been assigned by the head of fundraising to present insights from donation data to inform our fundraising strategy and increase donations. This information is crucial for our upcoming fundraising strategy meeting, where our team will discuss and plan for the fundraising efforts of the following year.
The objectives are:
- Increase the number of donors in our database.
- Increase the donation frequency of existing donors.
- Increase the value of donation in our database.
Dataset:
To accomplish these objectives, I have been provided with two data sets ( donation_data and donor data)
The donation_data consists of the following data:
id
first_name
last_name
gender
job_field
Donation
State
shirt_size
The donor_data consists of the following data:
id
donation_frequency
Second_language
favourite_color
movie_genre
Tools used for the analysis :
PostgreSQL: it was used to analyze the data, uncover patterns and derive key insights for the fundraising strategy
Tableau : As a data visualization tool, it was used to create visually informative representations of the analysis results. These visualizations would facilitate a deeper understanding of the data
Business Questions
To analyze the data and gain valuable insights, these are the business questions to answer
1. Who made the highest donation and what are their details?
2. What are the top 5 states with the highest total donation amounts?
and What are the bottom 5 states with the lowest total donation amounts?
3. What are the car, university, second language and favorite color of the top 10 donors with the highest donation amounts?
4. What is the number of donors that attended a university and the number of those that didn’t attend a university?
5. What is the number of donations and total donation for each gender?
6. What is the total donation amount for each donation frequency?
7. What is the distribution of donation amounts in different donation groups?
8. What is the total donation amount for the top 5 job fields?
Before diving into answering the business questions, I used the SELECT and asterisk function to ensure that the datasets were imported properly and to have an overview of the data.
I used the COUNT() function to get the number of donations, which shows that there are 1000 donors in the database.
I then used the SUM() function to calculate the total donation amount, the total amount donated is $249,085.
I used the MIN() function to get the lowest donation, this shows that the lowest amount donated was $5
I used the MAX() function to get the highest amount donated, this shows that the highest amount donated was $500.
I proceeded to answer the business questions:
1. Who made the highest donation and what are their details?
The highest amount $500 was donated by only 2 donors.
2. What are the top 5 states with the highest total donation amounts, and what are the bottom 5 states with the lowest total donation amounts?
California has the highest number of donations (113) and the highest total donation ($30,264), followed by Texas and Florida. The states with the lowest total donation amounts are South Dakota, Maine, and Wyoming.
3. What are the car, university, second language and favourite colour of the top 10 donors with the highest donation amounts?
Donors have diverse preferences when it comes to car brands, university attended, favorite color, and second language. However, these preferences do not seem to have an impact on the donation amount.
4. What is the number of donors that attended a university and the number of those that didn’t attend a university?
This shows that the majority of the donors (748) have a university education.
5. What is the number of donations and total donation for each gender?
The number of donations is relatively evenly distributed between females and males. However, the total donation amount from males is slightly higher than that from females.
6. What is the total donation amount for each donation frequency?
Donations made yearly have the highest total donation amount, followed by donations made once. Also, Donations made monthly and weekly contribute significantly to the total donation amount.
7. What is the distribution of donation amounts in different donation groups?
The highest donation amount $500 was made by only 2 donors. The majority of the donations fall into the lower ranges (under $100 and $100–199).
8. What are the top 5 job fields by total donation?
Among the top 5 job fields Human Resources, Research and Development, and Product Management have made the highest donations.
Below is a tableau dashboard representing the analysis results:
Insights & Recommendations
- Donors are diverse in terms of states, job fields, and donation frequency preferences. However, only two donors donated the highest amount which is $500. To encourage repeat donations, expressing gratitude through thank-you messages or emails could be effective.
- California has the highest total donation ($30,264), followed by Texas and Florida. Build strong relationships with donors from these states by providing regular updates on the impact of their donations to beneficiaries.
- This shows that the majority of the donors (748) have a university education. Develop targeted messaging strategies to effectively connect with donors irrespective of their educational background.
- Donations are evenly distributed between males and females. Strategies should be implemented to encourage increased donations from both genders.
- Donations made yearly have the highest total donation amount, followed by donations made once. Emphasize the impact of yearly and once donation to the donors while we encourage monthly and weekly donors.
- While the majority of donations fall into the lower ranges, efforts should be focused on encouraging larger donations. Implement targeted fundraising campaigns and emphasize the impact of larger donations to motivate donors to contribute more
