{"id":196444,"date":"2022-05-03T08:22:00","date_gmt":"2022-05-03T08:22:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=196444"},"modified":"2023-11-09T13:31:57","modified_gmt":"2023-11-09T13:31:57","slug":"power-query-sur-mac","status":"publish","type":"post","link":"https:\/\/datascientest.com\/power-query-sur-mac","title":{"rendered":"Power Query sur Mac : Tutoriel complet"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"196444\" class=\"elementor elementor-196444\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-743e5ae e-flex e-con-boxed e-con\" data-id=\"743e5ae\" 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-d065803 elementor-widget elementor-widget-heading\" data-id=\"d065803\" 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\">Comptant parmi les outils de traitement des donn\u00e9es pr\u00e9f\u00e9r\u00e9s des <a href=\"https:\/\/datascientest.com\/formation-data-analyst\">Data Analysts<\/a>, Power Query offre de nombreux avantages pour exploiter au mieux les data de diff\u00e9rentes sources.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-58ebca3 elementor-widget elementor-widget-text-editor\" data-id=\"58ebca3\" 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;\">Excel pour Mac int\u00e8gre Power Query, aussi appel\u00e9 Get &amp; Transform, permettant notamment la gestion de sources de donn\u00e9es, la mise en forme, la mise \u00e0 jour et la modification de l\u2019emplacement des sources de donn\u00e9es dans un tableau. Alors, <\/span><b>comment utiliser Power Query sur Mac<\/b><span style=\"font-weight: 400;\"> ? Quelle est son utilit\u00e9 ? Quelles sont ses fonctionnalit\u00e9s ? R\u00e9ponses en d\u00e9tail dans cet article.\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-a92400c e-flex e-con-boxed e-con\" data-id=\"a92400c\" 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-0e06fd1 elementor-widget elementor-widget-heading\" data-id=\"0e06fd1\" 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\">Quelle est l\u2019utilit\u00e9 de Power Query ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cc3cbe4 elementor-widget elementor-widget-text-editor\" data-id=\"cc3cbe4\" 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;\"><a href=\"https:\/\/datascientest.com\/power-query-tout-savoir\">Power Query<\/a> est un outil Microsoft tr\u00e8s utile. Il permet d\u2019<\/span><b>uniformiser les bases de donn\u00e9es<\/b><span style=\"font-weight: 400;\"> afin de simplifier l\u2019analyse de la data. Get &amp; Transform facilite notamment le traitement des donn\u00e9es, de la collecte jusqu\u2019\u00e0 la mise \u00e0 jour. Cela est rendu possible gr\u00e2ce \u00e0 de nombreuses fonctionnalit\u00e9s comme :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">l\u2019importation depuis diff\u00e9rentes sources de donn\u00e9es ;<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">la connexion entre le fichier source et l\u2019\u00e9diteur de requ\u00eate ;<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">la transformation des data ;<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">les reportings.<\/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-7591d4e elementor-widget elementor-widget-text-editor\" data-id=\"7591d4e\" 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;\">Puisque Power Query peut se connecter \u00e0 des <\/span><b>centaines de data source<\/b><span style=\"font-weight: 400;\">, il est possible d\u2019utiliser les donn\u00e9es issues de n\u2019importe quelle source et de n\u2019importe quelle forme.<\/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-aaee522 e-flex e-con-boxed e-con\" data-id=\"aaee522\" 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-cb4e29a elementor-widget elementor-widget-heading\" data-id=\"cb4e29a\" 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 Mac ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c7b3f76 elementor-widget elementor-widget-text-editor\" data-id=\"c7b3f76\" 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 \u00eatre utilis\u00e9 au sein d\u2019autres produits de Microsoft comme Power BI ou Excel. La m\u00e9thode pour b\u00e9n\u00e9ficier de Power Query sur Mac expliqu\u00e9e plus bas dans cet article passe par Excel. N\u00e9anmoins, les flux de donn\u00e9es de Power Query s\u2019ex\u00e9cutent dans le cloud. Vous pouvez donc stocker la sortie dans d\u2019autres outils comme Dataverse ou Data Lake Storage, par exemple.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Vous pouvez utiliser facilement <\/span><a href=\"https:\/\/datascientest.com\/power-query-excel-tout-savoir\">Power Query sur Mac directement dans Excel<\/a><span style=\"font-weight: 400;\">. Cet outil n\u2019est pr\u00e9sent que dans les versions depuis Excel 2016. Pour les versions d\u2019Excel pr\u00e9c\u00e9dentes, rendez-vous sur le site de Microsoft pour t\u00e9l\u00e9charger Power Query et l\u2019installer dans votre feuille de calcul.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Pour utiliser Power Query sur Mac, ouvrez votre feuille de calcul :\u00a0<\/span><\/p><ol><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez \u00ab\u00a0Donn\u00e9es\u00a0\u00bb.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur \u00ab\u00a0Obtenir des donn\u00e9es\u00a0\u00bb.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez \u00ab\u00a0Obtenir des donn\u00e9es (Power Query)\u00a0\u00bb pour choisir la source de donn\u00e9es.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Une bo\u00eete de dialogue s\u2019ouvre : \u00ab\u00a0Choisir une source de donn\u00e9es\u00a0\u00bb. S\u00e9lectionnez la source de donn\u00e9es de votre choix.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Choisissez le type de source de donn\u00e9es \u00e0 importer.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur le bouton \u00ab\u00a0Charger\u00a0\u00bb.<\/span><\/li><\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-481b1a3 elementor-widget elementor-widget-text-editor\" data-id=\"481b1a3\" 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 va alors ouvrir une nouvelle feuille. Power Query dispose ensuite de plusieurs fonctionnalit\u00e9s pour am\u00e9liorer la qualit\u00e9 des donn\u00e9es et <strong>simplifier le travail des Data Analysts<\/strong>.<\/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-23f72e7 elementor-widget elementor-widget-image\" data-id=\"23f72e7\" 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=\"800\" height=\"450\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/data-analyst-power-query-mac.png\" class=\"attachment-full size-full wp-image-196469\" alt=\"\" loading=\"lazy\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/data-analyst-power-query-mac.png 800w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/data-analyst-power-query-mac-300x169.png 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/data-analyst-power-query-mac-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\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-14a311f elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"14a311f\" 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 sur MacOS<\/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-c045be8 elementor-widget elementor-widget-heading\" data-id=\"c045be8\" 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\">L\u2019importation de sources de donn\u00e9es<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8d3dde5 elementor-widget elementor-widget-text-editor\" data-id=\"8d3dde5\" 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 est possible d\u2019importer des donn\u00e9es dans Excel provenant d\u2019une <\/span><b>vari\u00e9t\u00e9 de sources de donn\u00e9es<\/b><span style=\"font-weight: 400;\">. Fichier Excel, <a href=\"https:\/\/datascientest.com\/importer-un-csv-sur-power-bi\">CSV<\/a>, <a href=\"https:\/\/datascientest.com\/formation-sql\">base de donn\u00e9es SQL<\/a><\/span><span style=\"font-weight: 400;\">, vos donn\u00e9es de site web et d\u2019autres outils comme Salesforce, Oracle ou Azure peuvent s\u2019importer :\u00a0<\/span><\/p><ol><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Donn\u00e9es \u2192 Obtenir des donn\u00e9es (Power Query).<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Choisissez la source de donn\u00e9es \u00e0 importer : \u00ab\u00a0From Text\/CSV\u00a0\u00bb, \u00ab\u00a0From SQL Server Database\u00a0\u00bb, ou \u00ab\u00a0From Oracle Database\u00a0\u00bb par exemple.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Selon la source de donn\u00e9es s\u00e9lectionn\u00e9e, proc\u00e9dez aux choix \u00e0 effectuer dans la bo\u00eete de dialogue.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Les donn\u00e9es apparaissent dans une nouvelle feuille.<\/span><\/li><\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2bb7301 elementor-widget elementor-widget-text-editor\" data-id=\"2bb7301\" 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 vous souhaitez mettre en forme et transformer les donn\u00e9es avec l\u2019\u00c9diteur Power Query, cliquez sur \u00ab\u00a0Transformer les donn\u00e9es\u00a0\u00bb.\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-9525b35 elementor-widget elementor-widget-heading\" data-id=\"9525b35\" 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 mise en forme des donn\u00e9es avec Power Query Editor<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-baec250 elementor-widget elementor-widget-text-editor\" data-id=\"baec250\" 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;\">Maintenant que vos donn\u00e9es sont import\u00e9es dans Power Query, vous pouvez les mettre en forme gr\u00e2ce \u00e0 l\u2019\u00e9diteur. Comprenez bien que <\/span><b>Power Query s\u2019organise par colonne<\/b><span style=\"font-weight: 400;\">. Vous modifiez donc les colonnes dans leur ensemble plut\u00f4t que chaque cellule individuellement.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Pour ce faire :\u00a0<\/span><\/p><ol><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionner \u00ab\u00a0Donn\u00e9es\u00a0\u00bb \u2192 \u00ab\u00a0Obtenir des donn\u00e9es (Power Query)\u00a0\u00bb.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur \u00ab\u00a0Lancer l\u2019\u00c9diteur Power Query\u00a0\u00bb.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Transformez vos donn\u00e9es \u00e0 l\u2019aide de l\u2019\u00c9diteur de requ\u00eate, avec la m\u00eame m\u00e9thode que sur Windows.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Une fois la mise en forme effectu\u00e9e, cliquez sur \u00ab\u00a0Accueil\u00a0\u00bb, puis sur \u00ab\u00a0Fermer et Charger\u00a0\u00bb.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Les donn\u00e9es apparaissent dans une nouvelle feuille.<\/span><\/li><\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0d44084 elementor-widget elementor-widget-text-editor\" data-id=\"0d44084\" 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\u00c9diteur Power Query propose de nombreuses fonctionnalit\u00e9s comme le remplacement de donn\u00e9es textuelles en donn\u00e9es num\u00e9riques, la suppression de colonnes, le changement d\u2019en-t\u00eate, la mise en forme de toutes les donn\u00e9es quelles que soient leurs formats et bien d\u2019autres encore. Cela facilite notamment la cr\u00e9ation de graphiques, d\u2019un <\/span><b>tableau crois\u00e9 dynamique<\/b><span style=\"font-weight: 400;\"> ou d\u2019autres rapports d\u2019analyse.<\/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-52ee984 elementor-widget elementor-widget-heading\" data-id=\"52ee984\" 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\">Mettre \u00e0 jour les sources de donn\u00e9es<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9ceb4b4 elementor-widget elementor-widget-text-editor\" data-id=\"9ceb4b4\" 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;\">Gr\u00e2ce \u00e0 Power Query, vous pouvez actualiser de nombreuses sources de donn\u00e9es comme des classeurs Excel, des fichiers CSV, des fichiers SharePoint, OData, XML ou Json, une base de donn\u00e9es Microsoft SQL Server, entre autres.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Pour la premi\u00e8re actualisation de sources de donn\u00e9es, mettez \u00e0 jour le chemin d\u2019acc\u00e8s au fichier :\u00a0<\/span><\/p><ol><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur \u00ab\u00a0Donn\u00e9es\u00a0\u00bb \u2192 \u00ab\u00a0Obtenir des donn\u00e9es\u00a0\u00bb.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez \u00ab\u00a0Param\u00e8tres de source de donn\u00e9es\u00a0\u00bb. Une bo\u00eete de dialogue s\u2019ouvre.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez \u00ab\u00a0Modifier le chemin d\u2019acc\u00e8s au fichier\u00a0\u00bb.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez enfin le nouvel emplacement puis cliquez sur \u00ab\u00a0Obtenir des donn\u00e9es\u00a0\u00bb.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur \u00ab\u00a0Fermer\u00a0\u00bb.<\/span><\/li><\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1543bfb elementor-widget elementor-widget-text-editor\" data-id=\"1543bfb\" 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;\">Les fois suivantes, la mise \u00e0 jour des sources de donn\u00e9es est rapide :\u00a0<\/span><\/p><ol><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Pour actualiser l\u2019int\u00e9gralit\u00e9 des sources de donn\u00e9es, cliquez sur \u00ab\u00a0Donn\u00e9es\u00a0\u00bb \u2192 \u00ab\u00a0Actualiser tout\u00a0\u00bb.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Pour actualiser une source de donn\u00e9es sp\u00e9cifique, clic droit sur une feuille ou une table de requ\u00eate puis s\u00e9lectionnez \u00ab\u00a0Actualiser\u00a0\u00bb.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dans un tableau crois\u00e9 dynamique, s\u00e9lectionnez une cellule puis cliquez sur \u00ab\u00a0Analyser le tableau crois\u00e9 dynamique\u00a0\u00bb, puis sur \u00ab\u00a0Actualiser les donn\u00e9es\u00a0\u00bb.<\/span><\/li><\/ol>\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-a08989f e-flex e-con-boxed e-con\" data-id=\"a08989f\" 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-f4bfbd5 elementor-widget elementor-widget-heading\" data-id=\"f4bfbd5\" 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\">La conclusion de Power Query sur Mac<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d49bea2 elementor-widget elementor-widget-text-editor\" data-id=\"d49bea2\" 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\u2019utilisation de Power Query sur Mac est intuitive. L\u2019outil permet notamment d\u2019importer des sources de donn\u00e9es, les transformer et mettre \u00e0 jour les sources de donn\u00e9es dans un tableau. <\/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-fd1a698 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"fd1a698\" 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\">D\u00e9marrer une formation Power BI<\/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-1d5d13f e-flex e-con-boxed e-con\" data-id=\"1d5d13f\" 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-11d1f59 elementor-widget elementor-widget-html\" data-id=\"11d1f59\" 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\": \"Quelle est l\u2019utilit\u00e9 de Power Query ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Power Query est un outil Microsoft tr\u00e8s utile. Il permet d\u2019uniformiser les bases de donn\u00e9es afin de simplifier l\u2019analyse de la data. Get & Transform facilite notamment le traitement des donn\u00e9es, de la collecte jusqu\u2019\u00e0 la mise \u00e0 jour.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment utiliser Power Query sur Mac ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Power Query peut \u00eatre utilis\u00e9 au sein d\u2019autres produits de Microsoft comme Power BI ou Excel. La m\u00e9thode pour b\u00e9n\u00e9ficier de Power Query sur Mac expliqu\u00e9e plus bas dans cet article passe par Excel. N\u00e9anmoins, les flux de donn\u00e9es de Power Query s\u2019ex\u00e9cutent dans le cloud. Vous pouvez donc stocker la sortie dans d\u2019autres outils comme Dataverse ou Data Lake Storage, par exemple.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"La mise en forme des donn\u00e9es avec Power Query Editor\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Maintenant que vos donn\u00e9es sont import\u00e9es dans Power Query, vous pouvez les mettre en forme gr\u00e2ce \u00e0 l\u2019\u00e9diteur. Comprenez bien que Power Query s\u2019organise par colonne. Vous modifiez donc les colonnes dans leur ensemble plut\u00f4t que chaque cellule individuellement.\"\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>Comptant parmi les outils de traitement des donn\u00e9es pr\u00e9f\u00e9r\u00e9s des Data Analysts, Power Query offre de nombreux avantages pour exploiter au mieux les data de diff\u00e9rentes sources. Excel pour Mac int\u00e8gre Power Query, aussi appel\u00e9 Get &amp; Transform, permettant notamment la gestion de sources de donn\u00e9es, la mise en forme, la mise \u00e0 jour et [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":196447,"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 Mac : Tutoriel complet | DataScientest.com<\/title>\n<meta name=\"description\" content=\"Comment utiliser Power Query sur Mac ? Quelle est son utilit\u00e9 ? Quelles sont ses fonctionnalit\u00e9s ? R\u00e9ponses en d\u00e9tail 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-sur-mac\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Query sur Mac : Tutoriel complet\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/power-query-sur-mac\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-03T08:22:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:31:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/power-query-mac.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=\"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=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/power-query-sur-mac\",\"url\":\"https:\/\/datascientest.com\/power-query-sur-mac\",\"name\":\"Power Query sur Mac : Tutoriel complet | DataScientest.com\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2022-05-03T08:22:00+00:00\",\"dateModified\":\"2023-11-09T13:31:57+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"Comment utiliser Power Query sur Mac ? Quelle est son utilit\u00e9 ? Quelles sont ses fonctionnalit\u00e9s ? R\u00e9ponses en d\u00e9tail dans cet article.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/power-query-sur-mac\"]}]},{\"@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 Mac : Tutoriel complet | DataScientest.com","description":"Comment utiliser Power Query sur Mac ? Quelle est son utilit\u00e9 ? Quelles sont ses fonctionnalit\u00e9s ? R\u00e9ponses en d\u00e9tail 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-sur-mac","og_locale":"fr_FR","og_type":"article","og_title":"Power Query sur Mac : Tutoriel complet","og_url":"https:\/\/datascientest.com\/power-query-sur-mac","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2022-05-03T08:22:00+00:00","article_modified_time":"2023-11-09T13:31:57+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/power-query-mac.png","type":"image\/png"}],"author":"Antoine Tardivon","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Antoine Tardivon","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/power-query-sur-mac","url":"https:\/\/datascientest.com\/power-query-sur-mac","name":"Power Query sur Mac : Tutoriel complet | DataScientest.com","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2022-05-03T08:22:00+00:00","dateModified":"2023-11-09T13:31:57+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"Comment utiliser Power Query sur Mac ? Quelle est son utilit\u00e9 ? Quelles sont ses fonctionnalit\u00e9s ? R\u00e9ponses en d\u00e9tail dans cet article.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/power-query-sur-mac"]}]},{"@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\/196444"}],"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=196444"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/196444\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/196447"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=196444"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=196444"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=196444"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}