/uploads/galerie/000186/PR Cockpit W.PNG
25 required attributes
  • stringFacility
  • stringStay #
  • stringStay Type
  • stringInpatient Flag
  • stringPatient #
  • stringSpecialty
  • stringService
  • stringDoctor
  • stringMain Diagnosis
  • stringMain Treatment
  • dateAdmission Date
  • dateDischarge Date
  • dateBirth Date
  • stringGender
  • stringPatient Country
  • stringPatient City
  • stringAdmission Mode
  • stringAdmission - Emergency Flag
  • stringDischarge Mode
  • stringDischarge - Decease Flag
  • numericLOS (days) - Length of Stay
  • numericDRG - LOS Benchmark
  • stringDRG Code - Diagnosis Related Group
  • stringDRG Status
  • numericDRG Cost-Weight

Detailed presentation of the PATIENT RECORD + DRG dashboard

Your PATIENT RECORD + DRG dashboard will contain 29 KPIs

and 22 dashboard pages

Home

Patient Record + DRG Home

Patient Record + DRG Home
Patient Record + DRG HomePatient Record + DRG Home
Get a Home Page for your Patient Record + DRG dashboard

Cockpit

Patient Record Cockpit

Patient Record Cockpit
Patient Record CockpitPatient Record Cockpit
Overview of your Patient Records: Admissions, Stays, Discharges and DRG

Patient Record + DRG Top KPIs Breakdown

Patient Record + DRG Top KPIs Breakdown
Patient Record + DRG Top KPIs BreakdownPatient Record + DRG Top KPIs Breakdown
Get a transverse view on your top 6 Patient Record + DRG KPIs, split by the dimension of your choice

Patient Record Top KPIs Trends

Patient Record Top KPIs Trends
Patient Record Top KPIs TrendsPatient Record Top KPIs Trends
Visualize how your Patient Record + DRG KPIs are evolving (Month-to-Date, Year-to-Date)

DRG Analytics

Top DRG

Top DRG
Top DRGTop DRG
Rank your DRG per Number of Stays, Inliers %, Outliers...

DRG - Diagnosis-Related Group

DRG - Diagnosis-Related Group
DRG - Diagnosis-Related GroupDRG - Diagnosis-Related Group
Analyze your DRG: Number and share of outliers, inliers

Stays Analytics

LOS - Length of Stay

LOS - Length of Stay
LOS - Length of StayLOS - Length of Stay
Get in-depth information of LOS (Length of Stay) per Specialty

Admissions

Admissions
AdmissionsAdmissions
Visualize when patients are admitted during the day

Discharges

Discharges
DischargesDischarges
Visualize when patients are discharged during the day

Stays - Cost-Weight (PR)

Stays - Cost-Weight (PR)
Stays - Cost-Weight (PR)Stays - Cost-Weight (PR)
Visualize the Cost-Weight per medical specialty, diagnosis, DRG Code...

Doctor Analysis

Doctor Analysis
Doctor AnalysisDoctor Analysis
Visualize how doctors perform

Specialty Analysis (PR)

Specialty Analysis (PR)
Specialty Analysis (PR)Specialty Analysis (PR)
Visualize the evolution of each medical specialty

Patients Analytics

Patient Base

Patient Base
Patient BasePatient Base
Overview of your Patient Base: Men / Women; Children / Adults, By age...

Deceases

Deceases
DeceasesDeceases
Analyze the deceases: case by case, age of patients, share of deceases...

Inpatients / Outpatients

Inpatients / Outpatients
Inpatients / OutpatientsInpatients / Outpatients
Analyze the evolution of inpatients/outpatients KPIs

Behavioral Analytics

Patient Record + DRG Seasonality Analysis

Patient Record + DRG Seasonality Analysis
Patient Record + DRG Seasonality AnalysisPatient Record + DRG Seasonality Analysis
Quickly identify seasonality patterns in your Patient Record + DRG dashboard. You can select any KPI you like, across multiple time level of details.

Patient Record + DRG KPI Performance

Patient Record + DRG KPI Performance
Patient Record + DRG KPI PerformancePatient Record + DRG KPI Performance
Visualize the overall performance of any of your Patient Record + DRG KPIs: what is the performance, how does this performance evolve, who contributes to this performance

GeoAnalytics

Patient Record + DRG Country Analysis

Patient Record + DRG Country Analysis
Patient Record + DRG Country AnalysisPatient Record + DRG Country Analysis
Visualize the performance of any of your Patient Record + DRG KPIs, at Country level

Patient Record + DRG City Analysis

Patient Record + DRG City Analysis
Patient Record + DRG City AnalysisPatient Record + DRG City Analysis
Visualize the performance of any of your Patient Record + DRG KPIs, at City level

Trends Analytics

Patient Record + DRG Trends Analysis

Patient Record + DRG Trends Analysis
Patient Record + DRG Trends AnalysisPatient Record + DRG Trends Analysis
Visualize the evolution of any of your Patient Record + DRG KPIs: Trends, Performance & Year over Year

Distribution Analytics

Patient Record + DRG Segmentation Analysis

Patient Record + DRG Segmentation Analysis
Patient Record + DRG Segmentation AnalysisPatient Record + DRG Segmentation Analysis
Visualize the value of any of your Patient Record + DRG KPIs, split by the dimension you selected (market share analysis)

Patient Record + DRG Pareto Analysis

Patient Record + DRG Pareto Analysis
Patient Record + DRG Pareto AnalysisPatient Record + DRG Pareto Analysis
Perform a Pareto Analysis on any of your Patient Record + DRG KPIs: the 80/20 rule.

Creating your PATIENT RECORD + DRG dashboard Step-by-Step

You want to get a clear understanding on your Patient Record + DRG results? You want to build a Tableau dashboard to better understand your Patient Record + DRG data?

Using LinPack-for-Tableau.com, you can generate an eye-catching, fit-for-purpose Tableau Dashboard on your Patient Record + DRG data in less than 5 minutes!

1st STEP: Create the initial Tableau workbook file

Create a Tableau workbook in which you map your Patient Record + DRG data (whether it comes from: ERP, database, Excel, CSV file...)

You must retrieve at least the following attributes (it is ok if the names don't match, and it is better to add additional attributes to analyze):

  • string
    Facility Facility, Clinic, Hospital, Department, Site...
  • string
    Stay # Stay Unique Identifier
  • string
    Stay Type Stay Type: Inpatient, Outpatient
  • string
    Inpatient Flag "Y" if Inpatient
  • string
    Patient # Patient Unique Identifier
  • string
    Specialty Medical Specialty
  • string
    Service Service
  • string
    Doctor Doctor
  • string
    Main Diagnosis Main Medical Diagnosis
  • string
    Main Treatment Main Treatment
  • date
    Admission Date Date when the patient was admitted
  • date
    Discharge Date Date when the patient was discharged (Date used for time-series analysis)
  • date
    Birth Date Patient Birth Date
  • string
    Gender Patient gender: Male, Female
  • string
    Patient Country Patient Country
  • string
    Patient City Patient City
  • string
    Admission Mode Admission Mode
  • string
    Admission - Emergency Flag "Y" is the admission was an emergency
  • string
    Discharge Mode Discharge Mode
  • string
    Discharge - Decease Flag "Y" is the discharge as due to a decease
  • numeric
    LOS (days) - Length of Stay Length of Stay according to DRG rules (in days)
  • numeric
    DRG - LOS Benchmark (optional attribute) LOS which is used as a reference to measure the performance of actual LOS (region average LOS for instance)
  • string
    DRG Code - Diagnosis Related Group Code of the Diagnosis Related Group
  • string
    DRG Status "Low Outliers", "Low Inliers", "High Inliers", "High Outliers"
  • numeric
    DRG Cost-Weight Actual Cost-Weight for the Stay

2nd STEP: Upload your Tableau workbook file

On LinPack-for-Tableau.com, select 'create dashboard from template: Patient Record + DRG' and upload your Tableau workbook (note: your data is NOT uploaded).

3rd STEP: Map your attributes

Map the attributes of your workbook on the attributes of the template.

Finally, click 'Confirm & Download'... and your Patient Record + DRG dashboard is already downloading :-)

Open the Tableau workbook file you received, it will automatically reconnect to your data sources.

Your Patient Record + DRG dashboard is now ready to be used or customized!


Other DataViz Packs