{"id":305,"date":"2025-07-27T22:24:28","date_gmt":"2025-07-27T20:24:28","guid":{"rendered":"https:\/\/giulia-governatori.alwaysdata.net\/?post_type=projects&#038;p=305"},"modified":"2025-08-13T17:08:08","modified_gmt":"2025-08-13T15:08:08","slug":"stock-management-data-cleaning-bottleneck","status":"publish","type":"projects","link":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/projects\/stock-management-data-cleaning-bottleneck\/","title":{"rendered":"Optimiser la gestion &amp; nettoyez les donn\u00e9es \u2028du stock d'une boutique"},"content":{"rendered":"<style>.kadence-column305_d027ec-58 > .kt-inside-inner-col,.kadence-column305_d027ec-58 > .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-column305_d027ec-58 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column305_d027ec-58 > .kt-inside-inner-col{flex-direction:column;}.kadence-column305_d027ec-58 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column305_d027ec-58 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column305_d027ec-58{position:relative;}.kadence-column305_d027ec-58, .kt-inside-inner-col > .kadence-column305_d027ec-58:not(.specificity){margin-top:30px;margin-bottom:30px;}@media all and (max-width: 1024px){.kadence-column305_d027ec-58 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column305_d027ec-58 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column305_d027ec-58\"><div class=\"kt-inside-inner-col\"><style>.kb-row-layout-id305_37546a-19 > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id305_37546a-19 > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id305_37546a-19 > .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-id305_37546a-19 > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}.kb-row-layout-id305_37546a-19 > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}.kb-row-layout-id305_37546a-19 > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id305_37546a-19 > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}}@media all and (max-width: 1024px){.kb-row-layout-id305_37546a-19 > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}@media all and (max-width: 767px){.kb-row-layout-id305_37546a-19 > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}.kb-row-layout-id305_37546a-19 > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}<\/style><div class=\"kb-row-layout-wrap kb-row-layout-id305_37546a-19 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-column305_d8b562-11 > .kt-inside-inner-col,.kadence-column305_d8b562-11 > .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-column305_d8b562-11 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column305_d8b562-11 > .kt-inside-inner-col{flex-direction:column;}.kadence-column305_d8b562-11 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column305_d8b562-11 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column305_d8b562-11{position:relative;}@media all and (max-width: 1024px){.kadence-column305_d8b562-11 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column305_d8b562-11 > .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-column305_d8b562-11\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading305_d4e45f-d6, .wp-block-kadence-advancedheading.kt-adv-heading305_d4e45f-d6[data-kb-block=\"kb-adv-heading305_d4e45f-d6\"]{font-size:var(--global-kb-font-size-sm, 0.9rem);font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading305_d4e45f-d6 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading305_d4e45f-d6[data-kb-block=\"kb-adv-heading305_d4e45f-d6\"] 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-heading305_d4e45f-d6 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading305_d4e45f-d6[data-kb-block=\"kb-adv-heading305_d4e45f-d6\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading305_d4e45f-d6 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading305_d4e45f-d6\">E-commerce &#8211; BottleNeck (Openclassroom)<\/p>\n<\/div><\/div>\n\n\n<style>.kadence-column305_547e51-08 > .kt-inside-inner-col{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kadence-column305_547e51-08 > .kt-inside-inner-col,.kadence-column305_547e51-08 > .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-column305_547e51-08 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column305_547e51-08 > .kt-inside-inner-col{flex-direction:column;}.kadence-column305_547e51-08 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column305_547e51-08 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column305_547e51-08{position:relative;}.kadence-column305_547e51-08, .kt-inside-inner-col > .kadence-column305_547e51-08:not(.specificity){margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;}@media all and (max-width: 1024px){.kadence-column305_547e51-08 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column305_547e51-08 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column305_547e51-08\"><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\">Optimiser la gestion &amp; nettoyez les donn\u00e9es \u2028du stock d'une boutique<\/h1><\/div><\/div>\n\n\n<style>.kadence-column305_bab0d0-b1 > .kt-inside-inner-col{display:flex;}.kadence-column305_bab0d0-b1 > .kt-inside-inner-col{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kadence-column305_bab0d0-b1 > .kt-inside-inner-col,.kadence-column305_bab0d0-b1 > .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-column305_bab0d0-b1 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column305_bab0d0-b1 > .kt-inside-inner-col{flex-direction:column;align-items:flex-start;}.kadence-column305_bab0d0-b1 > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column305_bab0d0-b1 > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column305_bab0d0-b1 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column305_bab0d0-b1 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column305_bab0d0-b1{position:relative;}@media all and (max-width: 1024px){.kadence-column305_bab0d0-b1 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}@media all and (max-width: 767px){.kadence-column305_bab0d0-b1 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column305_bab0d0-b1\"><div class=\"kt-inside-inner-col\"><style>.kb-row-layout-wrap.wp-block-kadence-rowlayout.kb-row-layout-id305_8f51e4-34{margin-top:0px;margin-bottom:0px;}.kb-row-layout-id305_8f51e4-34 > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id305_8f51e4-34 > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id305_8f51e4-34 > .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-id305_8f51e4-34 > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id305_8f51e4-34 > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}}@media all and (max-width: 1024px){.kb-row-layout-id305_8f51e4-34 > .kt-row-column-wrap{grid-template-columns:repeat(3, minmax(0, 1fr));}}@media all and (max-width: 767px){.kb-row-layout-id305_8f51e4-34 > .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-id305_8f51e4-34 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-column305_3053e5-9c > .kt-inside-inner-col{display:flex;}.kadence-column305_3053e5-9c > .kt-inside-inner-col,.kadence-column305_3053e5-9c > .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-column305_3053e5-9c > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column305_3053e5-9c > .kt-inside-inner-col{flex-direction:column;align-items:flex-start;}.kadence-column305_3053e5-9c > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column305_3053e5-9c > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column305_3053e5-9c > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column305_3053e5-9c > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column305_3053e5-9c{position:relative;}@media all and (max-width: 1024px){.kadence-column305_3053e5-9c > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}@media all and (max-width: 767px){.kadence-column305_3053e5-9c > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column305_3053e5-9c\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading305_d38be9-aa, .wp-block-kadence-advancedheading.kt-adv-heading305_d38be9-aa[data-kb-block=\"kb-adv-heading305_d38be9-aa\"]{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-heading305_d38be9-aa mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading305_d38be9-aa[data-kb-block=\"kb-adv-heading305_d38be9-aa\"] 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-heading305_d38be9-aa img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading305_d38be9-aa[data-kb-block=\"kb-adv-heading305_d38be9-aa\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading305_d38be9-aa wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading305_d38be9-aa\">Fictif<\/p>\n<\/div><\/div>\n\n\n<style>.kadence-column305_55f939-ba > .kt-inside-inner-col,.kadence-column305_55f939-ba > .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-column305_55f939-ba > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column305_55f939-ba > .kt-inside-inner-col{flex-direction:column;}.kadence-column305_55f939-ba > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column305_55f939-ba > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column305_55f939-ba{position:relative;}@media all and (max-width: 1024px){.kadence-column305_55f939-ba > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column305_55f939-ba > .kt-inside-inner-col{display:flex;flex-direction:column;justify-content:center;align-items:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column305_55f939-ba\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading305_8afab2-50, .wp-block-kadence-advancedheading.kt-adv-heading305_8afab2-50[data-kb-block=\"kb-adv-heading305_8afab2-50\"]{font-size:var(--global-kb-font-size-sm, 0.9rem);font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading305_8afab2-50 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading305_8afab2-50[data-kb-block=\"kb-adv-heading305_8afab2-50\"] 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-heading305_8afab2-50 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading305_8afab2-50[data-kb-block=\"kb-adv-heading305_8afab2-50\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading305_8afab2-50 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading305_8afab2-50\">|<\/p>\n<\/div><\/div>\n\n\n<style>.kadence-column305_eb1fa5-ea > .kt-inside-inner-col,.kadence-column305_eb1fa5-ea > .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-column305_eb1fa5-ea > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column305_eb1fa5-ea > .kt-inside-inner-col{flex-direction:column;}.kadence-column305_eb1fa5-ea > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column305_eb1fa5-ea > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column305_eb1fa5-ea{position:relative;}@media all and (max-width: 1024px){.kadence-column305_eb1fa5-ea > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column305_eb1fa5-ea > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column305_eb1fa5-ea\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading305_c1494a-a9, .wp-block-kadence-advancedheading.kt-adv-heading305_c1494a-a9[data-kb-block=\"kb-adv-heading305_c1494a-a9\"]{text-align:left;font-size:var(--global-kb-font-size-sm, 0.9rem);font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading305_c1494a-a9 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading305_c1494a-a9[data-kb-block=\"kb-adv-heading305_c1494a-a9\"] 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-heading305_c1494a-a9 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading305_c1494a-a9[data-kb-block=\"kb-adv-heading305_c1494a-a9\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading305_c1494a-a9 project-dates wp-block-kadence-advancedheading has-theme-palette-5-color has-text-color\" data-kb-block=\"kb-adv-heading305_c1494a-a9\">01\/02\/2025 &gt; 09\/03\/2025<\/p>\n<\/div><\/div>\n\n<\/div><\/div><\/div><\/div>\n\n\n<style>.kadence-column305_350e9f-0a > .kt-inside-inner-col,.kadence-column305_350e9f-0a > .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-column305_350e9f-0a > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column305_350e9f-0a > .kt-inside-inner-col{flex-direction:column;}.kadence-column305_350e9f-0a > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column305_350e9f-0a > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column305_350e9f-0a{position:relative;}@media all and (max-width: 1024px){.kadence-column305_350e9f-0a > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column305_350e9f-0a > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column305_350e9f-0a\"><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-column305_0d41f8-b9 > .kt-inside-inner-col{display:flex;}.kadence-column305_0d41f8-b9 > .kt-inside-inner-col,.kadence-column305_0d41f8-b9 > .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-column305_0d41f8-b9 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column305_0d41f8-b9 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}.kadence-column305_0d41f8-b9 > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column305_0d41f8-b9 > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column305_0d41f8-b9 > .kt-inside-inner-col > .aligncenter{width:100%;}.kt-row-column-wrap > .kadence-column305_0d41f8-b9{align-self:center;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column305_0d41f8-b9{align-self:auto;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column305_0d41f8-b9 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}.kadence-column305_0d41f8-b9 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column305_0d41f8-b9{position:relative;}.kadence-column305_0d41f8-b9, .kt-inside-inner-col > .kadence-column305_0d41f8-b9:not(.specificity){margin-top:30px;margin-bottom:0px;}@media all and (max-width: 1024px){.kt-row-column-wrap > .kadence-column305_0d41f8-b9{align-self:center;}}@media all and (max-width: 1024px){.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column305_0d41f8-b9{align-self:auto;}}@media all and (max-width: 1024px){.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column305_0d41f8-b9 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 1024px){.kadence-column305_0d41f8-b9 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}}@media all and (max-width: 767px){.kt-row-column-wrap > .kadence-column305_0d41f8-b9{align-self:center;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column305_0d41f8-b9{align-self:auto;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column305_0d41f8-b9 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}.kadence-column305_0d41f8-b9 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column305_0d41f8-b9\"><div class=\"kt-inside-inner-col\"><style>.kb-row-layout-id305_240417-30 > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id305_240417-30 > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id305_240417-30 > .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-id305_240417-30 > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id305_240417-30 > .kt-row-column-wrap{grid-template-columns:minmax(0, 2fr) minmax(0, 1fr);}}@media all and (max-width: 767px){.kb-row-layout-id305_240417-30 > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}<\/style><div class=\"kb-row-layout-wrap kb-row-layout-id305_240417-30 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-column305_319f3f-84 > .kt-inside-inner-col,.kadence-column305_319f3f-84 > .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-column305_319f3f-84 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column305_319f3f-84 > .kt-inside-inner-col{flex-direction:column;}.kadence-column305_319f3f-84 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column305_319f3f-84 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column305_319f3f-84{position:relative;}@media all and (max-width: 1024px){.kadence-column305_319f3f-84 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column305_319f3f-84 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column305_319f3f-84\"><div class=\"kt-inside-inner-col\"><style>.kb-gallery-id-305_756680-a3.kb-gallery-ul.kb-gallery-type-fluidcarousel .kt-blocks-carousel figure .kb-gal-image-radius, .kb-gallery-id-305_756680-a3.kb-gallery-ul.kb-gallery-type-fluidcarousel .kt-blocks-carousel figure .kb-gal-image-radius img{height:350px;}.kb-gallery-id-305_756680-a3 .kadence-blocks-gallery-item .kb-gal-image-radius, .kb-gallery-id-305_756680-a3 .kb-slide-item .kb-gal-image-radius img{border-radius:0px 0px 0px 0px;;}.kb-gallery-wrap-id-305_756680-a3.wp-block-kadence-advancedgallery{overflow:visible;}.kb-gallery-wrap-id-305_756680-a3.wp-block-kadence-advancedgallery .kt-blocks-carousel{overflow:visible;max-width:100%;}.kb-gallery-id-305_756680-a3 .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-305_756680-a3 .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-305_756680-a3 alignnone wp-block-kadence-advancedgallery\"><div class=\"kb-gallery-ul kb-gallery-non-static kb-gallery-type-fluidcarousel kb-gallery-id-305_756680-a3 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\/P6_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\/P6_1.webp\" width=\"1334\" height=\"753\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_1.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_1.webp\" data-id=\"874\" class=\"wp-image-874 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_1.webp 1334w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_1-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_1-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_1-768x434.webp 768w\" sizes=\"auto, (max-width: 1334px) 100vw, 1334px\" \/><\/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\/P6_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\/P6_2.webp\" width=\"1334\" height=\"753\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_2.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_2.webp\" data-id=\"875\" class=\"wp-image-875 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_2.webp 1334w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_2-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_2-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_2-768x434.webp 768w\" sizes=\"auto, (max-width: 1334px) 100vw, 1334px\" \/><\/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\/P6_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\/P6_3.webp\" width=\"1334\" height=\"753\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_3.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_3.webp\" data-id=\"876\" class=\"wp-image-876 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_3.webp 1334w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_3-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_3-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_3-768x434.webp 768w\" sizes=\"auto, (max-width: 1334px) 100vw, 1334px\" \/><\/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\/P6_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\/P6_4.webp\" width=\"1334\" height=\"753\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_4.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_4.webp\" data-id=\"877\" class=\"wp-image-877 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_4.webp 1334w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_4-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_4-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_4-768x434.webp 768w\" sizes=\"auto, (max-width: 1334px) 100vw, 1334px\" \/><\/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\/P6_5.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\/P6_5.webp\" width=\"1334\" height=\"753\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_5.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_5.webp\" data-id=\"878\" class=\"wp-image-878 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_5.webp 1334w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_5-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_5-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P6_5-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-column305_55f612-70 > .kt-inside-inner-col,.kadence-column305_55f612-70 > .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-column305_55f612-70 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column305_55f612-70 > .kt-inside-inner-col{flex-direction:column;}.kadence-column305_55f612-70 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column305_55f612-70 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column305_55f612-70{position:relative;}@media all and (max-width: 1024px){.kadence-column305_55f612-70 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column305_55f612-70 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column305_55f612-70\"><div class=\"kt-inside-inner-col\"><style>.kb-table-of-content-nav.kb-table-of-content-id305_8c9e18-04 .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-id305_8c9e18-04 .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-id305_8c9e18-04 .kb-table-of-contents-title-wrap{color:#9b9958;}.kb-table-of-content-nav.kb-table-of-content-id305_8c9e18-04 .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-id305_8c9e18-04 .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-id305_8c9e18-04 .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\">Contexte<\/h2>\n\n\n\n<p>J\u2019ai rejoint BottleNeck (fictif), marchand de vin, sur une mission pilot\u00e9e par Nicolas (responsable des ventes) afin d\u2019optimiser la gestion commerciale et le stock. Mon r\u00f4le a consist\u00e9 \u00e0 agr\u00e9ger les exports ERP, site web et table de liaison, \u00e0 d\u00e9tecter et corriger les incoh\u00e9rences, puis \u00e0 fournir des analyses et des recommandations au comit\u00e9 de direction.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Datasets<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Extraction ERP (CSV)\u202f: r\u00e9f\u00e9rence produit, prix d\u2019achat, prix de vente, \u00e9tat du stock au 31\u202foctobre (825 lignes x 6 colonnes)<\/li>\n\n\n\n<li>Extraction site Web (CSV)\u202f: SKU, quantit\u00e9s vendues du 1er au\u202f31\u202foctobre 2020, titres, cat\u00e9gories, disponibilit\u00e9 (1513 lignes x 29 colonnes)<\/li>\n\n\n\n<li>Table de liaison (CSV)\u202f: correspondance entre PRODUCT_ID ERP et SKU Web (825 lignes x 2 colonnes)<\/li>\n\n\n\n<li>Dataset agr\u00e9g\u00e9 final\u202f: 825\u202flignes \u00d7\u202f35\u202fcolonnes, enrichi de colonnes de flag (valeurs n\u00e9gatives, vides, nombres d\u2019erreurs)<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Workflow<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Environnement Jupyter Notebook\/Python (pandas, numpy, scipy) pour l\u2019ETL et l\u2019EDA.<\/li>\n\n\n\n<li class=\"translation-block\">Fusion des trois sources par jointures\u202f; d\u00e9tection et sommation des doublons sur TOTAL_SALES.<\/li>\n\n\n\n<li>Traitement des incoh\u00e9rences \u202f:\n<ul class=\"wp-block-list\">\n<li>Valeurs n\u00e9gatives converties en NaN et flagg\u00e9es.<\/li>\n\n\n\n<li>Valeurs manquantes identifi\u00e9es et comptabilis\u00e9es.<\/li>\n\n\n\n<li>R\u00e9solution des SKU manquants par correspondance prix\/disponibilit\u00e9.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Analyses univari\u00e9es\u202f: distribution des prix, d\u00e9tection d\u2019outliers (IQR, z\u2011score).<\/li>\n\n\n\n<li>Analyses multivari\u00e9es\u202f: calcul du CA par produit, palmar\u00e8s 20\/80, rotation de stock (mois_disponibles), valorisation financi\u00e8re (STOCK_QUANTITY\u00d7PURCHASE_PRICE), taux de marge, corr\u00e9lations (heatmap).<\/li>\n\n\n\n<li>Visualisations exploratoires int\u00e9gr\u00e9es au notebook pour appuyer les conclusions.<\/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>714\u202fdoublons initiaux, consolid\u00e9s par r\u00e8gles m\u00e9tiers (sommation ou priorit\u00e9).<\/li>\n\n\n\n<li>36\u202foutliers d\u00e9tect\u00e9s via z\u2011score, 16 via IQR\u202f; prix moyen\u202f32,35\u202f\u20ac (\u00e9cart\u2011type\u202f26,62).<\/li>\n\n\n\n<li>CA total\u202f:\u202f154\u202f623\u202f\u20ac (hors outliers 146\u202f028\u202f\u20ac), top\u202f20 articles couvrant 80\u202f% du CA (59\u202f% du catalogue Web).<\/li>\n\n\n\n<li>Valorisation des stocks\u202f:\u202f298\u202f628\u202f\u20ac immobilis\u00e9s pour 17\u202f822\u202funit\u00e9s en stock.<\/li>\n\n\n\n<li>Taux de marge moyen par cat\u00e9gorie, identification de produits \u00e0 marge n\u00e9gative.<\/li>\n\n\n\n<li>Corr\u00e9lations\u202f: CA_par_article\u2194TOTAL_SALES (0,60), PRICE\u2194TOTAL_SALES (0,25), PRICE\u2194CA_par_article (0,33)\u202f; volume plus d\u00e9terminant que prix.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Business Impact<\/h2>\n\n\n\n<p>Gr\u00e2ce \u00e0 ce travail, BottleNeck dispose d\u00e9sormais \u202f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>D\u2019un dataset fiable et tra\u00e7able pour tout futur projet de visualisation.<\/li>\n\n\n\n<li>D\u2019une compr\u00e9hension pr\u00e9cise des r\u00e9f\u00e9rences strat\u00e9giques (20\/80) pour optimiser portefeuille.<\/li>\n\n\n\n<li>De recommandations concr\u00e8tes\u202f: ajuster les prix des best\u2011sellers, r\u00e9duire progressivement ceux des stocks lents, corriger les SKU manquants et maintenir la qualit\u00e9 des donn\u00e9es<\/li>\n\n\n\n<li>D\u2019un protocole ETL reproductible pour garantir la fiabilit\u00e9 et la tra\u00e7abilit\u00e9 des processus.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Links<\/h2>\n\n\n\n<p><a href=\"https:\/\/colab.research.google.com\/drive\/1N-jLWcfo5XjkQt6ob-dp20a5hf8V_JrA?usp=sharing\" data-type=\"link\" data-id=\"https:\/\/colab.research.google.com\/drive\/1N-jLWcfo5XjkQt6ob-dp20a5hf8V_JrA?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">Notebook (EDA)<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P6\/Governatori_Giulia_2_presentation_022025.pdf\" data-type=\"link\" data-id=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P6\/Governatori_Giulia_2_presentation_022025.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Pr\u00e9sentation<\/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>E-commerce &#8211; BottleNeck (Openclassroom) Fictional | 01\/02\/2025 &gt; 09\/03\/2025 Context I joined BottleNeck (fictional), a wine merchant, on a mission led by Nicolas (sales manager) to optimize stock and sales management. My role was to aggregate ERP, website, and mapping table exports, detect and fix inconsistencies, then deliver analyses and recommendations to the executive committee&#8230;.<\/p>","protected":false},"featured_media":289,"menu_order":6,"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":[8,35,4,5,7,19,15,6,32,33,9],"class_list":["post-305","projects","type-projects","status-publish","has-post-thumbnail","hentry","category-data-cleaning","category-data-gouvernance","category-data-methods","category-data-tools","category-exploratory-data-analysis","category-google-collab","category-kpi-tracking","category-languages","category-python","category-sql","category-statistical-analysis"],"_links":{"self":[{"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/projects\/305","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\/289"}],"wp:attachment":[{"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/media?parent=305"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/categories?post=305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}