{"id":301,"date":"2025-07-27T22:14:45","date_gmt":"2025-07-27T20:14:45","guid":{"rendered":"https:\/\/giulia-governatori.alwaysdata.net\/?post_type=projects&#038;p=301"},"modified":"2025-09-30T12:33:24","modified_gmt":"2025-09-30T10:33:24","slug":"analyze-customer-churn","status":"publish","type":"projects","link":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/projects\/analyze-customer-churn\/","title":{"rendered":"Visualiser des donn\u00e9es avec Excel"},"content":{"rendered":"<style>.kadence-column301_88bdce-d0 > .kt-inside-inner-col,.kadence-column301_88bdce-d0 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column301_88bdce-d0 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column301_88bdce-d0 > .kt-inside-inner-col{flex-direction:column;}.kadence-column301_88bdce-d0 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column301_88bdce-d0 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column301_88bdce-d0{position:relative;}.kadence-column301_88bdce-d0, .kt-inside-inner-col > .kadence-column301_88bdce-d0:not(.specificity){margin-top:30px;margin-bottom:30px;}@media all and (max-width: 1024px){.kadence-column301_88bdce-d0 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column301_88bdce-d0 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column301_88bdce-d0\"><div class=\"kt-inside-inner-col\"><style>.kb-row-layout-id301_04eafa-4e > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id301_04eafa-4e > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id301_04eafa-4e > .kt-row-column-wrap{column-gap:var(--global-kb-gap-none, 0rem );row-gap:var(--global-kb-gap-none, 0rem );padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kb-row-layout-id301_04eafa-4e > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}.kb-row-layout-id301_04eafa-4e > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}.kb-row-layout-id301_04eafa-4e > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id301_04eafa-4e > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}}@media all and (max-width: 1024px){.kb-row-layout-id301_04eafa-4e > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}@media all and (max-width: 767px){.kb-row-layout-id301_04eafa-4e > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}.kb-row-layout-id301_04eafa-4e > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}<\/style><div class=\"kb-row-layout-wrap kb-row-layout-id301_04eafa-4e alignnone wp-block-kadence-rowlayout\"><div class=\"kt-row-column-wrap kt-has-4-columns kt-row-layout-row kt-tab-layout-inherit kt-mobile-layout-row kt-row-valign-top\">\n<style>.kadence-column301_7361ce-a8 > .kt-inside-inner-col,.kadence-column301_7361ce-a8 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column301_7361ce-a8 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column301_7361ce-a8 > .kt-inside-inner-col{flex-direction:column;}.kadence-column301_7361ce-a8 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column301_7361ce-a8 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column301_7361ce-a8{position:relative;}@media all and (max-width: 1024px){.kadence-column301_7361ce-a8 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column301_7361ce-a8 > .kt-inside-inner-col{display:flex;flex-direction:column;justify-content:center;align-items:flex-start;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column301_7361ce-a8\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading301_e06374-67, .wp-block-kadence-advancedheading.kt-adv-heading301_e06374-67[data-kb-block=\"kb-adv-heading301_e06374-67\"]{font-size:var(--global-kb-font-size-sm, 0.9rem);font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading301_e06374-67 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading301_e06374-67[data-kb-block=\"kb-adv-heading301_e06374-67\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading301_e06374-67 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading301_e06374-67[data-kb-block=\"kb-adv-heading301_e06374-67\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading301_e06374-67 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading301_e06374-67\">Banque - ESN Data (Openclassroom)<\/p>\n<\/div><\/div>\n\n\n<style>.kadence-column301_72e885-e5 > .kt-inside-inner-col{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kadence-column301_72e885-e5 > .kt-inside-inner-col,.kadence-column301_72e885-e5 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column301_72e885-e5 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column301_72e885-e5 > .kt-inside-inner-col{flex-direction:column;}.kadence-column301_72e885-e5 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column301_72e885-e5 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column301_72e885-e5{position:relative;}.kadence-column301_72e885-e5, .kt-inside-inner-col > .kadence-column301_72e885-e5:not(.specificity){margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;}@media all and (max-width: 1024px){.kadence-column301_72e885-e5 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column301_72e885-e5 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column301_72e885-e5\"><div class=\"kt-inside-inner-col\"><h1 style=\"padding-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;\" class=\"wp-block-post-title\">Visualiser des donn\u00e9es avec Excel<\/h1><\/div><\/div>\n\n\n<style>.kadence-column301_539fa9-74 > .kt-inside-inner-col{display:flex;}.kadence-column301_539fa9-74 > .kt-inside-inner-col{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kadence-column301_539fa9-74 > .kt-inside-inner-col,.kadence-column301_539fa9-74 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column301_539fa9-74 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column301_539fa9-74 > .kt-inside-inner-col{flex-direction:column;align-items:flex-start;}.kadence-column301_539fa9-74 > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column301_539fa9-74 > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column301_539fa9-74 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column301_539fa9-74 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column301_539fa9-74{position:relative;}@media all and (max-width: 1024px){.kadence-column301_539fa9-74 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}@media all and (max-width: 767px){.kadence-column301_539fa9-74 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column301_539fa9-74\"><div class=\"kt-inside-inner-col\"><style>.kb-row-layout-wrap.wp-block-kadence-rowlayout.kb-row-layout-id301_cd740c-be{margin-top:0px;margin-bottom:0px;}.kb-row-layout-id301_cd740c-be > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id301_cd740c-be > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id301_cd740c-be > .kt-row-column-wrap{column-gap:var(--global-kb-gap-none, 0rem );row-gap:var(--global-kb-gap-sm, 1rem);max-width:922px;margin-left:auto;margin-right:auto;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;grid-template-columns:minmax(0, calc(40% - ((var(--global-kb-gap-none, 0rem ) * 2 )\/3)))minmax(0, calc(20% - ((var(--global-kb-gap-none, 0rem ) * 2 )\/3)))minmax(0, calc(40% - ((var(--global-kb-gap-none, 0rem ) * 2 )\/3)));}.kb-row-layout-id301_cd740c-be > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id301_cd740c-be > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}}@media all and (max-width: 1024px){.kb-row-layout-id301_cd740c-be > .kt-row-column-wrap{grid-template-columns:repeat(3, minmax(0, 1fr));}}@media all and (max-width: 767px){.kb-row-layout-id301_cd740c-be > .kt-row-column-wrap{padding-bottom:1px;grid-template-columns:minmax(0, 1fr) minmax(0, 1fr) minmax(0, 2fr);}}<\/style><div class=\"kb-row-layout-wrap kb-row-layout-id301_cd740c-be alignnone wp-block-kadence-rowlayout\"><div class=\"kt-row-column-wrap kt-has-3-columns kt-row-layout-equal kt-tab-layout-inherit kt-mobile-layout-right-half kt-row-valign-top\">\n<style>.kadence-column301_635100-09 > .kt-inside-inner-col{display:flex;}.kadence-column301_635100-09 > .kt-inside-inner-col,.kadence-column301_635100-09 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column301_635100-09 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column301_635100-09 > .kt-inside-inner-col{flex-direction:column;align-items:flex-start;}.kadence-column301_635100-09 > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column301_635100-09 > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column301_635100-09 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column301_635100-09 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column301_635100-09{position:relative;}@media all and (max-width: 1024px){.kadence-column301_635100-09 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}@media all and (max-width: 767px){.kadence-column301_635100-09 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column301_635100-09\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading301_8d1880-e6, .wp-block-kadence-advancedheading.kt-adv-heading301_8d1880-e6[data-kb-block=\"kb-adv-heading301_8d1880-e6\"]{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;font-size:var(--global-kb-font-size-sm, 0.9rem);font-style:normal;color:#ff275d;}.wp-block-kadence-advancedheading.kt-adv-heading301_8d1880-e6 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading301_8d1880-e6[data-kb-block=\"kb-adv-heading301_8d1880-e6\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading301_8d1880-e6 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading301_8d1880-e6[data-kb-block=\"kb-adv-heading301_8d1880-e6\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading301_8d1880-e6 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading301_8d1880-e6\">Fictif<\/p>\n<\/div><\/div>\n\n\n<style>.kadence-column301_98aabe-71 > .kt-inside-inner-col,.kadence-column301_98aabe-71 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column301_98aabe-71 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column301_98aabe-71 > .kt-inside-inner-col{flex-direction:column;}.kadence-column301_98aabe-71 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column301_98aabe-71 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column301_98aabe-71{position:relative;}@media all and (max-width: 1024px){.kadence-column301_98aabe-71 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column301_98aabe-71 > .kt-inside-inner-col{display:flex;flex-direction:column;justify-content:center;align-items:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column301_98aabe-71\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading301_498b7f-62, .wp-block-kadence-advancedheading.kt-adv-heading301_498b7f-62[data-kb-block=\"kb-adv-heading301_498b7f-62\"]{font-size:var(--global-kb-font-size-sm, 0.9rem);font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading301_498b7f-62 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading301_498b7f-62[data-kb-block=\"kb-adv-heading301_498b7f-62\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading301_498b7f-62 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading301_498b7f-62[data-kb-block=\"kb-adv-heading301_498b7f-62\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading301_498b7f-62 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading301_498b7f-62\">|<\/p>\n<\/div><\/div>\n\n\n<style>.kadence-column301_e498e6-18 > .kt-inside-inner-col,.kadence-column301_e498e6-18 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column301_e498e6-18 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column301_e498e6-18 > .kt-inside-inner-col{flex-direction:column;}.kadence-column301_e498e6-18 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column301_e498e6-18 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column301_e498e6-18{position:relative;}@media all and (max-width: 1024px){.kadence-column301_e498e6-18 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column301_e498e6-18 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column301_e498e6-18\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading301_857d21-fe, .wp-block-kadence-advancedheading.kt-adv-heading301_857d21-fe[data-kb-block=\"kb-adv-heading301_857d21-fe\"]{text-align:left;font-size:var(--global-kb-font-size-sm, 0.9rem);font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading301_857d21-fe mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading301_857d21-fe[data-kb-block=\"kb-adv-heading301_857d21-fe\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading301_857d21-fe img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading301_857d21-fe[data-kb-block=\"kb-adv-heading301_857d21-fe\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading301_857d21-fe project-dates wp-block-kadence-advancedheading has-theme-palette-5-color has-text-color\" data-kb-block=\"kb-adv-heading301_857d21-fe\">27\/11\/2024 &gt; 13\/12\/2024<\/p>\n<\/div><\/div>\n\n<\/div><\/div><\/div><\/div>\n\n\n<style>.kadence-column301_90e7b9-f2 > .kt-inside-inner-col,.kadence-column301_90e7b9-f2 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column301_90e7b9-f2 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column301_90e7b9-f2 > .kt-inside-inner-col{flex-direction:column;}.kadence-column301_90e7b9-f2 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column301_90e7b9-f2 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column301_90e7b9-f2{position:relative;}@media all and (max-width: 1024px){.kadence-column301_90e7b9-f2 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column301_90e7b9-f2 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column301_90e7b9-f2\"><div class=\"kt-inside-inner-col\">\n<hr class=\"wp-block-separator aligncenter has-text-color has-theme-palette-4-color has-alpha-channel-opacity has-theme-palette-4-background-color has-background is-style-wide\" style=\"margin-top:20px\"\/>\n<\/div><\/div>\n\n<\/div><\/div><\/div><\/div>\n\n\n<style>.kadence-column301_307aed-68 > .kt-inside-inner-col{display:flex;}.kadence-column301_307aed-68 > .kt-inside-inner-col,.kadence-column301_307aed-68 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column301_307aed-68 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column301_307aed-68 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}.kadence-column301_307aed-68 > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column301_307aed-68 > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column301_307aed-68 > .kt-inside-inner-col > .aligncenter{width:100%;}.kt-row-column-wrap > .kadence-column301_307aed-68{align-self:center;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column301_307aed-68{align-self:auto;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column301_307aed-68 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}.kadence-column301_307aed-68 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column301_307aed-68{position:relative;}.kadence-column301_307aed-68, .kt-inside-inner-col > .kadence-column301_307aed-68:not(.specificity){margin-top:30px;margin-bottom:0px;}@media all and (max-width: 1024px){.kt-row-column-wrap > .kadence-column301_307aed-68{align-self:center;}}@media all and (max-width: 1024px){.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column301_307aed-68{align-self:auto;}}@media all and (max-width: 1024px){.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column301_307aed-68 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 1024px){.kadence-column301_307aed-68 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}}@media all and (max-width: 767px){.kt-row-column-wrap > .kadence-column301_307aed-68{align-self:center;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column301_307aed-68{align-self:auto;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column301_307aed-68 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}.kadence-column301_307aed-68 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column301_307aed-68\"><div class=\"kt-inside-inner-col\"><style>.kb-row-layout-id301_d8ba39-82 > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id301_d8ba39-82 > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id301_d8ba39-82 > .kt-row-column-wrap{column-gap:var(--global-kb-gap-md, 2rem);row-gap:var(--global-kb-gap-sm, 1rem);padding-top:10px;padding-bottom:24px;grid-template-columns:minmax(0, 2fr) minmax(0, 1fr);}.kb-row-layout-id301_d8ba39-82 > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id301_d8ba39-82 > .kt-row-column-wrap{grid-template-columns:minmax(0, 2fr) minmax(0, 1fr);}}@media all and (max-width: 767px){.kb-row-layout-id301_d8ba39-82 > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}<\/style><div class=\"kb-row-layout-wrap kb-row-layout-id301_d8ba39-82 alignnone wp-block-kadence-rowlayout\"><div class=\"kt-row-column-wrap kt-has-2-columns kt-row-layout-left-golden kt-tab-layout-inherit kt-mobile-layout-row kt-row-valign-top\">\n<style>.kadence-column301_b14d74-cc > .kt-inside-inner-col,.kadence-column301_b14d74-cc > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column301_b14d74-cc > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column301_b14d74-cc > .kt-inside-inner-col{flex-direction:column;}.kadence-column301_b14d74-cc > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column301_b14d74-cc > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column301_b14d74-cc{position:relative;}@media all and (max-width: 1024px){.kadence-column301_b14d74-cc > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column301_b14d74-cc > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column301_b14d74-cc\"><div class=\"kt-inside-inner-col\"><style>.kb-gallery-id-301_9ee006-1e.kb-gallery-ul.kb-gallery-type-fluidcarousel .kt-blocks-carousel figure .kb-gal-image-radius, .kb-gallery-id-301_9ee006-1e.kb-gallery-ul.kb-gallery-type-fluidcarousel .kt-blocks-carousel figure .kb-gal-image-radius img{height:350px;}.kb-gallery-id-301_9ee006-1e .kadence-blocks-gallery-item .kb-gal-image-radius, .kb-gallery-id-301_9ee006-1e .kb-slide-item .kb-gal-image-radius img{border-radius:0px 0px 0px 0px;;}.kb-gallery-wrap-id-301_9ee006-1e.wp-block-kadence-advancedgallery{overflow:visible;}.kb-gallery-wrap-id-301_9ee006-1e.wp-block-kadence-advancedgallery .kt-blocks-carousel{overflow:visible;max-width:100%;}.kb-gallery-id-301_9ee006-1e .splide.kt-carousel-dotstyle-outlinelight .splide__pagination__page{background-color:transparent;box-shadow:inset 0 0 0 1px #fff;-webkit-transition:box-shadow 0.3s ease;-moz-transition:box-shadow 0.3s ease;transition:box-shadow 0.3s ease;}.kb-gallery-id-301_9ee006-1e .splide.kt-carousel-dotstyle-outlinelight .splide__pagination__page.is-active{background-color:transparent;box-shadow:inset 0 0 0 8px #fff;}<\/style><div class=\"kb-gallery-wrap-id-301_9ee006-1e alignnone wp-block-kadence-advancedgallery\"><div class=\"kb-gallery-ul kb-gallery-non-static kb-gallery-type-fluidcarousel kb-gallery-id-301_9ee006-1e kb-gallery-caption-style-bottom-hover kb-gallery-filter-none kb-gallery-magnific-init\" data-image-filter=\"none\" data-lightbox-caption=\"true\"><div class=\"kt-blocks-carousel splide kt-carousel-container-dotstyle-outlinelight kt-carousel-arrowstyle-blackonlight kt-carousel-dotstyle-outlinelight kb-slider-group-arrow kb-slider-arrow-position-center\" data-slider-anim-speed=\"1500\" data-slider-scroll=\"1\" data-slider-arrows=\"true\" data-slider-dots=\"true\" data-slider-hover-pause=\"false\" data-slider-auto=\"1\" data-slider-speed=\"3000\" data-slider-type=\"fluidcarousel\" data-slider-center-mode=\"true\" data-slider-gap=\"10px\" data-slider-gap-tablet=\"10px\" data-slider-gap-mobile=\"10px\" data-show-pause-button=\"false\"><div class=\"splide__track\"><ul class=\"kt-blocks-carousel-init kb-blocks-fluid-carousel splide__list\"><li class=\"kb-slide-item kb-gallery-carousel-item splide__slide\"><div class=\"kadence-blocks-gallery-item\"><div class=\"kadence-blocks-gallery-item-inner\"><figure class=\"kb-gallery-figure kb-gallery-item-has-link kadence-blocks-gallery-item-hide-caption\"><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_1.webp\" class=\"kb-gallery-item-link\"  ><div class=\"kb-gal-image-radius\"><div class=\"kb-gallery-image-contain\" ><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_1.webp\" width=\"1520\" height=\"859\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_1.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_1.webp\" data-id=\"857\" class=\"wp-image-857 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_1.webp 1520w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_1-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_1-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_1-768x434.webp 768w\" sizes=\"auto, (max-width: 1520px) 100vw, 1520px\" \/><\/div><\/div><\/a><\/figure><\/div><\/div><\/li><li class=\"kb-slide-item kb-gallery-carousel-item splide__slide\"><div class=\"kadence-blocks-gallery-item\"><div class=\"kadence-blocks-gallery-item-inner\"><figure class=\"kb-gallery-figure kb-gallery-item-has-link kadence-blocks-gallery-item-hide-caption\"><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_2.webp\" class=\"kb-gallery-item-link\"  ><div class=\"kb-gal-image-radius\"><div class=\"kb-gallery-image-contain\" ><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_2.webp\" width=\"1520\" height=\"859\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_2.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_2.webp\" data-id=\"858\" class=\"wp-image-858 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_2.webp 1520w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_2-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_2-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_2-768x434.webp 768w\" sizes=\"auto, (max-width: 1520px) 100vw, 1520px\" \/><\/div><\/div><\/a><\/figure><\/div><\/div><\/li><li class=\"kb-slide-item kb-gallery-carousel-item splide__slide\"><div class=\"kadence-blocks-gallery-item\"><div class=\"kadence-blocks-gallery-item-inner\"><figure class=\"kb-gallery-figure kb-gallery-item-has-link kadence-blocks-gallery-item-hide-caption\"><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_3.webp\" class=\"kb-gallery-item-link\"  ><div class=\"kb-gal-image-radius\"><div class=\"kb-gallery-image-contain\" ><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_3.webp\" width=\"1520\" height=\"859\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_3.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_3.webp\" data-id=\"859\" class=\"wp-image-859 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_3.webp 1520w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_3-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_3-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_3-768x434.webp 768w\" sizes=\"auto, (max-width: 1520px) 100vw, 1520px\" \/><\/div><\/div><\/a><\/figure><\/div><\/div><\/li><li class=\"kb-slide-item kb-gallery-carousel-item splide__slide\"><div class=\"kadence-blocks-gallery-item\"><div class=\"kadence-blocks-gallery-item-inner\"><figure class=\"kb-gallery-figure kb-gallery-item-has-link kadence-blocks-gallery-item-hide-caption\"><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_4.webp\" class=\"kb-gallery-item-link\"  ><div class=\"kb-gal-image-radius\"><div class=\"kb-gallery-image-contain\" ><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_4.webp\" width=\"1334\" height=\"753\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_4.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_4.webp\" data-id=\"860\" class=\"wp-image-860 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_4.webp 1334w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_4-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_4-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P2_4-768x434.webp 768w\" sizes=\"auto, (max-width: 1334px) 100vw, 1334px\" \/><\/div><\/div><\/a><\/figure><\/div><\/div><\/li><\/ul><\/div><\/div><\/div><\/div><\/div><\/div>\n\n\n<style>.kadence-column301_a5623f-72 > .kt-inside-inner-col,.kadence-column301_a5623f-72 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column301_a5623f-72 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column301_a5623f-72 > .kt-inside-inner-col{flex-direction:column;}.kadence-column301_a5623f-72 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column301_a5623f-72 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column301_a5623f-72{position:relative;}@media all and (max-width: 1024px){.kadence-column301_a5623f-72 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column301_a5623f-72 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column301_a5623f-72\"><div class=\"kt-inside-inner-col\"><style>.kb-table-of-content-nav.kb-table-of-content-id301_57bb0b-ce .kb-table-of-content-wrap{padding-top:40px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kb-table-of-content-nav.kb-table-of-content-id301_57bb0b-ce .kb-table-of-contents-title-wrap{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kb-table-of-content-nav.kb-table-of-content-id301_57bb0b-ce .kb-table-of-contents-title-wrap{color:#9b9958;}.kb-table-of-content-nav.kb-table-of-content-id301_57bb0b-ce .kb-table-of-contents-title{color:#9b9958;font-size:35px;line-height:5px;font-family:'Crimson Text';font-weight:400;font-style:normal;}.kb-table-of-content-nav.kb-table-of-content-id301_57bb0b-ce .kb-table-of-content-wrap .kb-table-of-content-list{color:#cef8a9;font-size:22px;font-style:normal;margin-top:var(--global-kb-spacing-sm, 1.5rem);margin-right:0px;margin-bottom:0px;margin-left:0px;}.kb-table-of-content-nav.kb-table-of-content-id301_57bb0b-ce .kb-table-of-content-wrap .kb-table-of-content-list .kb-table-of-contents__entry:hover{color:var(--global-palette2, #2B6CB0);}<\/style><\/div><\/div>\n\n<\/div><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"context\">Contexte<\/h2>\n\n\n\n<p class=\"translation-block\">Dans ce projet, j\u2019ai int\u00e9gr\u00e9 ESN Data (fictif), une soci\u00e9t\u00e9 de services num\u00e9riques, en tant que consultante junior en Business Intelligence. Ma mission \u00e9tait de collaborer avec Mehdi, un consultant senior, sur un projet pour le client Primero Bank (fictif).\nLa banque faisait face \u00e0 une hausse pr\u00e9occupante du taux d\u2019attrition de ses clients. L'objectif de la mission \u00e9tait d'analyser les donn\u00e9es client pour identifier les causes des d\u00e9parts et anticiper les futurs d\u00e9sengagements, afin d\u2019aider la direction commerciale \u00e0 prendre des d\u00e9cisions \u00e9clair\u00e9es.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Datasets<\/h2>\n\n\n\n<p class=\"translation-block\">Source : Donn\u00e9es extraites du logiciel de gestion commerciale de Primero Bank.\nNature : Informations client (profils, historique, comportement d\u2019utilisation, statut de d\u00e9part ou fid\u00e9lit\u00e9).\nVolume : Jeu de donn\u00e9es couvrant l\u2019ensemble des clients (10127\u202fenregistrements, 15\u202fattributs cl\u00e9s), suffisamment cons\u00e9quent pour n\u00e9cessiter l\u2019utilisation de filtres, tableaux crois\u00e9s dynamiques et statistiques descriptives<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Workflow<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Exploration et pr\u00e9paration des donn\u00e9es dans Excel\u202f: tris, filtres, cr\u00e9ation de colonnes calcul\u00e9es et v\u00e9rification d\u2019int\u00e9grit\u00e9.<\/li>\n\n\n\n<li>Analyse descriptive via tableaux crois\u00e9s dynamiques pour comparer les profils clients perdus vs restants.<\/li>\n\n\n\n<li>Conception de visualisations appropri\u00e9es selon la situation (histogrammes, camemberts, graphiques combin\u00e9s, graphiques en anneau) et bonnes pratiques d\u2019accessibilit\u00e9 (WebAIM Contrast Checker, Microsoft\u202fAccessibility).<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Insights<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Taux de churn global: 16\u202f% des clients ont quitt\u00e9 la banque r\u00e9cemment.<\/li>\n\n\n\n<li>Profil des churners vs restants:\n<ul class=\"wp-block-list\">\n<li>Mariage\u202f: 57\u202f% des churners \u00e9taient mari\u00e9s vs 43\u202f% des restants (+14\u202f%).<\/li>\n\n\n\n<li>Personnes \u00e0 charge\u202f: les churners mari\u00e9s ont en moyenne une personne \u00e0 charge de plus que les autres.<\/li>\n\n\n\n<li>Revenus\u202f: pr\u00e8s de 50\u202f% des churners ont un revenu annuel entre 40\u202f000\u202f\u20ac et 80\u202f000\u202f\u20ac (vs 31\u202f% pour l\u2019ensemble).<\/li>\n\n\n\n<li>Cr\u00e9dit renouvel\u00e9\u202f: les churners renouvellent en moyenne moins de cr\u00e9dit que les clients restants.<\/li>\n\n\n\n<li>Inactivit\u00e9\u202f: les churners restent inactifs 1\u202fmois de plus en moyenne que les clients restants.<\/li>\n\n\n\n<li>Service client\u202f: 60\u202f% des churners contactent plus fr\u00e9quemment le service client, signe possible d\u2019insatisfaction.<\/li>\n\n\n\n<li>Carte Platinum\u202f: malgr\u00e9 les d\u00e9faut de cette carte, seuls 0,1\u202f% des clients perdus d\u00e9tenaient la carte Platinum.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Segments \u00e0 risque\u202f: j\u2019ai identifi\u00e9 les clients peu actifs (1\u202f803) et les couples avec enfants (1\u202f552) comme priorit\u00e9s pour des actions de r\u00e9tention.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Business Impact<\/h2>\n\n\n\n<p class=\"translation-block\">J\u2019ai produit un rapport d\u2019analyse structur\u00e9, valid\u00e9 par Mehdi, et une pr\u00e9sentation claire de 15 slides destin\u00e9e \u00e0 Paola, la directrice marketing de la banque.<\/p>\n\n\n\n<p>Mon travail a permis de :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"translation-block\">Identifier des profils \u00e0 risque, permettant \u00e0 l\u2019\u00e9quipe de mettre en place des actions cibl\u00e9es de fid\u00e9lisation.<\/li>\n\n\n\n<li class=\"translation-block\">Pr\u00e9senter des visualisations accessibles facilitant la compr\u00e9hension des donn\u00e9es par des non-experts.<\/li>\n\n\n\n<li class=\"translation-block\">Sensibiliser \u00e0 l\u2019importance de la data visualisation dans la communication business.<\/li>\n<\/ul>\n\n\n\n<p>\u00c0 partir de ces insights, j\u2019ai formul\u00e9 et pr\u00e9sent\u00e9 \u00e0 Paola plusieurs recommandations op\u00e9rationnelles:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Revoir les services et avantages li\u00e9s \u00e0 la carte Platinum pour en am\u00e9liorer l\u2019attractivit\u00e9.<\/li>\n\n\n\n<li>D\u00e9velopper des offres cibl\u00e9es pour les familles (couples avec enfants).<\/li>\n\n\n\n<li>Mettre en place un suivi et des relances automatis\u00e9es pour les clients inactifs afin de r\u00e9engager leur int\u00e9r\u00eat.<\/li>\n\n\n\n<li>Cr\u00e9er un programme d\u00e9di\u00e9 aux clients \u00e0 haut potentiel d\u2019investissement pour renforcer leur fid\u00e9lit\u00e9.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Links<\/h2>\n\n\n\n<p><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P2\/Governatori_Giulia_1_rapport_analyse_112024.pdf\" data-type=\"link\" data-id=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P2\/Governatori_Giulia_1_rapport_analyse_112024.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Rapport d'analyse<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P2\/P2_presentation_GG.pdf\" data-type=\"link\" data-id=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P2\/P2_presentation_GG.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Pr\u00e9sentation PDF<\/a><\/p>\n\n\n<style>.kadence-column311_6aa044-75 > .kt-inside-inner-col{display:flex;}.kadence-column311_6aa044-75{max-width:1140px;margin-left:auto;margin-right:auto;}.wp-block-kadence-column.kb-section-dir-horizontal:not(.kb-section-md-dir-vertical)>.kt-inside-inner-col>.kadence-column311_6aa044-75{-webkit-flex:0 1 1140px;flex:0 1 1140px;max-width:unset;margin-left:unset;margin-right:unset;}.kadence-column311_6aa044-75 > .kt-inside-inner-col,.kadence-column311_6aa044-75 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column311_6aa044-75 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column311_6aa044-75 > .kt-inside-inner-col{flex-direction:column;align-items:center;}.kadence-column311_6aa044-75 > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column311_6aa044-75 > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column311_6aa044-75 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column311_6aa044-75 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column311_6aa044-75{position:relative;}@media all and (min-width: 1025px){.wp-block-kadence-column.kb-section-dir-horizontal>.kt-inside-inner-col>.kadence-column311_6aa044-75{-webkit-flex:0 1 1140px;flex:0 1 1140px;max-width:unset;margin-left:unset;margin-right:unset;}}@media all and (max-width: 1024px){.kadence-column311_6aa044-75 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}}@media all and (max-width: 767px){.wp-block-kadence-column.kb-section-sm-dir-vertical:not(.kb-section-sm-dir-horizontal):not(.kb-section-sm-dir-specificity)>.kt-inside-inner-col>.kadence-column311_6aa044-75{max-width:1140px;-webkit-flex:1;flex:1;margin-left:auto;margin-right:auto;}.kadence-column311_6aa044-75 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column311_6aa044-75\"><div class=\"kt-inside-inner-col\">\n<style>\n  .project-select-wrapper {\n    display: flex;\n    align-items: center;\n    gap: 0.5rem;\n    font-family: 'Roboto Mono', monospace;\n    position: relative;\n  }\n\n  .project-select-wrapper label {\n    font-weight: 600;\n    margin: 0;\n    white-space: nowrap; \/* Ne passe pas \u00e0 la ligne *\/\n  }\n\n  .custom-select {\n    font-family: 'Roboto Mono', monospace;\n    font-size: 1rem;\n    font-weight: 700;\n    padding: 0.5rem 0.8rem;\n    border: 1px solid #fff;\n    border-radius: 6px;\n    background: transparent;\n    color: #fff;\n    cursor: pointer;\n    min-width: 90px; \/* juste suffisant pour le texte \"Select\" *\/\n  }\n.custom-select:focus,\n.custom-select:active,\n.custom-select:hover {\n    border: 1px solid #FF678D!important;\n    background: transparent!important;\n    color: #FF678D!important;\n}\n\n  .dropdown-menu {\n    margin-bottom: 5px;\n    position: absolute;\n    bottom: 100%;\n    left: 0;\n    background: #9b9958;\n    border-radius: 6px;\n    display: none;\n    flex-direction: column;\n    z-index: 100;\n    white-space: nowrap;\n  }\n\n  .dropdown-menu a {\n    display: block;\n    padding: 0.5rem 0.8rem;\n    color: #7D0202;\n    text-decoration: none;\n  }\n\n  .dropdown-menu a:hover {\n    background: #7D0202;\n    color: #fff;\n  }\n\n  .project-select-wrapper.open .dropdown-menu {\n    display: flex;\n  }\n<\/style>\n\n<div class=\"project-select-wrapper\">\n  <label for=\"project-toggle\">Voir les autres projets<\/label>\n  <button id=\"project-toggle\" class=\"custom-select\" type=\"button\">S\u00e9lectionner<\/button>\n  <div class=\"dropdown-menu\">\n    <a href=\"\/fr\/projects\/real%E2%80%91estate-price-prediction\/\">Analyser l\u2019\u00e9volution des prix \u2028de l\u2019immobilier avec Python<\/a>\n    <a href=\"\/fr\/projects\/market-segmentation-aaa-strategy-uoi-games\/\">Segmentation du march\u00e9 et strat\u00e9gie AAA<\/a>\n    <a href=\"\/fr\/projects\/portfolio-creation-documentation\/\">Cr\u00e9er mon portfolio de professionnel de la data<\/a>\n    <a href=\"\/fr\/projects\/the-hidden-realities-of-animation-in-france\/\">Sondage personnel : les r\u00e9alit\u00e9s cach\u00e9es de l'animation en France<\/a>\n    <a href=\"\/fr\/projects\/power-bi-project-dashboard-sanitoral\/\">Cr\u00e9er un tableau de bord dynamique avec PowerBI<\/a>\n    <a href=\"\/fr\/projects\/stock-management-data-cleaning-bottleneck\/\">Optimiser la gestion &amp; nettoyez les donn\u00e9es \u2028du stock d'une boutique<\/a>\n    <a href=\"\/fr\/projects\/sales-dashboard-recs-bottleneck\/\">Am\u00e9liorez les performances de l'entreprise<\/a>\n    <a href=\"\/fr\/projects\/customer-satisfaction-tracking-bestmarket\/\">Manipuler une base de donn\u00e9es avec SQL pour suivre la satisfaction client<\/a>\n    <a href=\"\/fr\/projects\/gdpr%E2%80%91compliant-data-collection\/\">Collecter des donn\u00e9es \u2028en respectant les normes RGPD<\/a>\n    <a href=\"\/fr\/projects\/analyze-customer-churn\/\">Visualiser des donn\u00e9es avec Excel<\/a>\n    <a href=\"\/fr\/projects\/sql-practice-housing-insurance\/\">Requ\u00eater une base de donn\u00e9es avec SQL<\/a>\n    <a href=\"\/fr\/projects\/analysis-of-my-business-intelligence-analyst-training\/\">Analyse de ma formation de Business Intelligence Analyst<\/a>\n  <\/div>\n<\/div>\n\n<script>\n  const toggle = document.getElementById('project-toggle');\n  const wrapper = document.querySelector('.project-select-wrapper');\n\n  toggle.addEventListener('click', () => {\n    wrapper.classList.toggle('open');\n  });\n\n  document.addEventListener('click', (e) => {\n    if (!wrapper.contains(e.target)) {\n      wrapper.classList.remove('open');\n    }\n  });\n\n  document.querySelectorAll('.dropdown-menu a').forEach(link => {\n    link.addEventListener('click', () => {\n      window.location.href = link.href;\n    });\n  });\n<\/script>\n\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Bank &#8211; ESN Data (Openclassroom) Fictional | 27\/11\/2024 &gt; 13\/12\/2024 Context In this project, I joined ESN Data (fictitious), an IT consulting firm, as a junior Business Intelligence consultant. My mission was to collaborate with Mehdi, a senior consultant, on a project for the client Primero Bank (fictitious).The bank was facing a concerning increase in&#8230;<\/p>","protected":false},"featured_media":281,"menu_order":10,"template":"","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":""},"categories":[16,8,4,5,29,18,15,6,9],"class_list":["post-301","projects","type-projects","status-publish","has-post-thumbnail","hentry","category-cohort-retention-analysis","category-data-cleaning","category-data-methods","category-data-tools","category-dax","category-excel","category-kpi-tracking","category-languages","category-statistical-analysis"],"_links":{"self":[{"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/projects\/301","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/projects"}],"about":[{"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/types\/projects"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/media\/281"}],"wp:attachment":[{"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/media?parent=301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/categories?post=301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}