Team statistics dashboard for high school sports

Project: Create an interactive dashboard to display team win/loss and scoring statistics for high school sports teams in Montgomery County Public Schools (MCPS).

Solution: Used data analysis and visualization tools to gather 10 seasons of game result data from countysports.zone and process and visualize the data.

In Section 1, sparkline-inspired facet charts convey a large amount of historical data in relatively little space. Vertical bar charts in Section 2 shows team stats versus the county average.

Currently showing girls' basketball, with more sports in progress. 

Tools
  • Python, Pandas, and Jupyter Notebook: data acquisition, cleanup, enhancement, and analysis
  • Text extraction: Tabula, Camelot, Acrobat Actions scripting
  • Claude.ai: Python and Javascript code enhancement and debugging
  • Excel and BBEdit: data review
  • Observable Plot and Javascript: data visualization
Credits

Comprehensive design packages for government and nonprofit institutions.