{"id":75,"date":"2025-04-16T09:07:32","date_gmt":"2025-04-16T09:07:32","guid":{"rendered":"http:\/\/portfolio-data.local\/?p=75"},"modified":"2025-05-06T10:41:28","modified_gmt":"2025-05-06T10:41:28","slug":"6-2","status":"publish","type":"post","link":"https:\/\/riverphot.com\/data\/6-2\/","title":{"rendered":"Tableau de bord Power BI pour la gestion de projets"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"75\" class=\"elementor elementor-75\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-843a64a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"843a64a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bb1ff17\" data-id=\"bb1ff17\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c26e0bf elementor-widget elementor-widget-heading\" data-id=\"c26e0bf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Tableau de bord Power BI pour la gestion de projets<br>Sanitoral Project Monitor<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-50fb5d1 elementor-widget elementor-widget-heading\" data-id=\"50fb5d1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Objectif du projet<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f0cd55b elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"f0cd55b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5216c1e elementor-widget elementor-widget-text-editor\" data-id=\"5216c1e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Concevoir un tableau de bord interactif sous Power BI pour l\u2019entreprise Sanitoral, permettant de visualiser, suivre et analyser l\u2019avancement de ses projets IT et marketing. L\u2019objectif \u00e9tait d\u2019offrir un outil simple et accessible aux chefs de projets pour anticiper les retards, v\u00e9rifier les performances et orienter les d\u00e9cisions strat\u00e9giques.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4e6937d elementor-widget elementor-widget-heading\" data-id=\"4e6937d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Approche m\u00e9thodologique<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8829f12 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"8829f12\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b990dcf elementor-widget elementor-widget-text-editor\" data-id=\"b990dcf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Le projet a d\u00e9marr\u00e9 par l\u2019analyse des besoins exprim\u00e9s par l\u2019entreprise cliente : disposer d\u2019un outil de pilotage visuel centr\u00e9 sur les \u00e9carts entre pr\u00e9visionnel et r\u00e9alis\u00e9, \u00e0 l\u2019\u00e9chelle des phases de projet.<\/p>\n<p>Les donn\u00e9es brutes ont \u00e9t\u00e9 nettoy\u00e9es et transform\u00e9es dans Power Query, notamment pour cr\u00e9er un mod\u00e8le relationnel exploitable. Un accent particulier a \u00e9t\u00e9 mis sur la conception d\u2019indicateurs dynamiques, incluant le calcul d\u2019\u00e9carts de dates et de taux de r\u00e9alisation.<\/p>\n<p>Des visuels pertinents ont \u00e9t\u00e9 s\u00e9lectionn\u00e9s (cartes, jauges, KPI) pour restituer les informations de mani\u00e8re intuitive, tout en offrant des filtres interactifs (par projet, par type, par statut).<\/p>\n<p>Enfin, des mesures DAX ont permis d\u2019automatiser certains calculs critiques pour l\u2019analyse crois\u00e9e.<\/p>\n<p>Une attention particuli\u00e8re a \u00e9t\u00e9 port\u00e9e \u00e0 l\u2019adaptation du tableau de bord aux diff\u00e9rents profils d\u2019utilisateurs. Trois niveaux d&rsquo;acc\u00e8s ont \u00e9t\u00e9 pris en compte : les responsables monde, r\u00e9gionaux et pays. Chacun peut se connecter et visualiser les indicateurs filtr\u00e9s selon son p\u00e9rim\u00e8tre, gr\u00e2ce \u00e0 une configuration dynamique des filtres et r\u00f4les. Cette personnalisation permet \u00e0 chaque niveau d\u00e9cisionnel d\u2019acc\u00e9der rapidement aux informations pertinentes, tout en conservant une structure unique de tableau de bord.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3300aeb elementor-widget elementor-widget-image\" data-id=\"3300aeb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"449\" src=\"https:\/\/riverphot.com\/data\/wp-content\/uploads\/2025\/05\/sanitoral1-1024x575.jpg\" class=\"attachment-large size-large wp-image-503\" alt=\"Dashboard PowerBi Gestion de Projet\" srcset=\"https:\/\/riverphot.com\/data\/wp-content\/uploads\/2025\/05\/sanitoral1-1024x575.jpg 1024w, https:\/\/riverphot.com\/data\/wp-content\/uploads\/2025\/05\/sanitoral1-300x168.jpg 300w, https:\/\/riverphot.com\/data\/wp-content\/uploads\/2025\/05\/sanitoral1-768x431.jpg 768w, https:\/\/riverphot.com\/data\/wp-content\/uploads\/2025\/05\/sanitoral1.jpg 1269w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e911303 elementor-widget elementor-widget-image\" data-id=\"e911303\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"448\" src=\"https:\/\/riverphot.com\/data\/wp-content\/uploads\/2025\/05\/sanitoral2-1024x573.jpg\" class=\"attachment-large size-large wp-image-504\" alt=\"Dashboard PowerBi Gestion de Projet\" srcset=\"https:\/\/riverphot.com\/data\/wp-content\/uploads\/2025\/05\/sanitoral2-1024x573.jpg 1024w, https:\/\/riverphot.com\/data\/wp-content\/uploads\/2025\/05\/sanitoral2-300x168.jpg 300w, https:\/\/riverphot.com\/data\/wp-content\/uploads\/2025\/05\/sanitoral2-768x430.jpg 768w, https:\/\/riverphot.com\/data\/wp-content\/uploads\/2025\/05\/sanitoral2.jpg 1267w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c75d8ab elementor-widget elementor-widget-image\" data-id=\"c75d8ab\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"447\" src=\"https:\/\/riverphot.com\/data\/wp-content\/uploads\/2025\/05\/sanitoral3-1024x572.jpg\" class=\"attachment-large size-large wp-image-505\" alt=\"Dashboard PowerBi Gestion de Projet\" srcset=\"https:\/\/riverphot.com\/data\/wp-content\/uploads\/2025\/05\/sanitoral3-1024x572.jpg 1024w, https:\/\/riverphot.com\/data\/wp-content\/uploads\/2025\/05\/sanitoral3-300x168.jpg 300w, https:\/\/riverphot.com\/data\/wp-content\/uploads\/2025\/05\/sanitoral3-768x429.jpg 768w, https:\/\/riverphot.com\/data\/wp-content\/uploads\/2025\/05\/sanitoral3.jpg 1267w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c81d17f elementor-widget elementor-widget-heading\" data-id=\"c81d17f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comp\u00e9tences et outils mobilis\u00e9s<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1d3674d elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"1d3674d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a1eb8ce elementor-widget elementor-widget-text-editor\" data-id=\"a1eb8ce\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul>\n<li class=\"\" data-start=\"1297\" data-end=\"1327\">\n<p class=\"\" data-start=\"1299\" data-end=\"1327\">Analyse de besoins m\u00e9tiers<\/p>\n<\/li>\n<li class=\"\" data-start=\"1328\" data-end=\"1395\">\n<p class=\"\" data-start=\"1330\" data-end=\"1395\">Pr\u00e9paration et mod\u00e9lisation de donn\u00e9es (Power Query, relations)<\/p>\n<\/li>\n<li class=\"\" data-start=\"1396\" data-end=\"1463\">\n<p class=\"\" data-start=\"1398\" data-end=\"1463\">Conception d\u2019indicateurs (calcul d\u2019\u00e9carts, taux de r\u00e9alisation)<\/p>\n<\/li>\n<li class=\"\" data-start=\"1464\" data-end=\"1511\">\n<p class=\"\" data-start=\"1466\" data-end=\"1511\">Visualisation de donn\u00e9es (Power BI Desktop)<\/p>\n<\/li>\n<li class=\"\" data-start=\"1512\" data-end=\"1539\">\n<p class=\"\" data-start=\"1514\" data-end=\"1539\">Cr\u00e9ation de mesures DAX<\/p>\n<\/li>\n<li class=\"\" data-start=\"1540\" data-end=\"1579\">\n<p class=\"\" data-start=\"1542\" data-end=\"1579\">Interactivit\u00e9 et filtrage dynamique<\/p>\n<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-808a18e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"808a18e\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7946079\" data-id=\"7946079\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8f47dee elementor-widget elementor-widget-heading\" data-id=\"8f47dee\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">\ud83d\udcbb Environnement technique et biblioth\u00e8ques\u200b<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-67bd672 liste-tag elementor-widget elementor-widget-text-editor\" data-id=\"67bd672\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<span>PowerBi<\/span>\n<span>Power Query<\/span>\n<span>Excel<\/span>\n<span>Dax<\/span>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1df6b3e elementor-widget elementor-widget-heading\" data-id=\"1df6b3e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">\ud83e\udde0 M\u00e9thodes et techniques appliqu\u00e9es<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-56a77e5 liste-tag-skills elementor-widget elementor-widget-text-editor\" data-id=\"56a77e5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<span>Nettoyage de donn\u00e9es<\/span>\n<span>Mod\u00e9lisation relationnelle<\/span>\n<span>KPI<\/span>\n<span>Filtrage dynamique<\/span>\n<span>Mesures DAX<\/span>\n<span>Visualisation interactive<\/span>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>R\u00e9alisation d\u2019un tableau de bord dynamique avec Power BI pour le client Sanitoral, visant \u00e0 suivre l\u2019avancement de projets IT et marketing. L\u2019outil permet d\u2019identifier les retards, contr\u00f4ler les performances, et faciliter la prise de d\u00e9cision gr\u00e2ce \u00e0 des indicateurs visuels clairs, un nettoyage automatis\u00e9 des donn\u00e9es, et un mod\u00e8le de donn\u00e9es optimis\u00e9.<\/p>\n","protected":false},"author":1,"featured_media":511,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_canvas","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[42,43,33,40,41],"class_list":["post-75","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-portfolio","tag-dashboard","tag-dax","tag-excel","tag-power-query","tag-powerbi"],"_links":{"self":[{"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/posts\/75","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/comments?post=75"}],"version-history":[{"count":10,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/posts\/75\/revisions"}],"predecessor-version":[{"id":510,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/posts\/75\/revisions\/510"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/media\/511"}],"wp:attachment":[{"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/media?parent=75"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/categories?post=75"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/tags?post=75"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}