{"id":1500,"date":"2025-03-17T12:08:38","date_gmt":"2025-03-17T16:08:38","guid":{"rendered":"https:\/\/damicrosolutions.com\/?post_type=special-course&#038;p=1500"},"modified":"2025-03-28T17:22:36","modified_gmt":"2025-03-28T21:22:36","slug":"excel-bi-power-query","status":"publish","type":"special-course","link":"https:\/\/damicrosolutions.com\/fr\/special-course\/excel-bi-power-query\/","title":{"rendered":"Excel BI \u2013 Power Query"},"content":{"rendered":"<h5 class=\"wp-block-heading has-ast-global-color-1-color has-text-color has-link-color wp-elements-5b7a5a2b65d962cd15d985b77c25609f\">Aper\u00e7u du cours<\/h5>\n\n\n\n<p id=\"block-45986751-c8b1-4a0c-8648-7fe7c5580009\">Lib\u00e9rez la puissance de <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/bi-capabilities-in-excel-and-office-365-26c0548e-124c-4fd3-aab3-5f64568cb743\">Excel BI<\/a> et <a href=\"https:\/\/learn.microsoft.com\/en-us\/power-query\/power-query-what-is-power-query\">Requ\u00eate de puissance<\/a> Avec ce cours approfondi, con\u00e7u pour les professionnels souhaitant ma\u00eetriser l&#039;extraction, la transformation et l&#039;automatisation des donn\u00e9es, ce cours, ax\u00e9 sur des applications concr\u00e8tes, aborde les techniques essentielles pour g\u00e9rer et analyser efficacement les donn\u00e9es.<\/p>\n\n\n\n<h5 class=\"wp-block-heading has-ast-global-color-1-color has-text-color has-link-color wp-elements-b2abec2309e1a75a6bb86f48fb290190\">Points forts du cours<\/h5>\n\n\n\n<ul class=\"wp-block-list is-style-checkbox\">\n<li style=\"padding-top:4px\"><strong>Principes fondamentaux de Power Query<\/strong> \u2013 Comprendre ce qu&#039;est Power Query, pourquoi il est essentiel et son r\u00f4le dans les processus ETL (Extraction, Transformation, Chargement).<\/li>\n\n\n\n<li style=\"padding-top:4px\"><strong>Connexion aux sources de donn\u00e9es<\/strong> \u2013 Cr\u00e9ez et g\u00e9rez des requ\u00eates \u00e0 partir de fichiers Excel (locaux et distants), de bases de donn\u00e9es (Access, SQL), de fichiers PDF, de fichiers CSV et d\u2019ensembles de donn\u00e9es Web.<\/li>\n\n\n\n<li style=\"padding-top:4px\"><strong>Nettoyage et transformation des donn\u00e9es<\/strong> \u2013 Supprimez les doublons, divisez\/fusionnez les colonnes, g\u00e9rez les valeurs manquantes, appliquez des transformations personnalis\u00e9es et utilisez des tables de recherche.<\/li>\n\n\n\n<li style=\"padding-top:4px\"><strong>\u00c9tablir des relations entre les donn\u00e9es<\/strong> \u2013 Travaillez avec des tables de jonction, des cl\u00e9s primaires\/\u00e9trang\u00e8res et mod\u00e9lisez des relations de donn\u00e9es complexes pour des rapports am\u00e9lior\u00e9s.<\/li>\n\n\n\n<li style=\"padding-top:4px\"><strong>Op\u00e9rations de requ\u00eate avanc\u00e9es<\/strong> \u2013 Fusionnez et ajoutez des requ\u00eates, automatisez la consolidation des donn\u00e9es et \u00e9liminez le besoin de RECHERCHEV avec les relations Power Query.<\/li>\n\n\n\n<li style=\"padding-top:4px\"><strong>Pivoter et r\u00e9sumer les donn\u00e9es<\/strong> \u2013 Cr\u00e9ez des rapports de tableau crois\u00e9 dynamique, annulez le pivotement des champs et regroupez les donn\u00e9es pour une meilleure analyse.<\/li>\n\n\n\n<li style=\"padding-top:4px\"><strong>Techniques avanc\u00e9es<\/strong> \u2013 Explorez le <strong>Langue M<\/strong>, cr\u00e9ez des fonctions personnalis\u00e9es, automatisez les flux de travail et int\u00e9grez des ensembles de donn\u00e9es JSON\/XML.<\/li>\n<\/ul>\n\n\n\n<p>Ce cours est id\u00e9al pour les analystes commerciaux, les comptables et les professionnels des donn\u00e9es qui souhaitent am\u00e9liorer l&#039;efficacit\u00e9 de la gestion et du reporting des donn\u00e9es avec Excel BI et Power Query. Il aborde plus sp\u00e9cifiquement les rapports financiers, les grands ensembles de donn\u00e9es et les transformations complexes. En acqu\u00e9rant ces comp\u00e9tences, vous rationaliserez vos flux de travail et prendrez de meilleures d\u00e9cisions.<\/p>\n\n\n\n<div class=\"gb-element-8615d25f\">\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped has-lightbox wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-full\" style=\"margin-right:0;margin-left:0\"><img data-dominant-color=\"ecebe7\" data-has-transparency=\"true\" style=\"--dominant-color: #ecebe7;\" loading=\"lazy\" decoding=\"async\" width=\"1680\" height=\"960\" data-id=\"1482\" src=\"https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/power-query-basics.png.webp\" alt=\"\" class=\"wp-image-1482 has-transparency\" srcset=\"https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/power-query-basics.png.webp 1680w, https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/power-query-basics.png-300x171.webp 300w, https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/power-query-basics.png-1024x585.webp 1024w, https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/power-query-basics.png-768x439.webp 768w, https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/power-query-basics.png-1536x878.webp 1536w, https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/power-query-basics.png-18x10.webp 18w\" sizes=\"auto, (max-width: 1680px) 100vw, 1680px\" \/><\/figure>\n<\/figure>\n<\/div>\n\n\n\n<div class=\"gb-element-f46974a2\">\n<a class=\"gb-text gb-text-524d6629\" href=\"https:\/\/damicrosolutions.com\/contact-us\/\" target=\"_blank\" rel=\"noopener\">En savoir plus sur ce cours<\/a>\n<\/div>","protected":false},"featured_media":1883,"parent":0,"template":"","meta":{"_acf_changed":false,"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"pgc_sgb_lightbox_settings":""},"class_list":["post-1500","special-course","type-special-course","status-publish","has-post-thumbnail","hentry"],"mb":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel BI - Power Query &#8211; Damicro Inc.<\/title>\n<meta name=\"description\" content=\"Learn how to use Excel BI and Power Query to extract, clean, transform, and automate data from multiple sources, improving efficiency.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/damicrosolutions.com\/fr\/special-course\/excel-bi-power-query\/\" \/>\n<meta property=\"og:locale\" content=\"fr_CA\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel BI - Power Query &#8211; Damicro Inc.\" \/>\n<meta property=\"og:description\" content=\"Learn how to use Excel BI and Power Query to extract, clean, transform, and automate data from multiple sources, improving efficiency.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/damicrosolutions.com\/fr\/special-course\/excel-bi-power-query\/\" \/>\n<meta property=\"og:site_name\" content=\"Damicro Inc.\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/damicrosolutions\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-28T21:22:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/Damicro-courses-rs.png\" \/>\n\t<meta property=\"og:image:width\" content=\"665\" \/>\n\t<meta property=\"og:image:height\" content=\"375\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimation du temps de lecture\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-bi-power-query\\\/\",\"url\":\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-bi-power-query\\\/\",\"name\":\"Excel BI - Power Query &#8211; Damicro Inc.\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-bi-power-query\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-bi-power-query\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/damicrosolutions.com\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/Damicro-courses-rs.png\",\"datePublished\":\"2025-03-17T16:08:38+00:00\",\"dateModified\":\"2025-03-28T21:22:36+00:00\",\"description\":\"Learn how to use Excel BI and Power Query to extract, clean, transform, and automate data from multiple sources, improving efficiency.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-bi-power-query\\\/#breadcrumb\"},\"inLanguage\":\"fr-CA\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-bi-power-query\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-CA\",\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-bi-power-query\\\/#primaryimage\",\"url\":\"https:\\\/\\\/damicrosolutions.com\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/Damicro-courses-rs.png\",\"contentUrl\":\"https:\\\/\\\/damicrosolutions.com\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/Damicro-courses-rs.png\",\"width\":665,\"height\":375},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-bi-power-query\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/damicrosolutions.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel BI &#8211; Power Query\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/#website\",\"url\":\"https:\\\/\\\/damicrosolutions.com\\\/\",\"name\":\"Damicro Solutions\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/damicrosolutions.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-CA\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/#organization\",\"name\":\"Damicro Inc.\",\"url\":\"https:\\\/\\\/damicrosolutions.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-CA\",\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/damicrosolutions.com\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/cropped-logo-removebg-1-1.png\",\"contentUrl\":\"https:\\\/\\\/damicrosolutions.com\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/cropped-logo-removebg-1-1.png\",\"width\":512,\"height\":512,\"caption\":\"Damicro Inc.\"},\"image\":{\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/damicrosolutions\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/damicrosolutions\\\/\",\"https:\\\/\\\/www.youtube.com\\\/@damicrosolutions\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel BI - Power Query &#8211; Damicro Inc.","description":"Learn how to use Excel BI and Power Query to extract, clean, transform, and automate data from multiple sources, improving efficiency.","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:\/\/damicrosolutions.com\/fr\/special-course\/excel-bi-power-query\/","og_locale":"fr_CA","og_type":"article","og_title":"Excel BI - Power Query &#8211; Damicro Inc.","og_description":"Learn how to use Excel BI and Power Query to extract, clean, transform, and automate data from multiple sources, improving efficiency.","og_url":"https:\/\/damicrosolutions.com\/fr\/special-course\/excel-bi-power-query\/","og_site_name":"Damicro Inc.","article_publisher":"https:\/\/www.facebook.com\/damicrosolutions","article_modified_time":"2025-03-28T21:22:36+00:00","og_image":[{"width":665,"height":375,"url":"https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/Damicro-courses-rs.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Estimation du temps de lecture":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/damicrosolutions.com\/special-course\/excel-bi-power-query\/","url":"https:\/\/damicrosolutions.com\/special-course\/excel-bi-power-query\/","name":"Excel BI - Power Query &#8211; Damicro Inc.","isPartOf":{"@id":"https:\/\/damicrosolutions.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/damicrosolutions.com\/special-course\/excel-bi-power-query\/#primaryimage"},"image":{"@id":"https:\/\/damicrosolutions.com\/special-course\/excel-bi-power-query\/#primaryimage"},"thumbnailUrl":"https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/Damicro-courses-rs.png","datePublished":"2025-03-17T16:08:38+00:00","dateModified":"2025-03-28T21:22:36+00:00","description":"Learn how to use Excel BI and Power Query to extract, clean, transform, and automate data from multiple sources, improving efficiency.","breadcrumb":{"@id":"https:\/\/damicrosolutions.com\/special-course\/excel-bi-power-query\/#breadcrumb"},"inLanguage":"fr-CA","potentialAction":[{"@type":"ReadAction","target":["https:\/\/damicrosolutions.com\/special-course\/excel-bi-power-query\/"]}]},{"@type":"ImageObject","inLanguage":"fr-CA","@id":"https:\/\/damicrosolutions.com\/special-course\/excel-bi-power-query\/#primaryimage","url":"https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/Damicro-courses-rs.png","contentUrl":"https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/Damicro-courses-rs.png","width":665,"height":375},{"@type":"BreadcrumbList","@id":"https:\/\/damicrosolutions.com\/special-course\/excel-bi-power-query\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/damicrosolutions.com\/"},{"@type":"ListItem","position":2,"name":"Excel BI &#8211; Power Query"}]},{"@type":"WebSite","@id":"https:\/\/damicrosolutions.com\/#website","url":"https:\/\/damicrosolutions.com\/","name":"Damicro Solutions","description":"","publisher":{"@id":"https:\/\/damicrosolutions.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/damicrosolutions.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-CA"},{"@type":"Organization","@id":"https:\/\/damicrosolutions.com\/#organization","name":"Damicro Inc.","url":"https:\/\/damicrosolutions.com\/","logo":{"@type":"ImageObject","inLanguage":"fr-CA","@id":"https:\/\/damicrosolutions.com\/#\/schema\/logo\/image\/","url":"https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/cropped-logo-removebg-1-1.png","contentUrl":"https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/cropped-logo-removebg-1-1.png","width":512,"height":512,"caption":"Damicro Inc."},"image":{"@id":"https:\/\/damicrosolutions.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/damicrosolutions","https:\/\/www.linkedin.com\/in\/damicrosolutions\/","https:\/\/www.youtube.com\/@damicrosolutions"]}]}},"mfb_rest_fields":["title","yoast_head","yoast_head_json"],"_links":{"self":[{"href":"https:\/\/damicrosolutions.com\/fr\/wp-json\/wp\/v2\/special-course\/1500","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/damicrosolutions.com\/fr\/wp-json\/wp\/v2\/special-course"}],"about":[{"href":"https:\/\/damicrosolutions.com\/fr\/wp-json\/wp\/v2\/types\/special-course"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/damicrosolutions.com\/fr\/wp-json\/wp\/v2\/media\/1883"}],"wp:attachment":[{"href":"https:\/\/damicrosolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=1500"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}