Patient Record + DRG

The Tableau Accelerator for Patient Record + DRG gives you a jumpstart to getting data-driven insights into patient records. You can use this Accelerator to better understand patient stays and how they have evolved.

LOS stands for length of stay (measured in days).

A diagnosis-related group (DRG) is a patient classification system that standardizes prospective payment to hospitals and encourages cost containment initiatives. In general, a DRG payment covers all charges associated with an inpatient stay from the time of admission to discharge. The DRG includes any services performed by an outside provider.

DRG-Inliers % represents the share of stays for which the LOS was between the two LOS thresholds recommended for this DRG.

Answer key business questions

• How many stays do we handle? Which trends?
• What it the typical LOS by specialty? How does it compare to the benchmark LOS?
• What is the share of DRG-inliers?
• How many discharges are done before noon?
• What is the share of inpatient stays?
• What is our average Cost-weight per stay? How does it evolve?

Monitor and improve KPIs

• Nb of Stays
• Nb of Inpatient Stays
• LOS (days)
• LOS (△ vs Benchmark)
• Emergency Admissions
• Deceases
• Dead Patient Age
• Nb of Patients
• Patient Age
• Discharges before midday
• Total Cost-Weight
• Cost-Weight per Stay
• DRG - Nb of Inliers
• DRG - Nb of Outliers
• DRG - Nb of Low Outliers
• DRG - Nb of Low Inliers
• DRG - Nb of High Inliers
• DRG - Nb of High Outliers
• Inpatient Stays %
• Emergency Admissions %
• Deceases % on patients
• Stays per Patient
• Discharges before midday %
• DRG - Inliers %
• DRG - Outliers %
• DRG - Low Outliers %
• DRG - Low Inliers %
• DRG - High Inliers %
• DRG - High Outliers %

Required attributes

• Facility (string)
• Stay # (string)
• Stay Type (string) ← expected values: 'Inpatient', 'Outpatient'
• Inpatient Flag (string) ← expected values: 'Y', 'N'. 'Y' if Stay Type is Inpatient
• Patient # (string)
• Specialty (string)
• Service (string)
• Doctor (string)
• Main Diagnosis (string)
• Main Treatment (string)
• Admission Date (date)
• Discharge Date (date)
• Birth Date (date)
• Gender (string)
• Admission Mode (string)
• Admission - Emergency Flag (string) ← expected values: 'Y', 'N'. 'Y' means the admission was an emergency.
• Discharge Mode (string)
• Discharge - Decease Flag (string) ← expected values: 'Y', 'N'. 'Y' means the discharge is due to a decease.
• DRG Code - Diagnosis Related Group (string)
• DRG Status (string) ← expected values: 'Low Outliers', 'Low Inliers', 'High Inliers', High Outliers'
• LOS (days) - Length of Stay (numeric)
• DRG - LOS Benchmark (numeric)
• DRG Cost-Weight (numeric)