HR Analytics Dashboard

(Data Visualization, Dashboarding)

Daelson Mangrobang
2 min readJul 20, 2024

Problem Statement

“For this requirement, you have been asked in your company to build a dashboard in Power BI considering the following challenges of HR people and provide an effective way to find the answers to their day-to-day questions.”

Data

Data Cleaning

  • Import dataset
  • Set appropriate data types per column

Relationships

Measures

Actives = CALCULATE([EmpCount], FILTER(Employee, ISBLANK(Employee[TermDate]))) 
// total active employees

AVG Tenure Days = AVERAGE(Employee[TenureDays])

AVG Tenure Months = ROUND([AVG Tenure Days]/30, 1)-1

EmpCount = CALCULATE(COUNT(Employee[EmplID]), FILTER(ALL('Date'[PeriodNumber]), 'Date'[PeriodNumber]=MAX('Date'[PeriodNumber])))

Female Actives = CALCULATE([Actives], Gender[Gender]="Female")

Female New Hires = CALCULATE([New Hires], Gender[Gender]="Female")

Female Separations = CALCULATE([Separations], Gender[Gender]="Female")

Male Actives = CALCULATE([Actives], Gender[Gender]="Male")

Male New Hires = CALCULATE([New Hires], Gender[Gender]="Male")

Male Separations = CALCULATE([Separations], Gender[Gender]="Male")

Separations = CALCULATE(COUNT(Employee[EmplID]), FILTER(Employee, NOT(ISBLANK(Employee[TermDate]))))
// separations or employees who left

Link: https://github.com/dvmangrobang/HR-Analytics-Dashboard

(This is the final project of the online course: “Data Storytelling with PowerBI” by Edureka on Coursera)

--

--

No responses yet