Built the analytics foundation for a 250-clinic dental services organisation

InterDent Inc. is one of the largest dental services organisations on the US West Coast — operating 250+ clinics with 1,000+ dentists and millions of active patients. The business runs on a commercial practice management system that manages clinical operations but provides no reporting or analytics capability.

Classic Informatics was engaged to build the analytics layer the PMS could never provide — and has been rebuilding and evolving it across three platform generations for over 20 years. 

• No reporting or analytics layer existed on top of the practice management system
• Operational data was locked across 20+ source databases with no way to aggregate it
• Management had no visibility into daily production, collections, or clinic performance
• Doctor-level performance tracking across 1,000+ providers was impossible at scale
• Insurance claims aging and revenue variance could not be monitored across 250 clinics

1. Embedded in the data first

We spent four to five months mapping every table and column across 20+ source databases alongside InterDent's data architect — building domain depth in dental billing, insurance claims, and provider compensation before writing a single pipeline. 

2. Built for business workflow, not schema

Every report and dashboard was designed around how InterDent's corporate, regional, and office managers actually make decisions — not what was easiest to extract from the source system. 

3. Rebuilt three times without disruption

As technology evolved, we rebuilt the architecture from on-premises SQL Server to a columnar SSAS cube to a cloud data warehouse — each migration completed without a single day of reporting downtime. 

4. Scaled with the business throughout

InterDent grew from 80 to 250+ clinics during this engagement. The platform scaled with it — new clinics, new reporting requirements, and new data sources absorbed without replacing the core architecture. 

Data Warehouse Architecture

• Three-generation data warehouse: on-premises ODW, columnar EDW, and cloud DW
• Bronze to Gold layered architecture with incremental daily pipelines
• SSIS ETL across 20+ source databases (~80–100 packages in Phase 1)
• SSAS columnar cube with DAX measures for fast query performance
• Cloud-hosted platform positioned for AI/ML workloads 

Reporting & Dashboards

• Daily Hurdle Report — morning dashboard covering production, confirmation, and slot projections
• Corporate, regional, and office Power BI with Row Level Security
• Provider Stack and Rank — 1,000+ doctors ranked by production and revenue per visit
• Operational Scorecard consolidating 15–20 complex reports into one management view
• Financial and aging reports across 30/60/90/180-day buckets with MTD/YTD/budget variance 

Compliance & Operations

• OHP State Billing Reports submitted monthly to Oregon state government on InterDent's behalf
• Raw CSV data extracts for payroll, transactions, specialty, and accounting teams
• Daily CEO-level summaries across all 250 clinics 

InterDent's leadership team went from having no visibility into group operations to starting every morning with dashboards covering production, collections, provider performance, and clinic-level variance — across 250 clinics in a single view. The same platform has run continuously through three complete technology generations.

Business Impact

• 80 to 220+ clinic locations scaled on Classic Informatics-built analytics throughout
• 1,000+ doctors ranked and tracked by production performance across all clinics
• 20-year engagement with zero reporting downtime across three platform migrations
• 80%+ of management reporting moved to Power BI in the second platform generation
• State compliance reporting for Oregon Health Plan managed entirely by Classic Informatics