Dorcas_Akinnibosun.xlsxOpen to work · Lagos · Remote, home page
← All case studiesCase study 04 · HR & workforce

Nexa Workforce Analytics

A 3-page Excel HR report that showed an ageing workforce, middling engagement and a $1.59M training budget that wasn't paying off.

BriefToolsDataDashboard
Nexa LtdExcel2,845 employees · 6 departments · 10 business units · training records3 pages
This dashboard is an interactive Excel workbook.

Slicers, pivot-driven charts and KPI cards all update together. Open the file and click the slicers to explore it yourself.

Get the interactive workbook ↗
Object · Nexa Ltd dashboard · light theme1 / 3
Nexa Workforce Analytics: Workforce overview dashboard pageFull size ↗

Workforce overview. Headcount, gender, tenure, age groups and how employees spread across departments and business units.

The brief

Workforce, engagement & training ROI

Note · the problem

Nexa Ltd's leadership needed one view of key HR metrics to plan for engagement, performance management, workforce planning and training effectiveness.

I turned raw employee, department, performance, engagement-survey and training data into a three-page interactive Excel dashboard covering the workforce overview, performance and engagement, and training and HR investment. It has slicers for departments, business units and training programmes.

TechniquesUsed
Power QueryTRUE
Pivot tables & chartsTRUE
Slicers by department & unitTRUE
Calculated completion ratesTRUE
High-performer analysisTRUE
Executive layoutTRUE
Key insights

What the data said.

#Key numberFinding
149Succession is the hidden risk2,845 employees, 56% female, with an average age of 49 and five years' average tenure. The 55+ group is the largest, so many experienced people are nearing retirement.
250%+One department carries the companyProduction holds over half of all employees, which makes the business heavily dependent on a single function.
32.9 / 5Engagement is only moderateEngagement averages 2.9, and satisfaction, work-life balance and ratings 3.0. Only 346 employees (12.16%) are high performers. Most are rated "Fully meets".
4$1.07MTraining spend isn't buying results$1.59M was invested across 2,845 programmes, $1.07M of it in Production, yet completion is 50.83%. Internal programmes complete more often but also record notable failures.
Recommendations

What to do next, with targets.

Each recommendation has a KPI, so the team can measure whether it worked.

#RecommendationTarget KPI
1Plan for succession nowWrite succession plans for critical roles, launch mentorship and knowledge transfer, and strengthen early-career hiring.100% succession cover for critical roles; +20% early-career hires
2Lift engagementRegular feedback surveys, recognition and career-development programmes, and better manager-employee communication.Engagement from 2.9 to 3.5+; satisfaction +15%
3Tie training to resultsAdd post-training assessments and ROI tracking, review weak programmes and prioritise high-impact learning.Completion above 70%; 25% fewer failed outcomes
4Grow more high performersTargeted development plans for high-potential staff, leadership programmes and performance coaching.+20% high performers; average rating 3.5+
Outcome

A single, interactive view of workforce health, engagement, training effectiveness and talent risk for Nexa's HR and leadership teams.

Data source

Datasets provided as part of a workforce analytics case study coordinated by Victory Nnajekwu. All cleaning, analysis and visuals were done independently by Dorcas.

Next case study ▸Finance Job Market IntelligenceA live Power BI report on the finance job market: who's hiring, what they pay, which skills keep coming up and how fast recruiters hire.
Contact

=IF(you_have_data, "let's look at it together", "say hello anyway")

Whether it's a role, a messy spreadsheet or a question about one of the case studies, messages come straight to my inbox.

Open to data analyst and BI work: full-time, contract or freelance, remote or on-site