{"id":335,"date":"2025-02-12T19:51:41","date_gmt":"2025-02-12T19:51:41","guid":{"rendered":"https:\/\/dbi.403.myftpupload.com\/?post_type=course&p=335"},"modified":"2025-03-28T17:51:19","modified_gmt":"2025-03-28T21:51:19","slug":"excel-power-bi","status":"publish","type":"course","link":"https:\/\/damicrosolutions.com\/fr\/course\/excel-power-bi\/","title":{"rendered":"Excel Power BI"},"content":{"rendered":"
Aper\u00e7u du cours<\/h5>\n\n\n\n

Cette formation Power BI Excel de deux jours se concentre sur l'utilisation de Power Query (PQ) dans Excel pour transformer et nettoyer les donn\u00e9es, cr\u00e9er des mod\u00e8les de donn\u00e9es et cr\u00e9er des rapports et tableaux de bord interactifs. Les participants acquerront une exp\u00e9rience pratique de la connexion \u00e0 diverses sources de donn\u00e9es, telles que des classeurs distants, des fichiers texte, des donn\u00e9es web et plusieurs feuilles et classeurs. La formation aborde les fonctionnalit\u00e9s essentielles de Power Query, telles que le fractionnement des colonnes, la suppression des doublons, le filtrage des donn\u00e9es, l'ajout de colonnes personnalis\u00e9es et l'application de transformations pour nettoyer et structurer les donn\u00e9es. De plus, les participants apprendront \u00e0 cr\u00e9er des relations entre les tables, \u00e0 ajouter des donn\u00e9es, \u00e0 fusionner des requ\u00eates et \u00e0 cr\u00e9er des requ\u00eates de base gr\u00e2ce \u00e0 la fonction \u00ab\u00a0Grouper par\u00a0\u00bb.<\/p>\n\n\n\n

La formation pr\u00e9sente \u00e9galement aux participants les concepts de tables de faits et de dimensions, de cl\u00e9s primaires et \u00e9trang\u00e8res, ainsi que les techniques de mod\u00e9lisation des donn\u00e9es. Un \u00e9l\u00e9ment cl\u00e9 de la formation est la cr\u00e9ation de tableaux de bord interactifs avec Power BI, notamment la cr\u00e9ation de tableaux crois\u00e9s dynamiques, l'application de filtres et l'int\u00e9gration d'Excel \u00e0 Power BI pour la cr\u00e9ation de rapports. Si le temps le permet, les participants exploreront des fonctionnalit\u00e9s avanc\u00e9es comme la technologie de reconnaissance d'images pour convertir une image en jeu de donn\u00e9es. \u00c0 l'issue de la formation, les participants seront capables de se connecter aux donn\u00e9es, de les nettoyer et de les transformer, d'\u00e9tablir des relations et de cr\u00e9er des rapports et des tableaux de bord interactifs et pertinents avec Power Query et Power BI dans Excel.<\/p>\n\n\n\n

\nEn savoir plus sur ce cours<\/a>\n<\/div>","protected":false},"featured_media":1883,"parent":0,"template":"","meta":{"_acf_changed":true,"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","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":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","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-335","course","type-course","status-publish","has-post-thumbnail","hentry"],"mb":[],"acf":[],"yoast_head":"\nExcel Power BI – Damicro Inc.<\/title>\n<meta name=\"description\" content=\"Learn how to create interactive dashboards using Power BI, build Pivot Tables, apply slicers for filtering and integrate Excel with Power BI.\" \/>\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\/course\/excel-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"fr_CA\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Power BI – Damicro Inc.\" \/>\n<meta property=\"og:description\" content=\"Learn how to create interactive dashboards using Power BI, build Pivot Tables, apply slicers for filtering and integrate Excel with Power BI.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/damicrosolutions.com\/fr\/course\/excel-power-bi\/\" \/>\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:51:19+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\\\/course\\\/excel-power-bi\\\/\",\"url\":\"https:\\\/\\\/damicrosolutions.com\\\/course\\\/excel-power-bi\\\/\",\"name\":\"Excel Power BI – Damicro Inc.\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/course\\\/excel-power-bi\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/course\\\/excel-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/damicrosolutions.com\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/Damicro-courses-rs.png\",\"datePublished\":\"2025-02-12T19:51:41+00:00\",\"dateModified\":\"2025-03-28T21:51:19+00:00\",\"description\":\"Learn how to create interactive dashboards using Power BI, build Pivot Tables, apply slicers for filtering and integrate Excel with Power BI.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/course\\\/excel-power-bi\\\/#breadcrumb\"},\"inLanguage\":\"fr-CA\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/damicrosolutions.com\\\/course\\\/excel-power-bi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-CA\",\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/course\\\/excel-power-bi\\\/#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\\\/course\\\/excel-power-bi\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/damicrosolutions.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Power BI\"}]},{\"@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 Power BI – Damicro Inc.","description":"Learn how to create interactive dashboards using Power BI, build Pivot Tables, apply slicers for filtering and integrate Excel with Power BI.","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\/course\/excel-power-bi\/","og_locale":"fr_CA","og_type":"article","og_title":"Excel Power BI – Damicro Inc.","og_description":"Learn how to create interactive dashboards using Power BI, build Pivot Tables, apply slicers for filtering and integrate Excel with Power BI.","og_url":"https:\/\/damicrosolutions.com\/fr\/course\/excel-power-bi\/","og_site_name":"Damicro Inc.","article_publisher":"https:\/\/www.facebook.com\/damicrosolutions","article_modified_time":"2025-03-28T21:51:19+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\/course\/excel-power-bi\/","url":"https:\/\/damicrosolutions.com\/course\/excel-power-bi\/","name":"Excel Power BI – Damicro Inc.","isPartOf":{"@id":"https:\/\/damicrosolutions.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/damicrosolutions.com\/course\/excel-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/damicrosolutions.com\/course\/excel-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/Damicro-courses-rs.png","datePublished":"2025-02-12T19:51:41+00:00","dateModified":"2025-03-28T21:51:19+00:00","description":"Learn how to create interactive dashboards using Power BI, build Pivot Tables, apply slicers for filtering and integrate Excel with Power BI.","breadcrumb":{"@id":"https:\/\/damicrosolutions.com\/course\/excel-power-bi\/#breadcrumb"},"inLanguage":"fr-CA","potentialAction":[{"@type":"ReadAction","target":["https:\/\/damicrosolutions.com\/course\/excel-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"fr-CA","@id":"https:\/\/damicrosolutions.com\/course\/excel-power-bi\/#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\/course\/excel-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/damicrosolutions.com\/"},{"@type":"ListItem","position":2,"name":"Excel Power BI"}]},{"@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\/course\/335","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/damicrosolutions.com\/fr\/wp-json\/wp\/v2\/course"}],"about":[{"href":"https:\/\/damicrosolutions.com\/fr\/wp-json\/wp\/v2\/types\/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=335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}