{"id":454,"date":"2025-05-05T16:46:51","date_gmt":"2025-05-05T16:46:51","guid":{"rendered":"http:\/\/portfolio-data.local\/?p=454"},"modified":"2025-05-13T16:29:02","modified_gmt":"2025-05-13T16:29:02","slug":"optimisation-des-donnees-dune-boutique-de-vin","status":"publish","type":"post","link":"https:\/\/riverphot.com\/data\/optimisation-des-donnees-dune-boutique-de-vin\/","title":{"rendered":"Optimisation des donn\u00e9es et Analyse strat\u00e9gique e-commerce"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"454\" class=\"elementor elementor-454\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b947c43 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b947c43\" 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-f108335\" data-id=\"f108335\" 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-8513e19 elementor-widget elementor-widget-heading\" data-id=\"8513e19\" 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\">Optimisation de la gestion des donn\u00e9es<br>&amp; Analyse strat\u00e9gique d'un site ecommerce<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1671368 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"1671368\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/github.com\/Riverphot\/formation-data\/tree\/main\/Projet%206%20-%20Gestion%20et%20Analyse%20de%20donn%C3%A9es%20site%20ecommerce\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-icon\">\n\t\t\t\t<i aria-hidden=\"true\" class=\"fab fa-github\"><\/i>\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Voir le projet sur GitHub<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\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-f758e17 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"f758e17\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"\/wp-content\/uploads\/2025\/05\/PresentationBottleNeck.pdf\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-icon\">\n\t\t\t\t<i aria-hidden=\"true\" class=\"far fa-share-square\"><\/i>\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Voir le rapport<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\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-76b6836 elementor-widget elementor-widget-heading\" data-id=\"76b6836\" 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-056f58c elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"056f58c\" 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-5255c44 elementor-widget elementor-widget-text-editor\" data-id=\"5255c44\" 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>Assainir, fiabiliser et croiser des donn\u00e9es issues de diff\u00e9rentes sources (site WordPress, ERP, outils d\u2019analyse de trafic) afin de d\u00e9tecter les anomalies de gestion et am\u00e9liorer le pilotage de l\u2019activit\u00e9 e-commerce.<\/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-0800b89 elementor-widget elementor-widget-image\" data-id=\"0800b89\" 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=\"300\" height=\"212\" src=\"https:\/\/riverphot.com\/data\/wp-content\/uploads\/2025\/05\/bottleneck-300x212.jpg\" class=\"attachment-medium size-medium wp-image-533\" alt=\"bottleneck\" srcset=\"https:\/\/riverphot.com\/data\/wp-content\/uploads\/2025\/05\/bottleneck-300x212.jpg 300w, https:\/\/riverphot.com\/data\/wp-content\/uploads\/2025\/05\/bottleneck.jpg 521w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\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-0e53f4b elementor-widget elementor-widget-heading\" data-id=\"0e53f4b\" 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-9841798 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"9841798\" 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-c4ab08a elementor-widget elementor-widget-text-editor\" data-id=\"c4ab08a\" 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 une phase de diagnostic des diff\u00e9rentes sources de donn\u00e9es : extractions CSV depuis WordPress (commandes, produits, utilisateurs), donn\u00e9es ERP compl\u00e9mentaires et donn\u00e9es d\u2019audience. Un premier travail d\u2019exploration a permis d\u2019identifier des doublons, incoh\u00e9rences et valeurs manquantes.<\/p>\n<p>Les jeux de donn\u00e9es ont \u00e9t\u00e9 nettoy\u00e9s et enrichis afin d\u2019uniformiser les informations produit et client. Un travail sp\u00e9cifique a \u00e9t\u00e9 men\u00e9 sur les statuts de commande pour isoler les ventes effectives. Des jointures ont ensuite \u00e9t\u00e9 r\u00e9alis\u00e9es pour croiser les informations et construire une base d\u2019analyse unique.<\/p>\n<p>Une analyse statistique et visuelle a permis de mettre en \u00e9vidence des points de friction dans le tunnel de conversion, d\u2019identifier les produits g\u00e9n\u00e9rant le plus de retours et d\u2019observer des diff\u00e9rences significatives selon les canaux de commande.<\/p>\n<p>Des recommandations ont \u00e9t\u00e9 formul\u00e9es pour am\u00e9liorer les processus de gestion commerciale et la qualit\u00e9 des donn\u00e9es.<\/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-b9844dc elementor-widget elementor-widget-heading\" data-id=\"b9844dc\" 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-8d6f5be elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"8d6f5be\" 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-6e79cab elementor-widget elementor-widget-text-editor\" data-id=\"6e79cab\" 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=\"1403\" data-end=\"1451\">\n<p class=\"\" data-start=\"1405\" data-end=\"1451\">Nettoyage et pr\u00e9paration de donn\u00e9es\u00a0<\/p>\n<\/li>\n<li class=\"\" data-start=\"1452\" data-end=\"1507\">\n<p class=\"\" data-start=\"1454\" data-end=\"1507\">Requ\u00eates, jointures et restructuration des datasets<\/p>\n<\/li>\n<li class=\"\" data-start=\"1508\" data-end=\"1557\">\n<p class=\"\" data-start=\"1510\" data-end=\"1557\">Analyse des ventes et des statuts de commande<\/p>\n<\/li>\n<li class=\"\" data-start=\"1558\" data-end=\"1607\">\n<p class=\"\" data-start=\"1560\" data-end=\"1607\">Analyse exploratoire et d\u00e9tection d\u2019anomalies<\/p>\n<\/li>\n<li class=\"\" data-start=\"1608\" data-end=\"1657\">\n<p class=\"\" data-start=\"1610\" data-end=\"1657\">Visualisation des donn\u00e9es (matplotlib, seaborn)<\/p>\n<\/li>\n<li data-start=\"1608\" data-end=\"1657\">Respect de la r\u00e8glementation RGPD<\/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-7080225 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7080225\" 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-4a60ef3\" data-id=\"4a60ef3\" 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-b783e91 elementor-widget elementor-widget-heading\" data-id=\"b783e91\" 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-5ec4cd4 liste-tag elementor-widget elementor-widget-text-editor\" data-id=\"5ec4cd4\" 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>Python<\/span>\n<span>Jupyter Notebook<\/span>\n<span>Pandas<\/span>\n<span>Numpy<\/span>\n<span>Matplotlib<\/span>\n<span>Seaborn<\/span>\n<span>Plotly Express<\/span>\n<span>WordPress<\/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-0b55ffc elementor-widget elementor-widget-heading\" data-id=\"0b55ffc\" 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-c782ef2 liste-tag-skills elementor-widget elementor-widget-text-editor\" data-id=\"c782ef2\" 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>Exploration de donn\u00e9es<\/span>\n<span>Nettoyage de donn\u00e9es<\/span>\n<span>Jointures<\/span>\n<span>Analyse des ventes<\/span>\n<span>Data Visualisation<\/span>\n<span>RGPD<\/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>Optimisation de la gestion des donn\u00e9es&amp; Analyse strat\u00e9gique d&rsquo;un site ecommerce Voir le projet sur GitHub Voir le rapport Objectif du projet Assainir, fiabiliser et croiser des donn\u00e9es issues de diff\u00e9rentes sources (site WordPress, ERP, outils d\u2019analyse de trafic) afin de d\u00e9tecter les anomalies de gestion et am\u00e9liorer le pilotage de l\u2019activit\u00e9 e-commerce. Approche m\u00e9thodologique [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":537,"comment_status":"closed","ping_status":"","sticky":false,"template":"elementor_canvas","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[35,21,38,39,48,20,30,36,49],"class_list":["post-454","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-portfolio","tag-jupyter-notebook","tag-matplotlib","tag-numpy","tag-pandas","tag-plotly-express","tag-python-2","tag-rgpd","tag-seaborn","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/posts\/454","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=454"}],"version-history":[{"count":21,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/posts\/454\/revisions"}],"predecessor-version":[{"id":994,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/posts\/454\/revisions\/994"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/media\/537"}],"wp:attachment":[{"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/media?parent=454"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/categories?post=454"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/tags?post=454"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}