Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Gender Pay Gap

Received Response
32
Views
5
Comments
Stefano_Mazzocca
Stefano_Mazzocca Rank 6 - Analytics & AI Lead
in Oracle Fusion AI Data Platform Forum

We are trying to setup some dashboard to show Gender Pay Gap. We think one of the best option we have is to upload a python script in order to pre calculate imported data. Here are some examplese:

https://docs.oracle.com/en-us/iaas/Content/data-science/using/models-practices.htm

We didn't understand yet what should be the inputs and outputs of .py file and how .yaml file is supposed to be

Tagged:

Answers

  • Daniel Ryan
    Daniel Ryan Rank 5 - Community Champion

    Hi @Stefano_Mazzocca

    What are you trying to do with the data? Would you be better using the Semantic Model in the FAIDP to create your calculations for gender pay gap and use those calculations to apply AI models on top in the AIDP Workbench? You already have a lot of payroll comparison capability pre-built in the FDI model of FAIDP which you can connect to in the Bronze layer of the workbench.

  • Stefano_Mazzocca
    Stefano_Mazzocca Rank 6 - Analytics & AI Lead

    Hi @Daniel Ryan , we are trying to see how compensation changes between men and women given parameters like age, seniority, performance and so on.

    Do you have some example/tutorial for what you are mentioning?

    Thanks

  • Daniel Ryan
    Daniel Ryan Rank 5 - Community Champion

    @Stefano_Mazzocca If you are using Oracle Payroll and have the FAIDP (FDI) pipelines configured in the console then you should have a Turnover by Compa Ratio Workbook. This doesn't have gender in it but if you go into the editor then you can quickly add this visualisation so you wouldn't need to use Python. The workbook is at Shared Folders/Oracle/Fusion HCM/Detail Dashboards/Workforce.

    On connecting this to the AIDP Workbench to create and apply AI models, I haven't done this personally but you should be able to connect to the schema as a Volume (might not be the right term sorry) which would connect to the data rather than replicate it.

    Screenshot 2026-03-26 at 12.22.55.png

    Screenshot has been taken from Oracle Demo instance so not real names/data.

  • Stefano_Mazzocca
    Stefano_Mazzocca Rank 6 - Analytics & AI Lead

    Thank you Daniel but this is still not sufficient since we need to calculate the adjusted gender pay gap formula, that's why we need multiple linear regression

  • Daniel Ryan
    Daniel Ryan Rank 5 - Community Champion

    If you take the semantic model into AIDP then you should be able to achieve that but I am not a Python expert so can't help with that side sorry.