/uploads/galerie/000186/PR Cockpit W.PNG /uploads/galerie/000186/PR Cockpit D.PNG

Detailed presentation of the PATIENT RECORD dashboard

Your PATIENT RECORD dashboard will contain 29 KPIs

and 20 dashboard pages

Home

Patient Record Home

Patient Record Home
Patient Record HomePatient Record Home
Get a Home Page for your Patient Record 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 Top KPIs Overview

Patient Record Top KPIs Overview
Patient Record Top KPIs OverviewPatient Record Top KPIs Overview
Get a transversal view on your top 6 Patient Record KPIs, split by the dimension of your choice

Patient Record Top KPIs Evolution

Patient Record Top KPIs Evolution
Patient Record Top KPIs EvolutionPatient Record Top KPIs Evolution
Visualize how your Patient Record KPIs are evolving (Month-to-Date, Year-to-Date)

Patients Analytics

Inpatients / Outpatients

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

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...

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 and Discharges

Admissions and Discharges
Admissions and DischargesAdmissions and Discharges
Visualize when patients are admitted and 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...

Specialty Analysis (PR)

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

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

GeoAnalytics

Patient Record Country Analysis

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

Patient Record City Analysis

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

Behavioral Analytics

Patient Record Seasonality Analysis

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

Trends Analytics

Patient Record Trends Analysis

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

Distribution Analytics

Patient Record Segmentation Analysis

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

Patient Record Pareto Analysis

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

Patient Record KPI Performance

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

Creating your PATIENT RECORD dashboard Step-by-Step

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

Using LinPack-for-Tableau.com, you can generate an eye-catching, fit-for-purpose Tableau Dashboard on your Patient Record 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 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' 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 dashboard is already downloading :-)

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

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


Other #DataViz Packs