Penn Football Testing Dashboard

Building a successful collegiate football roster requires long-term planning and strategic decision-making across multiple domains, from athlete recruitment to game-day performance. Optimal decisions rely on understanding each athlete’s physical and performance characteristics, which vary substantially by position. At the University of Pennsylvania (Penn), these decisions are frequently guided by subjective impressions rather than systematic, data-driven assessments. This reliance on intuition can lead to suboptimal outcomes, such as recruiting mismatches, misaligned position assignments, and ineffective player utilization during competition. Since 2019, Penn’s strength and conditioning staff have collected annual data on athletes’ anthropometric measurements and performance in key strength, power, speed, and agility tests. This dataset represents a valuable resource for identifying historical trends and evaluating individual athletic profiles over time. This capstone project develops a data pipeline and interactive web-based dashboard to transform raw performance data into actionable insights. The tool generates comprehensive athlete profiles to support evidence-based coaching decisions, including benchmarking, longitudinal progress tracking, and within-position comparisons. The pipeline integrates R for data processing, Firebase for storage and retrieval, and JavaScript for front-end development. The resulting interface allows coaches to input and update athlete data easily, select players for side-by-side comparison, and visualize relative strengths and development trajectories across seasons, facilitating roster management from recruitment through game day.

Learn More

GitHub
Website
Powerpoint slides