{"id":192946,"date":"2023-03-24T12:31:40","date_gmt":"2023-03-24T12:31:40","guid":{"rendered":"https:\/\/datascientest.com\/?p=192946"},"modified":"2023-11-09T13:30:23","modified_gmt":"2023-11-09T13:30:23","slug":"power-query-excel-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/power-query-excel-tout-savoir","title":{"rendered":"Power Query sur Excel : Comment connecter ces deux outils ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"192946\" class=\"elementor elementor-192946\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e9fb383 e-flex e-con-boxed e-con\" data-id=\"e9fb383\" 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-21777b8 elementor-widget elementor-widget-heading\" data-id=\"21777b8\" 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\">Une analyse de donn\u00e9es efficace repose avant tout sur des donn\u00e9es fiables et harmonis\u00e9es. \u00c0 ce titre, la pr\u00e9paration des donn\u00e9es est indispensable. Mais il s\u2019agit souvent d\u2019une t\u00e2che chronophage qui empi\u00e8te sur le travail d\u2019analyse. Heureusement, il existe plusieurs outils pour faciliter le traitement des donn\u00e9es. C\u2019est justement le cas de Power Query dans Excel. <\/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-7fe1b3e e-flex e-con-boxed e-con\" data-id=\"7fe1b3e\" 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-1bded86 elementor-widget elementor-widget-heading\" data-id=\"1bded86\" 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 Power Query ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a4fef7d elementor-widget elementor-widget-text-editor\" data-id=\"a4fef7d\" 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;\"><a href=\"https:\/\/datascientest.com\/power-query-tout-savoir\">Power Query<\/a> est l\u2019un des modules phares de <a href=\"https:\/\/datascientest.com\/power-bi\">Power BI<\/a><\/span><span style=\"font-weight: 400;\">. Cet outil peut se connecter \u00e0 une grande quantit\u00e9 de sources de donn\u00e9es pour permettre aux data analysts et data scientists d&rsquo;effectuer des analyses compl\u00e8tes.&nbsp;<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Mais comme les sources de donn\u00e9es sont extr\u00eamement vari\u00e9es, leur format souffre parfois d\u2019incoh\u00e9rence et de difficult\u00e9s de compr\u00e9hension. L\u2019objectif est alors de vous aider \u00e0 <\/span><b>transformer les donn\u00e9es et \u00e0 construire un mod\u00e8le harmonieux.<\/b><span style=\"font-weight: 400;\"> Autrement dit, c\u2019est un outil indispensable en phase de pr\u00e9paration des donn\u00e9es. <\/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-0d0f921 e-flex e-con-boxed e-con\" data-id=\"0d0f921\" 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-cfd1c18 elementor-widget elementor-widget-heading\" data-id=\"cfd1c18\" 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 utiliser Power Query sur Excel ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d601fcd elementor-widget elementor-widget-heading\" data-id=\"d601fcd\" 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-medium\">L\u2019installation de Power Query<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dd156a7 elementor-widget elementor-widget-text-editor\" data-id=\"dd156a7\" 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 versions les plus r\u00e9centes d\u2019Excel<\/b><span style=\"font-weight: 400;\"> (depuis Excel 2016).\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Comme il est d\u00e9j\u00e0 install\u00e9, vous pouvez suivre les d\u00e9marches ci-dessous pour y acc\u00e9der :\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><\/ul><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">s\u00e9lectionner la rubrique \u00ab\u00a0Obtenir et transformer les donn\u00e9es\u00a0\u00bb ;<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">cliquer sur \u00ab\u00a0Obtenir des donn\u00e9es\u00a0\u00bb ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">cliquer \u00ab\u00a0utiliser l\u2019\u00e9diteur Power Query\u00a0\u00bb. <\/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-4660ef2 elementor-widget elementor-widget-text-editor\" data-id=\"4660ef2\" 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;\">L\u2019\u00e9diteur de requ\u00eate Power Query s\u2019ouvre alors dans une nouvelle fen\u00eatre.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">En revanche, si vous avez la version d\u2019Excel 2010 ou 2013, il faudra t\u00e9l\u00e9charger Power Query <a href=\"https:\/\/www.microsoft.com\/fr-FR\/download\/details.aspx?id=39379\">sur le site de Microsoft<\/a><\/span><span style=\"font-weight: 400;\">. Pour installer l\u2019\u00e9diteur de requ\u00eate sur votre feuille de calcul Excel, vous devez ex\u00e9cuter le fichier t\u00e9l\u00e9charg\u00e9 et suivre les instructions qui s\u2019affichent. Ensuite, vous devrez ouvrir Excel et activer le compl\u00e9ment Power Query. Vous pouvez aussi l\u2019ajouter sur votre ruban pour faciliter l\u2019acc\u00e8s. <\/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-5130083 elementor-widget elementor-widget-image\" data-id=\"5130083\" 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=\"1289\" height=\"814\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/telechargement-power-query.jpg\" class=\"attachment-full size-full wp-image-192956\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/telechargement-power-query.jpg 1289w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/telechargement-power-query-300x189.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/telechargement-power-query-1024x647.jpg 1024w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/telechargement-power-query-768x485.jpg 768w\" sizes=\"(max-width: 1289px) 100vw, 1289px\" \/>\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-25ea988 elementor-widget elementor-widget-heading\" data-id=\"25ea988\" 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-medium\">L\u2019importation des donn\u00e9es<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-316833d elementor-widget elementor-widget-text-editor\" data-id=\"316833d\" 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 dans Excel vous permet d<\/span><b>\u2019importer des donn\u00e9es en provenance d\u2019une multitude de sources diff\u00e9rentes :<\/b><span style=\"font-weight: 400;\"> un classeur Excel, un fichier texte PDF, une base de donn\u00e9es <a href=\"https:\/\/datascientest.com\/formation-sql\">SQL<\/a>, Oracle, SAP HANA, Microsoft Access, un site web, un rapport Salesforce, des emails de Microsoft Exchange, une <a href=\"https:\/\/datascientest.com\/construire-des-api-premiere-partie\">API<\/a>\u2026\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Quelle que soit la source d\u2019origine, voici la d\u00e9marche \u00e0 suivre :\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 \u00ab\u00a0Obtenir des donn\u00e9es\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-0b8d0ad elementor-widget elementor-widget-text-editor\" data-id=\"0b8d0ad\" 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 , vous pourrez transformer les donn\u00e9es pour faciliter leur exploitation. Il est aussi possible de combiner plusieurs sources pour croiser les donn\u00e9es et ainsi b\u00e9n\u00e9ficier d\u2019analyses encore plus pertinentes.\u00a0\u00a0<\/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-ed44231 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"ed44231\" 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-data-management\">\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\u00e9marrer une formation en Data Management<\/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-574cd4d elementor-widget elementor-widget-heading\" data-id=\"574cd4d\" 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-medium\">La transformation des donn\u00e9es<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b9f1a6 elementor-widget elementor-widget-text-editor\" data-id=\"7b9f1a6\" 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 que vous avez lanc\u00e9 Power Query sur Excel, vous b\u00e9n\u00e9ficiez d<\/span><b>e plus de 300 options de transformation. <\/b><span style=\"font-weight: 400;\">Vous pouvez ainsi mettre en forme les donn\u00e9es en fonction de vos besoins.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Par exemple, remplacer certaines donn\u00e9es textuelles en donn\u00e9es num\u00e9riques, supprimer ou modifier des colonnes, filtrer des lignes, changer l\u2019en-t\u00eate, uniformiser le format de toutes les donn\u00e9es, etc.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Toutes les actions de mise en forme des donn\u00e9es sont facilement accessibles dans le <a href=\"https:\/\/datascientest.com\/dashboard-tout-savoir\">tableau de bord<\/a> <\/span><span style=\"font-weight: 400;\">de Power Query. <\/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-a2707c0 elementor-widget elementor-widget-heading\" data-id=\"a2707c0\" 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-medium\">La cr\u00e9ation d\u2019un mod\u00e8le de donn\u00e9es<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0c596b7 elementor-widget elementor-widget-text-editor\" data-id=\"0c596b7\" 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;\">Chaque \u00e9tape de la transformation des donn\u00e9es est <\/span><b>automatiquement enregistr\u00e9e par Power Query <\/b><span style=\"font-weight: 400;\">en arri\u00e8re plan. Vous pouvez les retrouver dans la section \u00ab\u00a0\u00c9tapes appliqu\u00e9es\u00a0\u00bb du volet \u00ab\u00a0Param\u00e8tre d\u2019une requ\u00eate\u00a0\u00bb. Cet ensemble de transformation constitue alors une requ\u00eate qui peut \u00eatre utilis\u00e9e pour <\/span><b>cr\u00e9er des mod\u00e8les de donn\u00e9es.\u00a0<\/b><\/p><p><span style=\"font-weight: 400;\">Ces derniers vous serviront si vous t\u00e9l\u00e9chargez plusieurs fois le m\u00eame type de donn\u00e9es. En effet, vous pourrez r\u00e9utiliser les mod\u00e8les enregistr\u00e9s pour gagner du temps lors de la transformation. Gr\u00e2ce \u00e0 Power Query dans Excel, vous n\u2019avez<\/span><b> pas besoin de r\u00e9p\u00e9ter toutes les \u00e9tapes<\/b><span style=\"font-weight: 400;\">, simplement appliquer le mod\u00e8le. Si besoin, il est aussi possible de modifier le mod\u00e8le en ajoutant ou supprimant des \u00e9tapes.\u00a0\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Pour faciliter votre organisation de travail, nous vous conseillons de <\/span><b>nommer vos requ\u00eates <\/b><span style=\"font-weight: 400;\">et toutes les \u00e9tapes appliqu\u00e9es. Pour cela, il suffit de faire un clic droit et de cliquer sur \u00ab\u00a0Renommer\u00a0\u00bb.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Par ailleurs, lorsque des modifications interviennent sur la source de donn\u00e9es originale, toutes les \u00e9tapes de transformations effectu\u00e9es en amont sont automatiquement reprises sur les nouvelles donn\u00e9es. Vous b\u00e9n\u00e9ficiez ainsi d\u2019un format uniforme sans avoir \u00e0 effectuer un travail de pr\u00e9paration fastidieux. <\/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-ae17923 elementor-widget elementor-widget-image\" data-id=\"ae17923\" 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=\"1851\" height=\"702\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/modele-donnees-power-query.png\" class=\"attachment-full size-full wp-image-192957\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/modele-donnees-power-query.png 1851w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/modele-donnees-power-query-300x114.png 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/modele-donnees-power-query-1024x388.png 1024w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/modele-donnees-power-query-768x291.png 768w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/modele-donnees-power-query-1536x583.png 1536w\" sizes=\"(max-width: 1851px) 100vw, 1851px\" \/>\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-da05d1c elementor-widget elementor-widget-heading\" data-id=\"da05d1c\" 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-medium\">La combinaison des requ\u00eates<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3854458 elementor-widget elementor-widget-text-editor\" data-id=\"3854458\" 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;\">Avec Power Query sur Excel, vous pouvez \u00e9galement <\/span><b>combiner plusieurs requ\u00eates <\/b><span style=\"font-weight: 400;\">; soit en ajoutant de nouvelles requ\u00eates, soit en fusionnant des requ\u00eates existantes.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">L\u2019ajout d\u2019une requ\u00eate implique d\u2019avoir toutes les lignes de la requ\u00eate initiale et toutes les lignes de la nouvelle requ\u00eate. \u00c0 l\u2019inverse, en cas de fusion, les lignes des deux requ\u00eates existantes peuvent \u00eatre m\u00e9lang\u00e9es si elles correspondent \u00e0 des colonnes. <\/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-14fbeff elementor-widget elementor-widget-heading\" data-id=\"14fbeff\" 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-medium\">L\u2019actualisation des donn\u00e9es<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dc9ce10 elementor-widget elementor-widget-text-editor\" data-id=\"dc9ce10\" 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 donn\u00e9es sont modifi\u00e9es dans Power Query, elles restent inchang\u00e9es dans la source originale. En revanche, si les donn\u00e9es sont modifi\u00e9es dans la source originale, elles viennent directement se modifier dans Power Query sur Excel. Et pour cause, <\/span><b>l\u2019\u00e9diteur de requ\u00eate se connecte \u00e0 chaque source<\/b><span style=\"font-weight: 400;\"> pour actualiser les informations en temps r\u00e9el.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Pour cela, il vous suffit d\u2019aller dans l\u2019onglet \u00ab\u00a0Donn\u00e9es\u00a0\u00bb de votre tableau et de cliquer sur \u00ab\u00a0Actualiser tout\u00a0\u00bb.<\/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-0554caf elementor-widget elementor-widget-heading\" data-id=\"0554caf\" 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-medium\">L\u2019exploitation des donn\u00e9es dans Excel<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c37af3d elementor-widget elementor-widget-text-editor\" data-id=\"c37af3d\" 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 que les donn\u00e9es sont connect\u00e9es et transform\u00e9es dans le bon format gr\u00e2ce \u00e0 Power Query, vous pourrez les analyser dans Excel ou Power BI.<\/span><\/p><p><span style=\"font-weight: 400;\">Mais avant cela, vous devez <\/span><b>charger les donn\u00e9es dans votre classeur Excel.<\/b><span style=\"font-weight: 400;\"> Vous pouvez le faire depuis :\u00a0\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power Query : aller dans l\u2019onglet \u00ab\u00a0Accueil\u00a0\u00bb puis \u00ab\u00a0Fermer\u00a0\u00bb et cliquer sur \u00ab\u00a0Fermer et charger\u00a0\u00bb.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Excel : rendez-vous dans le volet \u00ab\u00a0Requ\u00eates\u00a0\u00bb, cliquez sur \u00ab\u00a0Requ\u00eates &amp; Connexions\u00a0\u00bb, s\u00e9lectionnez la requ\u00eate qui vous int\u00e9resse et cliquez sur \u00ab\u00a0Charger vers\u00a0\u00bb.<\/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-2649328 elementor-widget elementor-widget-text-editor\" data-id=\"2649328\" 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;\">Depuis Excel, vous pouvez ins\u00e9rer la requ\u00eate sous forme de tableau.\u00a0 Pour cela, il suffit de cocher \u00ab\u00a0Tableau\u00a0\u00bb, puis \u00ab\u00a0Nouvelle feuille de calcul\u00a0\u00bb. Une fois que vos donn\u00e9es sont pr\u00eates, vous pourrez <\/span><b>cr\u00e9er des graphiques, des tableaux crois\u00e9s dynamiques, des reporting<\/b><span style=\"font-weight: 400;\">, etc.<\/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-9f7492c e-flex e-con-boxed e-con\" data-id=\"9f7492c\" 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-4cd06b2 elementor-widget elementor-widget-heading\" data-id=\"4cd06b2\" 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\">Apprenez \u00e0 utiliser Power Query dans Excel<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6fb1fe2 elementor-widget elementor-widget-text-editor\" data-id=\"6fb1fe2\" 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 l\u2019un des outils indispensables pour la pr\u00e9paration des donn\u00e9es. Mais au vu de toutes les options disponibles, il est pr\u00e9f\u00e9rable de <strong>se former pour ma\u00eetriser l\u2019ensemble de ces fonctionnalit\u00e9s<\/strong>. C\u2019est justement pour cette raison que <strong>nous vous proposons nos <\/strong><\/span><strong>formations data<\/strong><span style=\"font-weight: 400;\">. \u00c0 travers ces<strong> cours en ligne<\/strong>, vous apprendrez tout ce qu\u2019il faut savoir sur les outils de traitement, d\u2019analyse ou de visualisation des donn\u00e9es.\u00a0<\/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-9f7a071 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"9f7a071\" 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-excel\">\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 notre formation Excel<\/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-625483e e-flex e-con-boxed e-con\" data-id=\"625483e\" 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-7817d00 elementor-widget elementor-widget-html\" data-id=\"7817d00\" 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\": \"Qu\u2019est-ce que Power Query ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Power Query est l\u2019un des modules phares de Power BI. Cet outil peut se connecter \u00e0 une grande quantit\u00e9 de sources de donn\u00e9es pour permettre aux data analysts et data scientists d'effectuer des analyses compl\u00e8tes.  Mais comme les sources de donn\u00e9es sont extr\u00eamement vari\u00e9es, leur format souffre parfois d\u2019incoh\u00e9rence et de difficult\u00e9s de compr\u00e9hension. L\u2019objectif est alors de vous aider \u00e0 transformer les donn\u00e9es et \u00e0 construire un mod\u00e8le harmonieux. Autrement dit, c\u2019est un outil indispensable en phase de pr\u00e9paration des donn\u00e9es.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment utiliser Power Query sur Excel ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Power Query est directement int\u00e9gr\u00e9 dans les versions les plus r\u00e9centes d\u2019Excel (depuis Excel 2016).\"\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>Une analyse de donn\u00e9es efficace repose avant tout sur des donn\u00e9es fiables et harmonis\u00e9es. \u00c0 ce titre, la pr\u00e9paration des donn\u00e9es est indispensable. Mais il s\u2019agit souvent d\u2019une t\u00e2che chronophage qui empi\u00e8te sur le travail d\u2019analyse. Heureusement, il existe plusieurs outils pour faciliter le traitement des donn\u00e9es. C\u2019est justement le cas de Power Query dans [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":192948,"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 sur Excel : Comment connecter ces deux outils ?<\/title>\n<meta name=\"description\" content=\"D\u00e9couvrez dans cet article tout ce qu&#039;il y a \u00e0 savoir sur Power Query dans Excel, un outil qui facilite le traitement des donn\u00e9es.\" \/>\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-excel-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 sur Excel : Comment connecter ces deux outils ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/power-query-excel-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-24T12:31:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:30:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/power-query-dans-excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Antoine Tardivon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Antoine Tardivon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/power-query-excel-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/power-query-excel-tout-savoir\",\"name\":\"Power Query sur Excel : Comment connecter ces deux outils ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-03-24T12:31:40+00:00\",\"dateModified\":\"2023-11-09T13:30:23+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"D\u00e9couvrez dans cet article tout ce qu'il y a \u00e0 savoir sur Power Query dans Excel, un outil qui facilite le traitement des donn\u00e9es.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/power-query-excel-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\/40cb5b6317e138be77b9dd23007cab57\",\"name\":\"Antoine Tardivon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"caption\":\"Antoine Tardivon\"},\"description\":\"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/\",\"Business Intelligence\"],\"url\":\"https:\/\/datascientest.com\/author\/antoinetardivon\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Power Query sur Excel : Comment connecter ces deux outils ?","description":"D\u00e9couvrez dans cet article tout ce qu'il y a \u00e0 savoir sur Power Query dans Excel, un outil qui facilite le traitement des donn\u00e9es.","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-excel-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"Power Query sur Excel : Comment connecter ces deux outils ?","og_url":"https:\/\/datascientest.com\/power-query-excel-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-03-24T12:31:40+00:00","article_modified_time":"2023-11-09T13:30:23+00:00","og_image":[{"width":1000,"height":500,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/power-query-dans-excel.png","type":"image\/png"}],"author":"Antoine Tardivon","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Antoine Tardivon","Dur\u00e9e de lecture estim\u00e9e":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/power-query-excel-tout-savoir","url":"https:\/\/datascientest.com\/power-query-excel-tout-savoir","name":"Power Query sur Excel : Comment connecter ces deux outils ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-03-24T12:31:40+00:00","dateModified":"2023-11-09T13:30:23+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"D\u00e9couvrez dans cet article tout ce qu'il y a \u00e0 savoir sur Power Query dans Excel, un outil qui facilite le traitement des donn\u00e9es.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/power-query-excel-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\/40cb5b6317e138be77b9dd23007cab57","name":"Antoine Tardivon","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","caption":"Antoine Tardivon"},"description":"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.","sameAs":["https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/","Business Intelligence"],"url":"https:\/\/datascientest.com\/author\/antoinetardivon"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/192946"}],"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\/74"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=192946"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/192946\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/192948"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=192946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=192946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=192946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}