{"id":218369,"date":"2023-12-19T06:30:00","date_gmt":"2023-12-19T06:30:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=218369"},"modified":"2023-12-15T14:10:55","modified_gmt":"2023-12-15T14:10:55","slug":"agregation-power-query","status":"publish","type":"post","link":"https:\/\/datascientest.com\/agregation-power-query","title":{"rendered":"Agr\u00e9gation sur Power Query : comment \u00e7a marche ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"218369\" class=\"elementor elementor-218369\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-78d4123 e-flex e-con-boxed e-con\" data-id=\"78d4123\" 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-89da1e3 elementor-widget elementor-widget-heading\" data-id=\"89da1e3\" 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\">\u00c0 l\u2019heure du Big data, le probl\u00e8me n\u2019est plus l\u2019acc\u00e8s aux donn\u00e9es, mais la compr\u00e9hension de celles-ci. Et pour cause, les volumes de donn\u00e9es sont tels que de nombreuses organisations ne savent plus que faire de tant d\u2019informations.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b9d9bf5 elementor-widget elementor-widget-text-editor\" data-id=\"b9d9bf5\" 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;\">Heureusement, il existe plusieurs solutions pour simplifier la compr\u00e9hension et la gestion de ces donn\u00e9es. Parmi lesquelles, <\/span><b>l\u2019agr\u00e9gation sur Power Query. <\/b><span style=\"font-weight: 400;\">D\u00e9couvrez de quoi il s\u2019agit, son int\u00e9r\u00eat pour les entreprises, et surtout, les manipulations \u00e0 effectuer pour agr\u00e9ger des donn\u00e9es sur cet \u00e9diteur de requ\u00eates. <\/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-d6af645 e-flex e-con-boxed e-con\" data-id=\"d6af645\" 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-9258379 elementor-widget elementor-widget-heading\" data-id=\"9258379\" 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\">Quel est l\u2019int\u00e9r\u00eat de l\u2019agr\u00e9gation dans Power Query ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-03416bb elementor-widget elementor-widget-text-editor\" data-id=\"03416bb\" 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 rappel, <a href=\"https:\/\/datascientest.com\/power-query-tout-savoir\">Power Query<\/a> est un \u00e9diteur de requ\u00eates permettant d&rsquo;importer et de modifier des donn\u00e9es, quels que soient leurs sources ou leurs formats. Et ce, aussi bien pour les <a href=\"https:\/\/datascientest.com\/formation-excel\">usagers d&rsquo;Excel<\/a> que ceux de <a href=\"https:\/\/datascientest.com\/power-bi\">Power BI<\/a>.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">L\u2019agr\u00e9gation des donn\u00e9es dans Power Query fait justement partie des multiples fonctionnalit\u00e9s de cet \u00e9diteur de requ\u00eates. Celle-ci vous permet alors de <\/span><b>regrouper et de r\u00e9sumer les donn\u00e9es afin qu\u2019elles soient plus faciles \u00e0 lire et \u00e0 g\u00e9rer.\u00a0<\/b><\/p><p><span style=\"font-weight: 400;\">Ce faisant, vous pourrez obtenir des informations suppl\u00e9mentaires, enrichir vos datasets, am\u00e9liorer vos rapports, identifier des mod\u00e8les, des tendances ou des anomalies, mais aussi r\u00e9duire les risques d&rsquo;erreurs et d&rsquo;impr\u00e9cisions.<\/span><\/p><p><span style=\"font-weight: 400;\">Agr\u00e9ger des donn\u00e9es est particuli\u00e8rement utile pour<\/span><b> traiter des ensembles de donn\u00e9es volumineux. <\/b><span style=\"font-weight: 400;\">Et oui, en r\u00e9sumant des donn\u00e9es brutes et massives en petits jeux de donn\u00e9es, vous pourrez plus facilement les analyser et d\u00e9gager des conclusions pertinentes.<\/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-72796e0 e-flex e-con-boxed e-con\" data-id=\"72796e0\" 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-df39670 elementor-widget elementor-widget-heading\" data-id=\"df39670\" 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 agr\u00e9ger des donn\u00e9es dans Power Query ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3a29175 elementor-widget elementor-widget-heading\" data-id=\"3a29175\" 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\">Agr\u00e9ger une colonne de donn\u00e9es sur Power Query<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5094732 elementor-widget elementor-widget-text-editor\" data-id=\"5094732\" 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;\">Sur Power Query, il est possible d<\/span><b>\u2019agr\u00e9ger une ou plusieurs colonnes d\u2019une table li\u00e9e. <\/b><span style=\"font-weight: 400;\">Par exemple, vous pourriez ajouter \u00e0 une colonne de prix, la somme des prix unitaires pour chaque commande, la moyenne de ces prix unitaires, le montant minimum, le montant maximum, etc.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Pour utiliser l\u2019agr\u00e9gation sur Power Query avec Excel, vous pouvez suivre les op\u00e9rations ci-dessous :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dans l\u2019onglet \u00ab\u00a0Accueil\u00a0\u00bb, s\u00e9lectionnez \u00ab\u00a0Nouvelle source\u00a0\u00bb, puis \u00ab\u00a0Autres sources\u00a0\u00bb,\u00a0 et la source de donn\u00e9es dont vous avez besoin.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Une bo\u00eete de dialogue appara\u00eet. Entrez l\u2019URL de la table dans laquelle vous souhaitez agr\u00e9ger une colonne.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur OK.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dans l\u2019onglet \u00ab\u00a0Navigateur\u00a0\u00bb, s\u00e9lectionnez la table que vous souhaitez agr\u00e9ger (vous pourrez pr\u00e9visualiser les donn\u00e9es sur la droite).\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur \u00ab\u00a0Transformer les donn\u00e9es\u00a0\u00bb.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u00c0 partir de l\u00e0, l\u2019\u00e9diteur Power Query s\u2019affiche. Faites-le d\u00e9filer vers la droite, jusqu\u2019\u00e0 voir appara\u00eetre la colonne que vous souhaitez agr\u00e9ger. Cliquez ensuite sur l\u2019ic\u00f4ne d&rsquo;expansion qui appara\u00eet \u00e0 droite de la colonne.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dans l\u2019encart, s\u00e9lectionnez l\u2019option \u00ab\u00a0Agr\u00e9ger\u00a0\u00bb, puis un \u00e9l\u00e9ment de fonction d\u2019agr\u00e9gation. Choisissez ensuite une ou plusieurs fonctions d\u2019agr\u00e9gation, comme somme, minimum, maximum, moyenne\u2026 <\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur OK.<\/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-3001736 elementor-widget elementor-widget-text-editor\" data-id=\"3001736\" 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 travers ces \u00e9l\u00e9ments de fonction d\u2019agr\u00e9gation, vous pourriez voir appara\u00eetre la somme, le minimum, le maximum, la moyenne, 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-2ef5b36 elementor-widget elementor-widget-image\" data-id=\"2ef5b36\" 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=\"500\" height=\"500\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/Agregation-Power-Query1.jpg\" class=\"attachment-full size-full wp-image-218399\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/Agregation-Power-Query1.jpg 500w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/Agregation-Power-Query1-300x300.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/Agregation-Power-Query1-150x150.jpg 150w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/>\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-1a9993d elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"1a9993d\" 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\">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-415ab5b elementor-widget elementor-widget-heading\" data-id=\"415ab5b\" 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\">Regrouper les donn\u00e9es avec Power Query<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e1afb05 elementor-widget elementor-widget-text-editor\" data-id=\"e1afb05\" 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 travers le regroupement de donn\u00e9es, vous pourrez <\/span><b>visualiser les donn\u00e9es \u00e0 un niveau plus \u00e9lev\u00e9 (ou agr\u00e9g\u00e9).\u00a0<\/b><\/p><p><span style=\"font-weight: 400;\">Pour cela, voici les \u00e9tapes \u00e0 suivre :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dans l\u2019onglet \u00ab\u00a0Accueil\u00a0\u00bb de l\u2019\u00e9diteur Power Query, cliquez sur \u00ab\u00a0Regrouper\u00a0\u00bb.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Une fen\u00eatre appara\u00eet o\u00f9 vous pouvez s\u00e9lectionner une ou plusieurs variables par lesquelles vous souhaitez regrouper vos donn\u00e9es. Si vous souhaitez regrouper les donn\u00e9es en fonction de plusieurs variables ou effectuer une op\u00e9ration sur plusieurs variables, choisissez l\u2019option \u00ab\u00a0Avanc\u00e9\u00a0\u00bb. \u00c0 d\u00e9faut, l\u2019option \u00ab\u00a0Basique\u00a0\u00bb est suffisante.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Choisissez plusieurs options pour la sortie de vos donn\u00e9es :\u00a0<\/span><ul><li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Donner un nom \u00e0 votre colonne agr\u00e9g\u00e9e sur Power Query ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Choisissez une fonction d\u2019agr\u00e9gation (somme, moyenne, minimum, maximum\u2026) ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">S\u00e9lectionnez la colonne et cliquez sur OK.\u00a0<\/span><\/li><\/ul><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez ensuite sur \u00ab\u00a0Fermer et T\u00e9l\u00e9charger\u00a0\u00bb pour d\u00e9placer ces donn\u00e9es vers la feuille de calcul.<\/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-86ede63 elementor-widget elementor-widget-text-editor\" data-id=\"86ede63\" 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 travers ces \u00e9l\u00e9ments de fonction d\u2019agr\u00e9gation, vous pourriez voir appara\u00eetre la somme, le minimum, le maximum, la moyenne, 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-aaca54e elementor-widget elementor-widget-heading\" data-id=\"aaca54e\" 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\">Rechercher les donn\u00e9es associ\u00e9es \u00e0 une colonne<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ee7b6a9 elementor-widget elementor-widget-text-editor\" data-id=\"ee7b6a9\" 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;\">Au-del\u00e0 de l\u2019agr\u00e9gation de donn\u00e9es, vous pouvez \u00e9galement<\/span><b> afficher la source de donn\u00e9es<\/b><span style=\"font-weight: 400;\">. Cela vous permettra alors de savoir d\u2019o\u00f9 viennent ces donn\u00e9es.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Voici les \u00e9tapes \u00e0 suivre :<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dans l\u2019onglet \u00ab\u00a0Requ\u00eate Param\u00e8tres\u00a0\u00bb, s\u00e9lectionnez \u00ab\u00a0Source\u00a0\u00bb (qui appara\u00eet sous \u00ab\u00a0\u00c9tapes appliqu\u00e9es\u00a0\u00bb),puis cliquez sur l\u2019ic\u00f4ne param\u00e8tres<\/span><span style=\"font-weight: 400;\">.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">La bo\u00eete de dialogue \u00ab\u00a0Source\u00a0\u00bb s\u2019affiche. Notez bien le nom de la source de donn\u00e9es, car vous en aurez besoin par la suite.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Retournez \u00e0 l\u2019onglet \u00ab\u00a0Accueil\u00a0\u00bb, puis cliquez sur \u00ab\u00a0Sources\u00a0\u00bb. \u00c0 ce stade, s\u00e9lectionnez la source de donn\u00e9es que vous avez pr\u00e9alablement not\u00e9e.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">La bo\u00eete de dialogue \u00ab\u00a0Navigateur\u00a0\u00bb s\u2019affiche avec une liste de toutes les tables de la source de donn\u00e9es. S\u00e9lectionnez uniquement la table associ\u00e9e qui vous int\u00e9resse. Dans l\u2019aper\u00e7u, vous pourrez aussi faire appara\u00eetre uniquement les colonnes pertinentes gr\u00e2ce aux options d\u2019affichage.<\/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-efd6912 elementor-widget elementor-widget-text-editor\" data-id=\"efd6912\" 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<span style=\"font-weight: 400;\">Vous souhaitez ma\u00eetriser Power Query et ses diff\u00e9rentes requ\u00eates ? La seule solution est de vous former. DataScientest vous propose justement des <a href=\"https:\/\/datascientest.com\/formations-data\">formations<\/a> alliant th\u00e9orie et pratique afin que vous soyez op\u00e9rationnel d\u00e8s la fin du cursus.\u00a0<\/span>\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-4e28982 e-flex e-con-boxed e-con\" data-id=\"4e28982\" 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-2aa0291 elementor-widget elementor-widget-heading\" data-id=\"2aa0291\" 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\">Ce qu\u2019il faut retenir :<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e58d026 elementor-widget elementor-widget-text-editor\" data-id=\"e58d026\" 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<ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">L\u2019option d\u2019agr\u00e9gation sur Power Query vous permet de regrouper et de r\u00e9sumer des donn\u00e9es.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cette fonctionnalit\u00e9 est particuli\u00e8rement utile aux experts data qui doivent traiter de grands volumes de donn\u00e9es.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Selon vos besoins, vous pouvez faire appara\u00eetre les sommes, moyennes, minimum, maximum\u2026 de donn\u00e9es chiffr\u00e9es li\u00e9es entre plusieurs tables. <\/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-389cfdf elementor-widget elementor-widget-image\" data-id=\"389cfdf\" 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=\"500\" height=\"500\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/Agregation-Power-Query2.jpg\" class=\"attachment-full size-full wp-image-218400\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/Agregation-Power-Query2.jpg 500w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/Agregation-Power-Query2-300x300.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/Agregation-Power-Query2-150x150.jpg 150w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/>\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-42cd32e elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"42cd32e\" 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\">Commencer une formation sur 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-a03ac79 e-flex e-con-boxed e-con\" data-id=\"a03ac79\" 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-3740ada elementor-widget elementor-widget-html\" data-id=\"3740ada\" 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\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"Quel est l\u2019int\u00e9r\u00eat de l\u2019agr\u00e9gation dans Power Query ?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Pour rappel, Power Query est un \u00e9diteur de requ\u00eates permettant d'importer et de modifier des donn\u00e9es, quels que soient leurs sources ou leurs formats. Et ce, aussi bien pour les usagers d'Excel que ceux de Power BI.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Comment agr\u00e9ger des donn\u00e9es dans Power Query ?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Sur Power Query, il est possible d\u2019agr\u00e9ger une ou plusieurs colonnes d\u2019une table li\u00e9e. Par exemple, vous pourriez ajouter \u00e0 une colonne de prix, la somme des prix unitaires pour chaque commande, la moyenne de ces prix unitaires, le montant minimum, le montant maximum, etc.\"\n    }\n  }]\n}\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>\u00c0 l\u2019heure du Big data, le probl\u00e8me n\u2019est plus l\u2019acc\u00e8s aux donn\u00e9es, mais la compr\u00e9hension de celles-ci. Et pour cause, les volumes de donn\u00e9es sont tels que de nombreuses organisations ne savent plus que faire de tant d\u2019informations. Heureusement, il existe plusieurs solutions pour simplifier la compr\u00e9hension et la gestion de ces donn\u00e9es. Parmi lesquelles, [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":218378,"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>Agr\u00e9gation sur Power Query : comment \u00e7a marche ?<\/title>\n<meta name=\"description\" content=\"Pour regrouper et r\u00e9sumer des donn\u00e9es, il y a la fonction d\u2019agr\u00e9gation sur Power Query. D\u00e9couvrez comment l\u2019utiliser.\" \/>\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\/agregation-power-query\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Agr\u00e9gation sur Power Query : comment \u00e7a marche ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/agregation-power-query\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-19T06:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-15T14:10:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/Agregation-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=\"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\/agregation-power-query\",\"url\":\"https:\/\/datascientest.com\/agregation-power-query\",\"name\":\"Agr\u00e9gation sur Power Query : comment \u00e7a marche ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-12-19T06:30:00+00:00\",\"dateModified\":\"2023-12-15T14:10:55+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"Pour regrouper et r\u00e9sumer des donn\u00e9es, il y a la fonction d\u2019agr\u00e9gation sur Power Query. D\u00e9couvrez comment l\u2019utiliser.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/agregation-power-query\"]}]},{\"@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":"Agr\u00e9gation sur Power Query : comment \u00e7a marche ?","description":"Pour regrouper et r\u00e9sumer des donn\u00e9es, il y a la fonction d\u2019agr\u00e9gation sur Power Query. D\u00e9couvrez comment l\u2019utiliser.","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\/agregation-power-query","og_locale":"fr_FR","og_type":"article","og_title":"Agr\u00e9gation sur Power Query : comment \u00e7a marche ?","og_url":"https:\/\/datascientest.com\/agregation-power-query","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-12-19T06:30:00+00:00","article_modified_time":"2023-12-15T14:10:55+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/Agregation-Power-Query.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\/agregation-power-query","url":"https:\/\/datascientest.com\/agregation-power-query","name":"Agr\u00e9gation sur Power Query : comment \u00e7a marche ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-12-19T06:30:00+00:00","dateModified":"2023-12-15T14:10:55+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"Pour regrouper et r\u00e9sumer des donn\u00e9es, il y a la fonction d\u2019agr\u00e9gation sur Power Query. D\u00e9couvrez comment l\u2019utiliser.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/agregation-power-query"]}]},{"@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\/218369"}],"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=218369"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/218369\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/218378"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=218369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=218369"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=218369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}