{"id":1322,"date":"2026-02-12T19:25:30","date_gmt":"2026-02-12T18:25:30","guid":{"rendered":"https:\/\/datalover.fr\/?page_id=1322"},"modified":"2026-02-13T10:37:41","modified_gmt":"2026-02-13T09:37:41","slug":"suivi-des-ventes-mensuelles","status":"publish","type":"page","link":"https:\/\/datalover.fr\/index.php\/suivi-des-ventes-mensuelles\/","title":{"rendered":"Suivi des Ventes Mensuelles"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"1322\" class=\"elementor elementor-1322\" data-elementor-post-type=\"page\">\n\t\t\t\t<div class=\"elementor-element elementor-element-00db973 e-flex e-con-boxed e-con e-parent\" data-id=\"00db973\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-1bd74da e-con-full e-flex e-con e-child\" data-id=\"1bd74da\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-baa1506 elementor-widget elementor-widget-heading\" data-id=\"baa1506\" 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\">Contexte<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3664619 e-grid e-con-full e-con e-child\" data-id=\"3664619\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b7bae28 elementor-widget elementor-widget-text-editor\" data-id=\"b7bae28\" 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>Un groupe <strong>industriel<\/strong> Europ\u00e9en sp\u00e9cialis\u00e9 dans l\u2019\u00e9quipement des camions et semi-remorques souhaite <strong>mettre \u00e0 disposition des managers<\/strong> un suivi d\u00e9taill\u00e9 des ventes mensuelles, avec une <strong>outil facile d\u2019acc\u00e8s<\/strong> et <strong>aucune maintenance technique<\/strong>.<\/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-cc2a658 elementor-widget elementor-widget-image\" data-id=\"cc2a658\" 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=\"750\" height=\"1125\" src=\"https:\/\/datalover.fr\/wp-content\/uploads\/2026\/02\/camion-768x1152.png\" class=\"attachment-medium_large size-medium_large wp-image-1331\" alt=\"camion\" srcset=\"https:\/\/datalover.fr\/wp-content\/uploads\/2026\/02\/camion-768x1152.png 768w, https:\/\/datalover.fr\/wp-content\/uploads\/2026\/02\/camion-200x300.png 200w, https:\/\/datalover.fr\/wp-content\/uploads\/2026\/02\/camion-683x1024.png 683w, https:\/\/datalover.fr\/wp-content\/uploads\/2026\/02\/camion.png 1024w\" sizes=\"(max-width: 750px) 100vw, 750px\" style=\"width:100%;height:150%;max-width:1024px\" \/>\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>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-4c9bb88 e-con-full e-flex e-con e-child\" data-id=\"4c9bb88\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-51b0285 elementor-widget elementor-widget-spacer\" data-id=\"51b0285\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\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-c78086b elementor-widget elementor-widget-heading\" data-id=\"c78086b\" 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\">Enjeux<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ba850fc elementor-widget elementor-widget-text-editor\" data-id=\"ba850fc\" 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>Mod\u00e9liser le <span style=\"text-decoration: underline;\">sch\u00e9ma de donn\u00e9es<\/span> dans un groupe qui souffre d\u2019un manque de structuration des donn\u00e9es malgr\u00e9 l\u2019abondance des outils et des investissements informatiques<br \/><span style=\"text-decoration: underline;\">Synth\u00e9tiser<\/span> l\u2019information de fa\u00e7on claire pour une utilisation facile pour tous les m\u00e9tiers, et permettre \u00e0 la direction de voir d\u2019un coup d\u2019\u0153il les <span style=\"text-decoration: underline;\">performances<\/span> par g\u00e9ographie, par vendeur, article, client\u2026<br \/>Utiliser <strong>Power BI<\/strong> pour la cr\u00e9ation et la publication du 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-756a487 elementor-widget elementor-widget-spacer\" data-id=\"756a487\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\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-fa9fd86 elementor-widget elementor-widget-heading\" data-id=\"fa9fd86\" 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\">Proc\u00e9d\u00e9 technique<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8608661 elementor-widget elementor-widget-text-editor\" data-id=\"8608661\" 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<ol style=\"direction: ltr; unicode-bidi: embed; margin-top: 0in; margin-bottom: 0in; font-family: Calibri; font-size: 11.0pt; font-weight: normal; font-style: normal;\" type=\"1\"><li lang=\"en-US\" style=\"margin-top: 0; margin-bottom: 0; vertical-align: middle;\" value=\"1\"><p>D\u00e9finir le besoin : suivre les ventes mensuelles avec la possibilit\u00e9 de filtrer selon les axes analytiques de l\u2019entreprise<\/p><\/li><li lang=\"en-US\" style=\"margin-top: 0; margin-bottom: 0; vertical-align: middle;\"><p>Sch\u00e9matiser le rendu final sur une maquette (mockup)<\/p><\/li><li lang=\"en-US\" style=\"margin-top: 0; margin-bottom: 0; vertical-align: middle;\"><p>Identifier la source de donn\u00e9es (Direct Query de SQL Server), normaliser les champs, construire le mod\u00e8le de donn\u00e9es en \u00e9toile<\/p><\/li><li lang=\"en-US\" style=\"margin-top: 0; margin-bottom: 0; vertical-align: middle;\"><p>Test avec des donn\u00e9es r\u00e9elles puis recette du produit avec la direction financi\u00e8re<\/p><\/li><li lang=\"en-US\" style=\"margin-top: 0; margin-bottom: 0; vertical-align: middle;\"><p><span style=\"font-family: Calibri; font-size: 11.0pt;\">Go-live ! et formation de l\u2019\u00e9quipe contr\u00f4le de gestion pour la suite<\/span><\/p><\/li><\/ol>\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-82c001f elementor-widget elementor-widget-spacer\" data-id=\"82c001f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\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-a3d73f4 elementor-widget elementor-widget-heading\" data-id=\"a3d73f4\" 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\">R\u00e9sultat<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-666c968 elementor-widget elementor-widget-text-editor\" data-id=\"666c968\" 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>Un rapport cr\u00e9\u00e9 sur Power BI Desktop et publi\u00e9 pour un acc\u00e8s via Teams. Synth\u00e9tique et robuste !<\/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-d2f2a76 elementor-widget elementor-widget-gallery\" data-id=\"d2f2a76\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;columns&quot;:2,&quot;lazyload&quot;:&quot;yes&quot;,&quot;gallery_layout&quot;:&quot;grid&quot;,&quot;columns_tablet&quot;:2,&quot;columns_mobile&quot;:1,&quot;gap&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:10,&quot;sizes&quot;:[]},&quot;gap_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:10,&quot;sizes&quot;:[]},&quot;gap_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:10,&quot;sizes&quot;:[]},&quot;link_to&quot;:&quot;file&quot;,&quot;aspect_ratio&quot;:&quot;3:2&quot;,&quot;overlay_background&quot;:&quot;yes&quot;,&quot;content_hover_animation&quot;:&quot;fade-in&quot;}\" data-widget_type=\"gallery.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-gallery__container\">\n\t\t\t\t\t\t\t<a class=\"e-gallery-item elementor-gallery-item elementor-animated-content\" href=\"https:\/\/datalover.fr\/wp-content\/uploads\/2026\/02\/SuiviVentes2.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-slideshow=\"d2f2a76\" data-elementor-lightbox-title=\"SuiviVentes2\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTMzNCwidXJsIjoiaHR0cHM6XC9cL2RhdGFsb3Zlci5mclwvd3AtY29udGVudFwvdXBsb2Fkc1wvMjAyNlwvMDJcL1N1aXZpVmVudGVzMi5wbmciLCJzbGlkZXNob3ciOiJkMmYyYTc2In0%3D\">\n\t\t\t\t\t<div class=\"e-gallery-image elementor-gallery-item__image\" data-thumbnail=\"https:\/\/datalover.fr\/wp-content\/uploads\/2026\/02\/SuiviVentes2-768x432.png\" data-width=\"750\" data-height=\"422\" aria-label=\"Suivi des Ventes Mensuelles\" role=\"img\" ><\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-gallery-item__overlay\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t<a class=\"e-gallery-item elementor-gallery-item elementor-animated-content\" href=\"https:\/\/datalover.fr\/wp-content\/uploads\/2026\/02\/SuiviVentes1.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-slideshow=\"d2f2a76\" data-elementor-lightbox-title=\"SuiviVentes1\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTMzMywidXJsIjoiaHR0cHM6XC9cL2RhdGFsb3Zlci5mclwvd3AtY29udGVudFwvdXBsb2Fkc1wvMjAyNlwvMDJcL1N1aXZpVmVudGVzMS5wbmciLCJzbGlkZXNob3ciOiJkMmYyYTc2In0%3D\">\n\t\t\t\t\t<div class=\"e-gallery-image elementor-gallery-item__image\" data-thumbnail=\"https:\/\/datalover.fr\/wp-content\/uploads\/2026\/02\/SuiviVentes1-768x431.png\" data-width=\"750\" data-height=\"421\" aria-label=\"\" role=\"img\" ><\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-gallery-item__overlay\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t<a class=\"e-gallery-item elementor-gallery-item elementor-animated-content\" href=\"https:\/\/datalover.fr\/wp-content\/uploads\/2026\/02\/SuiviVentes3.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-slideshow=\"d2f2a76\" data-elementor-lightbox-title=\"SuiviVentes3\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTMzNSwidXJsIjoiaHR0cHM6XC9cL2RhdGFsb3Zlci5mclwvd3AtY29udGVudFwvdXBsb2Fkc1wvMjAyNlwvMDJcL1N1aXZpVmVudGVzMy5wbmciLCJzbGlkZXNob3ciOiJkMmYyYTc2In0%3D\">\n\t\t\t\t\t<div class=\"e-gallery-image elementor-gallery-item__image\" data-thumbnail=\"https:\/\/datalover.fr\/wp-content\/uploads\/2026\/02\/SuiviVentes3-768x432.png\" data-width=\"750\" data-height=\"422\" aria-label=\"\" role=\"img\" ><\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-gallery-item__overlay\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t<a class=\"e-gallery-item elementor-gallery-item elementor-animated-content\" href=\"https:\/\/datalover.fr\/wp-content\/uploads\/2026\/02\/DataModelPBI.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-slideshow=\"d2f2a76\" data-elementor-lightbox-title=\"DataModelPBI\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTMzMiwidXJsIjoiaHR0cHM6XC9cL2RhdGFsb3Zlci5mclwvd3AtY29udGVudFwvdXBsb2Fkc1wvMjAyNlwvMDJcL0RhdGFNb2RlbFBCSS5wbmciLCJzbGlkZXNob3ciOiJkMmYyYTc2In0%3D\">\n\t\t\t\t\t<div class=\"e-gallery-image elementor-gallery-item__image\" data-thumbnail=\"https:\/\/datalover.fr\/wp-content\/uploads\/2026\/02\/DataModelPBI.png\" data-width=\"604\" data-height=\"429\" aria-label=\"\" role=\"img\" ><\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-gallery-item__overlay\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-84957a8 elementor-widget elementor-widget-spacer\" data-id=\"84957a8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\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-46b72f4 elementor-widget elementor-widget-heading\" data-id=\"46b72f4\" 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\">Mes difficult\u00e9s...<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d2fe602 elementor-widget elementor-widget-text-editor\" data-id=\"d2fe602\" 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>Aucune documentation des data donc tout \u00e0 faire (<a href=\"https:\/\/datalover.fr\/index.php\/lexique\/\">data gouvernance<\/a>) avec un dictionnaire des donn\u00e9es, un business glossary<br \/>Traduire les transactions en monnaie du groupe (euro)<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Contexte Un groupe industriel Europ\u00e9en sp\u00e9cialis\u00e9 dans l\u2019\u00e9quipement des camions et semi-remorques souhaite mettre \u00e0 disposition des managers un suivi d\u00e9taill\u00e9 des ventes mensuelles, avec une outil facile d\u2019acc\u00e8s et aucune maintenance technique. Enjeux Mod\u00e9liser le sch\u00e9ma de donn\u00e9es dans un groupe qui souffre d\u2019un manque de structuration des donn\u00e9es malgr\u00e9 l\u2019abondance des outils et&hellip; <a class=\"more-link\" href=\"https:\/\/datalover.fr\/index.php\/suivi-des-ventes-mensuelles\/\">Poursuivre la lecture <span class=\"screen-reader-text\">Suivi des Ventes Mensuelles<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1322","page","type-page","status-publish","hentry","entry"],"_links":{"self":[{"href":"https:\/\/datalover.fr\/index.php\/wp-json\/wp\/v2\/pages\/1322","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datalover.fr\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/datalover.fr\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/datalover.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/datalover.fr\/index.php\/wp-json\/wp\/v2\/comments?post=1322"}],"version-history":[{"count":28,"href":"https:\/\/datalover.fr\/index.php\/wp-json\/wp\/v2\/pages\/1322\/revisions"}],"predecessor-version":[{"id":1364,"href":"https:\/\/datalover.fr\/index.php\/wp-json\/wp\/v2\/pages\/1322\/revisions\/1364"}],"wp:attachment":[{"href":"https:\/\/datalover.fr\/index.php\/wp-json\/wp\/v2\/media?parent=1322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}