Identifying, Quantifying, and Visualizing Alumni Affinity Networks
2:30 PM - 3:30 PM CT
Speaker(s): Nicholas Hersey, Data Analyst, Williams College, Heather Forman, Prospect Management and Research Analyst, Williams College
Competencies: Relationship BuildingStrategic Thinking
Elective Session
A review of the Williams College Affinity Network Dashboard project, including SQL data extraction, statistical analysis using R, and dynamic, Tableau-based visualizations. Goals of the project were to calculate the size and capacity of student affinity groups, assigning a personal network value to each alumnus. This allows us to pinpoint high-capacity networks that warrant attention from development staff, infusing greater socioeconomic diversity into prospect portfolios. We are also able to identify alumni of influence and facilitate personal connections with hard-to-reach prospects.