←   Back to Home

POWER BI PROJECT

HR Analytics Dashboard

Employee, Department & Workforce Analysis

Power BI Data Analysis Dashboard Design HR Analytics SQL

Power BI Dashboard

HR Dashboard
Overview Dashboard
HR Dashboard
Department Analysis
HR Dashboard
Employee Analysis 1
HR Dashboard
Employee Analysis 2

Project Overview

This HR Analytics Dashboard provides an interactive view of employee information, workforce structure, departmental distribution, payroll, promotion status, retirement status, and employee service years.

The dashboard is designed to help analyze workforce characteristics and provide a clear overview of employee demographics, organizational levels, department distribution, working shifts, payroll, and employee status.

Dataset

HR Employee Dataset

The dashboard analyzes employee-level HR information including department, employee name, age, shift, organization level, payroll, salary per day, sick leave, service years, employee status, and hiring information.

Dimension Tables

  • Hr_Shift
  • HR_Department
  • Employee_Department
  • Employee_Pay_History
  • HumanResources_vJobCandidate_Employee
  • HumanResources_vJobCandidate_Education

Fact Table

  • Fact_Employee
  • HumanResources_vJobCandidate

Tools

Power BI Data Analysis Data Visualization HR Analytics Dashboard Design SQL

Project Brief

01

Analyze employee demographics including gender, department, service years, organization level, and working shift.

02

Analyze departmental workforce distribution and monthly payroll costs across departments.

03

Identify employees due for promotion, employees approaching retirement, salary patterns, and sick-leave trends.

Data Model

Adventure Works Power BI Data Model

✍ Acknowledgement

I would like to express my sincere gratitude to Databuzz KP for organizing Data Challenge #01 and providing an excellent opportunity to apply my data analytics skills to a real-world business scenario.
I am truly grateful for the opportunity to work with the AdventureWorks2022 database, explore HR-related insights, and challenge myself through this competition.

Receiving 2nd Prize for this project was an unexpected and rewarding experience. 🥈 I sincerely appreciate Databuzz KP for creating a platform that encourages learning, practical experience, and continuous growth in data analytics.
Thank you, Databuzz KP, for the opportunity, inspiration, and recognition.

Interactive Dashboard

Explore the interactive Power BI dashboard.

Open Power BI Dashboard →