{"id":1502,"date":"2025-03-17T12:42:32","date_gmt":"2025-03-17T16:42:32","guid":{"rendered":"https:\/\/damicrosolutions.com\/?post_type=special-course&#038;p=1502"},"modified":"2025-03-28T17:22:55","modified_gmt":"2025-03-28T21:22:55","slug":"excel-power-pivot","status":"publish","type":"special-course","link":"https:\/\/damicrosolutions.com\/fr\/special-course\/excel-power-pivot\/","title":{"rendered":"Excel Power Pivot"},"content":{"rendered":"<h5 class=\"wp-block-heading has-ast-global-color-1-color has-text-color has-link-color wp-elements-98d13375a5a0a04ac0d8b62609c84612\" id=\"block-5c76e4f4-6fc1-44cd-815e-66ddd68a1a10\">Aper\u00e7u du cours<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Ce cours est con\u00e7u pour les professionnels souhaitant approfondir leurs connaissances en mati\u00e8re de mod\u00e9lisation de donn\u00e9es dans Excel \u00e0 l&#039;aide de <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/power-pivot-overview-and-learning-f9001958-7901-4caa-ad80-028a6d2432ed\">Pivot de puissance<\/a>Vous apprendrez \u00e0 g\u00e9rer et mod\u00e9liser les donn\u00e9es pour am\u00e9liorer la prise de d\u00e9cision et le reporting. Ce cours aborde les concepts de base de donn\u00e9es, les relations et les techniques avanc\u00e9es de mod\u00e9lisation de donn\u00e9es avec Power Pivot. Il inclut \u00e9galement l&#039;utilisation des fonctions DAX pour des calculs et des mesures personnalis\u00e9s.<\/p>\n\n\n\n<h5 class=\"wp-block-heading has-ast-global-color-1-color has-text-color has-link-color wp-elements-6db8581d0c9c1ef12c9099a58eb7db3d\"><strong>Key Topics<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list is-style-checkbox\">\n<li style=\"padding-top:4px\"><strong>Principes fondamentaux de la mod\u00e9lisation des donn\u00e9es<\/strong> \u2013 Apprenez les techniques avanc\u00e9es de nommage de plage, les concepts et les directives des bases de donn\u00e9es. Comprenez la normalisation des bases de donn\u00e9es et les relations entre les tables.<\/li>\n\n\n\n<li style=\"padding-top:4px\"><strong>Normalisation et relations des bases de donn\u00e9es<\/strong> \u2013 Apprenez \u00e0 normaliser les donn\u00e9es, \u00e0 \u00e9tablir des relations avec des cl\u00e9s \u00e9trang\u00e8res et primaires et \u00e0 travailler avec des tables de jonction, de recherche et de r\u00e9sum\u00e9.<\/li>\n\n\n\n<li style=\"padding-top:4px\"><strong>Configuration et mod\u00e9lisation de Power Pivot<\/strong> \u2013 Ma\u00eetrisez le module compl\u00e9mentaire Power Pivot COM. Apprenez \u00e0 importer et \u00e0 lier des tables de base de donn\u00e9es Excel. Cr\u00e9ez des colonnes calcul\u00e9es et des mesures. Utilisez la vue Diagramme Power Pivot pour lier des tables et finaliser votre mod\u00e8le.<\/li>\n\n\n\n<li style=\"padding-top:4px\"><strong>Cr\u00e9ation d&#039;un mod\u00e8le \u00e0 partir d&#039;un classeur distant<\/strong> \u2013 Utilisez l&#039;Assistant Services de connexion \u00e0 distance pour vous connecter \u00e0 des donn\u00e9es externes. Int\u00e9grez des tables de bases de donn\u00e9es locales et distantes. Cr\u00e9ez des relations, des colonnes calcul\u00e9es et des tableaux crois\u00e9s dynamiques.<\/li>\n\n\n\n<li style=\"padding-top:4px\"><strong>Fonctionnalit\u00e9s avanc\u00e9es de Power Pivot<\/strong> \u2013 Explorez les fonctionnalit\u00e9s avanc\u00e9es de Power Pivot. Apprenez \u00e0 cr\u00e9er des mod\u00e8les avec des tables principales et li\u00e9es. Cr\u00e9ez des champs calcul\u00e9s et des mesures avec DAX. Comprendre les fonctions logiques, textuelles, de date et statistiques.<\/li>\n\n\n\n<li style=\"padding-top:4px\"><strong>Liaison \u00e0 des bases de donn\u00e9es distantes<\/strong> \u2013 Reliez des tables \u00e0 Power Pivot \u00e0 partir de bases de donn\u00e9es comme Access, SQL et ASCII. Filtrez les donn\u00e9es, d\u00e9finissez des relations et cr\u00e9ez des tableaux crois\u00e9s dynamiques et des graphiques pour l&#039;analyse.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Ce cours est id\u00e9al pour les analystes commerciaux, les comptables et les professionnels des donn\u00e9es qui souhaitent exploiter toute la puissance de Power Pivot pour la mod\u00e9lisation et le reporting avanc\u00e9s des donn\u00e9es dans Excel. \u00c0 l&#039;issue de ce cours, vous ma\u00eetriserez les comp\u00e9tences n\u00e9cessaires pour g\u00e9rer et mod\u00e9liser efficacement vos donn\u00e9es avec Power Pivot, am\u00e9liorant ainsi l&#039;efficacit\u00e9 de vos rapports et analyses.<\/p>\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-1502","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.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel Power Pivot &#8211; Damicro Inc.<\/title>\n<meta name=\"description\" content=\"Learn data modeling in Excel using Power Pivot to build relationships and perform advanced calculations with DAX for improved analysis.\" \/>\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-power-pivot\/\" \/>\n<meta property=\"og:locale\" content=\"fr_CA\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Power Pivot &#8211; Damicro Inc.\" \/>\n<meta property=\"og:description\" content=\"Learn data modeling in Excel using Power Pivot to build relationships and perform advanced calculations with DAX for improved analysis.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/damicrosolutions.com\/fr\/special-course\/excel-power-pivot\/\" \/>\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:55+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-power-pivot\\\/\",\"url\":\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-power-pivot\\\/\",\"name\":\"Excel Power Pivot &#8211; Damicro Inc.\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-power-pivot\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-power-pivot\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/damicrosolutions.com\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/Damicro-courses-rs.png\",\"datePublished\":\"2025-03-17T16:42:32+00:00\",\"dateModified\":\"2025-03-28T21:22:55+00:00\",\"description\":\"Learn data modeling in Excel using Power Pivot to build relationships and perform advanced calculations with DAX for improved analysis.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-power-pivot\\\/#breadcrumb\"},\"inLanguage\":\"fr-CA\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-power-pivot\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-CA\",\"@id\":\"https:\\\/\\\/damicrosolutions.com\\\/special-course\\\/excel-power-pivot\\\/#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-power-pivot\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/damicrosolutions.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Power Pivot\"}]},{\"@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 Pivot &#8211; Damicro Inc.","description":"Learn data modeling in Excel using Power Pivot to build relationships and perform advanced calculations with DAX for improved analysis.","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-power-pivot\/","og_locale":"fr_CA","og_type":"article","og_title":"Excel Power Pivot &#8211; Damicro Inc.","og_description":"Learn data modeling in Excel using Power Pivot to build relationships and perform advanced calculations with DAX for improved analysis.","og_url":"https:\/\/damicrosolutions.com\/fr\/special-course\/excel-power-pivot\/","og_site_name":"Damicro Inc.","article_publisher":"https:\/\/www.facebook.com\/damicrosolutions","article_modified_time":"2025-03-28T21:22:55+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-power-pivot\/","url":"https:\/\/damicrosolutions.com\/special-course\/excel-power-pivot\/","name":"Excel Power Pivot &#8211; Damicro Inc.","isPartOf":{"@id":"https:\/\/damicrosolutions.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/damicrosolutions.com\/special-course\/excel-power-pivot\/#primaryimage"},"image":{"@id":"https:\/\/damicrosolutions.com\/special-course\/excel-power-pivot\/#primaryimage"},"thumbnailUrl":"https:\/\/damicrosolutions.com\/wp-content\/uploads\/2025\/03\/Damicro-courses-rs.png","datePublished":"2025-03-17T16:42:32+00:00","dateModified":"2025-03-28T21:22:55+00:00","description":"Learn data modeling in Excel using Power Pivot to build relationships and perform advanced calculations with DAX for improved analysis.","breadcrumb":{"@id":"https:\/\/damicrosolutions.com\/special-course\/excel-power-pivot\/#breadcrumb"},"inLanguage":"fr-CA","potentialAction":[{"@type":"ReadAction","target":["https:\/\/damicrosolutions.com\/special-course\/excel-power-pivot\/"]}]},{"@type":"ImageObject","inLanguage":"fr-CA","@id":"https:\/\/damicrosolutions.com\/special-course\/excel-power-pivot\/#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-power-pivot\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/damicrosolutions.com\/"},{"@type":"ListItem","position":2,"name":"Excel Power Pivot"}]},{"@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\/1502","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=1502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}