{"id":311,"date":"2025-07-28T18:29:07","date_gmt":"2025-07-28T16:29:07","guid":{"rendered":"https:\/\/giulia-governatori.alwaysdata.net\/?post_type=projects&#038;p=311"},"modified":"2025-08-13T16:59:44","modified_gmt":"2025-08-13T14:59:44","slug":"power-bi-project-dashboard-sanitoral","status":"publish","type":"projects","link":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/projects\/power-bi-project-dashboard-sanitoral\/","title":{"rendered":"Cr\u00e9er un tableau de bord dynamique avec PowerBI"},"content":{"rendered":"<style>.kadence-column311_c235dd-8d > .kt-inside-inner-col,.kadence-column311_c235dd-8d > .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_c235dd-8d > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column311_c235dd-8d > .kt-inside-inner-col{flex-direction:column;}.kadence-column311_c235dd-8d > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column311_c235dd-8d > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column311_c235dd-8d{position:relative;}.kadence-column311_c235dd-8d, .kt-inside-inner-col > .kadence-column311_c235dd-8d:not(.specificity){margin-top:30px;margin-bottom:30px;}@media all and (max-width: 1024px){.kadence-column311_c235dd-8d > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column311_c235dd-8d > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column311_c235dd-8d\"><div class=\"kt-inside-inner-col\"><style>.kb-row-layout-id311_56737c-7c > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id311_56737c-7c > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id311_56737c-7c > .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-id311_56737c-7c > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}.kb-row-layout-id311_56737c-7c > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}.kb-row-layout-id311_56737c-7c > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id311_56737c-7c > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}}@media all and (max-width: 1024px){.kb-row-layout-id311_56737c-7c > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}@media all and (max-width: 767px){.kb-row-layout-id311_56737c-7c > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}.kb-row-layout-id311_56737c-7c > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}<\/style><div class=\"kb-row-layout-wrap kb-row-layout-id311_56737c-7c 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-column311_cb053b-ee > .kt-inside-inner-col,.kadence-column311_cb053b-ee > .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_cb053b-ee > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column311_cb053b-ee > .kt-inside-inner-col{flex-direction:column;}.kadence-column311_cb053b-ee > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column311_cb053b-ee > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column311_cb053b-ee{position:relative;}@media all and (max-width: 1024px){.kadence-column311_cb053b-ee > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column311_cb053b-ee > .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-column311_cb053b-ee\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading311_f90c05-bc, .wp-block-kadence-advancedheading.kt-adv-heading311_f90c05-bc[data-kb-block=\"kb-adv-heading311_f90c05-bc\"]{font-size:var(--global-kb-font-size-sm, 0.9rem);font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading311_f90c05-bc mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading311_f90c05-bc[data-kb-block=\"kb-adv-heading311_f90c05-bc\"] 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-heading311_f90c05-bc img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading311_f90c05-bc[data-kb-block=\"kb-adv-heading311_f90c05-bc\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading311_f90c05-bc wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading311_f90c05-bc\">Sant\u00e9 \u2013 Sanitoral (Openclassroom)<\/p>\n<\/div><\/div>\n\n\n<style>.kadence-column311_c05901-c5 > .kt-inside-inner-col{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kadence-column311_c05901-c5 > .kt-inside-inner-col,.kadence-column311_c05901-c5 > .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_c05901-c5 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column311_c05901-c5 > .kt-inside-inner-col{flex-direction:column;}.kadence-column311_c05901-c5 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column311_c05901-c5 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column311_c05901-c5{position:relative;}.kadence-column311_c05901-c5, .kt-inside-inner-col > .kadence-column311_c05901-c5:not(.specificity){margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;}@media all and (max-width: 1024px){.kadence-column311_c05901-c5 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column311_c05901-c5 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column311_c05901-c5\"><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\">Cr\u00e9er un tableau de bord dynamique avec PowerBI<\/h1><\/div><\/div>\n\n\n<style>.kadence-column311_a90029-ca > .kt-inside-inner-col{display:flex;}.kadence-column311_a90029-ca > .kt-inside-inner-col{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kadence-column311_a90029-ca > .kt-inside-inner-col,.kadence-column311_a90029-ca > .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_a90029-ca > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column311_a90029-ca > .kt-inside-inner-col{flex-direction:column;align-items:flex-start;}.kadence-column311_a90029-ca > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column311_a90029-ca > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column311_a90029-ca > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column311_a90029-ca > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column311_a90029-ca{position:relative;}@media all and (max-width: 1024px){.kadence-column311_a90029-ca > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}@media all and (max-width: 767px){.kadence-column311_a90029-ca > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column311_a90029-ca\"><div class=\"kt-inside-inner-col\"><style>.kb-row-layout-wrap.wp-block-kadence-rowlayout.kb-row-layout-id311_8fef63-3a{margin-top:0px;margin-bottom:0px;}.kb-row-layout-id311_8fef63-3a > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id311_8fef63-3a > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id311_8fef63-3a > .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-id311_8fef63-3a > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id311_8fef63-3a > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}}@media all and (max-width: 1024px){.kb-row-layout-id311_8fef63-3a > .kt-row-column-wrap{grid-template-columns:repeat(3, minmax(0, 1fr));}}@media all and (max-width: 767px){.kb-row-layout-id311_8fef63-3a > .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-id311_8fef63-3a 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-column311_7924e8-e5 > .kt-inside-inner-col{display:flex;}.kadence-column311_7924e8-e5 > .kt-inside-inner-col,.kadence-column311_7924e8-e5 > .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_7924e8-e5 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column311_7924e8-e5 > .kt-inside-inner-col{flex-direction:column;align-items:flex-start;}.kadence-column311_7924e8-e5 > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column311_7924e8-e5 > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column311_7924e8-e5 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column311_7924e8-e5 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column311_7924e8-e5{position:relative;}@media all and (max-width: 1024px){.kadence-column311_7924e8-e5 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}@media all and (max-width: 767px){.kadence-column311_7924e8-e5 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column311_7924e8-e5\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading311_894563-45, .wp-block-kadence-advancedheading.kt-adv-heading311_894563-45[data-kb-block=\"kb-adv-heading311_894563-45\"]{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-heading311_894563-45 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading311_894563-45[data-kb-block=\"kb-adv-heading311_894563-45\"] 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-heading311_894563-45 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading311_894563-45[data-kb-block=\"kb-adv-heading311_894563-45\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading311_894563-45 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading311_894563-45\">Fictif<\/p>\n<\/div><\/div>\n\n\n<style>.kadence-column311_ffeb38-6a > .kt-inside-inner-col,.kadence-column311_ffeb38-6a > .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_ffeb38-6a > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column311_ffeb38-6a > .kt-inside-inner-col{flex-direction:column;}.kadence-column311_ffeb38-6a > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column311_ffeb38-6a > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column311_ffeb38-6a{position:relative;}@media all and (max-width: 1024px){.kadence-column311_ffeb38-6a > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column311_ffeb38-6a > .kt-inside-inner-col{display:flex;flex-direction:column;justify-content:center;align-items:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column311_ffeb38-6a\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading311_a09441-04, .wp-block-kadence-advancedheading.kt-adv-heading311_a09441-04[data-kb-block=\"kb-adv-heading311_a09441-04\"]{font-size:var(--global-kb-font-size-sm, 0.9rem);font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading311_a09441-04 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading311_a09441-04[data-kb-block=\"kb-adv-heading311_a09441-04\"] 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-heading311_a09441-04 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading311_a09441-04[data-kb-block=\"kb-adv-heading311_a09441-04\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading311_a09441-04 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading311_a09441-04\">|<\/p>\n<\/div><\/div>\n\n\n<style>.kadence-column311_8a7b8f-bd > .kt-inside-inner-col,.kadence-column311_8a7b8f-bd > .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_8a7b8f-bd > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column311_8a7b8f-bd > .kt-inside-inner-col{flex-direction:column;}.kadence-column311_8a7b8f-bd > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column311_8a7b8f-bd > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column311_8a7b8f-bd{position:relative;}@media all and (max-width: 1024px){.kadence-column311_8a7b8f-bd > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column311_8a7b8f-bd > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column311_8a7b8f-bd\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading311_9898b8-e5, .wp-block-kadence-advancedheading.kt-adv-heading311_9898b8-e5[data-kb-block=\"kb-adv-heading311_9898b8-e5\"]{text-align:left;font-size:var(--global-kb-font-size-sm, 0.9rem);font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading311_9898b8-e5 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading311_9898b8-e5[data-kb-block=\"kb-adv-heading311_9898b8-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-heading311_9898b8-e5 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading311_9898b8-e5[data-kb-block=\"kb-adv-heading311_9898b8-e5\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading311_9898b8-e5 project-dates wp-block-kadence-advancedheading has-theme-palette-5-color has-text-color\" data-kb-block=\"kb-adv-heading311_9898b8-e5\">10\/03\/2025 &gt; 10\/04\/2025<\/p>\n<\/div><\/div>\n\n<\/div><\/div><\/div><\/div>\n\n\n<style>.kadence-column311_250bda-11 > .kt-inside-inner-col,.kadence-column311_250bda-11 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column311_250bda-11 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column311_250bda-11 > .kt-inside-inner-col{flex-direction:column;}.kadence-column311_250bda-11 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column311_250bda-11 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column311_250bda-11{position:relative;}@media all and (max-width: 1024px){.kadence-column311_250bda-11 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column311_250bda-11 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column311_250bda-11\"><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-column951_8ea1bb-37 > .kt-inside-inner-col{display:flex;}.kadence-column951_8ea1bb-37 > .kt-inside-inner-col,.kadence-column951_8ea1bb-37 > .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-column951_8ea1bb-37 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column951_8ea1bb-37 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}.kadence-column951_8ea1bb-37 > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column951_8ea1bb-37 > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column951_8ea1bb-37 > .kt-inside-inner-col > .aligncenter{width:100%;}.kt-row-column-wrap > .kadence-column951_8ea1bb-37{align-self:center;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column951_8ea1bb-37{align-self:auto;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column951_8ea1bb-37 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}.kadence-column951_8ea1bb-37 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column951_8ea1bb-37{position:relative;}.kadence-column951_8ea1bb-37, .kt-inside-inner-col > .kadence-column951_8ea1bb-37:not(.specificity){margin-top:30px;margin-bottom:0px;}@media all and (max-width: 1024px){.kt-row-column-wrap > .kadence-column951_8ea1bb-37{align-self:center;}}@media all and (max-width: 1024px){.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column951_8ea1bb-37{align-self:auto;}}@media all and (max-width: 1024px){.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column951_8ea1bb-37 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 1024px){.kadence-column951_8ea1bb-37 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}}@media all and (max-width: 767px){.kt-row-column-wrap > .kadence-column951_8ea1bb-37{align-self:center;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column951_8ea1bb-37{align-self:auto;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column951_8ea1bb-37 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}.kadence-column951_8ea1bb-37 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column951_8ea1bb-37\"><div class=\"kt-inside-inner-col\"><style>.kb-row-layout-id951_48f54d-ab > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id951_48f54d-ab > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id951_48f54d-ab > .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-id951_48f54d-ab > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id951_48f54d-ab > .kt-row-column-wrap{grid-template-columns:minmax(0, 2fr) minmax(0, 1fr);}}@media all and (max-width: 767px){.kb-row-layout-id951_48f54d-ab > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}<\/style><div class=\"kb-row-layout-wrap kb-row-layout-id951_48f54d-ab 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-column951_d0b206-ea > .kt-inside-inner-col,.kadence-column951_d0b206-ea > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column951_d0b206-ea > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column951_d0b206-ea > .kt-inside-inner-col{flex-direction:column;}.kadence-column951_d0b206-ea > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column951_d0b206-ea > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column951_d0b206-ea{position:relative;}@media all and (max-width: 1024px){.kadence-column951_d0b206-ea > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column951_d0b206-ea > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column951_d0b206-ea\"><div class=\"kt-inside-inner-col\"><style>.kb-gallery-id-951_e3121f-56.kb-gallery-ul.kb-gallery-type-fluidcarousel .kt-blocks-carousel figure .kb-gal-image-radius, .kb-gallery-id-951_e3121f-56.kb-gallery-ul.kb-gallery-type-fluidcarousel .kt-blocks-carousel figure .kb-gal-image-radius img{height:350px;}.kb-gallery-id-951_e3121f-56 .kadence-blocks-gallery-item .kb-gal-image-radius, .kb-gallery-id-951_e3121f-56 .kb-slide-item .kb-gal-image-radius img{border-radius:0px 0px 0px 0px;;}.kb-gallery-wrap-id-951_e3121f-56.wp-block-kadence-advancedgallery{overflow:visible;}.kb-gallery-wrap-id-951_e3121f-56.wp-block-kadence-advancedgallery .kt-blocks-carousel{overflow:visible;max-width:100%;}.kb-gallery-id-951_e3121f-56 .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-951_e3121f-56 .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-951_e3121f-56 alignnone wp-block-kadence-advancedgallery\"><div class=\"kb-gallery-ul kb-gallery-non-static kb-gallery-type-fluidcarousel kb-gallery-id-951_e3121f-56 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\/P7_0.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\/P7_0.webp\" width=\"1334\" height=\"753\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_0.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_0.webp\" data-id=\"879\" class=\"wp-image-879 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_0.webp 1334w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_0-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_0-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_0-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\/P7_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\/P7_1.webp\" width=\"1334\" height=\"753\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_1.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_1.webp\" data-id=\"880\" class=\"wp-image-880 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_1.webp 1334w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_1-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_1-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_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\/P7_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\/P7_2.webp\" width=\"1334\" height=\"753\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_2.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_2.webp\" data-id=\"881\" class=\"wp-image-881 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_2.webp 1334w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_2-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_2-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_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\/P7_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\/P7_3.webp\" width=\"1334\" height=\"753\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_3.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_3.webp\" data-id=\"882\" class=\"wp-image-882 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_3.webp 1334w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_3-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_3-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_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\/P7_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\/P7_4.webp\" width=\"1334\" height=\"753\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_4.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_4.webp\" data-id=\"883\" class=\"wp-image-883 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_4.webp 1334w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_4-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_4-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_4-768x434.webp 768w\" sizes=\"auto, (max-width: 1334px) 100vw, 1334px\" \/><\/div><\/div><\/a><\/figure><\/div><\/div><\/li><li class=\"kb-slide-item kb-gallery-carousel-item splide__slide\"><div class=\"kadence-blocks-gallery-item\"><div class=\"kadence-blocks-gallery-item-inner\"><figure class=\"kb-gallery-figure kb-gallery-item-has-link kadence-blocks-gallery-item-hide-caption\"><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_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\/P7_5.webp\" width=\"1334\" height=\"753\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_5.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_5.webp\" data-id=\"884\" class=\"wp-image-884 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_5.webp 1334w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_5-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_5-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_5-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\/P7_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\/P7_6.webp\" width=\"1334\" height=\"753\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_6.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_6.webp\" data-id=\"885\" class=\"wp-image-885 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_6.webp 1334w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_6-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_6-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P7_6-768x434.webp 768w\" sizes=\"auto, (max-width: 1334px) 100vw, 1334px\" \/><\/div><\/div><\/a><\/figure><\/div><\/div><\/li><\/ul><\/div><\/div><\/div><\/div><\/div><\/div>\n\n\n<style>.kadence-column951_e78e3e-9c > .kt-inside-inner-col,.kadence-column951_e78e3e-9c > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column951_e78e3e-9c > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column951_e78e3e-9c > .kt-inside-inner-col{flex-direction:column;}.kadence-column951_e78e3e-9c > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column951_e78e3e-9c > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column951_e78e3e-9c{position:relative;}@media all and (max-width: 1024px){.kadence-column951_e78e3e-9c > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column951_e78e3e-9c > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column951_e78e3e-9c\"><div class=\"kt-inside-inner-col\"><style>.kb-table-of-content-nav.kb-table-of-content-id951_7e3c07-5e .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-id951_7e3c07-5e .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-id951_7e3c07-5e .kb-table-of-contents-title-wrap{color:#9b9958;}.kb-table-of-content-nav.kb-table-of-content-id951_7e3c07-5e .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-id951_7e3c07-5e .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-id951_7e3c07-5e .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 \u00e9t\u00e9 missionn\u00e9e par Sanitoral (fictif), fabricant international de soins bucco\u2011dentaires, pour concevoir un tableau de bord dynamique sous Power\u202fBI afin de \u202f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u202fSuivre l\u2019avancement de leurs projets (typologies IT et Marketing, de 2018 \u00e0 d\u00e9but\u202f2022) ;<\/li>\n\n\n\n<li>\u202fIdentifier automatiquement les d\u00e9passements de budget (&gt;\u202f+15\u202f%), les retards (&gt;\u202f+15\u202f%) et les baisses de livraison (&lt;\u202f\u201315\u202f%) ;<\/li>\n\n\n\n<li>Permettre aux directeurs (G\u00e9n\u00e9ral, R\u00e9gional, Pays) de filtrer par phase, typologie et zone g\u00e9ographique pour guider leurs d\u00e9cisions strat\u00e9giques.<\/li>\n<\/ul>\n\n\n\n<p>Le Product Strategy Canvas a \u00e9t\u00e9 valid\u00e9 le 14\/03\/2025 par Sophie, cheffe\u202fde\u202fprojet, et j'ai structur\u00e9 ainsi les user stories pour chaque r\u00f4le.<\/p>\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 du logiciel de gestion de projets de Sanitoral (fichiers CSV import\u00e9s dans Power\u202fBI)<\/li>\n\n\n\n<li><strong>Tables<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Projects plans:  Project ID, Phase, Phase ID, Start Date, Planned_Duration, Planned_Cost, Planned_Delivrable (520 lignes)<\/li>\n\n\n\n<li>Project Type:  Project ID, Project Type (520 lignes)<\/li>\n\n\n\n<li>Actual Cost:  Project ID, Phase ID, Phase, Actual_Cost (520 lignes)<\/li>\n\n\n\n<li>Actual Delivrable:  Project ID, Phase ID, Phase, Actual_Delivrable (520 lignes)<\/li>\n\n\n\n<li>Actual Duraction:  Project ID, Phase ID, Phase, Actual_Duraction (520 lignes)<\/li>\n\n\n\n<li>Country Profiles: Country, Region, Type (52 lignes)<\/li>\n\n\n\n<li>Project Location: Project ID, Country, NormalizedCountry, NormalizedCountryMAP.NAME_FR (104 lignes)<\/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>Recueil et cadrage<\/strong>: formalisation du PSC (Product Strategy Canvas) valid\u00e9 avec le client.<\/li>\n\n\n\n<li><strong>Pr\u00e9\u2011traitement\u202f :<\/strong>\n<ul class=\"wp-block-list\">\n<li>Power\u202fQuery Editor pour automatiser les \u00e9tapes de nettoyage: \u202fnettoyage des dates, typage, suppression de doublons, cr\u00e9ation de colonnes calcul\u00e9es (d\u00e9lais r\u00e9els vs pr\u00e9vus, % budget consomm\u00e9).<\/li>\n\n\n\n<li>Jointure des tables (Projects\u202f\u2194\u202fPhases\u202f\u2194\u202fDeliverables) sans toucher aux sources.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Mod\u00e9lisation<\/strong>\u202f: sch\u00e9ma de donn\u00e9es dans Power\u202fBI (relations 1\u2013N), model \u00e0 \u00e9toile<\/li>\n\n\n\n<li><strong>D\u00e9veloppement du dashboard\u202f :<\/strong>\n<ul class=\"wp-block-list\">\n<li>Mesures DAX pour\u202f :\n<ol class=\"wp-block-list\">\n<li>%\u202fde d\u00e9passement de budget <\/li>\n\n\n\n<li>%\u202fde retard <\/li>\n\n\n\n<li>%\u202fd\u2019\u00e9cart de livraison<\/li>\n<\/ol>\n<\/li>\n\n\n\n<li>Visualisations cl\u00e9s\u202f: KPI cards, Gantt chart par typologie (extension Gantt), heatmap de retards, slicers (pays, phase, typologie).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Storytelling &amp; documentation<\/strong>:\u202fonglet \u201cMise \u00e0 jour\u201d int\u00e9grant le PSC en image, la proc\u00e9dure Power\u202fQuery en screenshots.<\/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>Bilan global \u202f:<\/strong>\n<ul class=\"wp-block-list\">\n<li>46\u202f% des phases ont d\u00e9pass\u00e9 le budget de &gt;\u202f15%<\/li>\n\n\n\n<li>18\u202f% des phases accusent un retard &gt;\u202f15%<\/li>\n\n\n\n<li>30\u202f% des phases ont livr\u00e9 &lt;\u202f85% des livrables pr\u00e9vus<\/li>\n\n\n\n<li>28 % des phases respectent les 3 KPI<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Performance par typologie\u202f:<\/strong>\n<ul class=\"wp-block-list\">\n<li>IT vs Marketing \u2013 comparaison des taux de retard et de d\u00e9passement:\n l'IT a +11 % de phases avec probl\u00e8mes<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Analyse g\u00e9ographique\u202f:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Les Pays avec le plus de retards sont aussi les Pays avec le plus de travail.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Axes strat\u00e9giques\u202f:<\/strong>\n<ol class=\"wp-block-list\">\n<li>Renforcer l\u2019anticipation sur les phases \u00e0 fort retard<\/li>\n\n\n\n<li>Ajuster la planification budg\u00e9taire et les d\u00e9lais par typologie et par zone, selon la quantit\u00e9 de travail<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Business Impact<\/h2>\n\n\n\n<p>Gr\u00e2ce \u00e0 ce dashboard, Sanitoral peut d\u00e9sormais\u202f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Suivre en temps r\u00e9el l\u2019\u00e9tat d\u2019avancement et anticiper les retards.<\/li>\n\n\n\n<li>Piloter les budgets et ajuster les allocations de ressources avant les comit\u00e9s.<\/li>\n\n\n\n<li>Mettre \u00e0 jour les donn\u00e9es eux\u2011m\u00eames chaque semaine via Power\u202fQuery.<\/li>\n\n\n\n<li>Disposer d\u2019un support de storytelling structur\u00e9 pour la prise de d\u00e9cision au CODIR.<\/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\/P7\/Product_Strategy_Canvas3.docx\" data-type=\"link\" data-id=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P7\/Product_Strategy_Canvas3.docx\" target=\"_blank\" rel=\"noreferrer noopener\">Product strategy Canvas<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P7\/P7_presentation_GG.pdf\" data-type=\"link\" data-id=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P7\/P7_presentation_GG.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Pr\u00e9sentation<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P7\/P7_screenshots_dashboard_GG.pdf\" data-type=\"link\" data-id=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P7\/P7_screenshots_dashboard_GG.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Dashboard Screenshots<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Dashboard<\/h2>\n\n\n\n<p><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/fr\/dashboard-p7\/\" data-type=\"page\" data-id=\"945\">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>Healthcare &#8211; Sanitoral (Openclassroom) Fictional | 10\/03\/2025 &gt; 10\/04\/2025 Context I was tasked by Sanitoral, an international oral care manufacturer, to design a dynamic Power BI dashboard to: The Product Strategy Canvas was approved on March 14, 2025 by Sophie, project manager, and I structured the user stories for each role accordingly. Datasets Workflow Insights&#8230;<\/p>","protected":false},"featured_media":290,"menu_order":5,"template":"","meta":{"_kad_post_transparent":"","_kad_post_title":"hide","_kad_post_layout":"default","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"default","_kad_post_feature_position":"below","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":""},"categories":[36,8,35,4,34,5,29,7,15,6,31,24,25,9],"class_list":["post-311","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-kpi-tracking","category-languages","category-m","category-power-bi","category-power-query","category-statistical-analysis"],"_links":{"self":[{"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/projects\/311","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\/290"}],"wp:attachment":[{"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/media?parent=311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/categories?post=311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}