Hack for the Community 2026 · Nashville

Clinical Pulse

A predictive dashboard that helps the Sexual Assault Center plan ahead so more survivors can get the therapy they need.

Nashville, Tennessee

Therapy at the Sexual Assault Center

Supporting survivors in Middle Tennessee since 1978.

~24,700therapy sessions in the last three years

FY27 funding and goals

Grants help pay for 8,900 therapy sessions

8,900therapy sessions SAC committed to deliver
×
$204in funding per session
=
$1.81Mfrom grants and donors

If SAC falls short, survivors get fewer sessions, and it’s harder to show funders what their grants delivered. How do we stay on track?

The planning challenge

Enough to report. Not enough to plan.

Month-end reportDay 1Day 30

At the end of every month, SAC’s directors report how many therapy sessions their teams delivered. But those totals don’t show whether SAC is on track to meet its commitments to funders or where therapists have capacity to see more patients.

The opportunity

Spot a shortfall while there’s time to act.

Are we on track?

Know whether SAC will hit its therapy goal by June, while there’s still time to adjust.

What we builtPredictive model

If not, why?

See which therapists have openings, which visits are missed, and when demand is highest.

What we builtCapacity drill-down

What can we change?

See where to fill openings or add hours, and how many sessions those changes could add.

What we builtNext best actions

Demo

Clinical Pulse prototype dashboard with the session forecast, weekly delivered and booked bars, and next actions

What we found · Are we on track?

Our forecast put SAC 1,326 sessions short by June.

03,0006,0009,000JulAugSepOctNovDecJanFebMarAprMayJun Oct close 8,900 promised7,574 forecast
$270Kworth of budgeted therapy in that gap

What we found · If not, why?

People were waiting. Appointments were open.

46 people waiting78 open therapy slots

Five therapists had 68 of those openings.

What we found · What can we change?

SAC can fill open slots and add coverage at busy times.

01

Fill open slots

Match 30 patients on the waitlist with openings that work for them.

02

Rebook missed visits

Try rebooking 10 visits a week. Fridays had fewer bookings than midweek.

03

Add therapist hours

Use busy times to guide staffing and estimate what one more therapist could add.

What SAC could recover

These changes could close about 78% of the gap.

~1,040more therapy sessions by June
~$212Kin budgeted therapy

What comes next · Four-week pilot

We’d like to try this with SAC.

Week 1

Validate

We’ll check the forecast against a month SAC knows well.

Week 2

Prioritize

SAC staff will choose the first scheduling problem to tackle.

Week 3

Try it

We’ll support staff as they rebook visits or match people to openings.

Week 4

Learn

Together, we’ll see what worked and what needs to change.

Appendix · Future version

What we’d build next

01 · Direct data connections

No CSV uploads

Connect to SAC’s approved scheduling, reporting, and finance systems so the dashboard refreshes from the source.

02 · LLM-powered assistant

Ask in plain language

Use an approved AI assistant for questions. Keep the forecast and its calculations separate.