The console — four views, four decisions.
Each view answers a question Campus Strategy actually asks. Each is sourced from named SQL views above. Each carries the assumptions that make the number defensible.
Capacity risk · building × day-of-week
Source: v_capacity_risk · 8-week rollingWhere the campus runs hot. Cells flagged HIGH approach unsafe density on peak days. The pattern is unmistakable — Tuesday and Wednesday are the binding constraint on three of four buildings.
Mon
Tue
Wed
Thu
Fri
Tower One
26%
46%
47%
46%
25%
Tower Two
35%
57%
60%
59%
33%
Commons
44%
72%
76%
72%
42%
Franklin Annex
113%
171%
190%
179%
106%
Decision this informs: Whether to add seats in Tower One (peak HIGH) or shift demand toward Commons (consistently LOW). The data favors demand-shifting over capital expansion.