Stratum Data Services Cuts Decision Latency from Weeks to Minutes, Driving a 15% Lift in Clinic Appointment Utilization

Independent medical groups historically lacked the shared data infrastructure to benchmark performance or answer operational questions without IT intervention. Stratum Data Services deployed Sigma on top of Snowflake as their cloud data warehouse, replacing fragmented legacy reporting systems and eliminating analyst bottlenecks across member medical groups.

• 15% – Appointment utilization lift at benchmarked member clinic
• Estimated $10M – Revenue recoverable per clinic from a 3% claim denial reduction
• Days to minutes – Ad hoc reporting cycle time reduction for clinic operators

“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."
_{— Jeramey Ward, Chief Data Officer}

The Challenge

Stratum Data Services,  a wholly owned subsidiary of Stratum Med, serves 24 independent medical groups representing over 12,000 physicians. Each member clinic operated on siloed transactional systems, including practice management platforms, EHRs, and claims feeds, with no shared data layer. Operators submitted tickets to data teams for even basic questions. Responses arrived in days, weeks, or not at all.

Without standardized definitions or a common data model, cross-clinic benchmarking was impossible. Clinics relied on national surveys and anecdotal peer conversations to gauge performance. A CFO wanting to understand claim denial rates or appointment utilization had no self-service path. The cost of that delay was not abstract: a 3% reduction in claim denials at a single clinic represents an estimated $10 million in recoverable revenue.

The Solution

Stratum Data Services started with Snowflake as its core infrastructure layer and selected Sigma as the analytics interface for clinic operators. The decision was deliberate. Clinic COOs, CFOs, and practice managers were already fluent in Excel. Sigma's spreadsheet-native interface removed the adoption barrier that had caused other BI tools to stall. No retraining was required. Operators moved directly from Excel habits into live warehouse queries.

Sigma's Input Tables became the mechanism for data standardization across clinics. Operators use Input Tables to reconcile provider specialty classifications, ensuring that benchmarking comparisons reflect consistent definitions rather than each clinic's local taxonomy. Scheduled reports deliver daily and weekly snapshots directly to inboxes. Ad hoc pivot tables built by operators against live warehouse data have replaced the ticket queue entirely.

The Results

The operational shift produced measurable outcomes at the clinic level. One member group running at 80% appointment utilization benchmarked against a peer clinic at 103%. That comparison, made possible by Sigma's benchmarking workbooks, prompted a direct operational conversation. The lagging clinic implemented scheduling changes and recorded a 15% lift in appointment utilization. Claim denial analysis through the same platform 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.

“Being able to reduce claim denials generates real money. If they just reduce their claim denials by 3%, that could be an additional estimated $10 million in actual dollars flowing into a clinic."
_{— Jeramey Ward, Chief Data Officer}

Stratum Data Services is now building toward AI-assisted querying within Sigma. The next phase allows operators to ask natural language questions against the governed warehouse, bypassing even the pivot table step. Because the data is contextualized and controlled within Sigma's environment, this approach addresses the compliance and PII concerns that make uncontrolled AI tool usage a liability in healthcare. The compounding effect is a platform that grows more valuable as each clinic contributes data, sharpens benchmarks, and reduces the time between question, decision, and action.