Hi! Here is some code I've written during my time on the Sunrise data team.
Analytics Engineering: Actblue Fundraising Models
Using dbt, I transformed raw Actblue tables into more insightful summary models for our fundraising analysis.
Reporting and Analysis: Fundraising Reporting
Using the models I created in dbt, I made an end of the year fundraising report in Hex that bought insights into our fundraising efforts. In addition to general trends like total amount raised per year and per month, I also focused on identifying which channels and which amount ranges brought in the most donations. Although I can't share the analysis part of the report, you can view some of my code here.
Dashboarding: Training and Coaching Program
Using Periscope, I created a dashboard that tracked participation in a training and coaching program. Metrics included number of RSVPs and attendees for each training, as well as the demographic breakdown of participants. This helped organizers track and make interventions to achieve their recruitment goals.