<aside> 🎯 Analyse and visualize the gender pay gap in the UK using data from various sources.

</aside>

Data Sources

  1. Gender Pay Gap data: UK Gov. - Gender Pay Gap [2021, 2022, 2023]
  2. SIC Codes from Companies House: UK Gov. - SIC Resources
  3. Postcode Details: Managed using Python with requests and Postcodes.io API.

SQL Implementation

<aside> 💡 This section outlines the creation and management of tables, data loading, and data transformations using PostgreSQL (with Pg Admin & Visual Studio Code).

</aside>

Creating & Loading Tables

Making Junction Tables

Final Result

Final Result

Database Detailed Tables

Python Requests

<aside> 💡 This section details the usage of Python libraries for data manipulation to gather postcode information (with Jupyter Notebook).

</aside>

Libraries & API

Code Implementation

Data Quality

<aside> 💡 This section is checking the dataset integrity to help focus on the most relevant metrics when analysing the data.

</aside>

Key Identification

Numerical Values

Dashboard