Business dashboard template: MEDICAL STAYS

/uploads/galerie/000163/PS Cockpit W.PNG

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 KPIs Breakdown

Get a transverse view on your top 6 Medical Stays KPIs, split by the dimension of your choice

Medical Stays Top KPIs Trends

Visualize how your Medical Stays KPIs are evolving (Month-to-Date, Year-to-Date)

8 required attributes

Facility
Stay #
Stay Type
Patient #
Specialty
Admission Date
Discharge Date
Cost-Weight

8 KPIs

13 dashboard pages

Detailed presentation of the MEDICAL STAYS dashboard

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

and 13 dashboard 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 KPIs Breakdown

Get a transverse view on your top 6 Medical Stays KPIs, split by the dimension of your choice

Medical Stays Top KPIs Trends

Visualize how your Medical Stays KPIs are evolving (Month-to-Date, 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

Patients Analytics

Inpatients / Outpatients

Analyze the evolution of inpatients/outpatients KPIs

Behavioral Analytics

Medical Stays Seasonality Analysis

Quickly identify seasonality patterns in your Medical Stays dashboard. You can select any KPI you like, across multiple time level of details.

Medical Stays KPI Performance

Visualize the overall performance of any of your Medical Stays KPIs: what is the performance, how does this performance evolve, who contributes to this performance

Trends Analytics

Medical Stays Trends Analysis

Visualize the evolution of any of your Medical Stays KPIs: Trends, Performance & Year over Year

Distribution Analytics

Medical Stays Segmentation Analysis

Visualize the value of any of your Medical Stays KPIs, split by the dimension you selected (market share analysis)

Medical Stays Pareto Analysis

Perform a Pareto Analysis on any of your Medical Stays KPIs: the 80/20 rule.

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