Leave Transactions
The data model encompasses detailed insights on employee leave usage, including the total leave taken, leave days taken this year and last year, balance carried forward, balance brought forward, year-to-date balance carried forward, leave entitlement, planned leave days, leave days taken this and last year, leave days allocated this and last year, leave usage rate this and last year, and the variance in leave usage rate between the current and previous years. The model provides a comprehensive analysis of leave utilization across different organizational hierarchies, employees' planned leave units, and total leave taken.
Benefits of This Data Model
- Enhanced Leave Utilization Insights: The data model provides detailed analysis on employee leave usage, including total leave taken, leave days taken this year and last year, balance carried forward, and balance brought forward. This allows for a comprehensive understanding of leave utilization trends.
- Efficient Organizational Hierarchy Analysis: With views such as "Leave Taken By Hierarchy", the model enables a deep dive into leave usage based on different organizational levels. This helps in identifying patterns and trends within the company structure.
- Improved Leave Planning: By showcasing planned leave units for each employee through the "Planned Leave Units By Employee" view, the data model facilitates better leave management and planning. This feature can contribute to more efficient workforce scheduling and resource allocation.
Key Performance Indicators (KPIs)
- Leave Taken: The total number of leave days taken by employees.
- Leave TY Taken: The total number of leave days taken this year.
- Leave LY Taken: The total number of leave days taken last year.
- Balance Carried Forward: The remaining balance of leave days from the previous period.
- Balance Brought Forward: The balance of leave days brought forward to the current period.
- Balance Carried Forward YTD: The year-to-date balance of leave days carried forward.
- Leave Entitlement: The total number of leave days an employee is entitled to.
- Leave Planned Days: The total number of leave days planned by employees.
- Leave Days taken TY: The total number of leave days taken this year.
- Leave Allocated TY: The total number of leave days allocated for this year.
- Leave Usage Rate TY: The rate at which leave days are being used this year.
- Leave Days taken LY: The total number of leave days taken last year.
- Leave Allocated LY: The total number of leave days allocated last year.
- Leave Usage Rate LY: The rate at which leave days were used last year.
- Leave Usage Rate Variance: The variance in leave usage rate between the current and previous years.
Available Visualisations
| View Name | Description |
|---|---|
| Leave Detail Report | Provides detailed information on employees' leave usage |
| Leave Taken By Hierarchy | Analyzes leave taken based on organizational hierarchy |
| Total Leave Taken | Calculates the total number of leave days taken |
| Planned Leave Units By Employee | Shows planned leave units for each employee |