New & Returning Patient Revenue

Business Problem

Total revenue alone could not tell leadership whether growth came from acquiring new patients, retaining existing ones, or changing patient value.

What I Built

Separated new and returning patient revenue by hospital, department, specialty, payment type, and patient volume to create an acquisition and retention view.

Scale

41.98M total revenue, including 22.98M from new patients and 19.00M from returning patients.

Outcome

Commercial leaders can identify which specialties drive acquisition, which support retention, and where patient growth is creating the strongest financial return.

Technology

Project Screenshots

Figures, names, and other identifying details shown in these dashboard screenshots have been randomized for privacy.