Providea workbookcontaining at least8 attributes
Geta ready-to-use,best-in-marketMEDICAL STAYS dashboard
Medical Stays Home
Medical Stays Home![Medical Stays Home]()
Get a Home Page for your Medical Stays dashboard
Cockpit
Cockpit![Cockpit]()
Get an overview of your KPIs around Patient stays
Medical Stays Top KPIs Overview
Medical Stays Top KPIs Overview![Medical Stays Top KPIs Overview]()
Get a transversal view on your top 6 Medical Stays KPIs, split by the dimension of your choice
Medical Stays Top KPIs Evolution
Medical Stays Top KPIs Evolution![Medical Stays Top KPIs Evolution]()
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
- Medical Stays Home
- Cockpit
- Medical Stays Top KPIs Overview
- Medical Stays Top KPIs Evolution
- Inpatients / Outpatients
- Admissions and Discharges
- Stays - Cost-Weight
- Specialty Analysis
- Medical Stays Seasonality Analysis
- Medical Stays Trends Analysis
- Medical Stays Segmentation Analysis
- Medical Stays Pareto Analysis
- Medical Stays KPI Performance
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
- Length of Stay (days)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
Medical Stays Home![Medical Stays Home]()
Get a Home Page for your Medical Stays dashboard
Cockpit
Cockpit
Cockpit![Cockpit]()
Get an overview of your KPIs around Patient stays
Medical Stays Top KPIs Overview
Medical Stays Top KPIs Overview![Medical Stays Top KPIs Overview]()
Get a transversal view on your top 6 Medical Stays KPIs, split by the dimension of your choice
Medical Stays Top KPIs Evolution
Medical Stays Top KPIs Evolution![Medical Stays Top KPIs Evolution]()
Visualize how your Medical Stays KPIs are evolving (Month-to-Date, Year-to-Date)
Patients Analysis
Inpatients / Outpatients
Inpatients / Outpatients![Inpatients / Outpatients]()
Analyze the evolution of inpatients/outpatients KPIs
Stays Analysis
Admissions and Discharges
Admissions and Discharges![Admissions and Discharges]()
Visualize when patients are admitted and discharged during the day
Stays - Cost-Weight
Stays - Cost-Weight![Stays - Cost-Weight]()
Visualize the Cost-Weight per medical specialty
Specialty Analysis
Specialty Analysis![Specialty Analysis]()
Visualize the impact of each medical specialty
Behavioral Analytics
Medical Stays Seasonality Analysis
Medical Stays Seasonality Analysis![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.
Trends Analysis
Medical Stays Trends Analysis
Medical Stays Trends Analysis![Medical Stays Trends Analysis]()
Visualize the evolution of any of your Medical Stays KPIs: Trends, Performance & Year over Year
Distribution Analysis
Medical Stays Segmentation Analysis
Medical Stays Segmentation Analysis![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
Medical Stays Pareto Analysis![Medical Stays Pareto Analysis]()
Perform a Pareto Analysis on any of your Medical Stays KPIs: the 80/20 rule.
Medical Stays KPI Performance
Medical Stays KPI Performance![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
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!
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).
Dashboard Template
- Predefined (and customizable) KPIs
- Predefined DataViz
Finance
Procurement
Digital Marketing
Processes
Case Management
Banking
Healthcare
Telecommunications
Fundraising
Insurance
3rd STEP: Map your attributes
Map the attributes of your workbook on the attributes of the template.
Finally, click 'Confirm & Download'... and your Medical Stays dashboard is already downloading :-)
Open the Tableau workbook file you received, it will automatically reconnect to your data sources.
Your Medical Stays dashboard is now ready to be used or customized!
Just give it a try here :-)
