
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)
- Visits
- Visits per day
- Centers
- Visits per Center
- Time: In-Center
- Time: In-Center (Scheduled)
- Time: Wait Room
- Time: Wait Room %
- Time: Patient Wait
- Time: Patient Wait %
- Time: Exam Duration
- Time: Exam Duration %
- Visits: Late Check-in
- Visits: Late Check-in %
- Visits: In-advance (15+ min early)
- Visits: In-advance (15+ min early) %
- Visits: On-time (less than 15 min late)
- Visits: On-time (less than 15 min late) %
- Visits: Late (15+ min late)
- Visits: Late (15+ min late) %
- Visits: Late (30+ min late)
- Visits: Late (30+ min late) %
- Visits: Late (60+ min late)
- Visits: Late (60+ min late) %
- Actual vs Scheduled: Appointment Start
- Actual vs Scheduled: Exam End
- Actual vs Scheduled: In-Center Time
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
Cockpit
Visits - Wait Time Cockpit
Visits - Wait Time Top Performers
Behavioral Analytics
Visits - Wait Time Adhoc Analysis
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):
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).
3rd STEP: Map your attributes
Map the attributes of your workbook on the attributes of the template.
Finally, click 'Confirm & Download'... and your Visits - Wait Time dashboard is already downloading :-)
Open the Tableau workbook file you received, it will automatically reconnect to your data sources.
Your Visits - Wait Time dashboard is now ready to be used or customized!