Intramural Sports Participation Analysis
Seven years of participation data, turned into dashboards UREC leadership used for scheduling, marketing, and retention decisions.
Excel · Tableau · Stakeholder Reporting
Overview
Seattle University Recreation runs an intramural program of 64+ teams and 469+ participants. I analyzed seven years of participation records (2018–2025) and presented dashboards to UREC leadership to support scheduling, marketing, and retention decisions.
Problem
Decisions about which leagues to grow, cut, or reschedule were made mostly on staff intuition. Years of participation records existed, but nobody had analyzed them.
Context
This wasn’t an outside consulting exercise. I worked inside this program for nearly four years as an official and later as Intramural Sports Manager, which shaped the questions: I knew where the operational pain was before opening the data.
My Role
Sole analyst: data consolidation and cleaning in Excel, dashboard design in Tableau, and the presentation to UREC leadership. Separately, I managed the program’s 40+ student officials.
Approach
- Consolidated and cleaned participation data across sports, seasons, and class years (2018–2025)
- Analyzed engagement trends and involvement drivers: which leagues were growing, which were declining, and when students actually sign up
- Built Tableau dashboards highlighting participation patterns by sport, season, and class year
- Presented findings to UREC leadership to inform scheduling, marketing, and retention planning
Key Findings
Content in progress. This section will be updated with public-safe findings and artifacts.
Recommendations
Content in progress. This section will be updated once the findings above are published.
Artifacts
Content in progress. Dashboard views will be added here.
Reflection
Knowing the program from the floor and then seeing it in the data taught me how different those two views can be, and how much easier leadership buy-in comes when findings arrive as a dashboard instead of a spreadsheet.
Status
The analysis and leadership presentation are complete; the public write-up with dashboard artifacts is in progress.