{"id":1297,"date":"2026-02-12T12:14:14","date_gmt":"2026-02-12T11:14:14","guid":{"rendered":"https:\/\/datalover.fr\/?page_id=1297"},"modified":"2026-02-13T10:47:46","modified_gmt":"2026-02-13T09:47:46","slug":"elementor-page-1297","status":"publish","type":"page","link":"https:\/\/datalover.fr\/index.php\/elementor-page-1297\/","title":{"rendered":"Comment faire du pain?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"1297\" class=\"elementor elementor-1297\" data-elementor-post-type=\"page\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ff51dcb e-flex e-con-boxed e-con e-parent\" data-id=\"ff51dcb\" 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-9468b73 e-con-full e-flex e-con e-child\" data-id=\"9468b73\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-46e0624 elementor-widget elementor-widget-heading\" data-id=\"46e0624\" 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-b62217f e-grid e-con-full e-con e-child\" data-id=\"b62217f\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8b8532b elementor-widget elementor-widget-text-editor\" data-id=\"8b8532b\" 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 client dans l&rsquo;industrie agroalimentaire, au sein d&rsquo;un des premiers groupes agricoles europ\u00e9ens (14&rsquo;500 collaborateurs) et engag\u00e9 dans une transition digitale, m&rsquo;a contact\u00e9 pour 2 missions :<\/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-e563fc5 elementor-widget elementor-widget-image\" data-id=\"e563fc5\" 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=\"565\" height=\"540\" src=\"https:\/\/datalover.fr\/wp-content\/uploads\/2024\/09\/pains.jpg\" class=\"attachment-medium_large size-medium_large wp-image-1223\" alt=\"\" srcset=\"https:\/\/datalover.fr\/wp-content\/uploads\/2024\/09\/pains.jpg 565w, https:\/\/datalover.fr\/wp-content\/uploads\/2024\/09\/pains-300x287.jpg 300w\" sizes=\"(max-width: 565px) 100vw, 565px\" style=\"width:100%;height:95.58%;max-width:565px\" \/>\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 class=\"elementor-element elementor-element-41bd52d elementor-widget elementor-widget-text-editor\" data-id=\"41bd52d\" 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 style=\"direction: ltr; unicode-bidi: embed; margin-top: 0in; margin-bottom: 0in;\" type=\"disc\"><li lang=\"en-US\" style=\"margin-top: 0; margin-bottom: 0; vertical-align: middle;\"><strong><span style=\"font-family: Calibri; font-size: 11.0pt;\">Identifier tous les \u00e9carts de m\u00e9thode et dosage de ses recettes (le co\u00fbt standard, des milliers de lignes et une vingtaine de param\u00e8tres) gr\u00e2ce \u00e0 un outil de BI : <a href=\"https:\/\/www.microsoft.com\/fr-fr\/power-platform\/products\/power-bi\/desktop\" target=\"_blank\" rel=\"noopener\">Power BI<\/a>. Puis correction des diff\u00e9rences pour harmoniser les process entre tous les sites de production. Mission de 3 mois<\/span><\/strong><\/li><li lang=\"en-US\" style=\"margin-top: 0; margin-bottom: 0; vertical-align: middle;\"><em><span style=\"font-family: Calibri; font-size: 11.0pt;\">R\u00e9pliquer le <\/span><a href=\"https:\/\/datalover.fr\/index.php\/reporting-industriel\/\"><span style=\"text-decoration: underline; font-family: Calibri; font-size: 11pt;\">rapport mensuel<\/span><\/a><span style=\"font-family: Calibri; font-size: 11.0pt;\"> fait par les contr\u00f4leurs de gestion industriels sur Excel pour l&rsquo;automatiser sur Power BI, et surtout gagner en visibilit\u00e9 et temps de process. Mission de 3 mois<\/span><\/em><\/li><\/ul>\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-2ee5a88 elementor-widget elementor-widget-spacer\" data-id=\"2ee5a88\" 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-5392993 elementor-widget elementor-widget-heading\" data-id=\"5392993\" 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-081362e elementor-widget elementor-widget-text-editor\" data-id=\"081362e\" 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>Traiter un <span style=\"text-decoration: underline;\">grand nombre de donn\u00e9es<\/span>, indigeste sur Excel &#8211;&gt; besoin d&rsquo;un outil plus performant<\/p><p>Identifier facilement les incoh\u00e9rences et corrections \u00e0 apporter sur les 600 produits en catalogue gr\u00e2ce \u00e0 de la<span style=\"text-decoration: underline;\"> data viz<\/span> sur <span style=\"font-weight: bold; text-decoration: underline;\">Power BI<\/span><\/p><p>Cr\u00e9er un <span style=\"text-decoration: underline;\">mod\u00e8le de donn\u00e9es<\/span> qui puisse r\u00e9pliquer cette analyse dans le futur, sans passer par une mise \u00e0 jour technique et couteuse d&rsquo;un consultant BI<\/p><p><span style=\"text-decoration: underline;\">Valoriser<\/span> en poids et en \u20ac l&rsquo;impact des changements de m\u00e9thodes-recettes sur la base du budget \u00e0 venir (un pain vendu 200 grammes que l&rsquo;on produit \u00e0 270 grammes g\u00e9n\u00e8re des variances qui p\u00e8sent lourd sur le r\u00e9sultat financier!)<\/p><p>Former le Key User \u00e0 la manipulation de Power BI pour <span style=\"text-decoration: underline;\">transmettre<\/span> les fondamentaux et <span style=\"text-decoration: underline;\">autonomiser<\/span> l&rsquo;\u00e9quipe en place<\/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-9662799 elementor-widget elementor-widget-spacer\" data-id=\"9662799\" 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-8d50822 elementor-widget elementor-widget-heading\" data-id=\"8d50822\" 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-2b22de6 elementor-widget elementor-widget-text-editor\" data-id=\"2b22de6\" 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><span style=\"font-family: Calibri; font-size: 11.0pt; font-weight: normal; font-style: normal;\">D\u00e9finition du p\u00e9rim\u00e8tre de l&rsquo;analyse avec le client, revue d\u00e9taill\u00e9e des \u00ab\u00a0best practices\u00a0\u00bb qui guideront les correctifs<\/span><\/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;\">Extractions en fichiers plats des donn\u00e9es (outil QlikView, lui-m\u00eame aliment\u00e9 par l&rsquo;ERP Infor M3), importation dans Power BI via Desktop<\/span><\/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;\">Analyse exploratoire des champs pour identifier leur format, comprendre les termes et leurs relations, et \u00e9valuer la qualit\u00e9 des donn\u00e9es<\/span><\/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;\">Cr\u00e9ation d&rsquo;une vue synth\u00e9tique par probl\u00e9matique, avec des visuels en matrice ou en graphique, selon la pertinence<\/span><\/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;\">Pr\u00e9paration des correctifs sur Excel, en collaboration avec le client, pour mise \u00e0 jour en base TEST par le service masterdata<\/span><\/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;\">V\u00e9rification de la base TEST, correctifs des erreurs, mise \u00e0 jour en base PROD<\/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-59c2f7f elementor-widget elementor-widget-spacer\" data-id=\"59c2f7f\" 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-2005e0a elementor-widget elementor-widget-heading\" data-id=\"2005e0a\" 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-e7cd333 elementor-widget elementor-widget-text-editor\" data-id=\"e7cd333\" 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 beau rapport Power BI respectant la charte graphique du client, qui pr\u00e9sente d&rsquo;un coup d&rsquo;oeil les gammes de produits sur des boxplot, bar chart, ou tableur selon la pertinence. L&rsquo;analyse des variances est maintenant possible et permet de mieux maitriser les co\u00fbts de production. Le client pourra \u00e0 l&rsquo;avenir actualiser le rapport dans 1 ou 2 ans et corriger lui-m\u00eame les \u00e9carts constat\u00e9s<\/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-30486fe elementor-widget elementor-widget-spacer\" data-id=\"30486fe\" 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-8717baa elementor-widget elementor-widget-heading\" data-id=\"8717baa\" 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-727d9b8 elementor-widget elementor-widget-text-editor\" data-id=\"727d9b8\" 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>Bien saisir le mod\u00e8le complexe du client pour ses recettes, avec une double nomenclature et beaucoup de param\u00e8tres parfois contradictoires!<\/p><p>Pr\u00e9senter les donn\u00e9es avec le bon visuel, pour apporter de la clart\u00e9 et non de la confusion<\/p><p>Parvenir \u00e0 synth\u00e9tiser les correctifs pour une bonne compr\u00e9hension et prise en main du sujet des op\u00e9rationnels (ils sont impact\u00e9s par ces changements et doivent donc se les approprier)<\/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 client dans l&rsquo;industrie agroalimentaire, au sein d&rsquo;un des premiers groupes agricoles europ\u00e9ens (14&rsquo;500 collaborateurs) et engag\u00e9 dans une transition digitale, m&rsquo;a contact\u00e9 pour 2 missions : Identifier tous les \u00e9carts de m\u00e9thode et dosage de ses recettes (le co\u00fbt standard, des milliers de lignes et une vingtaine de param\u00e8tres) gr\u00e2ce \u00e0 un outil&hellip; <a class=\"more-link\" href=\"https:\/\/datalover.fr\/index.php\/elementor-page-1297\/\">Poursuivre la lecture <span class=\"screen-reader-text\">Comment faire du pain?<\/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-1297","page","type-page","status-publish","hentry","entry"],"_links":{"self":[{"href":"https:\/\/datalover.fr\/index.php\/wp-json\/wp\/v2\/pages\/1297","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=1297"}],"version-history":[{"count":8,"href":"https:\/\/datalover.fr\/index.php\/wp-json\/wp\/v2\/pages\/1297\/revisions"}],"predecessor-version":[{"id":1372,"href":"https:\/\/datalover.fr\/index.php\/wp-json\/wp\/v2\/pages\/1297\/revisions\/1372"}],"wp:attachment":[{"href":"https:\/\/datalover.fr\/index.php\/wp-json\/wp\/v2\/media?parent=1297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}