{"id":252018,"date":"2026-08-03T18:37:40","date_gmt":"2026-08-03T18:37:40","guid":{"rendered":"https:\/\/globalhrafrica.com\/catalogue-formation\/piloter-rh-excel-powerbi\/"},"modified":"2026-08-11T02:08:39","modified_gmt":"2026-08-11T02:08:39","slug":"piloter-rh-excel-powerbi","status":"publish","type":"ghrm_formation","link":"https:\/\/globalhrafrica.com\/catalogue-formation\/piloter-rh-excel-powerbi\/","title":{"rendered":"Piloter ses RH avec Excel et Power BI"},"content":{"rendered":"<div class=\"et_pb_section_0 et_pb_section et_section_regular et_flex_section\">\n<div class=\"et_pb_row_0 et_pb_row et_flex_row preset--module--divi-row--q4kay8fcjg\">\n<div class=\"et_pb_column_0 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_24_24 et_flex_column_24_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_text_0 et_pb_text et_pb_bg_layout_light et_pb_module et_flex_module preset--module--divi-text--mgi0t6kqb0\"><div class=\"et_pb_text_inner\"><p>Transformer vos donn\u00e9es de paie et d'effectifs en tableaux de bord lisibles par la direction g\u00e9n\u00e9rale.<\/p>\n<\/div><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n<div class=\"et_pb_section_1 et_pb_section et_section_regular et_flex_section preset--module--divi-section--ghrmsecgutter\">\n<div class=\"et_pb_row_1 et_pb_row et_flex_row preset--module--divi-row--q4kay8fcjg\">\n<div class=\"et_pb_column_1 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_24_24 et_flex_column_24_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_heading_0 et_pb_heading et_pb_module et_flex_module\"><div class=\"et_pb_heading_container\"><h2 class=\"et_pb_module_header\">Objectifs p\u00e9dagogiques<\/h2><\/div><\/div>\n\n<ul class=\"et_pb_icon_list_0 et_pb_icon_list et_pb_module et_flex_module preset--group--divi-icon-list--divi-layout--hp3jn2g--cgtxobs9ya preset--module--divi-icon-list--default\"><li class=\"et_pb_icon_list_item_0 et_pb_icon_list_item et_pb_module et_flex_module preset--group--divi-icon-list-item--divi-layout--nested--lpubxu7op2 preset--module--divi-icon-list-item--default\"><span class=\"et-pb-icon\">N<\/span><div class=\"et_pb_icon_list_text\">Structurer une base de donn\u00e9es RH fiable<\/div><\/li><li class=\"et_pb_icon_list_item_1 et_pb_icon_list_item et_pb_module et_flex_module preset--group--divi-icon-list-item--divi-layout--nested--lpubxu7op2 preset--module--divi-icon-list-item--default\"><span class=\"et-pb-icon\">N<\/span><div class=\"et_pb_icon_list_text\">Calculer turnover, absent\u00e9isme et masse salariale<\/div><\/li><li class=\"et_pb_icon_list_item_2 et_pb_icon_list_item et_pb_module et_flex_module preset--group--divi-icon-list-item--divi-layout--nested--lpubxu7op2 preset--module--divi-icon-list-item--default\"><span class=\"et-pb-icon\">N<\/span><div class=\"et_pb_icon_list_text\">Construire un tableau de bord automatis\u00e9<\/div><\/li><li class=\"et_pb_icon_list_item_3 et_pb_icon_list_item et_pb_module et_flex_module preset--group--divi-icon-list-item--divi-layout--nested--lpubxu7op2 preset--module--divi-icon-list-item--default\"><span class=\"et-pb-icon\">N<\/span><div class=\"et_pb_icon_list_text\">Pr\u00e9senter des indicateurs qui d\u00e9clenchent des d\u00e9cisions<\/div><\/li><\/ul>\n<\/div>\n<\/div>\n<\/div>\n\n<div class=\"et_pb_section_2 et_pb_section et_section_regular et_flex_section\">\n<div class=\"et_pb_row_2 et_pb_row et_flex_row preset--module--divi-row--q4kay8fcjg\">\n<div class=\"et_pb_column_2 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_24_24 et_flex_column_24_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_heading_1 et_pb_heading et_pb_module et_flex_module\"><div class=\"et_pb_heading_container\"><h2 class=\"et_pb_module_header\">Programme<\/h2><\/div><\/div>\n\n<div class=\"et_pb_accordion_0 et_pb_accordion et_pb_module et_flex_module preset--module--divi-accordion--ghrmfaqacc\"><div class=\"et_pb_accordion_item_0 et_pb_accordion_item et_pb_toggle et_pb_module et_pb_toggle_open et_flex_module preset--module--divi-accordion-item--ghrmfaqitem\"><h3 class=\"et_pb_toggle_title\">Module 1 \u2014 Pr\u00e9parer la donn\u00e9e<\/h3><div class=\"et_pb_toggle_content et_flex_module\"><ul>\n<li>Nettoyage et normalisation<\/li>\n<li>R\u00e9f\u00e9rentiels et nomenclatures<\/li>\n<\/ul>\n<\/div><\/div><div class=\"et_pb_accordion_item_1 et_pb_accordion_item et_pb_toggle et_pb_module et_pb_toggle_close et_flex_module preset--module--divi-accordion-item--ghrmfaqitem\"><h3 class=\"et_pb_toggle_title\">Module 2 \u2014 Indicateurs RH<\/h3><div class=\"et_pb_toggle_content et_flex_module\"><ul>\n<li>Effectifs, turnover, absent\u00e9isme<\/li>\n<li>Masse salariale et \u00e9carts de r\u00e9mun\u00e9ration<\/li>\n<\/ul>\n<\/div><\/div><div class=\"et_pb_accordion_item_2 et_pb_accordion_item et_pb_toggle et_pb_module et_pb_toggle_close et_flex_module preset--module--divi-accordion-item--ghrmfaqitem\"><h3 class=\"et_pb_toggle_title\">Module 3 \u2014 Restitution<\/h3><div class=\"et_pb_toggle_content et_flex_module\"><ul>\n<li>Visualisations utiles<\/li>\n<li>Automatisation et diffusion<\/li>\n<\/ul>\n<\/div><\/div><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n<div class=\"et_pb_section_3 et_pb_section et_section_regular et_flex_section preset--module--divi-section--ghrmsecgutter\">\n<div class=\"et_pb_row_3 et_pb_row et_flex_row preset--module--divi-row--q4kay8fcjg\">\n<div class=\"et_pb_column_3 et_pb_column et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_12_24 et_flex_column_12_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_heading_2 et_pb_heading et_pb_module et_flex_module\"><div class=\"et_pb_heading_container\"><h2 class=\"et_pb_module_header\">Public concern\u00e9<\/h2><\/div><\/div>\n\n<div class=\"et_pb_text_1 et_pb_text et_pb_bg_layout_light et_pb_module et_flex_module preset--module--divi-text--mgi0t6kqb0\"><div class=\"et_pb_text_inner\"><p>Responsables RH, contr\u00f4leurs de gestion sociale<\/p>\n<\/div><\/div>\n<\/div>\n\n<div class=\"et_pb_column_4 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_12_24 et_flex_column_12_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_heading_3 et_pb_heading et_pb_module et_flex_module\"><div class=\"et_pb_heading_container\"><h2 class=\"et_pb_module_header\">Pr\u00e9requis<\/h2><\/div><\/div>\n\n<div class=\"et_pb_text_2 et_pb_text et_pb_bg_layout_light et_pb_module et_flex_module preset--module--divi-text--mgi0t6kqb0\"><div class=\"et_pb_text_inner\"><p>Usage r\u00e9gulier d'Excel \u2014 tableaux crois\u00e9s dynamiques appr\u00e9ci\u00e9s.<\/p>\n<\/div><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>Transformer vos donn\u00e9es de paie et d&rsquo;effectifs en tableaux de bord lisibles par la direction g\u00e9n\u00e9rale.<\/p>\n","protected":false},"featured_media":252054,"template":"","secteur":[23,24,25,32,26,28,27,29,30,31],"categorie-formation":[37],"fonction":[],"class_list":["post-252018","ghrm_formation","type-ghrm_formation","status-publish","has-post-thumbnail","hentry","ghrm_secteur-agro-industrie","ghrm_secteur-banque-microfinance","ghrm_secteur-btp-mines","ghrm_secteur-commerce-distribution","ghrm_secteur-energie","ghrm_secteur-institutions-publiques","ghrm_secteur-ong-humanitaire","ghrm_secteur-sante","ghrm_secteur-telecoms-numerique","ghrm_secteur-transport-logistique","ghrm_formation_cat-digital-rh"],"acf":[],"_links":{"self":[{"href":"https:\/\/globalhrafrica.com\/wp-json\/wp\/v2\/formations\/252018","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/globalhrafrica.com\/wp-json\/wp\/v2\/formations"}],"about":[{"href":"https:\/\/globalhrafrica.com\/wp-json\/wp\/v2\/types\/ghrm_formation"}],"version-history":[{"count":2,"href":"https:\/\/globalhrafrica.com\/wp-json\/wp\/v2\/formations\/252018\/revisions"}],"predecessor-version":[{"id":263683,"href":"https:\/\/globalhrafrica.com\/wp-json\/wp\/v2\/formations\/252018\/revisions\/263683"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/globalhrafrica.com\/wp-json\/wp\/v2\/media\/252054"}],"wp:attachment":[{"href":"https:\/\/globalhrafrica.com\/wp-json\/wp\/v2\/media?parent=252018"}],"wp:term":[{"taxonomy":"ghrm_secteur","embeddable":true,"href":"https:\/\/globalhrafrica.com\/wp-json\/wp\/v2\/secteur?post=252018"},{"taxonomy":"ghrm_formation_cat","embeddable":true,"href":"https:\/\/globalhrafrica.com\/wp-json\/wp\/v2\/categorie-formation?post=252018"},{"taxonomy":"ghrm_fonction","embeddable":true,"href":"https:\/\/globalhrafrica.com\/wp-json\/wp\/v2\/fonction?post=252018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}