{"id":5351,"date":"2024-04-22T12:46:05","date_gmt":"2024-04-22T10:46:05","guid":{"rendered":"https:\/\/controlc.fr\/?post_type=lp_course&p=5351"},"modified":"2025-12-02T17:12:42","modified_gmt":"2025-12-02T16:12:42","slug":"power-pivot-excel","status":"publish","type":"lp_course","link":"https:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/","title":{"rendered":"POWER PIVOT EXCEL"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

\u00a0Programme<\/h2>

Introduction et installation<\/strong>
Installation et Pr\u00e9sentation g\u00e9n\u00e9rale de Power Pivot
R\u00f4le et int\u00e9r\u00eat de Power Pivot dans le processus d’informatique d\u00e9cisionnelle (BI) pour r\u00e9pondre aux
limites d\u2019Excel
R\u00e9partition des t\u00e2ches entre Power Pivot, PowerQuery et Excel\u00a0
Acc\u00e9der au cube Power Pivot et pr\u00e9sentation de son interface<\/p>

Charger et pr\u00e9parer les donn\u00e9es sources dans le <\/strong>mod\u00e8le relationnel<\/strong>
A partir de fichiers (Excel, csv\u2026)
A partir de bases de donn\u00e9es (Access\u2026)
A partir de Power Query
A partir d’autres sources
Cr\u00e9er son mod\u00e8le de donn\u00e9es en \u00e9tablissant des relations et int\u00e9r\u00eat du mod\u00e8le de donn\u00e9es
Vue diagramme et vue donn\u00e9es
La d\u00e9marche du sch\u00e9ma en \u00e9toile
Mettre \u00e0 jour les donn\u00e9es<\/p>

Analyser les donn\u00e9es dans Power Pivot<\/strong>
Trier et filtrer un jeu de donn\u00e9e
Renommer des champs<\/p>

DAX, le langage pour interroger les donn\u00e9es<\/strong>
Cr\u00e9er des colonnes calcul\u00e9es
Cr\u00e9er des mesures (implicites, explicites)
Fonctions incontournables : RELATED, IF, SWITCH
Fonctions d’agr\u00e9gation : SUM, AVERAGE, COUNTA,
DISTINCTCOUNT<\/p>

Exploitation des donn\u00e9es de Power Pivot dans Excel<\/strong>
Utiliser les tableaux et graphiques crois\u00e9s dynamiques bas\u00e9s sur le mod\u00e8le Power Pivot pour cr\u00e9er des
rapports et tableaux de bord
Filtrer les donn\u00e9es \u00e0 l’aide des segments et chronologies
Ajouter, g\u00e9rer des mesures, des indicateurs de performance (KPI) directement \u00e0 partir d’Excel<\/p>

Moyens techniques mis \u00e0 disposition<\/strong>
Supports d\u2019animation p\u00e9dagogique utilis\u00e9s en vid\u00e9oprojection. 1 PC\/stagiaire \u00e9quip\u00e9 du(es) logiciel(s) pr\u00e9vu(s), connexion Wifi, imprimante multifonctions.
Installations dans notre centre de formation : salles de formation \u00e9quip\u00e9es de tables, chaises, mur clair pour la projection, paperboard et\/ou tableau blanc ou num\u00e9rique interactif.
En cas de formation intra-entreprise, des installations
\u00e9quivalentes doivent \u00eatre mises \u00e0 disposition par l\u2019employeur des stagiaires<\/p><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tLa fiche formation<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tNos tarifs<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tLe planning<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

\u00a0Programme Introduction et installationInstallation et Pr\u00e9sentation g\u00e9n\u00e9rale de Power PivotR\u00f4le et int\u00e9r\u00eat de Power Pivot dans le processus d’informatique d\u00e9cisionnelle (BI) pour r\u00e9pondre aux limites d\u2019ExcelR\u00e9partition des t\u00e2ches entre Power Pivot, PowerQuery et Excel\u00a0Acc\u00e9der au cube Power Pivot et pr\u00e9sentation de son interface Charger et pr\u00e9parer les donn\u00e9es sources dans…<\/p>\n","protected":false},"author":6,"featured_media":6001,"comment_status":"closed","ping_status":"closed","template":"","course_category":[10,36],"course_tag":[],"class_list":["post-5351","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category-bureautique","course_category-tableur-excel-et-calc","course"],"yoast_head":"\nPOWER PIVOT EXCEL -<\/title>\n<meta name=\"description\" content=\"Programme de la formation d'une journ\u00e9e sur Power Pivot afin de g\u00e9rer des donn\u00e9es de sources volumineuses et \u00e9tablir des tableaux de bord\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"POWER PIVOT EXCEL -\" \/>\n<meta property=\"og:description\" content=\"Programme de la formation d'une journ\u00e9e sur Power Pivot afin de g\u00e9rer des donn\u00e9es de sources volumineuses et \u00e9tablir des tableaux de bord\" \/>\n<meta property=\"og:url\" content=\"https:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-02T16:12:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@controlcmelun\" \/>\n<meta name=\"twitter:label1\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\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:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/\",\"url\":\"https:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/\",\"name\":\"POWER PIVOT EXCEL -\",\"isPartOf\":{\"@id\":\"https:\/\/controlc.fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png\",\"datePublished\":\"2024-04-22T10:46:05+00:00\",\"dateModified\":\"2025-12-02T16:12:42+00:00\",\"description\":\"Programme de la formation d'une journ\u00e9e sur Power Pivot afin de g\u00e9rer des donn\u00e9es de sources volumineuses et \u00e9tablir des tableaux de bord\",\"breadcrumb\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/#primaryimage\",\"url\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png\",\"contentUrl\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png\",\"width\":200,\"height\":200,\"caption\":\"Microsoft Excel 2019 ic\u00f4ne par Icons8\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/controlc.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cours\",\"item\":\"https:\/\/controlc.fr\/index.php\/cours-2\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"POWER PIVOT EXCEL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/controlc.fr\/#website\",\"url\":\"https:\/\/controlc.fr\/\",\"name\":\"Controlc.fr\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/controlc.fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/controlc.fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/controlc.fr\/#organization\",\"name\":\"Control^C\",\"url\":\"https:\/\/controlc.fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/controlc.fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2020\/12\/cropped-cropped-cropped-logo-melun.png\",\"contentUrl\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2020\/12\/cropped-cropped-cropped-logo-melun.png\",\"width\":427,\"height\":100,\"caption\":\"Control^C\"},\"image\":{\"@id\":\"https:\/\/controlc.fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/controlcmelun\",\"https:\/\/www.linkedin.com\/company\/8009384\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"POWER PIVOT EXCEL -","description":"Programme de la formation d'une journ\u00e9e sur Power Pivot afin de g\u00e9rer des donn\u00e9es de sources volumineuses et \u00e9tablir des tableaux de bord","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:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/","og_locale":"fr_FR","og_type":"article","og_title":"POWER PIVOT EXCEL -","og_description":"Programme de la formation d'une journ\u00e9e sur Power Pivot afin de g\u00e9rer des donn\u00e9es de sources volumineuses et \u00e9tablir des tableaux de bord","og_url":"https:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/","article_modified_time":"2025-12-02T16:12:42+00:00","og_image":[{"width":200,"height":200,"url":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@controlcmelun","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/","url":"https:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/","name":"POWER PIVOT EXCEL -","isPartOf":{"@id":"https:\/\/controlc.fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/#primaryimage"},"image":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png","datePublished":"2024-04-22T10:46:05+00:00","dateModified":"2025-12-02T16:12:42+00:00","description":"Programme de la formation d'une journ\u00e9e sur Power Pivot afin de g\u00e9rer des donn\u00e9es de sources volumineuses et \u00e9tablir des tableaux de bord","breadcrumb":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/#primaryimage","url":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png","contentUrl":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png","width":200,"height":200,"caption":"Microsoft Excel 2019 ic\u00f4ne par Icons8"},{"@type":"BreadcrumbList","@id":"https:\/\/controlc.fr\/index.php\/courses\/power-pivot-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/controlc.fr\/"},{"@type":"ListItem","position":2,"name":"Cours","item":"https:\/\/controlc.fr\/index.php\/cours-2\/"},{"@type":"ListItem","position":3,"name":"POWER PIVOT EXCEL"}]},{"@type":"WebSite","@id":"https:\/\/controlc.fr\/#website","url":"https:\/\/controlc.fr\/","name":"Controlc.fr","description":"","publisher":{"@id":"https:\/\/controlc.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/controlc.fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/controlc.fr\/#organization","name":"Control^C","url":"https:\/\/controlc.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/controlc.fr\/#\/schema\/logo\/image\/","url":"https:\/\/controlc.fr\/wp-content\/uploads\/2020\/12\/cropped-cropped-cropped-logo-melun.png","contentUrl":"https:\/\/controlc.fr\/wp-content\/uploads\/2020\/12\/cropped-cropped-cropped-logo-melun.png","width":427,"height":100,"caption":"Control^C"},"image":{"@id":"https:\/\/controlc.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/controlcmelun","https:\/\/www.linkedin.com\/company\/8009384"]}]}},"_links":{"self":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/5351","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course"}],"about":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/types\/lp_course"}],"author":[{"embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/comments?post=5351"}],"version-history":[{"count":18,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/5351\/revisions"}],"predecessor-version":[{"id":6470,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/5351\/revisions\/6470"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/media\/6001"}],"wp:attachment":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/media?parent=5351"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/course_category?post=5351"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/course_tag?post=5351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}