{"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\">Stock Management &amp; Data Cleaning<\/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\">Fictional<\/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\"   role=\"button\" aria-haspopup=\"dialog\"><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\"   role=\"button\" aria-haspopup=\"dialog\"><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\"   role=\"button\" aria-haspopup=\"dialog\"><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\"   role=\"button\" aria-haspopup=\"dialog\"><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\"   role=\"button\" aria-haspopup=\"dialog\"><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\">Context<\/h2>\n\n\n\n<p>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.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Datasets<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>ERP export (CSV): product reference, purchase price, selling price, stock status as of October 31 (825 rows \u00d7 6 columns)<\/li>\n\n\n\n<li>Website export (CSV): SKU, quantity sold from October 1 to 31, 2020, titles, categories, availability (1,513 rows \u00d7 29 columns)<\/li>\n\n\n\n<li>Mapping table (CSV): match between ERP PRODUCT_ID and website SKU (825 rows \u00d7 2 columns)<\/li>\n\n\n\n<li>Final aggregated dataset: 825 rows \u00d7 35 columns, enriched with flag columns (negative values, missing data, error counts)<\/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>Jupyter Notebook\/Python environment (pandas, numpy, scipy) for ETL and EDA<\/li>\n\n\n\n<li>Merging of the three sources via joins; duplicate detection and aggregation on <code>TOTAL_SALES<\/code><\/li>\n\n\n\n<li>Inconsistency handling:\n<ul class=\"wp-block-list\">\n<li>Negative values converted to NaN and flagged<\/li>\n\n\n\n<li>Missing values identified and counted<\/li>\n\n\n\n<li>Missing SKUs resolved via price\/availability match<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Univariate analysis: price distribution, outlier detection (IQR, z-score)<\/li>\n\n\n\n<li>Multivariate analysis: revenue per product, 20\/80 ranking, stock turnover (months_available), stock value (STOCK_QUANTITY \u00d7 PURCHASE_PRICE), margin rate, correlation analysis (heatmap)<\/li>\n\n\n\n<li>Exploratory visualizations integrated into the notebook to support findings<\/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 initial duplicates, consolidated using business rules (aggregation or priority)<\/li>\n\n\n\n<li>36 outliers detected via z-score, 16 via IQR; average price: \u20ac32.35 (standard deviation: \u20ac26.62)<\/li>\n\n\n\n<li>Total revenue: \u20ac154,623 (excluding outliers: \u20ac146,028); top 20 items generate 80% of revenue (59% of website catalog)<\/li>\n\n\n\n<li>Stock valuation: \u20ac298,628 immobilized across 17,822 units in stock<\/li>\n\n\n\n<li>Average margin rate by category, including identification of negative-margin products<\/li>\n\n\n\n<li>Correlations: CA_par_article\u2194TOTAL_SALES (0,60), PRICE\u2194TOTAL_SALES (0,25), PRICE\u2194CA_par_article (0,33)\u202f; Volume is more decisive than price<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Business Impact<\/h2>\n\n\n\n<p>Thanks to this work, BottleNeck now has:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A reliable, traceable dataset for any future visualization project<\/li>\n\n\n\n<li>A clear understanding of key strategic products (20\/80 rule) to optimize the catalog<\/li>\n\n\n\n<li>Concrete recommendations: adjust prices of best-sellers, progressively reduce prices of slow-moving stock, fix missing SKUs, maintain data quality<\/li>\n\n\n\n<li>A reproducible ETL protocol to ensure ongoing reliability and traceability<\/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\">Presentation<\/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\">See other projects<\/label>\n  <button id=\"project-toggle\" class=\"custom-select\" type=\"button\">Select<\/button>\n  <div class=\"dropdown-menu\">\n    <a href=\"\/projects\/real%E2%80%91estate-price-prediction\/\">Real-Estate Price Prediction<\/a>\n    <a href=\"\/projects\/market-segmentation-aaa-strategy-uoi-games\/\">Market Segmentation &#038; AAA Strategy<\/a>\n    <a href=\"\/projects\/portfolio-creation-documentation\/\">Portfolio Creation &#038; Documentation<\/a>\n    <a href=\"\/projects\/the-hidden-realities-of-animation-in-france\/\">Personal survey: \u201cthe Hidden Realities of Animation in France\u201d<\/a>\n    <a href=\"\/projects\/power-bi-project-dashboard-sanitoral\/\">Power BI Project Dashboard<\/a>\n    <a href=\"\/projects\/stock-management-data-cleaning-bottleneck\/\">Stock Management &#038; Data Cleaning<\/a>\n    <a href=\"\/projects\/sales-dashboard-recs-bottleneck\/\">Dashboard &#038; Business Recommandations<\/a>\n    <a href=\"\/projects\/customer-satisfaction-tracking-bestmarket\/\">Customer Satisfaction Tracking<\/a>\n    <a href=\"\/projects\/gdpr%E2%80%91compliant-data-collection\/\">GDPR-Compliant Data Collection<\/a>\n    <a href=\"\/projects\/analyze-customer-churn\/\">Analyze Customer Churn<\/a>\n    <a href=\"\/projects\/sql-practice-housing-insurance\/\">SQL Practice : Housing Insurance<\/a>\n    <a href=\"\/projects\/analysis-of-my-business-intelligence-analyst-training\/\">Analysis of my Business Intelligence Analyst training<\/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>\n","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}]}}