{"id":315,"date":"2025-07-28T18:38:23","date_gmt":"2025-07-28T16:38:23","guid":{"rendered":"https:\/\/giulia-governatori.alwaysdata.net\/?post_type=projects&#038;p=315"},"modified":"2025-08-13T17:06:50","modified_gmt":"2025-08-13T15:06:50","slug":"sales-dashboard-recs-bottleneck","status":"publish","type":"projects","link":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/projects\/sales-dashboard-recs-bottleneck\/","title":{"rendered":"Am\u00e9liorez les performances de l'entreprise"},"content":{"rendered":"<style>.kadence-column315_374aec-ac > .kt-inside-inner-col,.kadence-column315_374aec-ac > .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-column315_374aec-ac > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column315_374aec-ac > .kt-inside-inner-col{flex-direction:column;}.kadence-column315_374aec-ac > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column315_374aec-ac > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column315_374aec-ac{position:relative;}.kadence-column315_374aec-ac, .kt-inside-inner-col > .kadence-column315_374aec-ac:not(.specificity){margin-top:30px;margin-bottom:30px;}@media all and (max-width: 1024px){.kadence-column315_374aec-ac > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column315_374aec-ac > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column315_374aec-ac\"><div class=\"kt-inside-inner-col\"><style>.kb-row-layout-id315_814a2e-29 > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id315_814a2e-29 > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id315_814a2e-29 > .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-id315_814a2e-29 > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}.kb-row-layout-id315_814a2e-29 > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}.kb-row-layout-id315_814a2e-29 > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id315_814a2e-29 > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}}@media all and (max-width: 1024px){.kb-row-layout-id315_814a2e-29 > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}@media all and (max-width: 767px){.kb-row-layout-id315_814a2e-29 > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}.kb-row-layout-id315_814a2e-29 > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}<\/style><div class=\"kb-row-layout-wrap kb-row-layout-id315_814a2e-29 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-column315_fc89c6-e8 > .kt-inside-inner-col,.kadence-column315_fc89c6-e8 > .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-column315_fc89c6-e8 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column315_fc89c6-e8 > .kt-inside-inner-col{flex-direction:column;}.kadence-column315_fc89c6-e8 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column315_fc89c6-e8 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column315_fc89c6-e8{position:relative;}@media all and (max-width: 1024px){.kadence-column315_fc89c6-e8 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column315_fc89c6-e8 > .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-column315_fc89c6-e8\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading315_c3fbca-e3, .wp-block-kadence-advancedheading.kt-adv-heading315_c3fbca-e3[data-kb-block=\"kb-adv-heading315_c3fbca-e3\"]{font-size:var(--global-kb-font-size-sm, 0.9rem);font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading315_c3fbca-e3 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading315_c3fbca-e3[data-kb-block=\"kb-adv-heading315_c3fbca-e3\"] 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-heading315_c3fbca-e3 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading315_c3fbca-e3[data-kb-block=\"kb-adv-heading315_c3fbca-e3\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading315_c3fbca-e3 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading315_c3fbca-e3\">E-commerce &#8211; Bottleneck (Openclassroom)<\/p>\n<\/div><\/div>\n\n\n<style>.kadence-column315_ceeaee-1c > .kt-inside-inner-col{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kadence-column315_ceeaee-1c > .kt-inside-inner-col,.kadence-column315_ceeaee-1c > .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-column315_ceeaee-1c > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column315_ceeaee-1c > .kt-inside-inner-col{flex-direction:column;}.kadence-column315_ceeaee-1c > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column315_ceeaee-1c > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column315_ceeaee-1c{position:relative;}.kadence-column315_ceeaee-1c, .kt-inside-inner-col > .kadence-column315_ceeaee-1c:not(.specificity){margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;}@media all and (max-width: 1024px){.kadence-column315_ceeaee-1c > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column315_ceeaee-1c > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column315_ceeaee-1c\"><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\">Am\u00e9liorez les performances de l'entreprise<\/h1><\/div><\/div>\n\n\n<style>.kadence-column315_651d53-b2 > .kt-inside-inner-col{display:flex;}.kadence-column315_651d53-b2 > .kt-inside-inner-col{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kadence-column315_651d53-b2 > .kt-inside-inner-col,.kadence-column315_651d53-b2 > .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-column315_651d53-b2 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column315_651d53-b2 > .kt-inside-inner-col{flex-direction:column;align-items:flex-start;}.kadence-column315_651d53-b2 > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column315_651d53-b2 > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column315_651d53-b2 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column315_651d53-b2 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column315_651d53-b2{position:relative;}@media all and (max-width: 1024px){.kadence-column315_651d53-b2 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}@media all and (max-width: 767px){.kadence-column315_651d53-b2 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column315_651d53-b2\"><div class=\"kt-inside-inner-col\"><style>.kb-row-layout-wrap.wp-block-kadence-rowlayout.kb-row-layout-id315_433ac0-e7{margin-top:0px;margin-bottom:0px;}.kb-row-layout-id315_433ac0-e7 > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id315_433ac0-e7 > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id315_433ac0-e7 > .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-id315_433ac0-e7 > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id315_433ac0-e7 > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}}@media all and (max-width: 1024px){.kb-row-layout-id315_433ac0-e7 > .kt-row-column-wrap{grid-template-columns:repeat(3, minmax(0, 1fr));}}@media all and (max-width: 767px){.kb-row-layout-id315_433ac0-e7 > .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-id315_433ac0-e7 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-column315_b32c53-d9 > .kt-inside-inner-col{display:flex;}.kadence-column315_b32c53-d9 > .kt-inside-inner-col,.kadence-column315_b32c53-d9 > .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-column315_b32c53-d9 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column315_b32c53-d9 > .kt-inside-inner-col{flex-direction:column;align-items:flex-start;}.kadence-column315_b32c53-d9 > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column315_b32c53-d9 > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column315_b32c53-d9 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column315_b32c53-d9 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column315_b32c53-d9{position:relative;}@media all and (max-width: 1024px){.kadence-column315_b32c53-d9 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}@media all and (max-width: 767px){.kadence-column315_b32c53-d9 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column315_b32c53-d9\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading315_6477f0-e7, .wp-block-kadence-advancedheading.kt-adv-heading315_6477f0-e7[data-kb-block=\"kb-adv-heading315_6477f0-e7\"]{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-heading315_6477f0-e7 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading315_6477f0-e7[data-kb-block=\"kb-adv-heading315_6477f0-e7\"] 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-heading315_6477f0-e7 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading315_6477f0-e7[data-kb-block=\"kb-adv-heading315_6477f0-e7\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading315_6477f0-e7 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading315_6477f0-e7\">Fictif<\/p>\n<\/div><\/div>\n\n\n<style>.kadence-column315_523508-76 > .kt-inside-inner-col,.kadence-column315_523508-76 > .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-column315_523508-76 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column315_523508-76 > .kt-inside-inner-col{flex-direction:column;}.kadence-column315_523508-76 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column315_523508-76 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column315_523508-76{position:relative;}@media all and (max-width: 1024px){.kadence-column315_523508-76 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column315_523508-76 > .kt-inside-inner-col{display:flex;flex-direction:column;justify-content:center;align-items:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column315_523508-76\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading315_df37b4-24, .wp-block-kadence-advancedheading.kt-adv-heading315_df37b4-24[data-kb-block=\"kb-adv-heading315_df37b4-24\"]{font-size:var(--global-kb-font-size-sm, 0.9rem);font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading315_df37b4-24 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading315_df37b4-24[data-kb-block=\"kb-adv-heading315_df37b4-24\"] 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-heading315_df37b4-24 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading315_df37b4-24[data-kb-block=\"kb-adv-heading315_df37b4-24\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading315_df37b4-24 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading315_df37b4-24\">|<\/p>\n<\/div><\/div>\n\n\n<style>.kadence-column315_bbeed1-b3 > .kt-inside-inner-col,.kadence-column315_bbeed1-b3 > .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-column315_bbeed1-b3 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column315_bbeed1-b3 > .kt-inside-inner-col{flex-direction:column;}.kadence-column315_bbeed1-b3 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column315_bbeed1-b3 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column315_bbeed1-b3{position:relative;}@media all and (max-width: 1024px){.kadence-column315_bbeed1-b3 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column315_bbeed1-b3 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column315_bbeed1-b3\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading315_de4bf6-f3, .wp-block-kadence-advancedheading.kt-adv-heading315_de4bf6-f3[data-kb-block=\"kb-adv-heading315_de4bf6-f3\"]{text-align:left;font-size:var(--global-kb-font-size-sm, 0.9rem);font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading315_de4bf6-f3 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading315_de4bf6-f3[data-kb-block=\"kb-adv-heading315_de4bf6-f3\"] 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-heading315_de4bf6-f3 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading315_de4bf6-f3[data-kb-block=\"kb-adv-heading315_de4bf6-f3\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading315_de4bf6-f3 project-dates wp-block-kadence-advancedheading has-theme-palette-5-color has-text-color\" data-kb-block=\"kb-adv-heading315_de4bf6-f3\">08\/05\/2025 &gt; 11\/06\/2025<\/p>\n<\/div><\/div>\n\n<\/div><\/div><\/div><\/div>\n\n\n<style>.kadence-column315_485f8f-25 > .kt-inside-inner-col,.kadence-column315_485f8f-25 > .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-column315_485f8f-25 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column315_485f8f-25 > .kt-inside-inner-col{flex-direction:column;}.kadence-column315_485f8f-25 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column315_485f8f-25 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column315_485f8f-25{position:relative;}@media all and (max-width: 1024px){.kadence-column315_485f8f-25 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column315_485f8f-25 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column315_485f8f-25\"><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-column315_c57e95-d5 > .kt-inside-inner-col{display:flex;}.kadence-column315_c57e95-d5 > .kt-inside-inner-col,.kadence-column315_c57e95-d5 > .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-column315_c57e95-d5 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column315_c57e95-d5 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}.kadence-column315_c57e95-d5 > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column315_c57e95-d5 > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column315_c57e95-d5 > .kt-inside-inner-col > .aligncenter{width:100%;}.kt-row-column-wrap > .kadence-column315_c57e95-d5{align-self:center;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column315_c57e95-d5{align-self:auto;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column315_c57e95-d5 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}.kadence-column315_c57e95-d5 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column315_c57e95-d5{position:relative;}.kadence-column315_c57e95-d5, .kt-inside-inner-col > .kadence-column315_c57e95-d5:not(.specificity){margin-top:30px;margin-bottom:0px;}@media all and (max-width: 1024px){.kt-row-column-wrap > .kadence-column315_c57e95-d5{align-self:center;}}@media all and (max-width: 1024px){.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column315_c57e95-d5{align-self:auto;}}@media all and (max-width: 1024px){.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column315_c57e95-d5 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 1024px){.kadence-column315_c57e95-d5 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}}@media all and (max-width: 767px){.kt-row-column-wrap > .kadence-column315_c57e95-d5{align-self:center;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column315_c57e95-d5{align-self:auto;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column315_c57e95-d5 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}.kadence-column315_c57e95-d5 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column315_c57e95-d5\"><div class=\"kt-inside-inner-col\"><style>.kb-row-layout-id315_7b1823-56 > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id315_7b1823-56 > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id315_7b1823-56 > .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-id315_7b1823-56 > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id315_7b1823-56 > .kt-row-column-wrap{grid-template-columns:minmax(0, 2fr) minmax(0, 1fr);}}@media all and (max-width: 767px){.kb-row-layout-id315_7b1823-56 > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}<\/style><div class=\"kb-row-layout-wrap kb-row-layout-id315_7b1823-56 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-column315_a93eb1-a2 > .kt-inside-inner-col,.kadence-column315_a93eb1-a2 > .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-column315_a93eb1-a2 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column315_a93eb1-a2 > .kt-inside-inner-col{flex-direction:column;}.kadence-column315_a93eb1-a2 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column315_a93eb1-a2 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column315_a93eb1-a2{position:relative;}@media all and (max-width: 1024px){.kadence-column315_a93eb1-a2 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column315_a93eb1-a2 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column315_a93eb1-a2\"><div class=\"kt-inside-inner-col\"><style>.kb-gallery-id-315_29a516-94.kb-gallery-ul.kb-gallery-type-fluidcarousel .kt-blocks-carousel figure .kb-gal-image-radius, .kb-gallery-id-315_29a516-94.kb-gallery-ul.kb-gallery-type-fluidcarousel .kt-blocks-carousel figure .kb-gal-image-radius img{height:350px;}.kb-gallery-id-315_29a516-94 .kadence-blocks-gallery-item .kb-gal-image-radius, .kb-gallery-id-315_29a516-94 .kb-slide-item .kb-gal-image-radius img{border-radius:0px 0px 0px 0px;;}.kb-gallery-wrap-id-315_29a516-94.wp-block-kadence-advancedgallery{overflow:visible;}.kb-gallery-wrap-id-315_29a516-94.wp-block-kadence-advancedgallery .kt-blocks-carousel{overflow:visible;max-width:100%;}.kb-gallery-id-315_29a516-94 .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-315_29a516-94 .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-315_29a516-94 alignnone wp-block-kadence-advancedgallery\"><div class=\"kb-gallery-ul kb-gallery-non-static kb-gallery-type-fluidcarousel kb-gallery-id-315_29a516-94 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\/P9_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\/P9_1.webp\" width=\"1334\" height=\"753\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_1.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_1.webp\" data-id=\"898\" class=\"wp-image-898 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_1.webp 1334w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_1-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_1-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_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\/P9_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\/P9_2.webp\" width=\"1334\" height=\"753\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_2.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_2.webp\" data-id=\"899\" class=\"wp-image-899 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_2.webp 1334w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_2-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_2-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_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\/P9_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\/P9_3.webp\" width=\"1334\" height=\"753\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_3.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_3.webp\" data-id=\"900\" class=\"wp-image-900 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_3.webp 1334w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_3-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_3-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_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\/P9_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\/P9_4.webp\" width=\"1450\" height=\"863\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_4.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_4.webp\" data-id=\"901\" class=\"wp-image-901 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_4.webp 1450w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_4-600x357.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_4-150x89.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_4-768x457.webp 768w\" sizes=\"auto, (max-width: 1450px) 100vw, 1450px\" \/><\/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\/P9_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\/P9_5.webp\" width=\"1450\" height=\"863\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_5.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_5.webp\" data-id=\"902\" class=\"wp-image-902 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_5.webp 1450w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_5-600x357.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_5-150x89.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_5-768x457.webp 768w\" sizes=\"auto, (max-width: 1450px) 100vw, 1450px\" \/><\/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\/P9_6.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\/P9_6.webp\" width=\"1450\" height=\"863\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_6.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_6.webp\" data-id=\"903\" class=\"wp-image-903 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_6.webp 1450w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_6-600x357.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_6-150x89.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_6-768x457.webp 768w\" sizes=\"auto, (max-width: 1450px) 100vw, 1450px\" \/><\/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\/P9_7.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\/P9_7.webp\" width=\"1450\" height=\"863\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_7.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_7.webp\" data-id=\"904\" class=\"wp-image-904 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_7.webp 1450w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_7-600x357.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_7-150x89.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_7-768x457.webp 768w\" sizes=\"auto, (max-width: 1450px) 100vw, 1450px\" \/><\/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\/P9_8.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\/P9_8.webp\" width=\"1450\" height=\"863\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_8.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_8.webp\" data-id=\"905\" class=\"wp-image-905 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_8.webp 1450w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_8-600x357.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_8-150x89.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P9_8-768x457.webp 768w\" sizes=\"auto, (max-width: 1450px) 100vw, 1450px\" \/><\/div><\/div><\/a><\/figure><\/div><\/div><\/li><\/ul><\/div><\/div><\/div><\/div><\/div><\/div>\n\n\n<style>.kadence-column315_10007d-23 > .kt-inside-inner-col,.kadence-column315_10007d-23 > .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-column315_10007d-23 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column315_10007d-23 > .kt-inside-inner-col{flex-direction:column;}.kadence-column315_10007d-23 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column315_10007d-23 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column315_10007d-23{position:relative;}@media all and (max-width: 1024px){.kadence-column315_10007d-23 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column315_10007d-23 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column315_10007d-23\"><div class=\"kt-inside-inner-col\"><style>.kb-table-of-content-nav.kb-table-of-content-id315_f95862-aa .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-id315_f95862-aa .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-id315_f95862-aa .kb-table-of-contents-title-wrap{color:#9b9958;}.kb-table-of-content-nav.kb-table-of-content-id315_f95862-aa .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-id315_f95862-aa .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-id315_f95862-aa .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>De retour chez BottleNeck (fictif) apr\u00e8s mon projet d\u2019optimisation des stocks, Nicolas (responsable des ventes) m\u2019a confi\u00e9 une nouvelle mission \u202f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u00c9tape 1<\/strong>\u202f: analyser trois solutions d\u2019acc\u00e8s aux donn\u00e9es (connexion directe SQLite, export CSV, ETL) et pr\u00e9coniser la meilleure approche via un rapport document\u00e9.<\/li>\n\n\n\n<li><strong>\u00c9tape 2<\/strong>\u202f: importer ces donn\u00e9es nettoy\u00e9es et consolideres dans un dashboard interactif sous Tableau, incluant au moins 3\u202frecommandations business pour Florian (PDG) et les chefs de produit.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Datasets<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Source<\/strong>\u202f: export SQLite couvrant la p\u00e9riode du 1\u202foctobre\u202f2022 au 30\u202fseptembre\u202f2023 (tables\u202f: Web, Finance, Sales, Promo, ca_par_segment).<\/li>\n\n\n\n<li><strong>Nature<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Web\u202f: r\u00e9f\u00e9rences produits, notes, commentaires, segments (761 lignes x 17 colonnes)<\/li>\n\n\n\n<li>Finance\u202f: prix d\u2019achat, prix de vente, statuts (11322 lignes x 6 colonnes)<\/li>\n\n\n\n<li>Sales\u202f: volumes (hors promo et global), commandes, stocks fin de mois (9564 lignes x 12 colonnes)<\/li>\n\n\n\n<li>Promo\u202f: d\u00e9tails des offres, ventes en promotion (698 lignes x 9 colonnes)<\/li>\n\n\n\n<li>ca_par_segment\u202f: chiffre d\u2019affaires agr\u00e9g\u00e9 par segment (5 lignes x 2 colonnes)<\/li>\n<\/ul>\n<\/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><strong>Analyse des solutions :<\/strong> comparaison des solutions (avantages\/inconv\u00e9nients): connexion SQL directe, extraction CSV, ETL visuel (KNIME\/Power\u202fQuery) .<\/li>\n\n\n\n<li><strong>Choix technologique\u202f :<\/strong>\n<ul class=\"wp-block-list\">\n<li><strong>Extraction &amp; nettoyage<\/strong>\u202f: pipeline Python (SQLite3\u2192pandas) ex\u00e9cut\u00e9 dans Google\u202fColab, pour normaliser types, corriger doublons, imputer valeurs manquantes, calculer KPI, et g\u00e9n\u00e9rer CSV.<\/li>\n\n\n\n<li><strong>Visualisation<\/strong>: Tableau Public (connexion aux CSV), no DAX, glisser\u2011d\u00e9poser pour un acc\u00e8s macOS\/Windows\/web.<\/li>\n\n\n\n<li><strong>Data cleaning<\/strong>\u202f: conversion des formats (float, datetime, bool), gestion des NaN, cr\u00e9ation de nouvelles colonnes (marge brute, rotation stock, taux de conversion, ROI), reproductibilit\u00e9 garantie via scripts versionn\u00e9s.<\/li>\n\n\n\n<li><strong>Dashboard design<\/strong>\u202f: architecture en 8\u202fonglets th\u00e9matiques\u202f\u2013 Vue\u202fd\u2019ensemble, Inflation &amp; marge, Promotions &amp; ROI, Meilleurs produits, Pr\u00e9f\u00e9rences clients, Segments, Rotation stock, Recommandations business.<\/li>\n<\/ul>\n<\/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><strong>Pipeline automatis\u00e9<\/strong>\u202f: un clic \u201cRefresh\u201d dans Tableau lance l\u2019ex\u00e9cution du notebook et met \u00e0 jour les donn\u00e9es.<\/li>\n\n\n\n<li><strong>8\u202fKPI cl\u00e9s\u202f<\/strong>:\n<ol class=\"wp-block-list\">\n<li>CA total et par segment<\/li>\n\n\n\n<li>Marge brute<\/li>\n\n\n\n<li>Rotation des stocks<\/li>\n\n\n\n<li>Prix d\u2019achat moyen (inflation)<\/li>\n\n\n\n<li>Volumes de ventes<\/li>\n\n\n\n<li>ROI des promotions<\/li>\n\n\n\n<li>Note moyenne client<\/li>\n\n\n\n<li>Taux de commentaires.<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Recommandations business \u202f:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Cibler les produits \u00e0 faible rotation pour lib\u00e9rer du cash,<\/li>\n\n\n\n<li>Ne pas solder les best\u2011sellers pour prot\u00e9ger la marge,<\/li>\n\n\n\n<li>Synchroniser les promotions en p\u00e9riodes creuses,<\/li>\n\n\n\n<li>Suivi mensuel diff\u00e9renci\u00e9 par segment,<\/li>\n\n\n\n<li>Seuils de stock par segment,<\/li>\n\n\n\n<li>Exploiter syst\u00e9matiquement les feedbacks clients.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Business Impact<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Un workflow modulaire\u202f\u2013 extraction Python \u2192 CSV \u2192 Tableau \u2013 garantissant \u202f:\n<ul class=\"wp-block-list\">\n<li>Tra\u00e7abilit\u00e9 et reproductibilit\u00e9,<\/li>\n\n\n\n<li>Performances optimales (calculs hors de Tableau),<\/li>\n\n\n\n<li>Autonomie des m\u00e9tiers (aucune comp\u00e9tence code requise pour actualiser).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Un outil unifi\u00e9 offrant une vision\u202f360\u00b0 instantan\u00e9e pour la prise de d\u00e9cision data\u2011driven. <strong>360\u00b0<\/strong> data-driven decision support<\/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\/P9\/Governatori_Giulia_1_rapport_052025.pdf\" data-type=\"link\" data-id=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P9\/Governatori_Giulia_1_rapport_052025.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Rapport<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/colab.research.google.com\/drive\/1flpbSAZg9xXhTQNGunW16FHDwVViH1Y9?usp=sharing\" data-type=\"link\" data-id=\"https:\/\/colab.research.google.com\/drive\/1flpbSAZg9xXhTQNGunW16FHDwVViH1Y9?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">Notebook (EDA)<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/colab.research.google.com\/drive\/1pFOhPSZC2vVJKdN81ZfGSo9cVp-y_jfj?usp=sharing\" data-type=\"link\" data-id=\"https:\/\/colab.research.google.com\/drive\/1pFOhPSZC2vVJKdN81ZfGSo9cVp-y_jfj?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">Code Python mis \u00e0 jour<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P9\/Governatori_Giulia_5_presentation_052025.pdf\" data-type=\"link\" data-id=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P9\/Governatori_Giulia_5_presentation_052025.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Pr\u00e9sentation<\/a><\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading315_653d42-7d, .wp-block-kadence-advancedheading.kt-adv-heading315_653d42-7d[data-kb-block=\"kb-adv-heading315_653d42-7d\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading315_653d42-7d mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading315_653d42-7d[data-kb-block=\"kb-adv-heading315_653d42-7d\"] 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-heading315_653d42-7d img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading315_653d42-7d[data-kb-block=\"kb-adv-heading315_653d42-7d\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<h2 class=\"kt-adv-heading315_653d42-7d wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading315_653d42-7d\">Dashboard<\/h2>\n\n\n\n<p><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/fr\/dashboard-p9\/\" data-type=\"page\" data-id=\"979\">Dashboard<\/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>\n\n\n\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>E-commerce &#8211; Bottleneck (Openclassroom) Fictional | 08\/05\/2025 &gt; 11\/06\/2025 Context Back at BottleNeck (fictional) after my stock optimization project, I was assigned a new mission by Nicolas (Head of Sales): Datasets Workflow Insights Business Impact Links Report Notebook (EDA) Updated Python code Presentation Dashboard Dashboard<\/p>","protected":false},"featured_media":295,"menu_order":7,"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":[36,8,35,4,34,5,29,7,19,15,6,32,33,9,27],"class_list":["post-315","projects","type-projects","status-publish","has-post-thumbnail","hentry","category-dashboarding","category-data-cleaning","category-data-gouvernance","category-data-methods","category-data-modeling","category-data-tools","category-dax","category-exploratory-data-analysis","category-google-collab","category-kpi-tracking","category-languages","category-python","category-sql","category-statistical-analysis","category-tableau"],"_links":{"self":[{"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/projects\/315","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\/295"}],"wp:attachment":[{"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/media?parent=315"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/categories?post=315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}