Monthly Leave Variance (TY vs LY)
The data model utilizes views such as Leave Trend, Leave YoY Variances, and Leave Trend YTD vs LYTD to analyze leave patterns and year-over-year comparisons. Measures like Termination Rate and Balance Carried Forward provide insights into termination trends and leave balances. With a focus on leave liabilities and workforce management, the model incorporates metrics like Leave Liability Change (MoM) and Leave Taken Change (MoM) to facilitate financial planning and optimize resource allocation.
Benefits of This Data Model
- Enhanced Leave Pattern Analysis: The data model allows for in-depth tracking and analysis of monthly leave trends through views like Leave Trend, enabling better understanding of patterns and seasonality.
- Improved Year-over-Year Comparisons: Utilizing views such as Leave YoY Variances, the model facilitates easy comparison of leave data between different years, aiding in identifying trends and anomalies for strategic decision-making.
- Optimized Workforce Management: By incorporating metrics like Leave Liability Change (MoM) and Leave Taken Change (MoM), the model assists in financial planning and resource allocation optimization by monitoring changes in leave liabilities and leave taken on a month-over-month basis.
Key Performance Indicators (KPIs)
- Leave Days Taken YTD: The total number of leave days taken year-to-date.
- Leave Days Taken LYTD: The total number of leave days taken last year-to-date.
- Leave Days Taken YoY Variance %: The percentage variance between leave days taken this year versus last year.
- Leave Days Taken YTD Previous Month: The total number of leave days taken year-to-date in the previous month.
- Leave Days Taken LYTD Previous Month: The total number of leave days taken last year-to-date in the previous month.
- Leave Days Taken TY MoM Variance (%): The percentage variance in leave days taken this year month-over-month.
- Leave Days Taken LY MoM Variance (%): The percentage variance in leave days taken last year month-over-month.
- Leave PrevTaken: The previous leave taken.
- Leave Avg YTD: The average number of leave days taken year-to-date.
- Termination Rate: The rate at which terminations occur.
- Balance Carried Forward: The remaining balance of leave carried forward from previous periods.
- Balance Carried Forward YTD: The balance of leave carried forward year-to-date.
- Balance Carried Forward LYTD: The balance of leave carried forward last year-to-date.
- Balance Carried Forward YTD Previous M: The balance of leave carried forward year-to-date in the previous month.
- Balance Carried Forward LYTD Previous M: The balance of leave carried forward last year-to-date in the previous month.
- Termination Payout YTD: The total termination payouts year-to-date.
- Termination Payout LYTD: The total termination payouts last year-to-date.
- Termination Payout YTD Previous Month: The total termination payouts year-to-date in the previous month.
- Termination Payout LYTD Previous Month: The total termination payouts last year-to-date in the previous month.
- Termination Payout TY MoM: The termination payout month-over-month.
Available Visualisations
| View Name | Description |
|---|---|
| Leave Trend | Tracks monthly leave trends to analyze patterns and seasonality. |
| Leave YoY Variances | Compares year-over-year leave data for identifying trends and deviations. |
| Leave Trend YTD vs LYTD | Contrasts year-to-date leave trends to previous year-to-date for insights. |
| Leave Liability Change (MoM) | Captures month-over-month changes in leave liabilities for financial planning. |
| Leave Provision by Department | Breaks down leave provision data by department to optimize resource allocation. |
| Leave Taken Change (MoM) | Monitors month-over-month changes in leave taken for workforce management. |
| Leave Liability Trend (Monthly) | Analyzes monthly trends in leave liabilities for budget forecasting. |
| Average Leave Trend by Hierarchy | Shows average leave trends by hierarchy levels for HR planning. |