{"id":190367,"date":"2023-02-20T18:10:00","date_gmt":"2023-02-20T18:10:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=190367"},"modified":"2024-03-28T13:46:30","modified_gmt":"2024-03-28T13:46:30","slug":"power-query-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/power-query-tout-savoir","title":{"rendered":"Power Query : Qu&rsquo;est-ce que c&rsquo;est ? \u00c0 quoi \u00e7a sert ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"190367\" class=\"elementor elementor-190367\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-956977a e-flex e-con-boxed e-con\" data-id=\"956977a\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-db14dbf elementor-widget elementor-widget-heading\" data-id=\"db14dbf\" 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\">Si l\u2019analyse des donn\u00e9es est de plus en plus valoris\u00e9e par les entreprises, les data analysts doivent r\u00e9aliser un travail de pr\u00e9paration colossal avant d\u2019exploiter les informations \u00e0 leur disposition. Heureusement, il existe des outils facilitant le traitement des donn\u00e9es en provenance de diff\u00e9rentes sources. C\u2019est notamment le cas de Power Query. Alors de quoi s\u2019agit-il ? \u00c0 quoi sert-il ? Quelles sont ses fonctionnalit\u00e9s ? Et ses avantages ? D\u00e9couvrez toutes les r\u00e9ponses dans cet article.<\/h2>\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<div class=\"elementor-element elementor-element-22a8149 e-flex e-con-boxed e-con\" data-id=\"22a8149\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-06203f0 elementor-widget elementor-widget-heading\" data-id=\"06203f0\" 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\">\u00c0 quoi sert Power Query ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4119122 elementor-widget elementor-widget-text-editor\" data-id=\"4119122\" 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>Power Query est un outil <b>d&rsquo;extraction<\/b>, de <b>transformation<\/b> et de <b>chargement<\/b> de donn\u00e9es (<a href=\"https:\/\/datascientest.com\/extract-transform-load-tout-savoir\">ETL pour <em>Extract<\/em>, <em>Transform<\/em>, <em>Load<\/em><\/a>) qui permet aux utilisateurs de connecter, d&rsquo;importer et de pr\u00e9parer des donn\u00e9es provenant de diff\u00e9rentes sources pour une analyse ult\u00e9rieure dans <a href=\"https:\/\/datascientest.com\/power-query-excel-tout-savoir\">Excel<\/a>, <a href=\"https:\/\/datascientest.com\/power-bi\">Power BI<\/a> ou d&rsquo;autres applications.<\/p><p>L\u2019objectif de Power Query est de vous aider \u00e0 uniformiser vos bases de donn\u00e9es pour simplifier l\u2019analyse a posteriori. L\u2019id\u00e9e est alors de <strong>favoriser le traitement de donn\u00e9es<\/strong>, depuis la collecte jusqu\u2019\u00e0 la mise \u00e0 jour.<\/p><p>Pour ce faire, Power Query vous propose une multitude de fonctionnalit\u00e9s, telles que l\u2019importation depuis diff\u00e9rentes <a href=\"https:\/\/datascientest.com\/definition-data-source\">sources de donn\u00e9es<\/a>, la connexion entre l\u2019\u00e9diteur de requ\u00eate et le fichier source, la transformation des datas, les reportings, etc.<\/p><p>Pour les <a href=\"https:\/\/datascientest.com\/formation-data-analyst\">Data Analysts<\/a>, l\u2019automatisation de ces t\u00e2ches permet de gagner un temps pr\u00e9cieux.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-5c00e77 e-flex e-con-boxed e-con\" data-id=\"5c00e77\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-b71b4f0 e-con-full e-flex e-con\" data-id=\"b71b4f0\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-c0a7b85 e-con-full e-flex e-con\" data-id=\"c0a7b85\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5d5a3e5 elementor-widget elementor-widget-video\" data-id=\"5d5a3e5\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/watch?v=woy6KoVQPrg&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.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-video .elementor-widget-container{overflow:hidden;transform:translateZ(0)}.elementor-widget-video .elementor-wrapper{aspect-ratio:var(--video-aspect-ratio)}.elementor-widget-video .elementor-wrapper iframe,.elementor-widget-video .elementor-wrapper video{height:100%;width:100%;display:flex;border:none;background-color:#000}@supports not (aspect-ratio:1\/1){.elementor-widget-video .elementor-wrapper{position:relative;overflow:hidden;height:0;padding-bottom:calc(100% \/ var(--video-aspect-ratio))}.elementor-widget-video .elementor-wrapper iframe,.elementor-widget-video .elementor-wrapper video{position:absolute;top:0;right:0;bottom:0;left:0}}.elementor-widget-video .elementor-open-inline .elementor-custom-embed-image-overlay{position:absolute;top:0;right:0;bottom:0;left:0;background-size:cover;background-position:50%}.elementor-widget-video .elementor-custom-embed-image-overlay{cursor:pointer;text-align:center}.elementor-widget-video .elementor-custom-embed-image-overlay:hover .elementor-custom-embed-play i{opacity:1}.elementor-widget-video .elementor-custom-embed-image-overlay img{display:block;width:100%;aspect-ratio:var(--video-aspect-ratio);-o-object-fit:cover;object-fit:cover;-o-object-position:center center;object-position:center center}@supports not (aspect-ratio:1\/1){.elementor-widget-video .elementor-custom-embed-image-overlay{position:relative;overflow:hidden;height:0;padding-bottom:calc(100% \/ var(--video-aspect-ratio))}.elementor-widget-video .elementor-custom-embed-image-overlay img{position:absolute;top:0;right:0;bottom:0;left:0}}.elementor-widget-video .e-hosted-video .elementor-video{-o-object-fit:cover;object-fit:cover}.e-con-inner>.elementor-widget-video,.e-con>.elementor-widget-video{width:var(--container-widget-width);--flex-grow:var(--container-widget-flex-grow)}<\/style>\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\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-d9f6a28 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"d9f6a28\" 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\">Apprendre \u00e0 utiliser Power Query<\/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<\/div>\n\t\t<div class=\"elementor-element elementor-element-08993d1 e-con-full e-flex e-con\" data-id=\"08993d1\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<\/div>\n\t\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<div class=\"elementor-element elementor-element-255a246 e-flex e-con-boxed e-con\" data-id=\"255a246\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d84072e elementor-widget elementor-widget-heading\" data-id=\"d84072e\" 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\">Comment fonctionne Power Query ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-292b997 elementor-widget elementor-widget-text-editor\" data-id=\"292b997\" 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;\">Power Query est <\/span><b>directement int\u00e9gr\u00e9 dans les outils Microsoft, <\/b><span style=\"font-weight: 400;\">tels que Power BI ou Excel.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Il est donc tr\u00e8s facile d\u2019utiliser Power Query dans Excel. Mais attention, sachez que cette solution n\u2019est pr\u00e9sente que dans les versions les plus r\u00e9centes (c\u2019est-\u00e0-dire depuis Excel 2016).\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Si vous avez l\u2019une de ces versions, il suffit de :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">se rendre sur l\u2019onglet <em>Donn\u00e9es<\/em> ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">aller dans la rubrique <em>Obtenir et transformer les donn\u00e9es<\/em>\u00a0;<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">cliquer sur <em>Obtenir des donn\u00e9es<\/em>, puis<em> utiliser l\u2019\u00e9diteur Power Query<\/em>.\u00a0<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a96a9e1 elementor-widget elementor-widget-text-editor\" data-id=\"a96a9e1\" 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;\">\u00c0 partir de l\u00e0, l\u2019\u00e9diteur de requ\u00eate s\u2019ouvre dans une nouvelle fen\u00eatre.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">En revanche, pour les versions Excel 2010 et 2013, Power Query n\u2019est pas int\u00e9gr\u00e9 automatiquement. Dans ce cadre, vous devez aller sur le site de Microsoft pour t\u00e9l\u00e9charger Power Query et l\u2019installer ensuite sur votre feuille de calcul Excel.<\/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-76d4c21 elementor-widget elementor-widget-image\" data-id=\"76d4c21\" 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=\"640\" height=\"361\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/excel-power-query.jpg\" class=\"attachment-full size-full wp-image-190390\" alt=\"\" loading=\"lazy\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/excel-power-query.jpg 640w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/excel-power-query-300x169.jpg 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/>\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-cd88f3d elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"cd88f3d\" 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=\"https:\/\/datascientest.com\/formation-power-bi\">\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\">Maitriser Power Query<\/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\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a4707f4 e-flex e-con-boxed e-con\" data-id=\"a4707f4\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d401c33 elementor-widget elementor-widget-heading\" data-id=\"d401c33\" 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\">Quelles sont les fonctionnalit\u00e9s de Power Query ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8a163e3 elementor-widget elementor-widget-text-editor\" data-id=\"8a163e3\" 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;\">Afin de simplifier le travail d\u2019analytics, Power Query vous fournit plusieurs fonctionnalit\u00e9s visant \u00e0 am\u00e9liorer la <a href=\"https:\/\/datascientest.com\/data-quality-pourquoi-est-elle-si-importante\">qualit\u00e9 des donn\u00e9es<\/a>. <\/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-037f033 elementor-widget elementor-widget-heading\" data-id=\"037f033\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Importation des donn\u00e9es<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f42c7a5 elementor-widget elementor-widget-text-editor\" data-id=\"f42c7a5\" 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;\">Power Query peut i<\/span><b>mporter des donn\u00e9es d\u2019une multitude de sources diff\u00e9rentes<\/b><span style=\"font-weight: 400;\"> : un classeur Excel, un fichier texte, une base de donn\u00e9es SQL, un site web une, <a href=\"https:\/\/datascientest.com\/construire-des-api-premiere-partie\">API<\/a>&#8230;\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Pour cela, vous devez suivre les \u00e9tapes suivantes :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">aller dans l\u2019onglet \u00ab\u00a0Donn\u00e9es\u00a0\u00bb ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">cliquer sur\u00a0 \u00ab\u00a0Nouvelles consultations\u00a0\u00bb ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">s\u00e9lectionner la source de donn\u00e9es dont vous avez besoin. <\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c07f170 elementor-widget elementor-widget-text-editor\" data-id=\"c07f170\" 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;\">Si les informations sont exploitables telles quelles, elles peuvent \u00eatre ajout\u00e9es directement \u00e0 votre feuille de calcul. En revanche, si vous souhaitez modifier le format, l\u2019\u00e9diteur de requ\u00eate Power Query vous permet de transformer les donn\u00e9es. <\/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-5654459 elementor-widget elementor-widget-heading\" data-id=\"5654459\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Transformer les donn\u00e9es<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-54f7bab elementor-widget elementor-widget-text-editor\" data-id=\"54f7bab\" 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 les donn\u00e9es impl\u00e9ment\u00e9es dans Power Query, vous pouvez les transformer comme bon vous semble.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Avant toute chose, il faut savoir que <\/span><b>Power Query s\u2019organise par colonne.<\/b><span style=\"font-weight: 400;\"> L\u2019objectif n\u2019est donc pas de modifier les cellules individuellement, mais les colonnes. Cela permet de gagner du temps lors du traitement des donn\u00e9es.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Gr\u00e2ce \u00e0 Power Query, vous pourrez :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Remplacer certaines donn\u00e9es textuelles en donn\u00e9es num\u00e9riques ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Supprimer des colonnes ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Changer l\u2019en-t\u00eate ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Uniformiser le format de toutes les donn\u00e9es ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">etc.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b39982d elementor-widget elementor-widget-text-editor\" data-id=\"b39982d\" 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;\">Il s\u2019agit d\u2019une liste non exhaustive, puisque le tableau de bord Power Query vous propose <\/span><b>plus de 300 options de transformation.<\/b><span style=\"font-weight: 400;\"> Y compris des modifications bas\u00e9es sur l\u2019intelligence artificielle. Cela vous permet ainsi de gagner une flexibilit\u00e9 incomparable par rapport \u00e0 d\u2019autres outils de traitement des donn\u00e9es.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Lorsque toutes les donn\u00e9es sont au bon format, vous pouvez les int\u00e9grer \u00e0 votre tableau Excel pour mieux les exploiter. En effet, gr\u00e2ce \u00e0 ce travail d\u2019uniformisation, il est plus facile de cr\u00e9er des graphiques, des tableaux crois\u00e9s dynamiques, des reporting, etc. <\/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-1dfafd6 elementor-widget elementor-widget-image\" data-id=\"1dfafd6\" 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=\"640\" height=\"381\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/data-power-query.jpg\" class=\"attachment-full size-full wp-image-190391\" alt=\"\" loading=\"lazy\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/data-power-query.jpg 640w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/data-power-query-300x179.jpg 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/>\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-04d7d74 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"04d7d74\" 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=\"https:\/\/datascientest.com\/formation-power-bi\">\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\">Suivre un cursus pour se former \u00e0 Power Query<\/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<div class=\"elementor-element elementor-element-002ee18 elementor-widget elementor-widget-heading\" data-id=\"002ee18\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Actualiser les donn\u00e9es<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4b05aae elementor-widget elementor-widget-text-editor\" data-id=\"4b05aae\" 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;\">La force Power Query, c\u2019est sa capacit\u00e9 de connexion. En effet, cette solution peut <\/span><b>se connecter \u00e0 plusieurs sources pour actualiser les donn\u00e9es en temps r\u00e9el<\/b><span style=\"font-weight: 400;\">. Ainsi, d\u00e8s qu\u2019une modification appara\u00eet sur le fichier original, vous pouvez le voir sur Excel. Pour cela, il suffit d\u2019actualiser votre tableau.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">En plus d\u2019une mise \u00e0 jour en temps r\u00e9el, l\u2019\u00e9diteur de requ\u00eates Power Query vous pr\u00e9sente <\/span><b>les informations dans le bon format. <\/b><span style=\"font-weight: 400;\">En effet, si vous avez format\u00e9 le fichier original lors de l\u2019importation, Power Query enregistre tous les param\u00e8tres d\u2019une requ\u00eate existante (par exemple la suppression d\u2019une colonne, la modification de l\u2019en-t\u00eate, l\u2019affichage des donn\u00e9es num\u00e9riques, \u2026). \u00c0 chaque fois que cet outil charge de nouvelles informations, il reprend les \u00e9tapes appliqu\u00e9es initialement pour vous proposer le bon mod\u00e8le de donn\u00e9es, sans que vous n\u2019ayez rien \u00e0 faire.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Cette fonctionnalit\u00e9 est particuli\u00e8rement<\/span><b> utile dans les entreprises ayant recours \u00e0 des jeux de donn\u00e9es qui changent constamment<\/b><span style=\"font-weight: 400;\">, comme les donn\u00e9es financi\u00e8res, les donn\u00e9es clients, etc. Gr\u00e2ce \u00e0 cette actualisation en temps r\u00e9el, les entreprises peuvent prendre de meilleures d\u00e9cisions. <\/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\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-0a28530 e-flex e-con-boxed e-con\" data-id=\"0a28530\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5e54dcf elementor-widget elementor-widget-heading\" data-id=\"5e54dcf\" 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\">Quels sont les avantages de Power Query ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6c388b5 elementor-widget elementor-widget-heading\" data-id=\"6c388b5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Le gain de temps<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d372307 elementor-widget elementor-widget-text-editor\" data-id=\"d372307\" 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;\">Pour les analystes, Power Query permet d&rsquo;<\/span><b>automatiser toutes les t\u00e2ches li\u00e9es \u00e0 la pr\u00e9paration des donn\u00e9es. <\/b><span style=\"font-weight: 400;\">Autrement dit, les t\u00e2ches les plus chronophages et apportant peu de valeur ajout\u00e9e \u00e0 l\u2019entreprise.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Ainsi, les Data Analysts pourront passer davantage de temps \u00e0 analyser et interpr\u00e9ter les donn\u00e9es afin d\u2019am\u00e9liorer la qualit\u00e9 du processus d\u00e9cisionnel.<\/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-676f03d elementor-widget elementor-widget-heading\" data-id=\"676f03d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">La connexion depuis grande vari\u00e9t\u00e9 de donn\u00e9es<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d209662 elementor-widget elementor-widget-text-editor\" data-id=\"d209662\" 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;\">Power Query <\/span><b>se connecte \u00e0 tous types de sources de donn\u00e9es. <\/b><span style=\"font-weight: 400;\">Que vous importiez des informations depuis un tableau Excel, un document PDF, une <a href=\"https:\/\/datascientest.com\/base-de-donnees-definition\">database<\/a>, un site web, une API&#8230; Power Query est capable d\u2019exploiter ces donn\u00e9es externes et de les actualiser en temps r\u00e9el. <\/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-0e6bb0e elementor-widget elementor-widget-heading\" data-id=\"0e6bb0e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">La simplicit\u00e9 d\u2019utilisation<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ae30749 elementor-widget elementor-widget-text-editor\" data-id=\"ae30749\" 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;\">Pour utiliser Power Query, vous n\u2019avez <\/span><b>pas besoin d\u2019\u00e9crire une seule ligne de code. <\/b><span style=\"font-weight: 400;\">Comme cette solution est directement int\u00e9gr\u00e9e dans vos outils d\u2019analyse, il vous suffit de suivre les diff\u00e9rentes propositions du dashboard pour importer, transformer ou connecter vos donn\u00e9es.\u00a0<\/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\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-862e445 e-flex e-con-boxed e-con\" data-id=\"862e445\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b2686f9 elementor-widget elementor-widget-heading\" data-id=\"b2686f9\" 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\">Power Query, la pr\u00e9paration des donn\u00e9es automatis\u00e9es<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5a19869 elementor-widget elementor-widget-text-editor\" data-id=\"5a19869\" 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>La pr\u00e9paration des donn\u00e9es est souvent une t\u00e2che chronophage qui peut empi\u00e9ter sur la phase d\u2019analyse. Et pourtant, cette \u00e9tape est indispensable pour assurer la qualit\u00e9 des informations et la pertinence des d\u00e9cisions prises. Power Query permet justement de <strong>r\u00e9duire le temps de pr\u00e9paration gr\u00e2ce \u00e0 ses fonctionnalit\u00e9s automatis\u00e9es<\/strong>. Avec cet \u00e9diteur de requ\u00eate, vous pouvez importer des donn\u00e9es depuis une grande vari\u00e9t\u00e9 de sources, transformer les datas pour en faciliter l\u2019exploitation, et actualiser <a href=\"https:\/\/datascientest.com\/dashboard-tout-savoir\">votre tableau de bord<\/a> en seulement quelques clics.<\/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-6b9b6be elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"6b9b6be\" 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=\"https:\/\/datascientest.com\/formation-power-bi\">\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\">Apprendre \u00e0 utiliser Power Query<\/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\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d8b3596 e-flex e-con-boxed e-con\" data-id=\"d8b3596\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b1389a0 elementor-widget elementor-widget-html\" data-id=\"b1389a0\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"\u00c0 quoi sert Power Query ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Spark Streaming utilise une architecture dite \u00ab micro-batch \u00bb, ce qui signifie que les donn\u00e9es sont divis\u00e9es en petits lots appel\u00e9s \u00ab batchs \u00bb et sont trait\u00e9es de mani\u00e8re s\u00e9quentielle. Chaque batch est trait\u00e9 comme un RDD (Resilient Distributed Dataset) dans Spark, ce qui permet de b\u00e9n\u00e9ficier de la puissance de traitement en parall\u00e8le de Spark. Pour rappel, un RDD est l\u2019unit\u00e9 de base de donn\u00e9es dans Apache Spark, qui est une collection immuable de donn\u00e9es partag\u00e9es parall\u00e8lement sur plusieurs n\u0153uds d\u2019un cluster.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment fonctionne Power Query ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Il est donc tr\u00e8s facile d\u2019utiliser Power Query dans Excel. Mais attention, sachez que cette solution n\u2019est pr\u00e9sente que dans les versions les plus r\u00e9centes (c\u2019est-\u00e0-dire depuis Excel 2016).\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Quelles sont les fonctionnalit\u00e9s de Power Query ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Power Query peut importer des donn\u00e9es d\u2019une multitude de sources diff\u00e9rentes : un classeur Excel, un fichier texte, une base de donn\u00e9es SQL, un site web une, API\u2026\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Quels sont les avantages de Power Query ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Pour les analystes, Power Query permet d\u2019automatiser toutes les t\u00e2ches li\u00e9es \u00e0 la pr\u00e9paration des donn\u00e9es. Autrement dit, les t\u00e2ches les plus chronophages et apportant peu de valeur ajout\u00e9e \u00e0 l\u2019entreprise.  Ainsi, les Data Analysts pourront passer davantage de temps \u00e0 analyser et interpr\u00e9ter les donn\u00e9es afin d\u2019am\u00e9liorer la qualit\u00e9 du processus d\u00e9cisionnel.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\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\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Si l\u2019analyse des donn\u00e9es est de plus en plus valoris\u00e9e par les entreprises, les data analysts doivent r\u00e9aliser un travail de pr\u00e9paration colossal avant d\u2019exploiter les informations \u00e0 leur disposition. Heureusement, il existe des outils facilitant le traitement des donn\u00e9es en provenance de diff\u00e9rentes sources. C\u2019est notamment le cas de Power Query. Alors de quoi [&hellip;]<\/p>\n","protected":false},"author":78,"featured_media":190373,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2493],"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>Power Query : Qu&#039;est-ce que c&#039;est ? \u00c0 quoi \u00e7a sert ? | DataScientest.com<\/title>\n<meta name=\"description\" content=\"Qu&#039;est-ce que Power Query ? \u00c0 quoi sert-il ? Quelles sont ses fonctionnalit\u00e9s ? Et ses avantages ? D\u00e9couvrez toutes les r\u00e9ponses dans cet article.\" \/>\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\/power-query-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Query : Qu&#039;est-ce que c&#039;est ? \u00c0 quoi \u00e7a sert ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/power-query-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-20T18:10:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T13:46:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/tout-sur-power-query.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00e9my Robert\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00e9my Robert\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/power-query-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/power-query-tout-savoir\",\"name\":\"Power Query : Qu'est-ce que c'est ? \u00c0 quoi \u00e7a sert ? | DataScientest.com\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-02-20T18:10:00+00:00\",\"dateModified\":\"2024-03-28T13:46:30+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925\"},\"description\":\"Qu'est-ce que Power Query ? \u00c0 quoi sert-il ? Quelles sont ses fonctionnalit\u00e9s ? Et ses avantages ? D\u00e9couvrez toutes les r\u00e9ponses dans cet article.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/power-query-tout-savoir\"]}]},{\"@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\/7af2361c48e24e79a8aa2360e6e74925\",\"name\":\"J\u00e9r\u00e9my Robert\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg\",\"caption\":\"J\u00e9r\u00e9my Robert\"},\"description\":\"J\u00e9r\u00e9my Robert est actuellement Directeur p\u00e9dagogique B2B chez DataScientest.com. Avant de rejoindre DataScientest, il a travaill\u00e9 en tant que Consultant Business Intelligence chez DEAPDATA, o\u00f9 il a g\u00e9r\u00e9 des projets dans les domaines de l'assurance, bancaire et industrie. Il a \u00e9galement \u00e9t\u00e9 Co-fondateur et pr\u00e9sident de Tripzer. En tant que consultant ind\u00e9pendant, J\u00e9r\u00e9my a propos\u00e9 des formations sur MicroStrategy pour divers niveaux professionnels. Il est dipl\u00f4m\u00e9 de l'Universit\u00e9 Paris Cit\u00e9 avec un Master MIAGE, combinant comp\u00e9tences en informatique et gestion.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/jeremyrobert1\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/jeremyrobert\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Power Query : Qu'est-ce que c'est ? \u00c0 quoi \u00e7a sert ? | DataScientest.com","description":"Qu'est-ce que Power Query ? \u00c0 quoi sert-il ? Quelles sont ses fonctionnalit\u00e9s ? Et ses avantages ? D\u00e9couvrez toutes les r\u00e9ponses dans cet article.","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\/power-query-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"Power Query : Qu'est-ce que c'est ? \u00c0 quoi \u00e7a sert ?","og_url":"https:\/\/datascientest.com\/power-query-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-02-20T18:10:00+00:00","article_modified_time":"2024-03-28T13:46:30+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/tout-sur-power-query.png","type":"image\/png"}],"author":"J\u00e9r\u00e9my Robert","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"J\u00e9r\u00e9my Robert","Dur\u00e9e de lecture estim\u00e9e":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/power-query-tout-savoir","url":"https:\/\/datascientest.com\/power-query-tout-savoir","name":"Power Query : Qu'est-ce que c'est ? \u00c0 quoi \u00e7a sert ? | DataScientest.com","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-02-20T18:10:00+00:00","dateModified":"2024-03-28T13:46:30+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925"},"description":"Qu'est-ce que Power Query ? \u00c0 quoi sert-il ? Quelles sont ses fonctionnalit\u00e9s ? Et ses avantages ? D\u00e9couvrez toutes les r\u00e9ponses dans cet article.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/power-query-tout-savoir"]}]},{"@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\/7af2361c48e24e79a8aa2360e6e74925","name":"J\u00e9r\u00e9my Robert","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg","caption":"J\u00e9r\u00e9my Robert"},"description":"J\u00e9r\u00e9my Robert est actuellement Directeur p\u00e9dagogique B2B chez DataScientest.com. Avant de rejoindre DataScientest, il a travaill\u00e9 en tant que Consultant Business Intelligence chez DEAPDATA, o\u00f9 il a g\u00e9r\u00e9 des projets dans les domaines de l'assurance, bancaire et industrie. Il a \u00e9galement \u00e9t\u00e9 Co-fondateur et pr\u00e9sident de Tripzer. En tant que consultant ind\u00e9pendant, J\u00e9r\u00e9my a propos\u00e9 des formations sur MicroStrategy pour divers niveaux professionnels. Il est dipl\u00f4m\u00e9 de l'Universit\u00e9 Paris Cit\u00e9 avec un Master MIAGE, combinant comp\u00e9tences en informatique et gestion.","sameAs":["https:\/\/www.linkedin.com\/in\/jeremyrobert1\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/jeremyrobert"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/190367"}],"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\/78"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=190367"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/190367\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/190373"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=190367"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=190367"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=190367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}