Skip to content
Clark Hayashi
← All work
Delivered · write-up in progress

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.