{"id":304,"date":"2025-07-27T22:22:45","date_gmt":"2025-07-27T20:22:45","guid":{"rendered":"https:\/\/giulia-governatori.alwaysdata.net\/?post_type=projects&#038;p=304"},"modified":"2025-08-13T17:08:31","modified_gmt":"2025-08-13T15:08:31","slug":"customer-satisfaction-tracking-bestmarket","status":"publish","type":"projects","link":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/projects\/customer-satisfaction-tracking-bestmarket\/","title":{"rendered":"Manipuler une base de donn\u00e9es avec SQL pour suivre la satisfaction client"},"content":{"rendered":"<style>.kadence-column304_579a64-1d > .kt-inside-inner-col,.kadence-column304_579a64-1d > .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-column304_579a64-1d > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column304_579a64-1d > .kt-inside-inner-col{flex-direction:column;}.kadence-column304_579a64-1d > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column304_579a64-1d > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column304_579a64-1d{position:relative;}.kadence-column304_579a64-1d, .kt-inside-inner-col > .kadence-column304_579a64-1d:not(.specificity){margin-top:30px;margin-bottom:30px;}@media all and (max-width: 1024px){.kadence-column304_579a64-1d > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column304_579a64-1d > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column304_579a64-1d\"><div class=\"kt-inside-inner-col\"><style>.kb-row-layout-id304_d74b1d-b0 > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id304_d74b1d-b0 > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id304_d74b1d-b0 > .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-id304_d74b1d-b0 > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}.kb-row-layout-id304_d74b1d-b0 > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}.kb-row-layout-id304_d74b1d-b0 > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id304_d74b1d-b0 > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}}@media all and (max-width: 1024px){.kb-row-layout-id304_d74b1d-b0 > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}@media all and (max-width: 767px){.kb-row-layout-id304_d74b1d-b0 > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}.kb-row-layout-id304_d74b1d-b0 > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}<\/style><div class=\"kb-row-layout-wrap kb-row-layout-id304_d74b1d-b0 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-column304_ac48bd-03 > .kt-inside-inner-col,.kadence-column304_ac48bd-03 > .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-column304_ac48bd-03 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column304_ac48bd-03 > .kt-inside-inner-col{flex-direction:column;}.kadence-column304_ac48bd-03 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column304_ac48bd-03 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column304_ac48bd-03{position:relative;}@media all and (max-width: 1024px){.kadence-column304_ac48bd-03 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column304_ac48bd-03 > .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-column304_ac48bd-03\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading304_6dcbe9-71, .wp-block-kadence-advancedheading.kt-adv-heading304_6dcbe9-71[data-kb-block=\"kb-adv-heading304_6dcbe9-71\"]{font-size:var(--global-kb-font-size-sm, 0.9rem);font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading304_6dcbe9-71 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading304_6dcbe9-71[data-kb-block=\"kb-adv-heading304_6dcbe9-71\"] 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-heading304_6dcbe9-71 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading304_6dcbe9-71[data-kb-block=\"kb-adv-heading304_6dcbe9-71\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading304_6dcbe9-71 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading304_6dcbe9-71\">Vente au d\u00e9tail \u2013 BestMarket (Openclassroom)<\/p>\n<\/div><\/div>\n\n\n<style>.kadence-column304_96779b-c4 > .kt-inside-inner-col{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kadence-column304_96779b-c4 > .kt-inside-inner-col,.kadence-column304_96779b-c4 > .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-column304_96779b-c4 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column304_96779b-c4 > .kt-inside-inner-col{flex-direction:column;}.kadence-column304_96779b-c4 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column304_96779b-c4 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column304_96779b-c4{position:relative;}.kadence-column304_96779b-c4, .kt-inside-inner-col > .kadence-column304_96779b-c4:not(.specificity){margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;}@media all and (max-width: 1024px){.kadence-column304_96779b-c4 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column304_96779b-c4 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column304_96779b-c4\"><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\">Manipuler une base de donn\u00e9es avec SQL pour suivre la satisfaction client<\/h1><\/div><\/div>\n\n\n<style>.kadence-column304_10e6bc-fb > .kt-inside-inner-col{display:flex;}.kadence-column304_10e6bc-fb > .kt-inside-inner-col{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kadence-column304_10e6bc-fb > .kt-inside-inner-col,.kadence-column304_10e6bc-fb > .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-column304_10e6bc-fb > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column304_10e6bc-fb > .kt-inside-inner-col{flex-direction:column;align-items:flex-start;}.kadence-column304_10e6bc-fb > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column304_10e6bc-fb > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column304_10e6bc-fb > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column304_10e6bc-fb > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column304_10e6bc-fb{position:relative;}@media all and (max-width: 1024px){.kadence-column304_10e6bc-fb > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}@media all and (max-width: 767px){.kadence-column304_10e6bc-fb > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column304_10e6bc-fb\"><div class=\"kt-inside-inner-col\"><style>.kb-row-layout-wrap.wp-block-kadence-rowlayout.kb-row-layout-id304_5cc978-a9{margin-top:0px;margin-bottom:0px;}.kb-row-layout-id304_5cc978-a9 > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id304_5cc978-a9 > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id304_5cc978-a9 > .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-id304_5cc978-a9 > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id304_5cc978-a9 > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}}@media all and (max-width: 1024px){.kb-row-layout-id304_5cc978-a9 > .kt-row-column-wrap{grid-template-columns:repeat(3, minmax(0, 1fr));}}@media all and (max-width: 767px){.kb-row-layout-id304_5cc978-a9 > .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-id304_5cc978-a9 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-column304_c4131b-d8 > .kt-inside-inner-col{display:flex;}.kadence-column304_c4131b-d8 > .kt-inside-inner-col,.kadence-column304_c4131b-d8 > .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-column304_c4131b-d8 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column304_c4131b-d8 > .kt-inside-inner-col{flex-direction:column;align-items:flex-start;}.kadence-column304_c4131b-d8 > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column304_c4131b-d8 > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column304_c4131b-d8 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column304_c4131b-d8 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column304_c4131b-d8{position:relative;}@media all and (max-width: 1024px){.kadence-column304_c4131b-d8 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}@media all and (max-width: 767px){.kadence-column304_c4131b-d8 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column304_c4131b-d8\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading304_f85d6e-c3, .wp-block-kadence-advancedheading.kt-adv-heading304_f85d6e-c3[data-kb-block=\"kb-adv-heading304_f85d6e-c3\"]{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-heading304_f85d6e-c3 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading304_f85d6e-c3[data-kb-block=\"kb-adv-heading304_f85d6e-c3\"] 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-heading304_f85d6e-c3 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading304_f85d6e-c3[data-kb-block=\"kb-adv-heading304_f85d6e-c3\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading304_f85d6e-c3 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading304_f85d6e-c3\">Fictif<\/p>\n<\/div><\/div>\n\n\n<style>.kadence-column304_f36bc3-84 > .kt-inside-inner-col,.kadence-column304_f36bc3-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-column304_f36bc3-84 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column304_f36bc3-84 > .kt-inside-inner-col{flex-direction:column;}.kadence-column304_f36bc3-84 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column304_f36bc3-84 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column304_f36bc3-84{position:relative;}@media all and (max-width: 1024px){.kadence-column304_f36bc3-84 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column304_f36bc3-84 > .kt-inside-inner-col{display:flex;flex-direction:column;justify-content:center;align-items:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column304_f36bc3-84\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading304_e091e8-e5, .wp-block-kadence-advancedheading.kt-adv-heading304_e091e8-e5[data-kb-block=\"kb-adv-heading304_e091e8-e5\"]{font-size:var(--global-kb-font-size-sm, 0.9rem);font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading304_e091e8-e5 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading304_e091e8-e5[data-kb-block=\"kb-adv-heading304_e091e8-e5\"] 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-heading304_e091e8-e5 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading304_e091e8-e5[data-kb-block=\"kb-adv-heading304_e091e8-e5\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading304_e091e8-e5 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading304_e091e8-e5\">|<\/p>\n<\/div><\/div>\n\n\n<style>.kadence-column304_c1d8f5-c0 > .kt-inside-inner-col,.kadence-column304_c1d8f5-c0 > .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-column304_c1d8f5-c0 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column304_c1d8f5-c0 > .kt-inside-inner-col{flex-direction:column;}.kadence-column304_c1d8f5-c0 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column304_c1d8f5-c0 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column304_c1d8f5-c0{position:relative;}@media all and (max-width: 1024px){.kadence-column304_c1d8f5-c0 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column304_c1d8f5-c0 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column304_c1d8f5-c0\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading304_d363d5-66, .wp-block-kadence-advancedheading.kt-adv-heading304_d363d5-66[data-kb-block=\"kb-adv-heading304_d363d5-66\"]{text-align:left;font-size:var(--global-kb-font-size-sm, 0.9rem);font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading304_d363d5-66 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading304_d363d5-66[data-kb-block=\"kb-adv-heading304_d363d5-66\"] 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-heading304_d363d5-66 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading304_d363d5-66[data-kb-block=\"kb-adv-heading304_d363d5-66\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading304_d363d5-66 project-dates wp-block-kadence-advancedheading has-theme-palette-5-color has-text-color\" data-kb-block=\"kb-adv-heading304_d363d5-66\">17\/01\/2025 &gt; 31\/01\/2025<\/p>\n<\/div><\/div>\n\n<\/div><\/div><\/div><\/div>\n\n\n<style>.kadence-column304_e9e59d-eb > .kt-inside-inner-col,.kadence-column304_e9e59d-eb > .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-column304_e9e59d-eb > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column304_e9e59d-eb > .kt-inside-inner-col{flex-direction:column;}.kadence-column304_e9e59d-eb > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column304_e9e59d-eb > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column304_e9e59d-eb{position:relative;}@media all and (max-width: 1024px){.kadence-column304_e9e59d-eb > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column304_e9e59d-eb > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column304_e9e59d-eb\"><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-column304_db1dcb-84 > .kt-inside-inner-col{display:flex;}.kadence-column304_db1dcb-84 > .kt-inside-inner-col,.kadence-column304_db1dcb-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-column304_db1dcb-84 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column304_db1dcb-84 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}.kadence-column304_db1dcb-84 > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column304_db1dcb-84 > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column304_db1dcb-84 > .kt-inside-inner-col > .aligncenter{width:100%;}.kt-row-column-wrap > .kadence-column304_db1dcb-84{align-self:center;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column304_db1dcb-84{align-self:auto;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column304_db1dcb-84 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}.kadence-column304_db1dcb-84 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column304_db1dcb-84{position:relative;}.kadence-column304_db1dcb-84, .kt-inside-inner-col > .kadence-column304_db1dcb-84:not(.specificity){margin-top:30px;margin-bottom:0px;}@media all and (max-width: 1024px){.kt-row-column-wrap > .kadence-column304_db1dcb-84{align-self:center;}}@media all and (max-width: 1024px){.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column304_db1dcb-84{align-self:auto;}}@media all and (max-width: 1024px){.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column304_db1dcb-84 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 1024px){.kadence-column304_db1dcb-84 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}}@media all and (max-width: 767px){.kt-row-column-wrap > .kadence-column304_db1dcb-84{align-self:center;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column304_db1dcb-84{align-self:auto;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column304_db1dcb-84 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}.kadence-column304_db1dcb-84 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column304_db1dcb-84\"><div class=\"kt-inside-inner-col\"><style>.kb-row-layout-id304_9d7b08-af > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id304_9d7b08-af > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id304_9d7b08-af > .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-id304_9d7b08-af > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id304_9d7b08-af > .kt-row-column-wrap{grid-template-columns:minmax(0, 2fr) minmax(0, 1fr);}}@media all and (max-width: 767px){.kb-row-layout-id304_9d7b08-af > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}<\/style><div class=\"kb-row-layout-wrap kb-row-layout-id304_9d7b08-af 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-column304_2df960-95 > .kt-inside-inner-col,.kadence-column304_2df960-95 > .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-column304_2df960-95 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column304_2df960-95 > .kt-inside-inner-col{flex-direction:column;}.kadence-column304_2df960-95 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column304_2df960-95 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column304_2df960-95{position:relative;}@media all and (max-width: 1024px){.kadence-column304_2df960-95 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column304_2df960-95 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column304_2df960-95\"><div class=\"kt-inside-inner-col\"><style>.kb-gallery-id-304_9b6c8b-f5.kb-gallery-ul.kb-gallery-type-fluidcarousel .kt-blocks-carousel figure .kb-gal-image-radius, .kb-gallery-id-304_9b6c8b-f5.kb-gallery-ul.kb-gallery-type-fluidcarousel .kt-blocks-carousel figure .kb-gal-image-radius img{height:350px;}.kb-gallery-id-304_9b6c8b-f5 .kadence-blocks-gallery-item .kb-gal-image-radius, .kb-gallery-id-304_9b6c8b-f5 .kb-slide-item .kb-gal-image-radius img{border-radius:0px 0px 0px 0px;;}.kb-gallery-wrap-id-304_9b6c8b-f5.wp-block-kadence-advancedgallery{overflow:visible;}.kb-gallery-wrap-id-304_9b6c8b-f5.wp-block-kadence-advancedgallery .kt-blocks-carousel{overflow:visible;max-width:100%;}.kb-gallery-id-304_9b6c8b-f5 .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-304_9b6c8b-f5 .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-304_9b6c8b-f5 alignnone wp-block-kadence-advancedgallery\"><div class=\"kb-gallery-ul kb-gallery-non-static kb-gallery-type-fluidcarousel kb-gallery-id-304_9b6c8b-f5 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\/P5_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\/P5_1.webp\" width=\"1331\" height=\"759\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_1.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_1.webp\" data-id=\"870\" class=\"wp-image-870 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_1.webp 1331w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_1-600x342.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_1-150x86.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_1-768x438.webp 768w\" sizes=\"auto, (max-width: 1331px) 100vw, 1331px\" \/><\/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\/P5_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\/P5_2.webp\" width=\"1331\" height=\"759\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_2.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_2.webp\" data-id=\"871\" class=\"wp-image-871 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_2.webp 1331w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_2-600x342.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_2-150x86.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_2-768x438.webp 768w\" sizes=\"auto, (max-width: 1331px) 100vw, 1331px\" \/><\/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\/P5_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\/P5_3.webp\" width=\"1331\" height=\"759\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_3.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_3.webp\" data-id=\"872\" class=\"wp-image-872 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_3.webp 1331w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_3-600x342.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_3-150x86.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_3-768x438.webp 768w\" sizes=\"auto, (max-width: 1331px) 100vw, 1331px\" \/><\/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\/P5_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\/P5_4.webp\" width=\"1331\" height=\"759\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_4.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_4.webp\" data-id=\"873\" class=\"wp-image-873 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_4.webp 1331w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_4-600x342.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_4-150x86.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P5_4-768x438.webp 768w\" sizes=\"auto, (max-width: 1331px) 100vw, 1331px\" \/><\/div><\/div><\/a><\/figure><\/div><\/div><\/li><\/ul><\/div><\/div><\/div><\/div><\/div><\/div>\n\n\n<style>.kadence-column304_b95d3f-76 > .kt-inside-inner-col,.kadence-column304_b95d3f-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-column304_b95d3f-76 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column304_b95d3f-76 > .kt-inside-inner-col{flex-direction:column;}.kadence-column304_b95d3f-76 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column304_b95d3f-76 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column304_b95d3f-76{position:relative;}@media all and (max-width: 1024px){.kadence-column304_b95d3f-76 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column304_b95d3f-76 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column304_b95d3f-76\"><div class=\"kt-inside-inner-col\"><style>.kb-table-of-content-nav.kb-table-of-content-id304_63b45e-2b .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-id304_63b45e-2b .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-id304_63b45e-2b .kb-table-of-contents-title-wrap{color:#9b9958;}.kb-table-of-content-nav.kb-table-of-content-id304_63b45e-2b .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-id304_63b45e-2b .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-id304_63b45e-2b .kb-table-of-content-wrap .kb-table-of-content-list .kb-table-of-contents__entry:hover{color:var(--global-palette2, #2B6CB0);}<\/style><\/div><\/div>\n\n<\/div><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Contexte<\/h2>\n\n\n\n<p>J\u2019ai rejoint BestMarket (fictif) pour son projet \u201cRetailInsight360\u201d, pilot\u00e9 par M\u00e9lanie (lead data analyst) et Olivier (service client). L\u2019objectif \u00e9tait de reformuler pr\u00e9cis\u00e9ment les besoins m\u00e9tier, charger et enrichir la base de feedbacks clients, puis d\u2019\u00e9crire et d\u2019ex\u00e9cuter plus de 20\u202frequ\u00eates SQL pour mesurer la satisfaction et guider les d\u00e9cisions op\u00e9rationnelles.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Datasets<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"translation-block\">Base initiale \u201ccustomer_data_feedback.sql\u201d import\u00e9e dans SQLite\u202fStudio\/DBeaver\u202f: table retour_client (3\u202f000\u202flignes), produit (145 entr\u00e9es) et ref_magasin (84 magasins).<\/li>\n\n\n\n<li>Dictionnaire de donn\u00e9es (Excel) d\u00e9crivant chaque colonne (nom, type, contrainte, description).<\/li>\n\n\n\n<li class=\"translation-block\">Fichier ref_magasin.csv pour compl\u00e9ter les m\u00e9tadonn\u00e9es g\u00e9ographiques des magasins.<\/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>Expression de besoins\u202f: pour valider le contexte, les enjeux (NPS, retours par cat\u00e9gorie) et les indicateurs \u00e0 produire<\/li>\n\n\n\n<li class=\"translation-block\">\u202fChargement et mise \u00e0 jour du sch\u00e9ma\u202f: import du script SQL, cr\u00e9ation de la table\u202fref_magasin \u00e0 partir du CSV, mise \u00e0 jour du sch\u00e9ma relationnel et du dictionnaire<\/li>\n\n\n\n<li class=\"translation-block\">R\u00e9daction de requ\u00eates SQL avanc\u00e9es\u202f: SELECT, JOIN, agr\u00e9gations, CTE, fonctions de fen\u00eatre et de date, alias pour la lisibilit\u00e9, filtrage et classement pour r\u00e9pondre aux 21\u202fquestions m\u00e9tier (retours par source, NPS global et par canal, top\u202f5 magasins, \u00e9volution trimestrielle, etc.)<\/li>\n\n\n\n<li>V\u00e9rification de la coh\u00e9rence et int\u00e9grit\u00e9\u202f: tests d\u2019unicit\u00e9 des PK\/FK, contr\u00f4le des plages de valeurs, d\u00e9tection d\u2019incoh\u00e9rences (note vs recommandations) et ajout de contraintes SQL pour pr\u00e9venir les anomalies<\/li>\n\n\n\n<li>\u202fPr\u00e9sentations et documentation\u202f: support PDF de 20\u202fslides synth\u00e9tiques (contexte, bonnes pratiques de backup et stockage, m\u00e9thodologie, captures d\u2019\u00e9cran du sch\u00e9ma et du dictionnaire mis \u00e0 jour, extraits de requ\u00eates et r\u00e9sultats, contr\u00f4les de coh\u00e9rence)<\/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>639 retours \u201clivraison\u201d et top\u202f3 sources de feedbacks (email:\u202f1\u202f032, r\u00e9seaux sociaux:\u202f998, t\u00e9l\u00e9phone:\u202f970).<\/li>\n\n\n\n<li>Note moyenne par cat\u00e9gorie\u202f: High\u2011tech\u202f8,16\u2009; Loisirs\u202f8,09\u2009; Alimentaire\u202f8,04\u2009; Maison\u202f7,85.<\/li>\n\n\n\n<li>Top\u202f5 magasins par note\u202f: Paris\u202f14e, Saint\u2011Pierre\u2011du\u2011Perray, Paris\u202f19e, Paris\u202f11e, Coulommiers.<\/li>\n\n\n\n<li>NPS global\u202f:\u202f31\u202fpts (promoteurs\u202f&gt;\u202f8, d\u00e9tracteurs\u202f\u2264\u202f6) et NPS par source (t\u00e9l\u00e9phone\u202f34\u202f; email\u202f30\u202f; r\u00e9seaux sociaux\u202f30).<\/li>\n\n\n\n<li>Meilleur jour en magasin\u202f: samedi<\/li>\n\n\n\n<li>Mois avec le plus de retours : octobre.<\/li>\n\n\n\n<li>\u00c9volution remarquable des typologies\u202f: +4,24\u202f% pour les Loisirs entre T1 et T2\u202f2021.<\/li>\n\n\n\n<li>Recommandations suppl\u00e9mentaires\u202f: int\u00e9grer le volume total de ventes pour calculer un vrai taux de retour\u202f; approfondir les incoh\u00e9rences \u201cnote\/recommandation\u201d\u202f; d\u00e9tailler le dictionnaire des cat\u00e9gories<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Business Impact<\/h2>\n\n\n\n<p>Mes livrables ont permis \u00e0 BestMarket de\u202f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Prioriser des actions par magasin et par typologie produit selon la satisfaction r\u00e9elle.<\/li>\n\n\n\n<li>Mettre en place un suivi NPS par canal pour ajuster l\u2019exp\u00e9rience multicanale.<\/li>\n\n\n\n<li>Renforcer la gouvernance des donn\u00e9es en ajoutant contraintes et contr\u00f4les d\u2019int\u00e9grit\u00e9.<\/li>\n\n\n\n<li>Fournir un cadre reproductible pour toute future analyse de feedback client.<\/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\/P5\/Governatori_Giulia_1_expression_besoin_012025.pdf\" data-type=\"link\" data-id=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P5\/Governatori_Giulia_1_expression_besoin_012025.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Brief besoins<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P5\/Governatori_Giulia_2_presentation_012025.pdf\" data-type=\"link\" data-id=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P5\/Governatori_Giulia_2_presentation_012025.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Pr\u00e9sentation<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P5\/Governatori_Giulia_3_ExecutiveSummary_012025.pdf\" data-type=\"link\" data-id=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P5\/Governatori_Giulia_3_ExecutiveSummary_012025.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Sommaire de gestion<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P5\/Governatori_Giulia_4_CoherenceDonnees_012025.pdf\" data-type=\"link\" data-id=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P5\/Governatori_Giulia_4_CoherenceDonnees_012025.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Coh\u00e9rence donn\u00e9es<\/a><\/p>\n\n\n<style>.kadence-column311_6aa044-75 > .kt-inside-inner-col{display:flex;}.kadence-column311_6aa044-75{max-width:1140px;margin-left:auto;margin-right:auto;}.wp-block-kadence-column.kb-section-dir-horizontal:not(.kb-section-md-dir-vertical)>.kt-inside-inner-col>.kadence-column311_6aa044-75{-webkit-flex:0 1 1140px;flex:0 1 1140px;max-width:unset;margin-left:unset;margin-right:unset;}.kadence-column311_6aa044-75 > .kt-inside-inner-col,.kadence-column311_6aa044-75 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column311_6aa044-75 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column311_6aa044-75 > .kt-inside-inner-col{flex-direction:column;align-items:center;}.kadence-column311_6aa044-75 > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column311_6aa044-75 > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column311_6aa044-75 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column311_6aa044-75 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column311_6aa044-75{position:relative;}@media all and (min-width: 1025px){.wp-block-kadence-column.kb-section-dir-horizontal>.kt-inside-inner-col>.kadence-column311_6aa044-75{-webkit-flex:0 1 1140px;flex:0 1 1140px;max-width:unset;margin-left:unset;margin-right:unset;}}@media all and (max-width: 1024px){.kadence-column311_6aa044-75 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}}@media all and (max-width: 767px){.wp-block-kadence-column.kb-section-sm-dir-vertical:not(.kb-section-sm-dir-horizontal):not(.kb-section-sm-dir-specificity)>.kt-inside-inner-col>.kadence-column311_6aa044-75{max-width:1140px;-webkit-flex:1;flex:1;margin-left:auto;margin-right:auto;}.kadence-column311_6aa044-75 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column311_6aa044-75\"><div class=\"kt-inside-inner-col\">\n<style>\n  .project-select-wrapper {\n    display: flex;\n    align-items: center;\n    gap: 0.5rem;\n    font-family: 'Roboto Mono', monospace;\n    position: relative;\n  }\n\n  .project-select-wrapper label {\n    font-weight: 600;\n    margin: 0;\n    white-space: nowrap; \/* Ne passe pas \u00e0 la ligne *\/\n  }\n\n  .custom-select {\n    font-family: 'Roboto Mono', monospace;\n    font-size: 1rem;\n    font-weight: 700;\n    padding: 0.5rem 0.8rem;\n    border: 1px solid #fff;\n    border-radius: 6px;\n    background: transparent;\n    color: #fff;\n    cursor: pointer;\n    min-width: 90px; \/* juste suffisant pour le texte \"Select\" *\/\n  }\n.custom-select:focus,\n.custom-select:active,\n.custom-select:hover {\n    border: 1px solid #FF678D!important;\n    background: transparent!important;\n    color: #FF678D!important;\n}\n\n  .dropdown-menu {\n    margin-bottom: 5px;\n    position: absolute;\n    bottom: 100%;\n    left: 0;\n    background: #9b9958;\n    border-radius: 6px;\n    display: none;\n    flex-direction: column;\n    z-index: 100;\n    white-space: nowrap;\n  }\n\n  .dropdown-menu a {\n    display: block;\n    padding: 0.5rem 0.8rem;\n    color: #7D0202;\n    text-decoration: none;\n  }\n\n  .dropdown-menu a:hover {\n    background: #7D0202;\n    color: #fff;\n  }\n\n  .project-select-wrapper.open .dropdown-menu {\n    display: flex;\n  }\n<\/style>\n\n<div class=\"project-select-wrapper\">\n  <label for=\"project-toggle\">Voir les autres projets<\/label>\n  <button id=\"project-toggle\" class=\"custom-select\" type=\"button\">S\u00e9lectionner<\/button>\n  <div class=\"dropdown-menu\">\n    <a href=\"\/fr\/projects\/real%E2%80%91estate-price-prediction\/\">Analyser l\u2019\u00e9volution des prix \u2028de l\u2019immobilier avec Python<\/a>\n    <a href=\"\/fr\/projects\/market-segmentation-aaa-strategy-uoi-games\/\">Segmentation du march\u00e9 et strat\u00e9gie AAA<\/a>\n    <a href=\"\/fr\/projects\/portfolio-creation-documentation\/\">Cr\u00e9er mon portfolio de professionnel de la data<\/a>\n    <a href=\"\/fr\/projects\/the-hidden-realities-of-animation-in-france\/\">Sondage personnel : les r\u00e9alit\u00e9s cach\u00e9es de l'animation en France<\/a>\n    <a href=\"\/fr\/projects\/power-bi-project-dashboard-sanitoral\/\">Cr\u00e9er un tableau de bord dynamique avec PowerBI<\/a>\n    <a href=\"\/fr\/projects\/stock-management-data-cleaning-bottleneck\/\">Optimiser la gestion &amp; nettoyez les donn\u00e9es \u2028du stock d'une boutique<\/a>\n    <a href=\"\/fr\/projects\/sales-dashboard-recs-bottleneck\/\">Am\u00e9liorez les performances de l'entreprise<\/a>\n    <a href=\"\/fr\/projects\/customer-satisfaction-tracking-bestmarket\/\">Manipuler une base de donn\u00e9es avec SQL pour suivre la satisfaction client<\/a>\n    <a href=\"\/fr\/projects\/gdpr%E2%80%91compliant-data-collection\/\">Collecter des donn\u00e9es \u2028en respectant les normes RGPD<\/a>\n    <a href=\"\/fr\/projects\/analyze-customer-churn\/\">Visualiser des donn\u00e9es avec Excel<\/a>\n    <a href=\"\/fr\/projects\/sql-practice-housing-insurance\/\">Requ\u00eater une base de donn\u00e9es avec SQL<\/a>\n    <a href=\"\/fr\/projects\/analysis-of-my-business-intelligence-analyst-training\/\">Analyse de ma formation de Business Intelligence Analyst<\/a>\n  <\/div>\n<\/div>\n\n<script>\n  const toggle = document.getElementById('project-toggle');\n  const wrapper = document.querySelector('.project-select-wrapper');\n\n  toggle.addEventListener('click', () => {\n    wrapper.classList.toggle('open');\n  });\n\n  document.addEventListener('click', (e) => {\n    if (!wrapper.contains(e.target)) {\n      wrapper.classList.remove('open');\n    }\n  });\n\n  document.querySelectorAll('.dropdown-menu a').forEach(link => {\n    link.addEventListener('click', () => {\n      window.location.href = link.href;\n    });\n  });\n<\/script>\n\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Retail &#8211; BestMarket (Openclassroom) Fictional | 17\/01\/2025 &gt; 31\/01\/2025 Context I joined BestMarket (fictional) for the \u201cRetailInsight360\u201d project, led by M\u00e9lanie (lead data analyst) and Olivier (customer service). The objective was to clearly reformulate business needs, load and enrich the customer feedback database, and write and execute over 20 SQL queries to measure satisfaction and&#8230;<\/p>","protected":false},"featured_media":288,"menu_order":8,"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,34,5,17,6,33,26,9],"class_list":["post-304","projects","type-projects","status-publish","has-post-thumbnail","hentry","category-data-cleaning","category-data-gouvernance","category-data-methods","category-data-modeling","category-data-tools","category-dbeaver","category-languages","category-sql","category-sqlite","category-statistical-analysis"],"_links":{"self":[{"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/projects\/304","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\/288"}],"wp:attachment":[{"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/media?parent=304"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/categories?post=304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}