This simple dashboard provides information about a company’s human resources. The database is in csv format and was downloaded from Kaggle.com. All performance indicators were created with the DAX language.
DAX Code
% due = DIVIDE([Promotion], [Total Empoyés], 0) --promotions in %
% female = DIVIDE([Female],[Total Empoyés],0) --total females in %
% male = DIVIDE([Male],[Total Empoyés],0) --total males in %
% not due = DIVIDE([Not due for promotion], [Total Empoyés], 0) --not due for promotion in %
% on service = DIVIDE([On service],[Total Empoyés],0) --on service in %
% retraite = DIVIDE([Retraite],[Total Empoyés],0) --leaving this year
Female = CALCULATE([Total Empoyés], 'HR Analytics Data'[Gender] = "female") --total females
Male = CALCULATE([Total Empoyés], 'HR Analytics Data'[Gender] = "male") --total males
Not due for promotion = CALCULATE([Total Empoyés], 'HR Analytics Data'[Promotion Status] = "Not due") --no promotion this year
On service =
IF(
ISBLANK(
CALCULATE([Total Empoyés], 'HR Analytics Data'[Retraite]="En service")),
0,
CALCULATE([Total Empoyés], 'HR Analytics Data'[Retraite]="En service"))
Promotion = CALCULATE([Total Empoyés], 'HR Analytics Data'[Promotion Status] = "Due for promotion")
Retraite = --column for retirements
IF(
ISBLANK(
CALCULATE([Total Empoyés], 'HR Analytics Data'[Retraite]="Doit partir en retraite")),
0,
CALCULATE([Total Empoyés], 'HR Analytics Data'[Retraite]="Doit partir en retraite"))
Total Empoyes = COUNTROWS('HR Analytics Data') --total employees
