Indzara

Category: HR

Recruitment Tracker 2024 – Free Recruitment Template in Power BI

Recruitment Tracker 2024 – Free Recruitment Template in Power BI

Your search for a simple and effective solution to manage your recruiting process ends here! Get key recruiting metrics and an amazing, fully interactive dashboard in Power BI with this template. Track status of applicants, view key recruiting metrics like the number of open positions, Conversion %, Hiring cost, to name a few, all in […]

Calculating Diversity Percentage % in Excel

Calculating Diversity Percentage % in Excel

The value of diversity in employees has been recognized and appreciated more in recent times. Diversity in all aspects is good for a company. In this article, I will explain how you can calculate a Diversity Percentage % KPI for your company. I will use Racial Diversity in my example below. However, this concept can […]

Calculating Average Employee Tenure in Excel

Calculating Average Employee Tenure in Excel HR KPI Avg. tenure

In this article, we will calculate a common HR KPI – Average Employee Tenure, using simple formulas in Excel. Data Let’s assume the dataset has a list of employees with a Status column to indicate Active vs Inactive employees. The table is converted to an Excel Table with name T_EMP Definition Tenure is the time […]

Employee Retention Dashboard Google Sheet Template – User Guide

In this article, we will explain step by step how to use the Retention Dashboard Google Sheet Template. To learn more about the features of the template and to download, please visit the Product page. OVERVIEW OF STEPS Enter data in Employees Data sheet Refresh Calculations View/Interact with 3 Dashboards STEP 1: ENTER DATA IN […]