← Back to selected work

People analytics

Target Energy

An HR performance dashboard connecting headcount, hiring, salary, terminations, satisfaction and workforce trends in one management view.

My roleFinancial analysis & dashboard design
ToolsPower BI · People analytics · HR reporting
TypePortfolio demonstration
Target Energy dashboard overview

The brief

From business question to decision-ready view.

01

Business question

Target Energy needed a centralized view of workforce trends, employee movement and people-performance signals so leadership could move from reactive HR decisions to earlier, evidence-based action.

02

The approach

  • Structured headcount, hiring, salary, termination and rate metrics around a clear year-selected HR overview.
  • Added year-over-year comparisons across departments, roles, demographics, satisfaction and performance dimensions.
  • Made workforce patterns filterable so emerging attrition, hiring and engagement signals could be investigated quickly.
03

What the sample data shows

Figures below describe the displayed portfolio dataset, not a client outcome.

  • The displayed 2024 view reports 847 headcount, 200 hires and 49 terminations.
  • Total salary is shown as 97.76M, with a 23.6% hire rate and 5.8% termination rate.
  • The report compares workforce movement across education, employment, department, age group, gender, job role, satisfaction, performance and work-life balance.
04

Decisions this supports

  • Which workforce signals need leadership attention first
  • Where attrition, hiring or satisfaction trends are changing
  • Which roles or demographics need a targeted people response

The transformation

A comprehensive succession planning system for a new HR vertical.

The Target Energy HR dashboard connects workforce trends, attrition signals, performance metrics and demographic patterns into one on-demand people-insights system.

Before working with us

TARGET faced:

  • No centralized view of workforce trends or turnover patterns.
  • Static reports offered no insight into root causes of resignations or low performance.
  • Leadership could not track year-over-year changes in headcount, pay or satisfaction efficiently.
  • Exit trends by role, department or demographics were unclear.
  • HR lacked data to identify who was most likely to leave or why.
  • Decisions were reactive, often made after problems escalated.
After working with us

TARGET got:

  • Enabled filtering by department, age, satisfaction and performance metrics.
  • Added year-over-year comparisons to highlight emerging attrition or hiring trends.
  • Forecasted results using predictive analysis to enable future-focused decisions.
  • Uncovered early-warning signs of employee churn with dynamic visual data.
  • Mapped resignation patterns by job role and demographics to target solutions.
  • Provided leadership with clear, on-demand insights to drive better HR decisions.

Interactive report

Explore the dashboard.

Use the report controls to navigate pages, filter the data and inspect individual views.

Target Energy dashboard preview

The interactive report is best viewed in a larger window.

Open interactive report (opens in a new tab)

Public portfolio report. The demonstration data is intentionally non-confidential.

Open report in a new tab (opens in a new tab)

People analytics walkthrough

Turn workforce signals into timely action.

The Target Energy view brings HR performance, workforce composition and year-over-year movement into one filterable dashboard for clearer people decisions.

Start a conversation

Have a similar reporting or modelling question?

Share the decision you need to support and the data or report you already have.

Work

Explore all
case studies.

Browse the complete portfolio of dashboards, models and reporting work. Choose another case study without leaving this page.

Use the arrows or swipe to browse the full case-study library.