BUSINESS PROBLEM

As a data analyst working for the charity, Education for All, I have been asked by the Head of Fundraising to present the data on donor insights and donation rates.

The goal is to present strategies to help;

1. Increase the number of donors
2. Increase the donation frequency
3. Increase the value of donations

DATASET

1. Donation_Data contains the following data:

• id - Donor ID
• first_name - Donor first name
• last_name - Donor last name
• email - Donor email address
• gender - Donor gender
• job_field - Donor job field
• donation - Donation amount
• state - Donor state of residence (US)
• shirt_size - Donor t-shirt size

2. Donor_Data contains the following data:

• id - Donor ID
• donation_frequency - Frequency of donation
• university Donor - University attended
• car - Donor car make
• second_language - Donor second language
• favourite_colour - Donor's favourite colour
• movie_genre - Donor favourite movie genre

BUSINESS QUESTIONS

1. How much is the total donation?
2. What is the total donation by gender?
3. Show the total donation and number of donations by gender
4. Total donation made by frequency of donation
5. Total donation and number of donations by job field
6. Total donations and number of donations above $200
7. Total donations and number of donations below $200
8. Which top 10 states contributed the highest donations?
9. Which top 10 states contributed the least donations?
10. What are the top 10 cars driven by the highest donors?

The data was imported into Postgre SQL and all questions were answered using the appropriate queries. This GitHub link contains the dataset, queries and recommendations.