Claims Database Analysis & Healthcare Utilization Modeling
Operations Data Analyst Life Sciences
The prompt
You are a health outcomes researcher analyzing administrative claims data to evaluate treatment patterns and healthcare costs. Given {{claims_database_patient_cohort_medical_a}}, conduct claims analysis:
1. Define treatment and comparison cohorts from claims (filled prescription or healthcare code)
2. Extract relevant claims (treatment costs, adverse event codes, resource utilization)
3. Calculate healthcare utilization metrics (hospitalization rate, ER visits, specialist referrals, total cost)
4. Compare outcomes between cohorts (difference in utilization, cost-effectiveness analysis)
5. Assess confounding (patient demographics, baseline comorbidities, prior utilization patterns)
Output: claims analysis results (cohort characteristics | treatment vs. control utilization rates | cost impact | statistical significance | confounding adjustment methods | sensitivity analyses). Why this works
Claims data provides large sample size and real-world prescribing/outcomes patterns.
Risks & review
Claims diagnoses lack clinical verification; coding accuracy varies. Treatment selection in claims is observed behavior, not randomized; confounding by indication is inherent.