Appointment
The data model encompasses insights into scheduled appointments, including date, time, and participants. It tracks metrics such as the average duration of appointments, the percentage of successful outcomes (Appointment Conversion Rate), the rate of clients not showing up (No-show Rate), the distribution of appointment types (Appointment Type Distribution), and the average client wait time before appointments.
Benefits of This Data Model
- Improved Appointment Scheduling: Enhances the ability to schedule appointments efficiently based on insights into date, time, and participants.
- Enhanced Decision-Making: Provides valuable metrics such as appointment conversion rate, no-show rate, and appointment type distribution to support data-driven decision-making.
- Optimized Resource Allocation: Helps in optimizing resource allocation by analyzing the average duration of appointments and average client wait time before appointments.
Key Performance Indicators (KPIs)
- Total Appointments: counts the total number of appointments made.
- Average Duration: calculates the average duration of appointments.
- Appointment Conversion Rate: measures the percentage of appointments that result in a successful outcome.
- No-show Rate: calculates the percentage of appointments where the client did not show up.
- Appointment Type Distribution: displays the distribution of different types of appointments.
- Average Wait Time: calculates the average time clients have to wait before their appointments.
Available Visualisations
| View Name | Description |
|---|---|
| Appointment | Provides insights on all scheduled appointments, including date, time, and participants. |