Appeals Friction Radar
Modeled 3,966 appeals and 35,443 workflow events in an event-level star schema; used SQL window functions to measure stage dwell time and median turnaround; built a 16-rule data-quality gate and Friction Score. Found incomplete documentation drove 31.7% rework vs. 7.7% when complete, and turnaround rose from 13.4 to 28.4 days after three reassignments.
