Archive for June, 2023
June 8, 2023
The project followed a structured approached and used a project plan to set objective and milestones. The entire project was performed using an iMac and MacBook which ran Parallels desktop to facilitate a Windows environment to use the desktop version of Power BI. I needed to use data cleaning, analysis, and visualisation skills to undertake
Read More
311- June 8, 2023
To continue this investigation, my next steps would be to collate bespoke data from a range of businesses. This would allow me to analyse the specifics of each organisation, including efforts over time to reduce the gender pay gap and resulting trends from this. I would also explore the pay quartiles and provide an in-depth
Read More269 - June 8, 2023
The original objectives of my investigation were to investigate the gender pay gap in Scotland vs UK over five years, specifically focusing on SMEs compared to large companies. Additionally, the investigation also sought to find any specific areas of industry with “biases in the recruitment, training and promotion of staff” (Delivering for Scotland, 2021) leading
Read More294 - June 8, 2023
The investigation can be summarised as follows: SMEs do not have a significantly lower gender pay gap compared to other employer sizes. Part-time employees are less affected by the gender pay gap in comparison to their full-time counterparts. The private and non-profit sectors tend to have lower gender pay gaps compared to the public sector.
Read More282 - June 8, 2023
Overview The overview analysis shows that for employers in the UK with less than 250 employees, the gender pay gap does not seem to fluctuate in significant difference from 2017 to 2021. This is also the case for employers with a size of 250 to 499, 500 to 999 and 1000 to 4999 employees. Employers
Read More323 - June 7, 2023
Outcome 3 focuses on analysing collected data to extract insights. (a) Prepare and pre-process data for analysis There were several aspects of data cleaning undertaken during the investigation. Firstly, data formats were standardised to ensure these would not cause an issue during the data analysis stage. The submission date column was altered to specify year,
Read More303 - June 7, 2023
Outcome 2 focuses on the collection of data safely and securely. (a) Identify the data required, and appropriate sources, for the chosen approach Several open-source datasets relate to the gender pay gap, including the Office for National Statistics (2022) dataset. The UK government provides datasets monitoring the gender pay gap (UK Government, 2023). Kaggle provides
Read More341 - June 5, 2023
Creating dashboards This part of the investigation has been the most time-consuming to undertake. As a starting point, I needed to consider the best data presentation formats carefully. I also felt it would be a good idea to consider the design of my report to ensure I had a clear vision of what I would
Read More312 - June 3, 2023
The gender pay gap remains a persistent issue across industries, demanding careful analysis and interpretation of data to drive meaningful change. We can use Power BI to shed light on the disparities and advocate for gender equality in the workplace. As the data had already been cleaned and filtered, potential bias and limitations were accounted
Read More353
