Case Study: Mosaic Medical achieves optimized physician resources and rapid predictive risk scoring with Alteryx

Mosaic Medical Uses Alteryx to Optimize Physician Resources

Mosaic Medical is a community health center in Central Oregon that manages primary care, school-based, and mobile clinics serving about 19,000 patients (roughly 60,000 visits a year), largely low-income and high-need. The organization needed a reliable patient risk score to set target provider panel sizes and predict demand, but existing manual workflows couldn’t adjust for patient severity across diverse provider types (e.g., pediatricians vs. internal medicine), and building the initial model was time-consuming and hard to update.

By adopting Alteryx, Mosaic’s analyst reduced model build time from 75 hours to three hours and automated weekly updates with a repeatable, annotated workflow. The cleaner, more accurate risk scores feed Tableau to reveal clear patterns (pediatricians have lower risk and larger panels; internal medicine providers have higher risk and smaller panels), enable proactive outreach to underutilizers, and support staffing, exam-room and claims forecasting — delivering faster insights and operational improvements.

Mosaic Medical

Marshall Greene

Senior Healthcare Data Analyst