{"id":1003,"date":"2021-04-05T12:01:06","date_gmt":"2021-04-05T08:01:06","guid":{"rendered":"https:\/\/dbformation.tech\/?p=1003"},"modified":"2021-11-08T12:54:22","modified_gmt":"2021-11-08T08:54:22","slug":"power-query-creer-des-tables-de-fait-et-de-dimension","status":"publish","type":"post","link":"https:\/\/dbformation.tech\/2021\/04\/05\/power-query-creer-des-tables-de-fait-et-de-dimension\/","title":{"rendered":"Power Query: Cr\u00e9er des tables de fait et de dimension"},"content":{"rendered":"\n<p class=\"has-drop-cap wp-block-paragraph\">Cette vid\u00e9o montre comment utiliser Power Query pour transformer un tableau en tables de fait et de dimension. Une \u00e9tape n\u00e9cessaire avant la mod\u00e9lisation en sch\u00e9ma \u00e9toile qui pourra \u00eatre op\u00e9r\u00e9e depuis Power Pivot.<\/p>\n\n\n\n<div style=\"height:12px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><span style=\"text-decoration: underline;\">Une fois la vid\u00e9o visionn\u00e9e vous saurez comment:<\/span><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Dupliquer\/renommer une table<\/li><li>Fractionner\/renommer une colonne<\/li><li>Supprimer des doublons<\/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:  tables de fait et de dimension\" src=\"https:\/\/player.vimeo.com\/video\/643404303?dnt=1&amp;app_id=122963\" width=\"525\" height=\"295\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write\"><\/iframe>\n<\/div><figcaption>Transformer une table en table de fait et dimension <\/figcaption><\/figure>\n\n\n\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-file\"><a href=\"https:\/\/dbformation.tech\/wp-content\/uploads\/2021\/04\/USINOR-OI-POWER-QWERY.xlsx\">USINOR-OI-POWER-QWERY<\/a><a href=\"https:\/\/dbformation.tech\/wp-content\/uploads\/2021\/04\/USINOR-OI-POWER-QWERY.xlsx\" class=\"wp-block-file__button\" download>T\u00e9l\u00e9charger la table de donn\u00e9es<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Cette vid\u00e9o montre comment utiliser Power Query pour transformer un tableau en tables de fait et de dimension. Une \u00e9tape n\u00e9cessaire avant la mod\u00e9lisation en sch\u00e9ma \u00e9toile qui pourra \u00eatre op\u00e9r\u00e9e depuis Power Pivot. Une fois la vid\u00e9o visionn\u00e9e vous saurez comment: Dupliquer\/renommer une table Fractionner\/renommer une colonne Supprimer des doublons<\/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,57],"tags":[7,48],"class_list":["post-1003","post","type-post","status-publish","format-standard","hentry","category-excel","category-power-query","category-table-de-donnees","tag-excel","tag-power-query"],"_links":{"self":[{"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/posts\/1003","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=1003"}],"version-history":[{"count":4,"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/posts\/1003\/revisions"}],"predecessor-version":[{"id":1895,"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/posts\/1003\/revisions\/1895"}],"wp:attachment":[{"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/media?parent=1003"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/categories?post=1003"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbformation.tech\/wp-json\/wp\/v2\/tags?post=1003"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}