Nexus Global Tech Executive HR Analytics

An end-to-end workforce analytics solution designed to identify employee attrition patterns and uncover the factors associated with retention risk.

MySQL Power BI DAX Data Modeling
1,470 Workforce Records
16.1% Baseline Attrition
20%+ Low-Satisfaction Attrition
KSh 2,100 Average Income Gap

Understanding workforce attrition.

The project models a simulated global technology company experiencing employee departures across technical and sales operations.

The objective was to move beyond simple employee counts and create an analytical system capable of identifying where attrition risk was concentrated and which workforce characteristics were associated with employee turnover.

From raw workforce data to decision intelligence.

01

Data Architecture

Structured the workforce dataset using a relational MySQL star schema.

02

Data Modeling

Connected fact and dimension structures to support scalable reporting.

03

Analytics

Developed explicit DAX measures for headcount and attrition analysis.

04

Visualization

Built an interactive Power BI workspace for executive analysis.

What the analysis revealed.

01

Satisfaction matters

Attrition exceeded 20% among employees with the lowest job-satisfaction score, compared with approximately 11% at higher satisfaction levels.

02

Counts can mislead

Comparing raw departure counts alone can obscure the underlying attrition rate. Percentage-based analysis exposed the stronger relationship between satisfaction and turnover risk.

03

Compensation anomaly

Departing employees averaged approximately KSh 4,700 in monthly income compared with KSh 6,800 among retained employees.

Built as an end-to-end BI pipeline.

MySQL Server Star Schema Power BI Advanced DAX Data Modeling Executive Reporting

Want to see the technical work?

View GitHub Repository →