Skip to content

Latest commit

 

History

3 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 

Repository files navigation

👥 HR Analytics Dashboard (Power BI Project)

📌 Project Purpose A complete HR analytics dashboard built in Power BI to track employee hiring, terminations, demographics, and workforce distribution. The project provides HR managers with insights into workforce composition, hiring trends, and departmental performance for data-driven decision-making.

🛠️ Tech Stack

  • Power BI Desktop
  • Power Query (M) for cleaning HR data
  • DAX (Data Analysis Expressions) for measures
  • Excel (HR Dataset)

📊 Data Source

  • Format: .xlsx
  • Records: ~1,000 employees
  • Fields include: Employee ID, Gender, Age, Education, Department, Job Role, Status (Hired/Terminated), etc.
  • Source: Simulated HR dataset

Features & Highlights

🧩 5.1.1 Business Problem The HR team wants to analyze workforce demographics, monitor hiring vs. termination rates, and identify job roles/departments with high employee turnover.

🎯 5.1.2 Dashboard Goals

  • Provide an overview of workforce composition (gender, age, education).
  • Compare hires vs. terminations across time and departments.
  • Identify top job roles with maximum hiring/turnover.
  • Support HR in making better talent management and retention decisions.

📊 5.1.3 Key Visuals

  • KPI Cards: Total Employees, Hired, Terminated
  • Donut Charts: Gender Distribution
  • Stacked Bar Charts: Age Group Distribution, Education Levels
  • Line Chart: Hiring & Termination Trend Over Time
  • Table: Hired vs. Terminated by Department
  • Bar Chart: Top 5 Job Roles by Hiring & Termination

💼 5.1.4 Business Impact & Insights

  • Workforce is almost evenly split across gender.
  • Most employees are in the 26–45 age range, showing a mid-career workforce.
  • Undergraduates form the majority of the workforce, followed by High School graduates.
  • Technology department has the highest hires & terminations → indicates growth but also potential retention issues.
  • Software Engineer role has the largest number of hires and terminations → highlights high demand and turnover.

🖼️ Dashboard Preview

🖼️Here is the link: View Full Dashboard Image

📎 Extras

  • Interactive slicers (can be added for gender, department, or job role).
  • Clean and modern layout with branded theme colors.
  • DAX measures for calculating dynamic KPIs.
  • Drill-down capability for department-level analysis.

About

No description, website, or topics provided.

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors