The Power BI Template has 13 metrics calculated and ready for use.
Availability %
- % of Total Capacity that is actually available. Calculated as (Available Capacity Man Days / Total Capacity Man days)
Total Capacity (Man Days)
- Total # of Man Days of capacity during the date range selected. For example, in a week of 5 working days (excluding weekends and holidays) where 10 employees are employed, the total capacity is 10*5 = 50 Man days.
Leave (Man Days)
- Total # of Man Days of leave planned/taken during the date range selected. For example, in a week of 5 working days (excluding weekends and holidays) where 2 employees are taking leave every day, the total Leave Man days is 5*2 = 10.
Available Capacity (Man Days)
- Total # of Man Days of Capacity Available to use during the date range selected. For example, in a week of 5 working days with 10 employees, with 2 employees taking leave every day, Total capacity is 5*10 = 50, Leave is 5*2 = 10 and hence Available capacity is 50 - 10 = 40 Man Days.
Employees on Leave
- Distinct count of Employees who are on leave on working days during date range selected.
Starting Headcount
- Active Employee Count at the Beginning of the date range selected.
Ending Headcount
- Active Employee Count at the End of the date range. If no date filters are applied, this will be the latest active employee count.
Average Headcount
- Average Headcount during the date range selected. (Starting Headcount + Ending Headcount)/2
Calendar Days
- Number of Calendar days during the date range selected.
Working days
- Number of Working Days during the date range selected. Number of Calendar days excluding days which are either weekend and/or holidays.
Non-Working Days
- Number of non-working days (holidays and weekends) during the date range selected
Weekend Days
- Number of days that fall in the weekend days during the date range selected. Weekend days are selected in the Weekend table according to company policies.
Holidays
- Number of Holidays during the date range selected.