People data and MI
People MI that links the whole HR lifecycle.
I design and build predictive, high-impact MI that unearths hidden bottlenecks, operational strains, and flight risks - turning fragmented legacy data into the exact insights the business needs to operate and course-correct.
It covers the whole lifecycle in three ways: the story behind the numbers, native MI you can slice and drill into, and linked insight across the stages.
People MI
Three ways of reporting across the lifecycle.
-
The story behind the numbers
A journey insight that tells the story behind the figures, in plain sentences, so a board hears what changed and why, not only what the numbers are.
-
Native MI you can slice and drill into
Reports you can cut by any people attribute and drill into, to investigate the detail behind the bigger numbers: every figure opens to the people and the records behind it.
-
Linked insight across the lifecycle
Linking data within the lifecycle to find what single reports cannot: employee relations cases before leavers, absence before resignations, and people rated well but given a lower pay rise who left.
Linked insight
What the areas say together.
Each link is tested on your own history. The research finds these relationships real but moderate, so a signal is a reason to look, never a verdict.
-
Employee relations, then leavers
Grievances and disciplinary cases read against who leaves, and how soon after.
-
Absence, then leavers
Absence patterns that come before resignations, by team and by person.
-
Rated well, paid less
People with good ratings who received a lower pay rise, and how many of them left within the year.
-
Manager patterns
Teams where absence, cases and leavers rise together under one manager, shown as a team pattern rather than a verdict on a person.
-
Pockets forming
Departments drifting away from the organisation, flagged when their twelve-month figure is 1.25 times the organisation’s, with the rule shown on the screen.
-
Key-person cover
Managers with no credible deputy within one grade step, where the team is already under strain.
The HR Intelligence engine
Siloed data in. A joined-up lifecycle out.
The engine takes the siloed data from any HRIS or EUC, cleans it, maps it, joins it into the lifecycle and analyses it, giving managers the visuals, insights and connections they would not normally have. It runs in the browser, so the data never leaves your machine. Alongside the lifecycle MI it carries tools of its own:
-
9-Boxer for year-end
A calibration workbook goes out to managers and comes back; the grid draws itself from the ratings in it.
-
Survey Desk
Who is due a new-starter or exit survey, the send lists, and the answers read by group, with small groups protected.
-
Org Redesigner
A proposed structure tested against the people and the numbers before it is announced.
-
Statutory returns
Pay gap and other returns prepared and checked back to source.
-
Company Story and Compare
Twenty-four months told in plain sentences, and any two months compared with a bridge that adds up.
-
Export for Board
A Power BI project built from the screens on view, and a live model month by month.
MI packs and data management
The packs people rely on, and the data underneath them.
-
A monthly insight service
Your exports each month, cleaned, reconciled and read, with a short written read-out of what moved, why, and what to watch next month. Delivered as a pack your board can take as it stands.
-
Board and Executive HR packs
Six years owning a bank’s executive and operational reporting, including the Board and Executive HR insight packs.
-
Regulatory & Compliance MI
When you owe the board or regulator a number. Diversity MI, ER reporting, and regulatory returns built as Power BI projects your own team can own, with a flawless audit trail back to the source.
-
MI Architecture Design
When reporting describes the past but needs to explain it. An agreed catalogue of measures mapped to the questions the business actually asks, delivered as a prioritised build plan.
-
Reporting brought together
Separate reporting processes consolidated into one enterprise solution, and reporting automated with VBA, Power Query and Power BI.
-
Cross-Lifecycle Predictive Analytics
When your reports never talk to each other. Recruitment, performance, employee relations, and leavers read together to answer what single reports cannot. Uncover whether healthy averages are masking critical failure points.
Across the lifecycle
Thirteen stages, and what I report on in each.
Across all of it: I work directly with HR and Finance teams, reporting independently across the whole HR lifecycle, partnered with the relevant HR managers.
Attract and recruit
Sourcing activity by department, recruiter and source, with KPIs on funnel bottlenecks and time to hire. Recruitment data also supports FTE profiling and talent planning: for roles that take a long time to recruit, attrition rates in key roles, set against average notice period, average time to accept and average time to start, show how long a gap would stay open. That gap is the business risk, and reporting it lets talent gaps be planned for before they open. Source of hire matters too, because some roles need agencies more, so agency engagement may have to be planned. As monthly reporting the figures come from each month’s exports; built as a recruitment model or tracker for the team, they update as the team works.
In the HR Intelligence engine
- Recruitment Open roles, the funnel from application to hire, source of hire, time to fill and time to accept, recruiters side by side; and talent gaps by role: attrition against notice period, time to accept and time to start, how long a seat would sit empty, and how much longer an agency fill takes.
- Cross-Domain Explorer Any recruiting figure cut by any people attribute, for the question nobody planned a report for.
Onboard
Where new hires settle in: probation reviews, new-starter risk, early attrition (leavers inside their first year) and the new-hire survey. New-hire education is part of onboarding too, with surveys of its own after the education, so the experience can be refined all the time. The education measures are under Learn and develop, and the post-education survey is in the Survey Desk beside the 90-day new-starter survey.
In the HR Intelligence engine
- Onboarding Intelligence Day 30, 60 and 90 checkpoints, who is overdue, new-starter risk bands, and where new starters are struggling by team or location.
- Attrition & Leavers Leavers inside their first year, by manager and team.
- Survey Desk Who is due a ninety-day new-starter survey, with the send list and the questionnaire.
Learn and develop
New-hire education comes first, because in many organisations it is the most important piece of learning. Financial organisations want to know when a new hire has paid for themselves: the cost of hire plus the cost of education, set against a tenure-based return, such as the person still being in the business after 90 days. I report on drop-outs from new-hire learning, first-time pass rates, and transition-team reports showing when the business accepts someone as competent for the job they were trained for. New hires have their own surveys after their education, so the programme can be refined constantly. Then development for existing staff, the performance and impact of internal educators, and mandatory training compliance.
In the HR Intelligence engine
- Learning & Compliance, with new-hire education Mandatory training compliance by team, overdue items and the learning delivered in the month; and, for new hires, drop-outs from programmes, first-time pass rates, how fast the transition team accepts people as competent, and whether hires are still here at a tenure point you set, such as 90 days, against the cost of hire plus the cost of education.
- Top Talent Who ranks highest and what they have in common, to steer development.
Perform and calibrate
A year-end model that gives managers the data to make informed pay and bonus review decisions: performance ratings, absence, employee relations data such as warnings, out-of-cycle salary increases to consider, and new roles that have already accounted for a pay increase. With the rating distribution and calibration, so the pattern reflects performance and not how ratings were given.
In the HR Intelligence engine
- Performance The rating distribution, and where ratings cluster by team, so calibration can check whether the pattern reflects performance or how ratings were given.
- 9-Boxer: talent review and calibration Every person rated for what they achieved and how they went about it; the grid, the proposed pay and bonus, and workbooks to send to business owners and collect back; and, beside each rating for the pay and bonus review, any out-of-cycle salary increases, new-role pay already given, formal employee relations cases and absence.
- Employee Scorecard One person's picture across absence, pay, performance and training.
Reward and recognise
Compa-ratio analysis, pay equity tracking, and bonus distribution modelling. Reconciles reward data against performance ratings to ensure compensation is genuinely merit-based and equitable.
In the HR Intelligence engine
- Reward A salary review modelled against budget, the people it would take past their band, and proposals flagged for review.
- Pay Equity The gender pay gap, quartiles, and pay gaps within a role.
- 9-Boxer: pay and bonus pots Pay-rise and bonus pots by division, and what the ratings ask for against each.
- Statutory Returns The official returns that draw on pay and workforce data.
Engage and listen
Joins engagement sentiment directly against attrition, absence, and performance. Exposes where high engagement masks burnout, or where low engagement serves as an early warning for turnover.
In the HR Intelligence engine
- Engagement Response, eNPS and wellbeing signals, and how people rate their line management.
- Culture Signals Teams where culture signals point the same way.
- Survey Desk Who is due a new-starter survey at ninety days or an exit survey on leaving, the send list and the questionnaire, without sending data anywhere.
Diversity and inclusion
Demographic representation, gender and ethnicity pay gap precursors, and progression tracking. Identifies structural bottlenecks where diverse talent enters the organisation but fails to advance.
In the HR Intelligence engine
- Culture & Diversity Gender and ethnicity mix, seniority, and women in leadership by division.
- Pay Equity Pay gaps by gender, and ethnicity and disability where declared.
- Statutory Returns Equality and gender pay returns.
Attendance and wellbeing
Absence Management: Open absence reporting to flag unclosed records and monitor Bradford Factor triggers. Holiday & Burnout: Audits mandatory two-week continuous block leave for regulated roles, preventing year-end operational bottlenecks and unearthing burnout risk.
In the HR Intelligence engine
- Absence The absence rate, by type, department and manager, and where it is moving.
- Absence Pulse The current month against the pattern.
- Absence Trends Seasonal and weekday patterns, return-to-work follow-up and spreading signals.
- Absence Watch Teams and individuals who have crossed a trigger.
- Open Absences Who is off today.
- Long-Term Absence Long spells and how long they have run.
- Leave Balance Holiday not yet taken and the year-end rush it creates.
- Holiday History by Group Holiday requests, approvals and declines by group.
Employee relations and conduct
Naming culture issues, which show up as stress indicators such as grievances and absences clustering in a team. With caseload volumes, grievance timelines, time to resolve, and manager hot spots where issues repeatedly surface, so HR can intervene before formal action is needed.
In the HR Intelligence engine
- Employee Relations Open cases ranked by risk, ACAS timelines, and whether similar cases were treated alike across managers.
- Culture Signals Teams where culture signals point the same way, drawing on grievance and case concentration and absence clustering.
Talent and succession
Bench strength and critical role cover. Identifies single points of failure where a key manager has no credible deputy within one grade step, mapping structural risk directly to the P&L. And how long it would take to backfill a role: the notice period, plus time to accept, plus time to start, with source of hire, since some roles need agencies more and agency engagement may be a requirement.
In the HR Intelligence engine
- Critical Roles The roles the organisation cannot afford to lose and how well covered they are.
- Succession Search Who could step up, searched across the population.
- Top Talent Ranked talent view for strategic review.
- 9-Boxer: talent review The grid of what and how across the organisation, with the unbalanced boxes marked for discussion.
- Org View Any manager's team with its measures.
- Org Chart A printable organisation chart.
Retain
Predictive flight risk. Joins absence, pay position, performance, and engagement to surface teams statistically drifting away from the organisation, enabling intervention before they resign.
In the HR Intelligence engine
- Retention Risk Everyone ranked by flight risk, with the factors behind each score.
- Watch Register The patterns that are forming now, and who they involve.
- Attrition & Leavers Attrition by manager, tenure and reason, and regrettable leavers.
Exit
Regretted loss tracking and exit interview sentiment analysis. Maps why people are leaving against their managers, testing historical data to see the real patterns preceding a resignation.
In the HR Intelligence engine
- Survey Desk Who is due an exit survey, whenever they leave, with the send list and the questionnaire.
- Exit Surveys Why people leave, which departures looked preventable, and what leavers said about their line management.
- Leaver Management Who is leaving and the backfill position.
- Future-Dated Leavers Everyone with a leaving date still to come.
- Attrition & Leavers The leaver rate and profile.
Core HR, structure and finance
One Version of the Truth: Headcount, FTE, and establishment gaps agreed between HR and Finance. Resolves data conflicts and provides a rigorous FTE governance model the resource committee will accept.
In the HR Intelligence engine
- FTE & Governance Headcount, FTE, contract mix, establishment and movement.
- Org Structure Layers, spans of control and single points of failure.
- Reconciliation Which records join the staff list and which do not.
- Data Health What is wrong in the files, ranked by effect on the numbers.
- Mapping Desk The few columns that need a decision, one click each.
- Migration Readiness Whether the data is ready to move to a new system.
Power BI
Fits the reporting a larger organisation already runs.
What the engine produces can be exported to populate Power BI, so it is compatible with a bigger organisation’s reporting where it needs to be. Power BI compatibility.
Every picture is the running product on Meridian Bank 2, a synthetic organisation. No real person, client or organisation appears in it. See the full journey, screen by screen, or watch the five-minute demo.
Talk it through
Start with the question your board keeps asking, or the data problem behind it.