LinPack-for-Tableau - Business dashboard template: VISITS

/uploads/galerie/000279/Visits - Wait Time Cockpit.PNG

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

Get a transversal view on your top 6 Visits - Wait Time KPIs, split by the dimension of your choice

Visits - Wait Time Top KPIs Trends

Visualize how your Visits - Wait Time KPIs are evolving (Month-to-Date, Year-to-Date)

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)

10 dashboard pages

Detailed presentation of the VISITS - WAIT TIME dashboard

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

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

Get a transversal view on your top 6 Visits - Wait Time KPIs, split by the dimension of your choice

Visits - Wait Time Top KPIs Trends

Visualize how your Visits - Wait Time KPIs are evolving (Month-to-Date, Year-to-Date)

Visits - Wait Time Performance Cockpit

Visualize the performance on your top 4 Visits - Wait Time KPIs, how this performance evolves over time and who contributes to this performance

Visits - Wait Time Top Contributors (6 KPIs)

Instant overview of your Visits - Wait Time top 6 KPIs split by the dimension you selected.

Behavioral Analytics

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.

Trends Analytics

Visits - Wait Time Trends Analysis

Visualize the evolution of any of your Visits - Wait Time KPIs: Trends, Performance & Year over Year

Distribution Analytics

Visits - Wait Time Segmentation Analysis

Visualize the value of any of your Visits - Wait Time KPIs, split by the dimension you selected (market share analysis)

Visits - Wait Time Pareto Analysis

Perform a Pareto Analysis on any of your Visits - Wait Time KPIs: the 80/20 rule.

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!

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