{"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\">Retail &#8211; 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\">Customer Satisfaction Tracking<\/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\">Fictional<\/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\"   role=\"button\" aria-haspopup=\"dialog\"><div class=\"kb-gal-image-radius\"><div class=\"kb-gallery-image-contain\" ><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/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\"   role=\"button\" aria-haspopup=\"dialog\"><div class=\"kb-gal-image-radius\"><div class=\"kb-gallery-image-contain\" ><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/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\"   role=\"button\" aria-haspopup=\"dialog\"><div class=\"kb-gal-image-radius\"><div class=\"kb-gallery-image-contain\" ><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/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\"   role=\"button\" aria-haspopup=\"dialog\"><div class=\"kb-gal-image-radius\"><div class=\"kb-gallery-image-contain\" ><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/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\">Context<\/h2>\n\n\n\n<p>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 support operational decisions.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Datasets<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Initial database customer_data_feedback.sql imported into SQLite Studio\/DBeaver: <strong>retour_client<\/strong> table (3,000 rows), <strong>produit <\/strong>table (145 entries), <strong>ref_magasin<\/strong> table (84 stores)<\/li>\n\n\n\n<li>Data dictionary (Excel) describing each column (name, type, constraint, description)<\/li>\n\n\n\n<li><strong>ref_magasin.csv<\/strong> file to complete store location metadata<\/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>Requirements gathering: validated the context, business stakes (NPS, returns by category), and KPIs to produce<\/li>\n\n\n\n<li>Schema loading and update: imported the SQL script, created the <code>ref_magasin<\/code> table from CSV, updated the relational schema and data dictionary<\/li>\n\n\n\n<li>Advanced SQL queries: used <code>SELECT<\/code>, <code>JOIN<\/code>, aggregations, CTEs, window\/date functions, aliases, filtering and ranking to answer 21 business questions (feedback by channel, overall and channel-based NPS, top 5 stores, quarterly evolution, etc.)<\/li>\n\n\n\n<li>Data integrity checks: uniqueness tests on PK\/FK, value range control, mismatch detection (rating vs. recommendation), added SQL constraints to prevent anomalies<\/li>\n\n\n\n<li>Presentation &amp; documentation: created a 20-slide PDF deck including context, backup\/storage best practices, methodology, screenshots of schema and updated dictionary, query snippets and results, and integrity control outputs<\/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 &#8220;delivery&#8221; feedbacks and top 3 feedback sources: email (1,032), social media (998), phone (970)<\/li>\n\n\n\n<li>Average satisfaction by product category: Electronics: 8.16, Leisure: 8.09, Food: 8.04, Home: 7.85<\/li>\n\n\n\n<li>Top 5 stores by rating: Paris 14th, Saint-Pierre-du-Perray, Paris 19th, Paris 11th, Coulommiers<\/li>\n\n\n\n<li>Global NPS: 31 pts (Promoters &gt;\u202f8, Detractors \u2264\u202f6), NPS by channel: Phone (34), Email (30), Social media (30)<\/li>\n\n\n\n<li>Best day in-store: Saturday<\/li>\n\n\n\n<li>Month with most feedbacks: October<\/li>\n\n\n\n<li>Notable trends: +4.24% increase in \u201cLeisure\u201d feedbacks from Q1 to Q2 2021<\/li>\n\n\n\n<li>Additional recommendations: include total sales volume to calculate real return rate ; investigate rating\/recommendation mismatches ; expand category dictionary for clarity<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Business Impact<\/h2>\n\n\n\n<p>My deliverables allowed BestMarket to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Prioritize store-level and category-level actions based on actual customer satisfaction<\/li>\n\n\n\n<li>Implement channel-based NPS monitoring to improve multichannel experience<\/li>\n\n\n\n<li>Strengthen data governance by adding constraints and integrity controls<\/li>\n\n\n\n<li>Provide a reusable framework for future customer feedback analysis<\/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\">Requirements brief<\/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\">Presentation<\/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\">Executive summary<\/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\">Data integrity checks<\/a><\/p>\n\n\n<style>.kadence-column311_6aa044-75 > .kt-inside-inner-col{display:flex;}.kadence-column311_6aa044-75{max-width:1140px;margin-left:auto;margin-right:auto;}.wp-block-kadence-column.kb-section-dir-horizontal:not(.kb-section-md-dir-vertical)>.kt-inside-inner-col>.kadence-column311_6aa044-75{-webkit-flex:0 1 1140px;flex:0 1 1140px;max-width:unset;margin-left:unset;margin-right:unset;}.kadence-column311_6aa044-75 > .kt-inside-inner-col,.kadence-column311_6aa044-75 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column311_6aa044-75 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column311_6aa044-75 > .kt-inside-inner-col{flex-direction:column;align-items:center;}.kadence-column311_6aa044-75 > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column311_6aa044-75 > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column311_6aa044-75 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column311_6aa044-75 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column311_6aa044-75{position:relative;}@media all and (min-width: 1025px){.wp-block-kadence-column.kb-section-dir-horizontal>.kt-inside-inner-col>.kadence-column311_6aa044-75{-webkit-flex:0 1 1140px;flex:0 1 1140px;max-width:unset;margin-left:unset;margin-right:unset;}}@media all and (max-width: 1024px){.kadence-column311_6aa044-75 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}}@media all and (max-width: 767px){.wp-block-kadence-column.kb-section-sm-dir-vertical:not(.kb-section-sm-dir-horizontal):not(.kb-section-sm-dir-specificity)>.kt-inside-inner-col>.kadence-column311_6aa044-75{max-width:1140px;-webkit-flex:1;flex:1;margin-left:auto;margin-right:auto;}.kadence-column311_6aa044-75 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column311_6aa044-75\"><div class=\"kt-inside-inner-col\">\n<style>\n  .project-select-wrapper {\n    display: flex;\n    align-items: center;\n    gap: 0.5rem;\n    font-family: 'Roboto Mono', monospace;\n    position: relative;\n  }\n\n  .project-select-wrapper label {\n    font-weight: 600;\n    margin: 0;\n    white-space: nowrap; \/* Ne passe pas \u00e0 la ligne *\/\n  }\n\n  .custom-select {\n    font-family: 'Roboto Mono', monospace;\n    font-size: 1rem;\n    font-weight: 700;\n    padding: 0.5rem 0.8rem;\n    border: 1px solid #fff;\n    border-radius: 6px;\n    background: transparent;\n    color: #fff;\n    cursor: pointer;\n    min-width: 90px; \/* juste suffisant pour le texte \"Select\" *\/\n  }\n.custom-select:focus,\n.custom-select:active,\n.custom-select:hover {\n    border: 1px solid #FF678D!important;\n    background: transparent!important;\n    color: #FF678D!important;\n}\n\n  .dropdown-menu {\n    margin-bottom: 5px;\n    position: absolute;\n    bottom: 100%;\n    left: 0;\n    background: #9b9958;\n    border-radius: 6px;\n    display: none;\n    flex-direction: column;\n    z-index: 100;\n    white-space: nowrap;\n  }\n\n  .dropdown-menu a {\n    display: block;\n    padding: 0.5rem 0.8rem;\n    color: #7D0202;\n    text-decoration: none;\n  }\n\n  .dropdown-menu a:hover {\n    background: #7D0202;\n    color: #fff;\n  }\n\n  .project-select-wrapper.open .dropdown-menu {\n    display: flex;\n  }\n<\/style>\n\n<div class=\"project-select-wrapper\">\n  <label for=\"project-toggle\">See other projects<\/label>\n  <button id=\"project-toggle\" class=\"custom-select\" type=\"button\">Select<\/button>\n  <div class=\"dropdown-menu\">\n    <a href=\"\/projects\/real%E2%80%91estate-price-prediction\/\">Real-Estate Price Prediction<\/a>\n    <a href=\"\/projects\/market-segmentation-aaa-strategy-uoi-games\/\">Market Segmentation &#038; AAA Strategy<\/a>\n    <a href=\"\/projects\/portfolio-creation-documentation\/\">Portfolio Creation &#038; Documentation<\/a>\n    <a href=\"\/projects\/the-hidden-realities-of-animation-in-france\/\">Personal survey: \u201cthe Hidden Realities of Animation in France\u201d<\/a>\n    <a href=\"\/projects\/power-bi-project-dashboard-sanitoral\/\">Power BI Project Dashboard<\/a>\n    <a href=\"\/projects\/stock-management-data-cleaning-bottleneck\/\">Stock Management &#038; Data Cleaning<\/a>\n    <a href=\"\/projects\/sales-dashboard-recs-bottleneck\/\">Dashboard &#038; Business Recommandations<\/a>\n    <a href=\"\/projects\/customer-satisfaction-tracking-bestmarket\/\">Customer Satisfaction Tracking<\/a>\n    <a href=\"\/projects\/gdpr%E2%80%91compliant-data-collection\/\">GDPR-Compliant Data Collection<\/a>\n    <a href=\"\/projects\/analyze-customer-churn\/\">Analyze Customer Churn<\/a>\n    <a href=\"\/projects\/sql-practice-housing-insurance\/\">SQL Practice : Housing Insurance<\/a>\n    <a href=\"\/projects\/analysis-of-my-business-intelligence-analyst-training\/\">Analysis of my Business Intelligence Analyst training<\/a>\n  <\/div>\n<\/div>\n\n<script>\n  const toggle = document.getElementById('project-toggle');\n  const wrapper = document.querySelector('.project-select-wrapper');\n\n  toggle.addEventListener('click', () => {\n    wrapper.classList.toggle('open');\n  });\n\n  document.addEventListener('click', (e) => {\n    if (!wrapper.contains(e.target)) {\n      wrapper.classList.remove('open');\n    }\n  });\n\n  document.querySelectorAll('.dropdown-menu a').forEach(link => {\n    link.addEventListener('click', () => {\n      window.location.href = link.href;\n    });\n  });\n<\/script>\n\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>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}]}}