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,
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
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