{"id":73,"date":"2025-04-16T09:07:26","date_gmt":"2025-04-16T09:07:26","guid":{"rendered":"http:\/\/portfolio-data.local\/?p=73"},"modified":"2025-06-04T07:17:36","modified_gmt":"2025-06-04T07:17:36","slug":"5-2","status":"publish","type":"post","link":"https:\/\/riverphot.com\/data\/5-2\/","title":{"rendered":"Rapport automatis\u00e9 de l\u2019\u00e9galit\u00e9 femmes-hommes en entreprise"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"73\" class=\"elementor elementor-73\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-37f9658 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"37f9658\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-40bded1\" data-id=\"40bded1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6b20b03 elementor-widget elementor-widget-heading\" data-id=\"6b20b03\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Rapport automatis\u00e9 de l'\u00e9galit\u00e9 femmes-hommes en entreprise<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-52cc8ef elementor-widget elementor-widget-text-editor\" data-id=\"52cc8ef\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Automatisation du rapport annuel sur l&rsquo;\u00e9galit\u00e9 Homme Femme en entreprise.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5142bcd elementor-align-center elementor-widget elementor-widget-button\" data-id=\"5142bcd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"\/wp-content\/uploads\/2025\/05\/RapportEgaliteHommeFemme.pdf\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-icon\">\n\t\t\t\t<i aria-hidden=\"true\" class=\"far fa-share-square\"><\/i>\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Voir le rapport<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5db180b elementor-widget elementor-widget-heading\" data-id=\"5db180b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Objectif du projet<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a614275 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"a614275\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d1d4f45 elementor-widget elementor-widget-text-editor\" data-id=\"d1d4f45\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Mettre en place un workflow automatis\u00e9 permettant de g\u00e9n\u00e9rer un rapport sur l\u2019\u00e9galit\u00e9 professionnelle femmes-hommes \u00e0 partir de donn\u00e9es RH internes, dans le respect du RGPD. Le projet vise \u00e0 fournir un diagnostic bas\u00e9 sur des indicateurs cl\u00e9s, incluant des visualisations graphiques exploitables et des recommandations concr\u00e8tes.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-75ad700 elementor-widget elementor-widget-heading\" data-id=\"75ad700\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Approche m\u00e9thodologique<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e02f528 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"e02f528\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3ae7835 elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"3ae7835\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p class=\"\" data-start=\"607\" data-end=\"863\">Le projet a d\u00e9but\u00e9 par l\u2019analyse du contexte r\u00e9glementaire (obligation l\u00e9gale pour les entreprises de plus de 50 salari\u00e9s de publier un index d\u2019\u00e9galit\u00e9 femmes-hommes) ainsi que l\u2019\u00e9tude des documents de r\u00e9f\u00e9rence (guide TPE\/PME et outil diagnostic \u00c9gaPro).<\/p><p class=\"\" data-start=\"865\" data-end=\"1415\">Les donn\u00e9es extraites du SIRH ont d&rsquo;abord \u00e9t\u00e9 anonymis\u00e9es afin de garantir leur conformit\u00e9 au RGPD, notamment par la suppression ou le masquage des identifiants individuels. Ensuite, une s\u00e9lection de 5 indicateurs pertinents a \u00e9t\u00e9 effectu\u00e9e parmi ceux recommand\u00e9s par le minist\u00e8re du Travail (\u00e9carts de r\u00e9mun\u00e9ration, d\u2019augmentations, de promotions, retour de cong\u00e9 maternit\u00e9, repr\u00e9sentation dans les hauts salaires). Ces indicateurs ont \u00e9t\u00e9 nettoy\u00e9s, standardis\u00e9s, puis pr\u00e9par\u00e9s dans un fichier .csv destin\u00e9 \u00e0 des usages futurs dans Tableau Software.<\/p><p class=\"\" data-start=\"1417\" data-end=\"1711\">Un workflow KNIME a \u00e9t\u00e9 structur\u00e9 pour int\u00e9grer : la pr\u00e9paration et l\u2019anonymisation des donn\u00e9es, le calcul automatique des indicateurs s\u00e9lectionn\u00e9s, la cr\u00e9ation de visualisations, le calcul des scores d&rsquo;\u00e9galit\u00e9 et l\u2019export des r\u00e9sultats. Tout cela dans le but de permettre une automatisation du calcul des scores pour les ann\u00e9es suivantes.<\/p><p class=\"\" data-start=\"1713\" data-end=\"1885\">Enfin, une pr\u00e9sentation synth\u00e9tique des r\u00e9sultats a \u00e9t\u00e9 r\u00e9alis\u00e9e, incluant score final de l\u2019entreprise, graphiques interpr\u00e9tables, et recommandations pour l\u2019ann\u00e9e suivante.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c73007c elementor-widget elementor-widget-image\" data-id=\"c73007c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"5496\" height=\"4648\" src=\"https:\/\/riverphot.com\/data\/wp-content\/uploads\/2025\/04\/workflow-1.svg\" class=\"attachment-full size-full wp-image-443\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c8038c2 elementor-widget elementor-widget-heading\" data-id=\"c8038c2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comp\u00e9tences et outils mobilis\u00e9s<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-988d92d elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"988d92d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-011c34a elementor-widget elementor-widget-text-editor\" data-id=\"011c34a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul><li>Lecture critique de documents r\u00e9glementaires<\/li><li>Pr\u00e9paration et traitement de donn\u00e9es RH<\/li><li>Anonymisation de donn\u00e9es sensibles (conformit\u00e9 RGPD)<\/li><li>S\u00e9lection d\u2019indicateurs et calcul de scores d&rsquo;\u00e9galit\u00e9<\/li><li>Automatisation avec workflow KNIME<\/li><li>Cr\u00e9ation de visualisations<\/li><li>Pr\u00e9sentation synth\u00e9tique orient\u00e9e d\u00e9cision<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d743be5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d743be5\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6f90dec\" data-id=\"6f90dec\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c762e6f elementor-widget elementor-widget-heading\" data-id=\"c762e6f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">\ud83d\udcbb Environnement technique et biblioth\u00e8ques\u200b<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d1a680f liste-tag elementor-widget elementor-widget-text-editor\" data-id=\"d1a680f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<span>Knime<\/span>\n<span>Excel<\/span>\n<span>PowerPoint<\/span>\n<span>CSV<\/span>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8de8dd3 elementor-widget elementor-widget-heading\" data-id=\"8de8dd3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">\ud83e\udde0 M\u00e9thodes et techniques appliqu\u00e9es<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0e7244a liste-tag-skills elementor-widget elementor-widget-text-editor\" data-id=\"0e7244a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<span>Workflow automatis\u00e9<\/span>\n<span>RGPD<\/span>\n<span>Data Visualisation<\/span>\n<span>Nettoyage de donn\u00e9es<\/span>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Mise en place d\u2019un workflow KNIME pour analyser des donn\u00e9es RH anonymis\u00e9es, calculer des indicateurs et scores r\u00e9glementaires sur l\u2019\u00e9galit\u00e9 professionnelle homme femme, et g\u00e9n\u00e9rer un rapport synth\u00e9tique conforme RGPD avec visualisations et recommandations.<\/p>\n","protected":false},"author":1,"featured_media":512,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_canvas","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[33,31,34,30,32],"class_list":["post-73","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-portfolio","tag-excel","tag-knime","tag-nettoyage-de-donnees","tag-rgpd","tag-workflow"],"_links":{"self":[{"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/posts\/73","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/comments?post=73"}],"version-history":[{"count":39,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/posts\/73\/revisions"}],"predecessor-version":[{"id":1001,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/posts\/73\/revisions\/1001"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/media\/512"}],"wp:attachment":[{"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/media?parent=73"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/categories?post=73"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/tags?post=73"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}