{"id":47559,"date":"2021-02-24T09:37:48","date_gmt":"2021-02-24T08:37:48","guid":{"rendered":"https:\/\/datascientest.com\/?p=47559"},"modified":"2023-11-09T14:09:55","modified_gmt":"2023-11-09T14:09:55","slug":"booster-sa-productivite-grace-a-powerquery","status":"publish","type":"post","link":"https:\/\/datascientest.com\/booster-sa-productivite-grace-a-powerquery","title":{"rendered":"Comment booster sa productivit\u00e9 Excel gr\u00e2ce \u00e0 PowerQuery ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"47559\" class=\"elementor elementor-47559\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4a48ddd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4a48ddd\" data-element_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-29f3569\" data-id=\"29f3569\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-cbefe09 elementor-widget elementor-widget-heading\" data-id=\"cbefe09\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">L\u2019analyse et la pr\u00e9paration des donn\u00e9es repr\u00e9sente bien souvent pr\u00e8s de 80% du travail d\u2019un data analyst ou data scientist. C\u2019est donc un goulet d\u2019\u00e9tranglement qui ralentit consid\u00e9rablement le travail d\u2019exploitation des donn\u00e9es. Heureusement il existe certains outils pour r\u00e9duire cette activit\u00e9 chronophage ! PowerQuery en est un des plus puissants et nous allons vous le pr\u00e9senter dans cet article.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6ddbb9f elementor-widget elementor-widget-heading\" data-id=\"6ddbb9f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Qu\u2019est ce que PowerQuery ?\n<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-663acc6 elementor-widget elementor-widget-text-editor\" data-id=\"663acc6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"font-weight: 400;\">PowerQuery est un outil d\u00e9velopp\u00e9 par Microsoft et directement int\u00e9gr\u00e9 dans certaines de ses applications, en particulier <a href=\"https:\/\/datascientest.com\/formation-excel\">Excel<\/a> et\u00a0<\/span><a href=\"https:\/\/datascientest.com\/power-bi\" target=\"_blank\" rel=\"noopener\">Power BI<\/a><span style=\"font-weight: 400;\">.<\/span><\/p><p><strong>Il permet de r\u00e9soudre de nombreux d\u00e9fis auxquels font face les professionnels lors de la pr\u00e9paration de la donn\u00e9e.<\/strong><\/p><p><span style=\"font-weight: 400;\">Parmi eux :\u00a0<\/span><span style=\"font-weight: 400;\">\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Les donn\u00e9es proviennent de <\/span><b>sources diverses<\/b><span style=\"font-weight: 400;\"> et non standardis\u00e9es<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Chaque source de donn\u00e9e demande un<\/span><b> traitement particulier <\/b><span style=\"font-weight: 400;\">et souvent complexe.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">L&rsquo;utilisation de macro est lente \u00e0 programmer et peu adaptable ou reproductible.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Le <\/span><b>volume de donn\u00e9es<\/b><span style=\"font-weight: 400;\"> est trop important pour \u00eatre trait\u00e9 par Excel<\/span><\/li><\/ul><p><span style=\"font-weight: 400;\">En adressant ces diff\u00e9rentes difficult\u00e9s, PowerQuery permet concr\u00e8tement de booster votre processus <\/span><b>ETL <\/b><span style=\"font-weight: 400;\">(Extract &#8211; Transform &#8211; Load).<\/span><\/p>\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\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ae7c3d1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ae7c3d1\" data-element_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-c4070b0\" data-id=\"c4070b0\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4b47611 elementor-widget elementor-widget-heading\" data-id=\"4b47611\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Les fonctionnalit\u00e9s de PowerQuery \n<\/h3>\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\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3c8c538 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3c8c538\" data-element_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-673e31c\" data-id=\"673e31c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d939860 elementor-widget elementor-widget-text-editor\" data-id=\"d939860\" data-element_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<p><span style=\"font-weight: 400;\">Tout d\u2019abord PowerQuery permet d\u2019<\/span><b>utiliser des sources vari\u00e9es de donn\u00e9es<\/b><span style=\"font-weight: 400;\">. A partir de l\u2019outil, il est possible de connecter de multiple sources de donn\u00e9es au m\u00eame fichier excel. Ces donn\u00e9es peuvent venir de bases de donn\u00e9es (SQL, Azure, Oracle, Salesforce), mais aussi de fichiers texte ou csv tout comme de pages web directement. (petit visuel si possible)<\/span><\/p><p><span style=\"font-weight: 400;\">Il est possible d&rsquo;acc\u00e9der \u00e0 cette option \u00e0 partir de l\u2019onglet <\/span><b>Donn\u00e9es<\/b><span style=\"font-weight: 400;\"> puis dans la partie <\/span><b>R\u00e9cup\u00e9rer et transformer des donn\u00e9es<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5ebf124 elementor-widget elementor-widget-image\" data-id=\"5ebf124\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"238\" height=\"161\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/02\/powerquery1.png\" class=\"attachment-large size-large wp-image-47993\" alt=\"Power query\" loading=\"lazy\" \/>\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-8a4336a elementor-widget elementor-widget-text-editor\" data-id=\"8a4336a\" data-element_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<p><span style=\"font-weight: 400;\">Une fois une source de donn\u00e9e s\u00e9lectionn\u00e9e, une requ\u00eate (query) s\u2019ouvre et permet de charger la donn\u00e9e. Le bouton <\/span><b>Transform <\/b><span style=\"font-weight: 400;\">permet alors d\u2019ouvrir une fen\u00eatre <\/span><b>PowerQuery Editor<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-99bf982 elementor-widget elementor-widget-image\" data-id=\"99bf982\" data-element_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=\"512\" height=\"90\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/02\/Powerquery2.png\" class=\"attachment-large size-large wp-image-47992\" alt=\"Power query\" loading=\"lazy\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/02\/Powerquery2.png 512w, https:\/\/datascientest.com\/wp-content\/uploads\/2021\/02\/Powerquery2-300x53.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/>\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-2133e63 elementor-widget elementor-widget-text-editor\" data-id=\"2133e63\" data-element_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<p><span style=\"font-weight: 400;\">Dans cet \u00e9diteur, il est possible de nombreuses op\u00e9rations de traitement de donn\u00e9es qui \u00e9taient auparavant r\u00e9alis\u00e9es par des macros lentes \u00e0 programmer et rigides.<\/span><\/p><p><span style=\"font-weight: 400;\">On peut par exemple :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">R\u00e9organiser les lignes et les colonnes<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Supprimer les valeurs manquantes<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Filtrer les lignes<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Utiliser la premi\u00e8re ligne comme en-t\u00eate<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Fusionner, d\u00e9couper ou regrouper les colonnes<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Et bien plus encore !<\/span><\/li><\/ul><p><span style=\"font-weight: 400;\">Une fois ce traitement d\u00e9fini, la donn\u00e9e est directement convertie en table est pr\u00eate \u00e0 \u00eatre utilis\u00e9e pour des <\/span><b>tableaux crois\u00e9s dynamiques<\/b><span style=\"font-weight: 400;\"> !<\/span><\/p><p><span style=\"font-weight: 400;\">Par ailleurs, une fois la requ\u00eate effectu\u00e9e,<\/span><b> il est possible de le sauvegarder et de la r\u00e9utiliser de nombreuses fois<\/b><span style=\"font-weight: 400;\"> \u00e0 la mani\u00e8re d\u2019une macro. Cependant pour cet outil, aucune connaissance en VBA n\u2019est requise.<\/span><\/p><p><span style=\"font-weight: 400;\">Il est donc possible de compl\u00e8tement automatiser le workflow de traitement de donn\u00e9es en combinant diff\u00e9rentes requ\u00eates.<\/span><\/p><p><span style=\"font-weight: 400;\">L\u2019un des derniers avantages de PowerQuery est qu\u2019il n\u2019<\/span><b>alourdit pas votre fichier excel<\/b><span style=\"font-weight: 400;\">. En effet il ne fait qu\u2019importe la donn\u00e9e des diff\u00e9rentes sources et la transforme sans la recopier int\u00e9gralement. Cette option permet donc de travailler sur des bases de donn\u00e9es de plusieurs millions de lignes !\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">SI vous comptez utiliser PowerQuery avec votre base de donn\u00e9es, nous vous conseillons au pr\u00e9alable de bien organiser votre base de donn\u00e9es pour vous \u00e9viter des efforts inutiles. Pour cela n&rsquo;h\u00e9sitez pas \u00e0 aller voir notre article : Tuto SQL : <a href=\"https:\/\/datascientest.com\/tuto-sql\">TOP 5 des fonctions les plus utiles <\/a><\/span><\/p>\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\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-90eacf6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"90eacf6\" data-element_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-0a8f176\" data-id=\"0a8f176\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f34ab1b elementor-widget elementor-widget-heading\" data-id=\"f34ab1b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Conclusion \n<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-eaf822d elementor-widget elementor-widget-text-editor\" data-id=\"eaf822d\" data-element_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<p><span style=\"font-weight: 400;\">PowerQuery est un outil puissant et indispensable lorsque l\u2019on travaille avec Excel et\u00a0<\/span><a href=\"https:\/\/www.google.fr\/url?sa=t&amp;rct=j&amp;q=&amp;esrc=s&amp;source=web&amp;cd=&amp;cad=rja&amp;uact=8&amp;ved=2ahUKEwjsm4yWj4LvAhUOzYUKHYzCCQQQFjAAegQIARAE&amp;url=https%3A%2F%2Fpowerbi.microsoft.com%2Ffr-fr%2F&amp;usg=AOvVaw1DidVAXaTmM_XofHYJt1f9\" target=\"_blank\" rel=\"noopener\">Power BI<\/a><span style=\"font-weight: 400;\">. Par ailleurs, il est compl\u00e9t\u00e9 par Power Pivot une nouvelle fonctionnalit\u00e9 qui permet une analyse rapide et automatis\u00e9e des donn\u00e9es d\u00e9j\u00e0 trait\u00e9es.\u00a0 Si vous voulez en d\u00e9couvrir plus sur le traitement et l\u2019acquisition automatique des donn\u00e9es, d\u00e9couvrez notre formation Data Engineer !<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4e6b68f elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"4e6b68f\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"\/formations-data\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">D\u00e9couvrir nos formations<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\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<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>L\u2019analyse et la pr\u00e9paration des donn\u00e9es repr\u00e9sente bien souvent pr\u00e8s de 80% du travail d\u2019un data analyst ou data scientist. C\u2019est donc un goulet d\u2019\u00e9tranglement qui ralentit consid\u00e9rablement le travail d\u2019exploitation des donn\u00e9es. Heureusement il existe certains outils pour r\u00e9duire cette activit\u00e9 chronophage ! PowerQuery en est un des plus puissants et nous allons vous [&hellip;]<\/p>\n","protected":false},"author":77,"featured_media":48722,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2497],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Comment booster sa productivit\u00e9 Excel gr\u00e2ce \u00e0 PowerQuery ?<\/title>\n<meta name=\"description\" content=\"D\u00e9couvrez PowerQuery : l&#039;outil d\u00e9velopp\u00e9 par Microsoft qui permet de r\u00e9soudre de nombreux d\u00e9fis lors de la pr\u00e9paration de la donn\u00e9e.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/booster-sa-productivite-grace-a-powerquery\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comment booster sa productivit\u00e9 Excel gr\u00e2ce \u00e0 PowerQuery ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/booster-sa-productivite-grace-a-powerquery\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-24T08:37:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T14:09:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/02\/illu_powerquery_blog-88-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1405\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Raphael Kassel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Raphael Kassel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/booster-sa-productivite-grace-a-powerquery\",\"url\":\"https:\/\/datascientest.com\/booster-sa-productivite-grace-a-powerquery\",\"name\":\"Comment booster sa productivit\u00e9 Excel gr\u00e2ce \u00e0 PowerQuery ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2021-02-24T08:37:48+00:00\",\"dateModified\":\"2023-11-09T14:09:55+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\"},\"description\":\"D\u00e9couvrez PowerQuery : l'outil d\u00e9velopp\u00e9 par Microsoft qui permet de r\u00e9soudre de nombreux d\u00e9fis lors de la pr\u00e9paration de la donn\u00e9e.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/booster-sa-productivite-grace-a-powerquery\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\",\"name\":\"Raphael Kassel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"caption\":\"Raphael Kassel\"},\"description\":\"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \\\"Chef de projet IA\\\" et \\\"Data Product Manager\\\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/raphaelkassel\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/raphaelkassel\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Comment booster sa productivit\u00e9 Excel gr\u00e2ce \u00e0 PowerQuery ?","description":"D\u00e9couvrez PowerQuery : l'outil d\u00e9velopp\u00e9 par Microsoft qui permet de r\u00e9soudre de nombreux d\u00e9fis lors de la pr\u00e9paration de la donn\u00e9e.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/booster-sa-productivite-grace-a-powerquery","og_locale":"fr_FR","og_type":"article","og_title":"Comment booster sa productivit\u00e9 Excel gr\u00e2ce \u00e0 PowerQuery ?","og_url":"https:\/\/datascientest.com\/booster-sa-productivite-grace-a-powerquery","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2021-02-24T08:37:48+00:00","article_modified_time":"2023-11-09T14:09:55+00:00","og_image":[{"width":2560,"height":1405,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/02\/illu_powerquery_blog-88-1.png","type":"image\/png"}],"author":"Raphael Kassel","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Raphael Kassel","Dur\u00e9e de lecture estim\u00e9e":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/booster-sa-productivite-grace-a-powerquery","url":"https:\/\/datascientest.com\/booster-sa-productivite-grace-a-powerquery","name":"Comment booster sa productivit\u00e9 Excel gr\u00e2ce \u00e0 PowerQuery ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2021-02-24T08:37:48+00:00","dateModified":"2023-11-09T14:09:55+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1"},"description":"D\u00e9couvrez PowerQuery : l'outil d\u00e9velopp\u00e9 par Microsoft qui permet de r\u00e9soudre de nombreux d\u00e9fis lors de la pr\u00e9paration de la donn\u00e9e.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/booster-sa-productivite-grace-a-powerquery"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1","name":"Raphael Kassel","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","caption":"Raphael Kassel"},"description":"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \"Chef de projet IA\" et \"Data Product Manager\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.","sameAs":["https:\/\/www.linkedin.com\/in\/raphaelkassel\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/raphaelkassel"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/47559"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=47559"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/47559\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/48722"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=47559"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=47559"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=47559"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}