Cleaning and Organizing Data for Better Insights

lient: A nonprofit organization managing donor records in messy spreadsheets.
Challenge:
The nonprofit struggled with duplicate entries, inconsistent formats (e.g., date and phone numbers), and missing fields in their donor database. This made reporting and outreach inefficient.

Solution:

• Used Excel/Google Sheets to clean and organize the data:

  • Removed duplicate entries using formulas like COUNTIF.

  • Standardized data formats (e.g., date, phone numbers) with custom functions and formatting.

  • Created drop-down lists for future data consistency.

• Generated a summary dashboard to visualize donor activity trends.

Results:

• Reduced data duplication by 95%.

• Improved the accuracy of donor outreach campaigns.

• Enabled the nonprofit to identify high-value donors, increasing donations by 20% in one quarter.