LinPack-for-Tableau - Business dashboard template: VISITS

dashboard template for tableau on Healthcare Medical Visits Visits - Wait Time cockpit

Providea workbookcontaining at least9 attributes

Geta ready-to-use,best-in-marketVISITS - WAIT TIME dashboard

Visits - Wait Time Home

Get a Home Page for your Visits - Wait Time dashboard

Visits - Wait Time Cockpit

Get a clear overview of the medical visits process in your centers.

Visits - Wait Time Top Performers

Get an instant understanding of your top Visits - Wait Time performers: current, mid and long term performance

Visits - Wait Time Adhoc Analysis

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

9 required attributes

Visit #
Center / Service
Procedure
Scheduled Appointment (date-time)
Scheduled In-Center Time (in min)
Check-in (date-time)
Arrival for examination (date-time)
Exam Start (date-time)
Exam End (date-time)

6 dashboard pages

Required Attributes

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

Visit # Unique identifier for each visit
Center / Service Center or Service to which the visit was done
Procedure Purpose of the visit - Medical procedure
Scheduled Appointment (date-time) Date and time when the appointment was scheduled (Date used for time-series analysis)
Scheduled In-Center Time (in min) Schedule duration of the entire procedure (in minutes)
Check-in (date-time) Date and time when the patient checked-in
Arrival for examination (date-time) Date and time when the patient arrived for examination
Exam Start (date-time) Date and time when the exam actually started
Exam End (date-time) Date and time when the exam actually ended

KPIs

Your VISITS - WAIT TIME dashboard will contain 27 KPIs

VisitsTotal number of visits
Visits per dayNumber of daily visits
CentersTotal number of center
Visits per CenterAverage number of visits per center
Time: In-CenterAverage number of minutes between check-in and exam end
Time: In-Center (Scheduled)Average in-center duration time in minutes
Time: Wait RoomAverage number of minutes between check-in and arrival for examination
Time: Wait Room %Share of wait room time on total in-center time
Time: Patient WaitAverage number of minutes between arrival for examination and exam start
Time: Patient Wait %Share of wait room time on total in-center time
Time: Exam DurationAverage number of minutes between exam start and end
Time: Exam Duration %Share of examination time on total in-center time
Visits: Late Check-inTotal number of visits for which the check-in was done after the appointment time
Visits: Late Check-in %Share of visits with late check-in
Visits: In-advance (15+ min early)Total number of visits when the exam end was at least 15 minutes earlier than scheduled
Visits: In-advance (15+ min early) %Share of visits for which the exam was finished in advance (more than 15 minutes earlier than scheduled)
Visits: On-time (less than 15 min late)Total number of visits when the exam end was within 15 minutes compared to schedule
Visits: On-time (less than 15 min late) %Share of visits for which the exam was finished on-time (less than 15 minutes late than scheduled)
Visits: Late (15+ min late)Total number of visits when the exam end was more then 15 minutes late compared to schedule
Visits: Late (15+ min late) %Share of visits for which the exam was finished late (more than 15 minutes late than scheduled)
Visits: Late (30+ min late)Total number of visits when the exam end was more then 30 minutes late compared to schedule
Visits: Late (30+ min late) %Share of visits for which the exam was finished late (more than 30 minutes late than scheduled)
Visits: Late (60+ min late)Total number of visits when the exam end was more then 60 minutes late compared to schedule
Visits: Late (60+ min late) %Share of visits for which the exam was finished late (more than 60 minutes late than scheduled)
Actual vs Scheduled: Appointment StartAverage number of minutes between scheduled appointment and check-in
Actual vs Scheduled: Exam EndAverage number of minutes between actual and scheduled exam end date
Actual vs Scheduled: In-Center TimeAverage difference in minutes between actual and scheduled in-center time

Dashboard Pages & Data Visualizations

Your Visits - Wait Time dashboard will contain 6 pages

Home

Visits - Wait Time Home

Get a Home Page for your Visits - Wait Time dashboard

Cockpit

Visits - Wait Time Cockpit

Get a clear overview of the medical visits process in your centers.

Visits - Wait Time Top Performers

Get an instant understanding of your top Visits - Wait Time 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)

Behavioral Analytics

Visits - Wait Time Adhoc Analysis

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

Visits - Wait Time Seasonality Analysis

Quickly identify seasonality patterns in your Visits - Wait Time dashboard. You can select any KPI you like, across multiple time level of details.

Creating your VISITS - WAIT TIME dashboard Step-by-Step

You want to get a clear understanding on your Visits - Wait Time results? You want to build a Tableau dashboard to better understand your Visits - Wait Time data?

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

Visits - Wait Time dashboard Live Demo

1st STEP: Create the initial Tableau workbook file

Create a Tableau workbook in which you map your Visits - Wait Time 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):

Visit # Unique identifier for each visit
Center / Service Center or Service to which the visit was done
Procedure Purpose of the visit - Medical procedure
Scheduled Appointment (date-time) Date and time when the appointment was scheduled (Date used for time-series analysis)
Scheduled In-Center Time (in min) Schedule duration of the entire procedure (in minutes)
Check-in (date-time) Date and time when the patient checked-in
Arrival for examination (date-time) Date and time when the patient arrived for examination
Exam Start (date-time) Date and time when the exam actually started
Exam End (date-time) Date and time when the exam actually ended

2nd STEP: Upload your Tableau workbook file

On LinPack-for-Tableau.com, select 'create dashboard from template: Visits - Wait Time' and upload your Tableau workbook (note: your data is NOT uploaded).

Collapse All Expand All