Loading chart
Loading chart
Loading chart
Loading chart
Dental Services Org
Standard
Quenwick Dental Partners
Dental production, insurance claims, hygiene recall, and chair utilization
50% OFF
$8.00$4.00USD, plus applicable tax
12 tables844K rowsParquet + CSV
About Quenwick Dental Partners
Industry
Dental Services Org
Company size
Fictional multi-office DSO with 20 dental offices, 120 dentists, hygienists, and specialists, and 40,000 active patients averaging a little over two visits a year each.
Staffing model
Every office carries two dentists, three hygienists, and one specialist, and providers work at their own office rather than floating across the group. Each office's care focus names the specialty its own resident specialist practises.
Procedure catalog
86 dental procedures across diagnostic, preventive, restorative, endodontic, periodontic, prosthodontic, oral surgery, and orthodontic categories, each with an internal procedure code, a chair time from 10 to 120 minutes, and a fee from $64 to $2,680.
Packaged scale
About 845,000 rows across 12 Standard-tier tables, including 180,000 appointments, 300,000 procedures, 200,000 insurance claims, 120,000 hygiene recall cycles, and an office-aware monthly chair utilization snapshot.
Production range
The two-year window carries roughly $100M to $110M of procedure production, which works out to about $50M to $55M of annual production across the offices, with roughly $84M of that submitted to insurance as claims.
Operating footprint
Five fictional reporting regions covering metro, lakeside, riverlands, and highlands areas.
Patient mix
A broad adult base with meaningful child, teen, and senior segments, split across commercial, PPO, HMO, and self-pay coverage, each carrying their own dental payer.
Quenwick Dental Partners is a fictional multi-office dental services organization used for synthetic BI analysis. The company story follows a group of neighborhood and flagship dental offices, the dentists, hygienists, and specialists who staff them, the patients they treat, and the daily flow of appointments, procedures, insurance claims, hygiene recall, and chair utilization. Everything here is invented for analytics practice. No real dental group, office, provider, patient, or payer is represented.
Operating Profile
- Runs general dentistry, hygiene, restorative care, and specialty services, with flagship sites carrying more operatories and specialists.
- Emphasizes appointment flow, procedure production, claim adjudication, recall cadence, and operatory utilization.
- Each office mixes recall visits, restorative work, new-patient exams, and a small share of emergency and consultation appointments.
- Excludes clinical charts, radiograph images, controlled-substance logs, lab case detail, payroll, and full financial ledger.
Recent Business Events
- 1The four highest-demand offices run near fully booked in peak months while the four lowest sit well under target on the same chairs.
- 2A push on hygiene recall and treatment follow-through is changing the appointment mix and specialist referral volume.
- 3Leadership wants one view connecting production, provider activity, claim performance, recall cadence, and chair utilization.
KPI Focus Areas
These are the operating questions this kit is optimized to answer first.
01Focus
Procedure volume, production amount, category mix, and production per visit
02Focus
Appointment volume, type mix, chair time, and scheduled production
03Focus
Claims billed, allowed, and paid, patient responsibility, and denial rate
04Focus
Hygiene recall volume, due and overdue cycles, and reminder cadence
05Focus
Available hours, booked hours, and utilization status by office and operatory
Embedded Analytical Stories
Gentle seasonality
Production rises through spring and early fall and eases around the holidays and midsummer.
Volume versus value
High-fee specialty procedures concentrate production while preventive visits drive the most appointments.
Chairs track demand
High-demand offices run near fully booked while the low end sits under target, with two on Remodel Watch.
Claim contrasts
Commercial preventive work and HMO orthodontics tell very different reimbursement stories.
Recall as a work queue
Compliance falls off with younger adults and holds with seniors and children, so the overdue list is real work.
Closed panels
Two offices stopped taking new patients, and their intake work drops to about a third of the group rate.
Quenwick Dental Partners
Buy Now$4.00USD, plus applicable tax