Back to selected work
People analytics / Portfolio project

Understand the workforce behind the numbers.

A people analytics dashboard for exploring headcount, compensation, termination rates and departmental differences.

Power BIDAXPower Query
Business area
Human resources
Focus
Headcount & compensation
Role
Data preparation, DAX & visualization
HR People Analytics dashboard

The question

Workforce information becomes more useful when headcount, salary and termination patterns can be explored together. A clear report needs to help readers understand both the overall picture and departmental differences.

The approach

I used Power Query, DAX and Power BI to build a people analytics view covering workforce size, average salary, termination rates and gender pay comparisons, with department-level reporting.

Workforce overview

Headcount and termination indicators provide a starting point for understanding workforce composition.

Compensation context

Average salary and gender pay comparisons help readers explore patterns that deserve further investigation.

Documentation alongside the report

The supporting PDF and video walkthrough make the work easier to review and understand.

What the report enables

The project provides a structured view of workforce and compensation patterns, supported by report documentation and a visual walkthrough. Readers can explore the overall workforce picture and the differences between departments.

Go a little deeper.

Read the HR documentation (PDF, opens in a new tab)

See the report in action. Loading the walkthrough connects to LinkedIn.

Watch on LinkedIn
Have a project in mind?

Let’s put your
data to work.

A new dashboard, a reporting bottleneck, or data that needs a clearer story. Tell me what you’re working on.

Cairo, Egypt · Working remotely with clients worldwide

Looking for something similar for your business?

Discuss your project