Patient Record + DRG
by Tableau
Description
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)
Partners of Choice
Our top consulting Partners may be able to help you customize this Accelerator for your own business needs.
United States / Canada
- Prominence Advisors - Tableau's top Partner in Healthcare Analytics
- InterWorks - Tableau expertise from 8X Partner of the Year
Latin America
- BluePatagon - Regional Partner that helps you make better decisions with BI, Big Data and Machine Learning
- TSoft Latam - Regional Partner that helps you drive business digital transformation through Data Analytics
- DataTeam - Foster Data Culture and Analytics for better business decision making