Study guide
2.2 Healthcare Datasets, Benchmarks & Population Health
AHIMA Certified Health Data Analyst CHDA
Track your progress as you read
Finished sections get a check mark.
1 Introduction & CHDA Exam Overview
0.1 About the AHIMA CHDA Exam 0.2 How to Use This Study Guide
2 Chapter 1: Healthcare Delivery Systems & Revenue Cycle
1.1 Healthcare Delivery Settings & Organizational Structures 1.2 Healthcare Revenue Cycle Management & Reimbursement Models 1.3 Regulatory Reporting & Accreditation Agencies
3 Chapter 2: Health Informatics, Datasets & AI
2.1 Electronic Health Records (EHR) & Health Informatics Foundations 2.2 Healthcare Datasets, Benchmarks & Population Health 2.3 Analytics Hierarchy & Artificial Intelligence in Healthcare
4 Chapter 3: Clinical Terminologies, Classifications & Standards
3.1 Clinical Classification Systems: ICD-10-CM/PCS & CPT/HCPCS 3.2 Clinical Terminologies & Ontologies: SNOMED CT, LOINC & RxNorm 3.3 Interoperability & Data Exchange Standards: HL7 v2, CDA & FHIR
5 Chapter 4: Business Needs Assessment & Scoping
4.1 Stakeholder Engagement & Analytics Needs Elicitation 4.2 Defining Metrics, KPIs & Healthcare Value 4.3 Analytics Project Management & Analysis Planning
6 Chapter 5: Data Sourcing, Lineage & Collection Methods
5.1 Healthcare Data Sourcing & Lineage 5.2 Healthcare Data Collection Methods & Architectures 5.3 Clinical & Financial Data Extraction
7 Chapter 6: Data Cleansing, Transformation & Validation
6.1 Healthcare Data Quality Assessment 6.2 Data Cleansing & Anomaly Remediation 6.3 Data Transformation, Mapping & Validation
8 Chapter 7: Exploratory Data Analysis & Descriptive Statistics
7.1 Healthcare Data Types & Scales of Measurement 7.2 Measures of Central Tendency & Dispersion 7.3 Exploratory Data Analysis in Clinical Populations
9 Chapter 8: Inferential Statistics & Hypothesis Testing
8.1 Sampling Techniques & Probability in Healthcare 8.2 Hypothesis Testing Fundamentals 8.3 Parametric vs. Non-Parametric Tests
10 Chapter 9: Advanced Statistical Modeling & Risk Adjustment
9.1 Correlation & Regression Analysis 9.2 Risk Adjustment & Healthcare Severity Modeling 9.3 Survival Analysis & Model Evaluation
11 Chapter 10: Healthcare Epidemiology & Study Methodologies
10.1 Epidemiological Measures of Disease Frequency & Association 10.2 Healthcare Study Designs & Methodologies 10.3 Confounding, Bias & Health Equity Analytics
12 Chapter 11: Healthcare Data Visualization & Dashboard Design
11.1 Principles of Effective Healthcare Data Visualization 11.2 Selecting Appropriate Healthcare Visualizations 11.3 Executive & Clinical Dashboard Architecture
13 Chapter 12: Healthcare Performance Measurement & CMS Quality Programs
12.1 CMS Quality Programs & Value-Based Purchasing 12.2 Clinical Quality Measures & Benchmarking 12.3 Financial Analytics & Case Mix Index Analysis
14 Chapter 13: Communicating Insights & Narrative Analytics
13.1 Translating Complex Analytics for Diverse Audiences 13.2 Contextualizing Limitations, Assumptions & Uncertainty 13.3 Narrative Reporting & Data-Driven Decision Support
15 Chapter 14: Healthcare Data Governance Frameworks & Stewardship
14.1 Enterprise Data Governance Frameworks 14.2 Data Stewardship & Master Patient Index (MPI) Management 14.3 Metadata Management & Business Glossaries
16 Chapter 15: Healthcare Privacy, Security & Data Ethics
15.1 HIPAA Privacy & Security Rules for Analysts 15.2 De-Identification Methodologies 15.3 Data Ethics, Audit Trails & Secondary Data Use
2.2 Healthcare Datasets, Benchmarks & Population Health
Key Takeaways Explain This Topic AI
Administrative claims datasets (Medicare SAF, MedPAR, HCUP, APCDs) provide standardized diagnostic, procedural, and financial data across large populations but carry billing latency and lack deep physiological metrics.
MedPAR collapses individual hospital claim line items into a single stay record per inpatient Medicare admission, serving as a primary benchmark for hospital utilization, length of stay, and Case Mix Index analysis.
Clinical registries (NCDR, SEER, NTDB, IIS) capture granular, disease-specific clinical variables (tumor histology, hemodynamic measurements, trauma scores) not found in administrative claims.
Public health datasets (CDC WONDER, NHANES, BRFSS, NVSS) provide essential population-level baselines, biometric distributions, behavioral risk factors, and vital statistics.
Social Determinants of Health (SDOH) are captured at the patient level via ICD-10-CM Z-codes (Z55–Z65) and at the geographic level via composite indices like the Area Deprivation Index (ADI) and Social Vulnerability Index (SVI).
Last updated: August 2026
Healthcare Datasets, Benchmarks & Population Health
Healthcare data analysts frequently leverage external datasets and national benchmarks to contextualize institutional performance, evaluate market share, design risk-adjustment models, and address population health disparities. Understanding the architectural structure, clinical granularity, financial validity, and inherent limitations of secondary datasets is a core competency tested on the CHDA examination.
Administrative Claims Datasets
Administrative claims data is generated during the healthcare revenue cycle when providers bill third-party payers for services rendered. Claims are formatted according to HIPAA Electronic Data Interchange (EDI) standards, specifically the ASC X12 837I (Institutional) and ASC X12 837P (Professional) transaction formats. ADMINISTRATIVE CLAIMS ATTRIBUTES
- ┌──────────────────────────────────────────────┬──────────────────────────────────────────────┐
- │ CORE ADVANTAGES │ CORE LIMITATIONS │
- ├──────────────────────────────────────────────┼──────────────────────────────────────────────┤
- │ • Standardized formats across all providers │ • Lack of clinical nuance & lab values │
- │ • Complete longitudinal utilization tracking │ • Adjudication lag (often 60 to 180+ days) │
- │ • Accurate adjudicated financial data │ • Coding driven by reimbursement rules │
- │ • Massive population-level sample sizes │ • Inability to capture unbilled care │
- └──────────────────────────────────────────────┴──────────────────────────────────────────────┘
- 1. Medicare Standard Analytical Files (SAF)
CMS produces the Standard Analytical Files (SAF) , which contain 100% of all adjudicated Medicare Fee-for-Service (FFS) claims. SAFs are segmented by care setting:
Inpatient SAF: Inpatient hospital claims (UB-04 / 837I).
Outpatient SAF: Hospital outpatient department, ambulatory surgery center, and clinic claims.
Carrier (Physician/Supplier) SAF: Professional services billed by physicians and practitioners (CMS-1500 / 837P).
Skilled Nursing Facility (SNF), Home Health Agency (HHA), Hospice, and Durable Medical Equipment (DME) SAFs.
Analytic Utility: SAF files provide complete line-item detail, revenue codes, modifier codes, National Drug Codes (NDC), allowed charges, and Medicare payment amounts.
2. Medicare Provider Analysis and Review (MedPAR) File
The MedPAR file aggregates Medicare inpatient hospital and skilled nursing facility claim records into a single consolidated record per beneficiary stay / admission .
Structure: Rather than presenting multiple interim claim line items, MedPAR condenses the entire hospitalization into one record containing the Medicare Severity Diagnosis-Related Group (MS-DRG), principal and secondary ICD-10-CM/PCS codes, admission/discharge dates, length of stay (LOS), total charges, covered charges, and Medicare reimbursement amounts.
Analytic Utility: MedPAR is the industry standard benchmark for hospital market share analysis, inpatient utilization tracking, geographic variation studies, and hospital Case Mix Index (CMI) benchmarking.
3. Healthcare Cost and Utilization Project (HCUP)
Sponsored by the Agency for Healthcare Research and Quality (AHRQ), HCUP is the largest collection of longitudinal, all-payer hospital care data in the United States, linking state data organizations, hospital associations, and private data organizations with the federal government.
National (Nationwide) Inpatient Sample (NIS): The largest publicly available all-payer inpatient database in the US. The NIS represents a 20% stratified sample of discharges from all US community hospitals (excluding rehabilitation and long-term acute care facilities). When weighted using HCUP discharge weights ( DISCWT ), it produces unbiased national estimates representing ~35 million hospitalizations annually.
Nationwide Emergency Department Sample (NEDS): Captures emergency department visits from over 950 hospitals, enabling national analyses of emergency care regardless of whether the visit resulted in an admission or discharge.
Kids' Inpatient Database (KID): Specifically sampled to analyze pediatric hospitalizations and rare childhood conditions.
State Databases (SID, SEDD, SASD): State Inpatient Databases (SID), State Emergency Department Databases (SEDD), and State Ambulatory Surgery and Services Databases (SASD) capture 100% of discharges within participating states, enabling comprehensive regional and state-level analyses.
4. All-Payer Claims Databases (APCDs)
APCDs are state-mandated or voluntary data repositories that collect medical, pharmacy, and dental claims from commercial health plans, Medicare Advantage, Medicaid managed care, and public programs.
Analytic Utility: APCDs provide comprehensive insight into commercial pricing variations, total cost of care across diverse payer types, and out-of-pocket patient liability across entire geographic populations.
Clinical Registries
Unlike administrative claims, clinical registries capture granular physiological, anatomical, procedural, and longitudinal outcome data directly from clinical records and specialized clinical workflows. Claims Data: [ICD-10: I21.09] ──> "ST-elevation myocardial infarction" (Billing Category)
Registry Data: [NCDR CathPCI] ──> Door-to-balloon time = 52 min, 99% LAD occlusion, 3.5x18mm drug-eluting stent
1. Cardiovascular Registries (NCDR)
The National Cardiovascular Data Registry (NCDR) , managed by the American College of Cardiology (ACC), comprises specialized clinical registries:
CathPCI Registry: Assesses characteristics, treatments, and outcomes for cardiac catheterization and percutaneous coronary intervention (PCI) procedures (e.g., door-to-balloon times, stent types, fluoroscopy duration, vessel anatomy).
ACTION Registry (Chest Pain-MI): Tracks acute myocardial infarction clinical management and adherence to ACC/AHA guideline-directed medical therapy.
STS/ACC TVT Registry: Monitors transcatheter valve therapies (TAVR/TEER) in partnership with the Society of Thoracic Surgeons.
2. Cancer Registries (SEER & NCDB)
Surveillance, Epidemiology, and End Results (SEER) Program: Administered by the National Cancer Institute (NCI), SEER collects population-based cancer incidence, stage at diagnosis (AJCC TNM classification), tumor histology, primary treatment modalities, and longitudinal survival data from central cancer registries covering ~48% of the US population.
National Cancer Database (NCDB): A joint clinical registry operated by the Commission on Cancer (CoC) of the American College of Surgeons and the American Cancer Society, capturing ~70% of all newly diagnosed cancer cases from accredited hospital cancer programs.
3. Trauma & Public Health Registries
National Trauma Data Bank (NTDB): Operated by the American College of Surgeons (ACS), aggregating standardized trauma metrics including Injury Severity Score (ISS), Revised Trauma Score (RTS), Glasgow Coma Scale (GCS), mechanism of injury, and emergency surgical intervention intervals.
Immunization Information Systems (IIS): Confidential, population-based, computer-based databases that record all vaccine doses administered by participating providers within a geographic jurisdiction, essential for calculating immunization coverage rates and tracking vaccine series completion.
Public Health & Epidemiological Datasets
Public health datasets provide population-level baselines and epidemiologic benchmarks essential for health status assessment, health services research, and community health needs assessments (CHNA).
Dataset / System Sponsoring Agency Data Collection Methodology Core Focus & Variables Analytic Application
CDC WONDER CDC Online querying of integrated federal health databases Mortality (NVSS underlying/multiple cause of death), births, cancer statistics, environmental exposures Epidemiologic trend analysis, crude and age-adjusted mortality rate calculations.
NHANES CDC / NCHS Continuous annual survey combining in-person interviews with mobile examination center (MEC) physical exams and lab tests (~5,000 persons/year) Biometric measurements (BP, BMI, lipid panels, HbA1c), nutritional intake, undiagnosed chronic conditions Establishing national biometric baseline distributions and disease prevalence benchmarks.
BRFSS CDC / State Health Departments Annual state-based random-digit-dial telephone survey (>400,000 adult interviews annually) Self-reported health risk behaviors (smoking, alcohol, physical inactivity), chronic diseases, preventive screening State and county-level behavioral risk tracking and health promotion evaluation.
NVSS CDC / NCHS Complete registration of vital events from 57 state and territorial jurisdictions Birth certificates, death certificates (immediate, underlying, contributing causes), infant mortality Official US mortality statistics, life expectancy tables, and perinatal health surveillance.
Social Determinants of Health (SDOH) Data & Indices
Social Determinants of Health (SDOH) are the non-medical conditions in which people are born, grow, live, work, and age. Research demonstrates that clinical medical care accounts for only ~20% of modifiable health outcomes, while SDOH factors, physical environments, and behavioral factors drive the remaining ~80%. DRIVERS OF HEALTH OUTCOMES
- ┌───────────────────────────────────────────────┬─────────────────────────────┐
- │ SDOH, Socioeconomic & Environmental Factors │ Clinical Medical Care │
- │ (Income, Housing, Food Security, Education) │ (Inpatient, Outpatient, Rx)│
- │ ~80% Impact │ ~20% Impact │
- └───────────────────────────────────────────────┴─────────────────────────────┘
- 1. ICD-10-CM SDOH Z-Codes (Z55–Z65)
ICD-10-CM provides discrete diagnosis codes to capture patient-level social, economic, and environmental risk factors:
Z55: Problems related to education and literacy (e.g., illiteracy, underachievement).
Z56: Problems related to employment and unemployment (e.g., job loss, stressful working conditions).
Z57: Occupational exposure to risk factors (e.g., toxic substances, noise, extreme temperatures).
Z59: Problems related to housing and economic circumstances (e.g., Z59.0 Homelessness, Z59.4 Lack of adequate food/food insecurity, Z59.1 Inadequate housing).
Z60: Problems related to social environment (e.g., living alone, acculturation difficulty).
Z62: Problems related to upbringing (e.g., parent-child conflict, history of abuse).
Z63: Other problems related to primary support group, including family circumstances.
Z65: Problems related to other psychosocial circumstances (e.g., incarceration).
CHDA Coding Rule: Official ICD-10-CM Coding Guidelines allow SDOH Z-codes (Z55–Z65) to be assigned based on documentation from any healthcare team member (e.g., social workers, case managers, discharge planners, nurses, community health workers), not solely the treating physician.
2. Composite SDOH Indices
When patient-level Z-codes are under-documented, analysts use geographic composite indices linked via patient residential ZIP codes or 12-digit Census Block Group Federal Information Processing Standards (FIPS) codes. COMPOSITE SDOH INDICES
- ┌──────────────────────────────────────────────┬──────────────────────────────────────────────┐
- │ AREA DEPRIVATION INDEX (ADI) │ SOCIAL VULNERABILITY INDEX (SVI) │
- ├──────────────────────────────────────────────┼──────────────────────────────────────────────┤
- │ • Developed by HRSA / Univ. of Wisconsin │ • Developed by CDC / ATSDR │
- │ • 17 US Census / ACS indicators │ • 16 US Census / ACS indicators │
- │ • Granularity: Census Block Group level │ • Granularity: Census Tract level │
- │ • Metrics: Income, education, housing, car │ • 4 Themes: Socioeconomic, Household, │
- │ • Output: National percentiles (1–100) or │ Minority/Language, Housing/Transportation │
- │ State deciles (1–10; 10 = most deprived) │ • Output: Percentile rank (0.000 to 1.000) │
- └──────────────────────────────────────────────┴──────────────────────────────────────────────┘
- Cross-Dataset Comparison Matrix
Dataset Category Representative Datasets Scope & Unit of Analysis Clinical Richness Financial Accuracy Data Latency Primary CHDA Applications
Administrative Claims Medicare SAF, MedPAR, APCDs Encounter or stay level; national or state populations Low (diagnoses, procedures, NDC; no vitals/labs) High (adjudicated payments, allowed amounts) Moderate to High (60–180 day lag) Utilization benchmarking, market share, total cost of care, CMI analysis.
Hospital Inpatient Discharges HCUP NIS, NEDS, KID, SID Discharge level; 20% sample (NIS) or 100% state census (SID) Moderate (ICD-10 codes, discharge status, charges) Moderate (total charges; requires Cost-to-Charge Ratios) High (12–24 month lag) National epidemiologic trends, readmission rates, hospital volume benchmarking.
Clinical Registries NCDR CathPCI, SEER, NTDB Disease/procedure specific; detailed clinical encounters High (physiological vitals, tumor staging, device serials) Low to None (rarely captures financial data) Moderate (60–180 day lag) Clinical quality improvement, surgical outcomes, survival analysis, device tracking.
Public Health Surveys NHANES, BRFSS, NVSS Person level; representative sample or 100% vital census High (biometrics, lab tests, self-reported risk) None (no billing data) Moderate to High (12–24 month lag) Population baseline risk, chronic disease prevalence, community health needs assessment.
SDOH Datasets ADI, CDC SVI, US Census ACS Geographic units (Census Tract, Block Group, ZIP code) Contextual/Environmental (income, education, housing) None (socioeconomic proxy data) High (1–5 year ACS updates) Health equity analytics, risk adjustment augmentation, community resource targeting.