Case Study: Stratum Data Services cuts decision latency from weeks to minutes with Sigma
Key results
The challenge
Stratum Data Services, a subsidiary of Stratum Med, serves 24 independent medical groups representing over 12,000 physicians, each operating on siloed practice-management systems, EHRs, and claims feeds with no shared data layer. Operators submitted tickets for even basic questions and responses arrived in days, weeks, or not at all, while the lack of standardized definitions made cross-clinic benchmarking impossible. A CFO wanting to understand claim denial rates or appointment utilization had no self-service path, and a 3% reduction in claim denials at a single clinic represents an estimated $10 million in recoverable revenue.
The solution
Stratum built on Snowflake as its core infrastructure and selected Sigma as the analytics interface for clinic operators, whose Excel fluency removed the adoption barrier that had stalled other BI tools. Sigma's Input Tables became the mechanism for data standardization across clinics, reconciling provider specialty classifications so benchmarking reflects consistent definitions. Scheduled reports deliver daily and weekly snapshots, and operator-built ad hoc pivot tables against live warehouse data replaced the ticket queue.
“You're literally going from sometimes never, sometimes six weeks, sometimes a year, to answering the question within five minutes. It's quite a transformation for these clinics.”
JWJeramey WardChief Data Officer, Stratum Data Services
The results, in context
One member group running at 80% appointment utilization benchmarked against a peer at 103%, prompting scheduling changes that produced a 15% lift in appointment utilization. Claim-denial analysis identified a path to an estimated $10 million in additional revenue per clinic from a 3% denial-rate reduction. Reporting cycles that previously took days or went unanswered now resolve in under five minutes.