Gender Pay Gap Analysis (2022)

Using Google Data Studio and Open Data

It was great to see so much support for International Women’s Day last week and I wanted to find my own way to raise awareness, so I thought I’d do it the only way I know how — with data.

Using publically available government data and Google Data Studio, I put together a dashboard that shows the gender pay gap data submitted by employers since 2017 in the UK.

The gender pay gap is the difference between the average (mean or median) earnings of men and women across a workforce.

From 2017, if you are an employer who has a headcount of 250 or more on your ‘snapshot date’ you must comply with regulations on gender pay gap reporting. Gender pay gap calculations are based on employer payroll data drawn from a specific date each year. This specific date is called the ‘snapshot date’.
Source

Caveat: The data makes no assumptions about job titles, hours worked, seniority, age, tenure and other factors that go into determining one’s pay. It has also in no way been normalised to isolate the gender variable in pay gaps. Presented below is simply a representation and visualisation of the data available from the public data set.

I’m fully aware that this is a complex topic that can’t be explained by a few simple graphs. My intention is not to present biased stats but really just to highlight the differences, whatever the underlying reason. However, there are studies that take into…