Local Watershed Association

Overview

The governing board of a watershed association needed a reliable record of donors, environmental readings, and grant programs. We partnered with their volunteer team to design a normalized schema, consolidate historical spreadsheets, and make it simple to compare internal data with state and federal sources.

What we implemented

1. Comprehensive data inventory: Audited scattered spreadsheets and legacy files to map key entities, relationships, and compliance requirements.
2. Unified Airtable workspace: Structured bases and linked tables for donors, events, inspections, and grants with role-based permissions.
3. Python-powered ingestion notebooks: Reusable Google Colab workflows that clean legacy CSV exports, match government datasets, and refresh Airtable tables.
4. Fundraising and compliance dashboards: Airtable interfaces that track donation velocity, water quality issues, and grant reporting milestones.

Key Features

• Schema governance: Documented naming conventions, field types, and sync rules so volunteers can safely extend the model.
• Automated dataset matching: Fuzzy joins across EPA and state water quality feeds to highlight anomalies that need on-site inspection.
• Instant fundraising insights: Board-ready dashboards showing donor retention, pledge conversion, and campaign performance.
• Self-service onboarding: Step-by-step playbooks so new volunteers can run ingestion notebooks and refresh dashboards without developer support.