HR Analytics Power BI IBM HR Dataset Workforce Intelligence

HR Analytics Dashboard

An end-to-end interactive workforce analytics solution built on Microsoft Power BI — transforming 1,470 employee records into actionable retention, compensation, and engagement intelligence for HR leaders and business decision-makers.

1,470

Employee Records

16.1%

Attrition Rate

7.01 yrs

Avg. Tenure

2.73/4

Avg. Job Satisfaction

Objective & Problem

The Objective

The goal was to design and deliver a professional, interactive HR Analytics Dashboard that equips HR leaders and organizational decision-makers with the visibility, context, and insight needed to manage their workforce strategically — replacing intuition-driven decisions with evidence-backed interventions.

Specific aims included quantifying attrition by department and role, monitoring key HR KPIs in real time, analysing the relationship between performance and compensation, and enabling self-service analysis through dynamic slicers — without requiring technical expertise from end users.

The Business Problem

The organization — a mid-to-large enterprise across Research & Development, Sales, and Human Resources — was making HR decisions without centralized data. With a 16.1% attrition rate, approximately 237 employees were leaving annually, each costing between 50% and 200% of their annual salary in recruitment, onboarding, and lost productivity.

Satisfaction scores averaging 2.73/4.0, 28.3% of staff working overtime (with triple the attrition risk), and misaligned compensation structures meant the organization was sitting on a ticking retention crisis — with no analytical infrastructure to detect or respond to it.

My Approach

A structured, end-to-end analytical process — from raw data ingestion to stakeholder-ready dashboard delivery.

1

Data Ingestion & Quality Assurance — Loaded the IBM HR dataset (1,470 records, 35 variables) into Power BI. Removed redundant constant columns (EmployeeCount, Over18, StandardHours) and validated data completeness — zero missing values confirmed across all records.
2

Data Transformation via Power Query — Applied M language transformations to decode categorical numeric fields (Education, JobLevel, JobSatisfaction, PerformanceRating) into human-readable labels, and created a derived Age Group dimension binning employees into five segments for trend analysis.
3

DAX & Custom Measure Development — Built four core KPI measures: Total Employees (1,470), Attrition Rate (16.1%), Average Tenure (7.01 years), and Average Job Satisfaction (2.73). Designed calculations to support dynamic filtering across all five slicer dimensions.
4

Insight Generation — Analysed attrition by department (Sales: 20.6%, HR: 19.0%), overtime impact (30.5% vs 10.4% attrition rate), satisfaction trends across age groups, and performance-versus-salary scatter to surface compensation equity gaps.
5

Dashboard Design & Delivery — Designed a single-page, dark-themed executive dashboard featuring KPI headline cards, attrition charts, headcount maps, satisfaction trend lines, scatter analysis, and five interactive slicers (Department, Gender, Education Field, Job Role, Age Group).
6

Business Communication — Translated all findings into plain-language recommendations targeted at HR managers and C-suite executives — no technical background required to act on the insights.

Metrics Tracked

Six core workforce intelligence dimensions monitored across the dashboard.

16.1%

Overall Attrition Rate — broken down by department, role, age group, and gender

2.73 / 4

Average Job Satisfaction — tracked alongside work-life balance (2.76) and environment (2.72)

28.3%

Overtime Prevalence — 416 employees working overtime with 3× higher attrition risk

$6,503

Average Monthly Income — range $1,009–$19,999, analysed against performance ratings

7.01 yrs

Average Employee Tenure — used to benchmark loyalty patterns across departments

1,470

Total Headcount — mapped across 3 departments and 9 distinct job roles

Key Insights

What the data revealed — and why it matters for the business.

Sales and HR carry the highest attrition risk. Sales department attrition (20.6%) and Human Resources (19.0%) significantly exceed the company average of 16.1%, signalling that targeted retention interventions are needed in these functions before the talent gap widens further.

Overtime is a critical, addressable attrition driver. Employees working overtime leave at a rate of 30.5% — nearly triple the 10.4% rate of non-overtime employees. With 416 staff (28.3% of the workforce) on overtime, workload redistribution or staffing adjustments could immediately reduce attrition risk at scale.

Engagement scores signal a systemic, not isolated, problem. Average satisfaction (2.73/4), work-life balance (2.76/4), and environment scores (2.72/4) are all below the midpoint threshold. Low engagement is a proven leading indicator of attrition — these scores suggest the organization is operating in a pre-attrition-spike environment.

Compensation and performance are misaligned. The performance-versus-salary scatter analysis reveals significant variance in how performance ratings translate into income levels. High performers who are underpaid relative to peers are prime voluntary attrition candidates — a risk that requires immediate compensation review.

R&D concentration creates structural dependency risk. With 65.4% of total headcount housed in Research & Development, attrition within this department — even at average rates — poses an outsized threat to organizational capability and project continuity.

Outcome & Impact

From Scattered Data to Strategic Clarity

The delivered dashboard transformed a static 1,470-row spreadsheet into a fully interactive, self-service workforce intelligence tool. HR managers and business leaders can now explore attrition risk, satisfaction trends, compensation equity, and headcount distribution in real time — filtering by department, gender, education field, job role, and age group without any technical support. The project shifted HR decision-making from reactive and intuition-driven to proactive and evidence-backed, providing the infrastructure for targeted retention strategies, overtime policy reform, and compensation equity reviews.

Tech Stack

Microsoft Power BI Power Query (M) DAX Microsoft Excel KPI Cards Scatter Plot Bar Charts Donut Chart Line Chart Slicers & Filters

Key Learning Points

Data Preparation & Quality Assurance — reproducible transformation pipelines in Power Query
DAX & Custom Measure Development — building dynamic KPIs that respond to slicer selections
Analytic Insight Generation — surfacing actionable findings from raw workforce data
Business Communication — translating technical findings into plain-language executive recommendations