Business dashboard template: MEDICAL STAYS

dashboard template for tableau on Healthcare Stays & Patients Medical Stays cockpit

Providea workbookcontaining at least8 attributes

Geta ready-to-use,best-in-marketMEDICAL STAYS dashboard

Medical Stays Home

Get a Home Page for your Medical Stays dashboard

Cockpit

Get an overview of your KPIs around Patient stays

Medical Stays Top Performers

Get an instant understanding of your top Medical Stays performers: current, mid and long term performance

Admissions and Discharges

Visualize when patients are admitted and discharged during the day

8 required attributes

Facility
Stay #
Stay Type
Patient #
Specialty
Admission Date
Discharge Date
Cost-Weight
...add your own attributes!

8 KPIs

8 dashboard pages

Required Attributes

To get your Medical Stays dashboard, you need to provide a Tableau workbook file with (at least) the following 5 attributes (the name of your attributes can differ):

Facility Facility, Clinic, Hospital, Department...
Stay # Stay Unique Identifier
Stay Type Stay Type: Inpatient, Outpatient
Patient # Patient Unique Identifier
Specialty Medical Specialty
Admission Date Date when the patient was admitted
Discharge Date Date when the patient was discharged (Date used for time-series analysis)
Cost-Weight Actual Cost-Weight for the Stay

KPIs

Your Medical Stays dashboard will contain 8 KPIs

Nb of StaysTotal number of stays
Nb of Inpatient StaysTotal number of inpatient stays
Inpatient Stays %Share of inpatient stays
LOS (Length of Stay)Average number of days between Admission and Discharge Date
Nb of PatientsTotal number of patients
Stays per PatientAverage number of Stays per Patient
Cost-Weight per StayAverage Cost-Weight per stay
Total Cost-WeightTotal Cost-Weight for all patient stays

Dashboard Pages & Data Visualizations

Your Medical Stays dashboard will contain 8 pages

Home

Medical Stays Home

Get a Home Page for your Medical Stays dashboard

Cockpit

Get an overview of your KPIs around Patient stays

Medical Stays Top Performers

Get an instant understanding of your top Medical Stays performers: current, mid and long term performance

Top 4 KPIs Trends (MTD/YTD)

Visualize how your Performance is evolving (Month-to-Date and Year-to-Date)

Stays Analytics

Admissions and Discharges

Visualize when patients are admitted and discharged during the day

Stays - Cost-Weight

Visualize the Cost-Weight per medical specialty

Specialty Analysis

Visualize the impact of each medical specialty on Total Cost Weight

Behavioral Analytics

Medical Stays Adhoc Analysis

Perform simple ad-hoc analysis on your Medical Stays data set: analyze any of your KPIs across any dimension (trends, distribution and pareto analysis)

Creating your MEDICAL STAYS dashboard Step-by-Step

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

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

Medical Stays dashboard Live Demo

1st STEP: Create the initial Tableau workbook file

Create a Tableau workbook in which you map your Medical Stays 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):

Facility Facility, Clinic, Hospital, Department...
Stay # Stay Unique Identifier
Stay Type Stay Type: Inpatient, Outpatient
Patient # Patient Unique Identifier
Specialty Medical Specialty
Admission Date Date when the patient was admitted
Discharge Date Date when the patient was discharged (Date used for time-series analysis)
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: Medical Stays' and upload your Tableau workbook (note: your data is NOT uploaded).

Collapse All Expand All