3. IBM HR ANALYTICS - EMPLOYEE ATTRITION
Interactive HR dashboards: workforce profile, incomes, and satisfaction with attrition analysis.
The report isn’t mobile responsive yet, sorry.
NAVIGATE THE PROJECT YOURSELF
Context & Objectives
Dataset & scope: Link to Kaggle; focused on BI storytelling, not predictive modeling
Business questions:
Workforce: how do demographics, tenure, and roles relate to attrition?
Incomes: how does pay vary by department, role, gender, and tenure?
Satisfaction: are there gaps in Environment/Job/Relationship/Work–Life satisfaction across segments?
Attrition: which combinations (overtime, travel, low tenure, pay bands) link most to higher attrition?
Process & Data Model
- Cleaning (Power Query): removed redundant fields; unpivoted 3 satisfaction columns.
Feature engineering: Age/Distance/Tenure/Income buckets, Experience Level.
Core measures (DAX): Headcount, % Attrition, Monthly Salary Cost, % Salary Cost, Avg/Median Income, Avg Tenure, Avg Training, satisfaction averages.
% logic:
% Attritionand % shares computed withREMOVEFILTERSto avoid slicer bias;ALL/ALLEXCEPTused to preserve group comparisons.
Report Structure (5 pages)
Cover (Presentation): branded landing page with navigation buttons and icons.
Employee Overview: KPIs, workforce breakdowns, attrition %; filter pop-up with bookmarks.
Employee Incomes: salary KPIs, breakdowns by department/role/gender, detailed table with conditional formatting.
Employee Satisfaction: treemap of satisfaction areas, gauge (Avg Global Satisfaction 1–4), and bookmark tabs for Age, Gender, Department, Income, Travel, Tenure, Experience.