March 9, 2021

Achieving diversity and inclusion aspirations in 2021 through data

Darshan Baskaran
Darshan Baskaran Consulting Manager

Business challenge:

Diversity and Inclusion
People Analytics

Gartner define the purpose of a diversity and inclusion manifesto, as a means of ensuring that the organisation is comprised of diverse individuals (based on individual characteristics, values, beliefs, and backgrounds) and to foster a work environment in which all employees feel respected, accepted, supported and valued.1

As such, diversity and Inclusion (D&I) is becoming increasingly important for employers and employees alike.

There are at least three good reasons why this is that come to mind:

There is plenty of research that backs-up the above claims. Nevertheless, whatever the reasons, it is evident that promoting Diversity and Inclusion in the workplace is something that organisational leaders are acutely aware of. Increasingly, more and more organisations are making Diversity and Inclusion (D&I) a core corporate objective.

A people data warehouse that brings together people data from different parts of an employee life cycle becomes an invaluable source of insight for D&I initiatives. We have demonstrated this in projects, where we identify whether there were any areas of the organisation affected by potential unconscious bias. The objectives are twofold:

  1. Identify any hidden issues that could hamper the organisation in achieving it’s ambitious D&I targets over the course of the next five-years
  2. Address any unconscious biases that have been found as this can improve employee engagement (3x), reduce employee flight risk (3x) and drive innovation (2.5x).2

The approach

We have developed hypothesis covering four key topics;

  1. Descriptive analysis of representation across the organisation
  2. Applications and hiring
  3. Turnover and leavers
  4. Career progression.

Some of the data used in the analysis is shown in figure 1.

TrueCue People Analytics Data Metrics
Figure 1.

Analysis of the data clearly demonstrates how representation has been changing over time (hopefully, improving). In addition, problem areas are quantified at a macro-level (affecting the entire organisation) as well as at a micro-level within a very specific area of the business. For example, the analysis can uncover potential hiring bias against women in specific grades within a specific function and geography. This is inferred using benchmark analysis of hiring rates and application success rates across the entire organisation.

Beyond a static report – the Drivers of Representation metric

A findings report with analysis provides actionable insight. However, we also realise that a breakdown of the contributing factors and drivers to changes in representation over time is also essential, so as to gain insight into the trajectory on which an organisation is heading. It would also allow organisations to determine specific areas of concern and address them with targeted initiatives on an on-going basis. This was the driving force behind the development of the Drivers of Representation (DoR) metric, designed to measure the following:

  1. Is an organisation on track to meeting a D&I target over time?
  2. Which are the key drivers for helping the organisaion meet / miss the targets?
  3. How equitable have internal policies been on the representation of the subgroups?

The DoR metric is based around the view that an employee population is a closed ‘stock and flow’ system, as illustrated in figure 2. Once an employee population is defined, all possible channels (or flows) in and out of this population can be identified and the metric is calculated for each.

Figure 2.
Source: Systems Thinking for 21st-Century Cities: A Beginner’s Introduction — Part #3. Megan McFadden, 2019

Broadly speaking, within an employee population, inflow is made up of; hiring, promotions in and lateral movement in. Outflows on the other hand are made up of; employees leaving the business, promotions out, lateral movement out. The DoR metric for each flow is a proxy for how it contributes to a D&I target. The sum of all components is referred to as the “total deviation” from target.

All inflows are tied to the strategic corporate target for representation (For example, 50% female representation). In doing so, we have set the expectation that any inflow, such as hires, should have at least the target representation, as this should be the ideal case in an equilibrium. The outflows, however, were benchmarked not against the corporate target, but against the existing representation at the start of the period. The assumption in this case is that outflows such as leavers, promotions and/or transfers out of the population should be evenly spread across the population. Any deviation from the existing proportion indicates an unequal impact between the groups.

The DoR metrics help evaluate whether the organisation (or a part of it) is heading towards achieving its corporate D&I target. It also helps uncover the underlying contribution of each inward and outward employee flow.

Figure 3.

To illustrate, let’s take the made-up example of a function within an organisation over a two-year period where female representation dropped from 29% to 26.0%. As demonstrated in figure 3., the number of females hired and moving into the function are compared to a target of 50%, while the target number of females leaving and moving out of the function should be no more than 29% to be representative of the gender representation at the start of the period. The total deviation (or sum of DoR contributions) is -12%; but if all targets were met, the female representation in the function would have been at 38% at the end of the two-year period. The current representation is 26%, which is approximately -12% away from 38%. From the contribution DoR metrics we can see that the major cause of the problem is that hiring is way off target while other inflows and outflows are less of a concern.

Ultimately, we believe that the DoR metrics, that can be filtered and benchmarked across different business dimensions, provide organisational leaders a valuable instrument to track progress towards D&I targets, identify problem areas and surgically address them when the need arises.

Want to learn more about how to improve diversity and inclusion in your organisation? Check-out our article on the role of data in achieving diversity, inclusion and equality in the workplace here.


1 Human Resources Glossary, Gartner, 2021

2 New Data Reveals The Hard Costs Of Bias And How To Disrupt It. Forbes, 2017

Business challenge:

Diversity and Inclusion
People Analytics
Darshan Baskaran
Written by Darshan Baskaran Consulting Manager

Data is in Darshan’s DNA – both literally and figuratively. Data story-telling is his passion. He obtained a DPhil. (Ph.D.) in “Molecular Cell Biology of Health and Disease” at the University of Oxford prior to joining Concentra's Analytical Consulting Team - now TrueCue Services. As Analytics Lead and Consulting Manager, he manages the delivery of analytics projects, develops analytics solutions and oversees the operational running of the Analytics Consulting Team. When on holiday, he can be found globetrotting, snowboarding, diving or taking a nap.

eBook: Organisational Network Analytics Playbook for HR Leaders

This playbook contains everything you need to get started on your journey with Organisational Network Analytics, with practical tips, examples and learnings from the field.   The result? Helping you to make the most of your organisation’s most valuable asset: your people

Download eBook