{"id":353,"date":"2021-01-02T11:19:07","date_gmt":"2021-01-02T07:19:07","guid":{"rendered":"https:\/\/dbformation.tech\/?p=353"},"modified":"2021-11-25T16:52:26","modified_gmt":"2021-11-25T12:52:26","slug":"power-query-transformer-des-donnees","status":"publish","type":"post","link":"https:\/\/dbformation.tech\/2021\/01\/02\/power-query-transformer-des-donnees\/","title":{"rendered":"Power Query : Transformer des donn\u00e9es"},"content":{"rendered":"\n<p class=\"has-drop-cap wp-block-paragraph\">Power Query est un \u00e9diteur de requ\u00eates int\u00e9gr\u00e9 \u00e0 MS Excel. Depuis le ruban <strong>Donn\u00e9es<\/strong>, il suffit de cliquer sur un des outils du groupe <strong>R\u00e9cup\u00e9rer et transformer des donn\u00e9es<\/strong> pour lancer l&rsquo;\u00e9diteur.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00c9conome en ressources machine, Power Query facilite l&rsquo;exploitation de grands tableaux (big data) car :<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>seules les donn\u00e9es strictement n\u00e9cessaires \u00e0 votre analyse sont employ\u00e9es,<\/li><li>les formules sont remplac\u00e9es par les valeurs calcul\u00e9es brutes<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Quand vous importez des donn\u00e9es avec Power Query, une requ\u00eate est lanc\u00e9e pour interroger la source des donn\u00e9es.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Vous pouvez <span style=\"text-decoration: underline;\">personnaliser cette requ\u00eate <\/span> en transformant les donn\u00e9es.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">La vid\u00e9o suivante vous montre, tour \u00e0 tour, quelques exemples de transformation:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Permuter, fusionner et supprimer des colonnes<\/li><li>Extraire les ann\u00e9es d&rsquo;un champs date<\/li><li>Filtrer des donn\u00e9es<\/li><li>Ajouter une colonne calcul\u00e9e<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-vimeo wp-block-embed-vimeo wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Power Query: transformer des donn\u00e9es\" src=\"https:\/\/player.vimeo.com\/video\/649936531?dnt=1&amp;app_id=122963\" width=\"525\" height=\"279\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write\"><\/iframe>\n<\/div><figcaption>Interroger une base Excel avec Power Query <\/figcaption><\/figure>\n\n\n\n<div class=\"wp-block-file\"><a href=\"https:\/\/dbformation.tech\/wp-content\/uploads\/2021\/01\/base_PELIKAN-2.xlsx\">Fichier li\u00e9 : base_PELIKAN-2<\/a><a href=\"https:\/\/dbformation.tech\/wp-content\/uploads\/2021\/01\/base_PELIKAN-2.xlsx\" class=\"wp-block-file__button\" download>T\u00e9l\u00e9charger<\/a><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>Une fois le fichier t\u00e9l\u00e9charg\u00e9, commencer l&rsquo;exercice \u00e0 partir d&rsquo;un classeur vierge.<\/li><li>L&rsquo;exemple reproduit, enregistrer votre classeur sous le nom <strong>Analyse_revenus<\/strong>.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Power Query est un \u00e9diteur de requ\u00eates int\u00e9gr\u00e9 \u00e0 MS Excel. Depuis le ruban Donn\u00e9es, il suffit de cliquer sur un des outils du groupe R\u00e9cup\u00e9rer et transformer des donn\u00e9es pour lancer l&rsquo;\u00e9diteur. \u00c9conome en ressources machine, Power Query facilite l&rsquo;exploitation de grands tableaux (big data) car : seules les donn\u00e9es strictement n\u00e9cessaires \u00e0 votre &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/dbformation.tech\/2021\/01\/02\/power-query-transformer-des-donnees\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de &laquo;&nbsp;Power Query : Transformer des donn\u00e9es&nbsp;&raquo;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[5,50],"tags":[46,7,49,48,38],"class_list":["post-353","post","type-post","status-publish","format-standard","hentry","category-excel","category-power-query","tag-colonne-calculee","tag-excel","tag-gif","tag-power-query","tag-requete"],"_links":{"self":[{"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/posts\/353","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/comments?post=353"}],"version-history":[{"count":12,"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/posts\/353\/revisions"}],"predecessor-version":[{"id":2019,"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/posts\/353\/revisions\/2019"}],"wp:attachment":[{"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/media?parent=353"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/categories?post=353"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/tags?post=353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}