{"id":6582,"date":"2026-03-16T16:07:01","date_gmt":"2026-03-16T15:07:01","guid":{"rendered":"https:\/\/controlc.fr\/?post_type=lp_course&p=6582"},"modified":"2026-03-16T16:17:13","modified_gmt":"2026-03-16T15:17:13","slug":"power-bi","status":"publish","type":"lp_course","link":"https:\/\/controlc.fr\/index.php\/courses\/power-bi\/","title":{"rendered":"POWER BI"},"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

Programme<\/h2>

Introduction<\/strong><\/p>

D\u00e9couverte de l\u2019offre BI propos\u00e9e par Microsoft.<\/p>

Exploration de la suite Power BI : Power BI Desktop, le service en ligne Power BI et les applications mobiles Power BI.<\/p>

Introduction \u00e0 l\u2019\u00e9diteur Power Query.<\/p>

Acquisition des donn\u00e9es<\/strong><\/p>

Importer, transformer et charger des informations dans Power BI<\/p>

Exploiter diff\u00e9rentes sources : fichiers plats, Excel, bases relationnelles, sources SSAS, donn\u00e9es issues du web<\/p>

S\u00e9lectionner les colonnes et lignes pertinentes, appliquer des filtres, trier et \u00e9liminer les doublons.<\/p>

Transformation des donn\u00e9es<\/strong><\/p>

Nettoyer et enrichir les ensembles de donn\u00e9es<\/p>

D\u00e9couper les colonnes, appliquer des formats et d\u00e9finir les types de donn\u00e9es, combiner et fusionner des tables<\/p>

Cr\u00e9er des colonnes calcul\u00e9es<\/p>

Empiler et combiner des requ\u00eates<\/p>

Mod\u00e9lisation des donn\u00e9es<\/strong><\/p>

Exploiter la vue Diagramme pour \u00e9tablir des relations entre les tables<\/p>

Construire des mesures en utilisant des fonctions statistiques<\/p>

Utiliser les fonctions DAX pour concevoir des mesures avanc\u00e9es : CALCULATE, ALL, ALLEXCEPT, FILTER, RANKX, etc.<\/p>

Mettre en \u0153uvre les fonctions DAX de type Time Intelligence<\/p>

Conception de rapports Power BI<\/strong><\/p>

Cr\u00e9er des rapports, des pages et des tableaux de bord<\/p>

Repr\u00e9senter les donn\u00e9es sous forme de Table, Matrice ou Carte<\/p>

Exploiter les param\u00e8tres de donn\u00e9es et de mise en forme<\/p>

Ajouter des visuels, utiliser les cartes g\u00e9ographiques.<\/p>

Importer des visuels personnalis\u00e9s (.pbviz) depuis la galerie : jauges, images, etc.<\/p>

Int\u00e9grer des filtres, segments et KPI. Adapter la mise en page pour ordinateur ou mobile<\/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":"

\u00c9tablir des connexions, explorer et combiner des sources de donn\u00e9es vari\u00e9es
\nD\u00e9finir des mesures gr\u00e2ce au langage DAX
\nExplorer les fonctionnalit\u00e9s offertes par Power BI Online
\nStructurer et pr\u00e9parer les ensembles de donn\u00e9es
\nConcevoir et mettre en forme des rapports avec Power BI Desktop<\/p>\n","protected":false},"author":6,"featured_media":6592,"comment_status":"closed","ping_status":"closed","template":"","course_category":[37,10,35],"course_tag":[],"class_list":["post-6582","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category-base-de-donnees","course_category-bureautique","course_category-outils-collaboratifs","course"],"yoast_head":"\nPOWER BI -<\/title>\n<meta name=\"description\" content=\"Programme de la formation sur le reporting gr\u00e2ce \u00e0 power BI fin 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-bi\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"POWER BI -\" \/>\n<meta property=\"og:description\" content=\"Programme de la formation sur le reporting gr\u00e2ce \u00e0 power BI fin 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-bi\/\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-16T15:17:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/controlc.fr\/wp-content\/uploads\/2026\/03\/icons8-power-bi-64-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"64\" \/>\n\t<meta property=\"og:image:height\" content=\"64\" \/>\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-bi\/\",\"url\":\"https:\/\/controlc.fr\/index.php\/courses\/power-bi\/\",\"name\":\"POWER BI -\",\"isPartOf\":{\"@id\":\"https:\/\/controlc.fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2026\/03\/icons8-power-bi-64-1.png\",\"datePublished\":\"2026-03-16T15:07:01+00:00\",\"dateModified\":\"2026-03-16T15:17:13+00:00\",\"description\":\"Programme de la formation sur le reporting gr\u00e2ce \u00e0 power BI fin de g\u00e9rer des donn\u00e9es de sources volumineuses et \u00e9tablir des tableaux de bord.\",\"breadcrumb\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/power-bi\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/controlc.fr\/index.php\/courses\/power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/power-bi\/#primaryimage\",\"url\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2026\/03\/icons8-power-bi-64-1.png\",\"contentUrl\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2026\/03\/icons8-power-bi-64-1.png\",\"width\":64,\"height\":64},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/power-bi\/#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 BI\"}]},{\"@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 BI -","description":"Programme de la formation sur le reporting gr\u00e2ce \u00e0 power BI fin 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-bi\/","og_locale":"fr_FR","og_type":"article","og_title":"POWER BI -","og_description":"Programme de la formation sur le reporting gr\u00e2ce \u00e0 power BI fin de g\u00e9rer des donn\u00e9es de sources volumineuses et \u00e9tablir des tableaux de bord.","og_url":"https:\/\/controlc.fr\/index.php\/courses\/power-bi\/","article_modified_time":"2026-03-16T15:17:13+00:00","og_image":[{"width":64,"height":64,"url":"https:\/\/controlc.fr\/wp-content\/uploads\/2026\/03\/icons8-power-bi-64-1.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-bi\/","url":"https:\/\/controlc.fr\/index.php\/courses\/power-bi\/","name":"POWER BI -","isPartOf":{"@id":"https:\/\/controlc.fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/power-bi\/#primaryimage"},"image":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/controlc.fr\/wp-content\/uploads\/2026\/03\/icons8-power-bi-64-1.png","datePublished":"2026-03-16T15:07:01+00:00","dateModified":"2026-03-16T15:17:13+00:00","description":"Programme de la formation sur le reporting gr\u00e2ce \u00e0 power BI fin de g\u00e9rer des donn\u00e9es de sources volumineuses et \u00e9tablir des tableaux de bord.","breadcrumb":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/power-bi\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/controlc.fr\/index.php\/courses\/power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/controlc.fr\/index.php\/courses\/power-bi\/#primaryimage","url":"https:\/\/controlc.fr\/wp-content\/uploads\/2026\/03\/icons8-power-bi-64-1.png","contentUrl":"https:\/\/controlc.fr\/wp-content\/uploads\/2026\/03\/icons8-power-bi-64-1.png","width":64,"height":64},{"@type":"BreadcrumbList","@id":"https:\/\/controlc.fr\/index.php\/courses\/power-bi\/#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 BI"}]},{"@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\/6582","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=6582"}],"version-history":[{"count":5,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/6582\/revisions"}],"predecessor-version":[{"id":6589,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/6582\/revisions\/6589"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/media\/6592"}],"wp:attachment":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/media?parent=6582"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/course_category?post=6582"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/course_tag?post=6582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}