{"id":20242,"date":"2024-11-19T09:35:29","date_gmt":"2024-11-19T08:35:29","guid":{"rendered":"https:\/\/middleweb.ovh\/asfo_2024\/formation\/excel-power-bi-desktop\/"},"modified":"2025-02-21T08:56:50","modified_gmt":"2025-02-21T07:56:50","slug":"excel-power-bi-desktop","status":"publish","type":"formation","link":"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-bi-desktop\/","title":{"rendered":"Power BI Desktop"},"content":{"rendered":"<h3>Nature de l&rsquo;action<\/h3>\n<p>Action d&rsquo;acquisition, d&rsquo;entretien ou de perfectionnement des connaissances.<\/p>\n<h3>Personnel concern\u00e9<\/h3>\n<p>Tout utilisateur du logiciel EXCEL<\/p>\n<h3>Pr\u00e9-requis<\/h3>\n<p>Connaissance des bases d&rsquo;EXCEL, des tableaux et des tableaux crois\u00e9s dynamiques.<\/p>\n<h3>Objectifs p\u00e9dagogiques<\/h3>\n<p>\u00catre capable de :<\/p>\n<ul>\n<li>Comprendre l&rsquo;offre BI de Microsoft<\/li>\n<li>Prendre en main de Microsoft Power BI<\/li>\n<li>Mettre en \u0153uvre la connexion aux donn\u00e9es, la transformation des donn\u00e9es, la restitution<\/li>\n<li>Cr\u00e9er et publier des rapports<\/li>\n<\/ul>\n<h3><strong>Programme<\/strong><\/h3>\n<p><strong>PRISE EN MAIN DE POWER BI DESKTOP<\/strong><\/p>\n<ul>\n<li>Pr\u00e9sentation de Power BI Desktop<\/li>\n<li>D\u00e9couverte de l&rsquo;interface<\/li>\n<li>Les modules de Power BI Desktop<\/li>\n<\/ul>\n<p><strong>IMPORTER DES DONN\u00c9ES<\/strong><\/p>\n<ul>\n<li>Connexion aux donn\u00e9es depuis Power BI Desktop<\/li>\n<li>Nettoyage et transformation des donn\u00e9es<\/li>\n<li>Traitement des donn\u00e9es<\/li>\n<\/ul>\n<p><strong>MOD\u00c9LISATION<\/strong><\/p>\n<ul>\n<li>Mod\u00e8le de donn\u00e9es et relations entre les donn\u00e9es<\/li>\n<li>Cr\u00e9ation de colonnes calcul\u00e9es<\/li>\n<li>Optimisation du mod\u00e8le de donn\u00e9es<\/li>\n<li>Cr\u00e9ation des mesures<\/li>\n<li>Cas de donn\u00e9es temporelles<\/li>\n<li>Cr\u00e9ation de tables calcul\u00e9es<\/li>\n<\/ul>\n<p><strong>CR\u00c9ATION DES RESTITUTIONS<\/strong><\/p>\n<ul>\n<li>Cr\u00e9ation d&rsquo;une restitution simple<\/li>\n<li>Graphiques combin\u00e9s<\/li>\n<li>Utilisation des segments<\/li>\n<li>Utilisation des cartes<\/li>\n<li>Tables et matrices<\/li>\n<li>Nuage de points<\/li>\n<li>Graphiques avanc\u00e9s<\/li>\n<li>Jauges<\/li>\n<li>Gestion des couleurs<\/li>\n<li>Am\u00e9liorer la mise en forme<\/li>\n<li>Cr\u00e9ation d&rsquo;interactions entre visualisations<\/li>\n<li>G\u00e9rer les donn\u00e9es manquantes<\/li>\n<li>G\u00e9rer des hi\u00e9rarchies visuelles<\/li>\n<\/ul>\n","protected":false},"featured_media":0,"parent":0,"template":"","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categorie-formation":[192],"etiquette-formation":[],"types-formation":[],"class_list":["post-20242","formation","type-formation","status-publish","hentry","categorie-formation-informatique-bureautique"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Power BI Desktop - ASFO Pyr\u00e9n\u00e9es<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI Desktop - ASFO Pyr\u00e9n\u00e9es\" \/>\n<meta property=\"og:description\" content=\"Nature de l&rsquo;action Action d&rsquo;acquisition, d&rsquo;entretien ou de perfectionnement des connaissances. Personnel concern\u00e9 Tout utilisateur du logiciel EXCEL [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-bi-desktop\/\" \/>\n<meta property=\"og:site_name\" content=\"ASFO Pyr\u00e9n\u00e9es\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-21T07:56:50+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-bi-desktop\/\",\"url\":\"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-bi-desktop\/\",\"name\":\"Power BI Desktop - ASFO Pyr\u00e9n\u00e9es\",\"isPartOf\":{\"@id\":\"https:\/\/middleweb.ovh\/asfo_2024\/#website\"},\"datePublished\":\"2024-11-19T08:35:29+00:00\",\"dateModified\":\"2025-02-21T07:56:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-bi-desktop\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-bi-desktop\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-bi-desktop\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/middleweb.ovh\/asfo_2024\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Formations\",\"item\":\"https:\/\/middleweb.ovh\/asfo_2024\/formations\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Power BI Desktop\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/middleweb.ovh\/asfo_2024\/#website\",\"url\":\"https:\/\/middleweb.ovh\/asfo_2024\/\",\"name\":\"ASFO Pyr\u00e9n\u00e9es\",\"description\":\"Centre de formation\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/middleweb.ovh\/asfo_2024\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power BI Desktop - ASFO Pyr\u00e9n\u00e9es","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"fr_FR","og_type":"article","og_title":"Power BI Desktop - ASFO Pyr\u00e9n\u00e9es","og_description":"Nature de l&rsquo;action Action d&rsquo;acquisition, d&rsquo;entretien ou de perfectionnement des connaissances. Personnel concern\u00e9 Tout utilisateur du logiciel EXCEL [&hellip;]","og_url":"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-bi-desktop\/","og_site_name":"ASFO Pyr\u00e9n\u00e9es","article_modified_time":"2025-02-21T07:56:50+00:00","twitter_card":"summary_large_image","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-bi-desktop\/","url":"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-bi-desktop\/","name":"Power BI Desktop - ASFO Pyr\u00e9n\u00e9es","isPartOf":{"@id":"https:\/\/middleweb.ovh\/asfo_2024\/#website"},"datePublished":"2024-11-19T08:35:29+00:00","dateModified":"2025-02-21T07:56:50+00:00","breadcrumb":{"@id":"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-bi-desktop\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-bi-desktop\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/middleweb.ovh\/asfo_2024\/formations\/gestion-administrative-et-commerciale\/excel-power-bi-desktop\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/middleweb.ovh\/asfo_2024\/"},{"@type":"ListItem","position":2,"name":"Formations","item":"https:\/\/middleweb.ovh\/asfo_2024\/formations\/"},{"@type":"ListItem","position":3,"name":"Power BI Desktop"}]},{"@type":"WebSite","@id":"https:\/\/middleweb.ovh\/asfo_2024\/#website","url":"https:\/\/middleweb.ovh\/asfo_2024\/","name":"ASFO Pyr\u00e9n\u00e9es","description":"Centre de formation","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/middleweb.ovh\/asfo_2024\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"}]}},"_links":{"self":[{"href":"https:\/\/middleweb.ovh\/asfo_2024\/wp-json\/wp\/v2\/formation\/20242","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/middleweb.ovh\/asfo_2024\/wp-json\/wp\/v2\/formation"}],"about":[{"href":"https:\/\/middleweb.ovh\/asfo_2024\/wp-json\/wp\/v2\/types\/formation"}],"version-history":[{"count":3,"href":"https:\/\/middleweb.ovh\/asfo_2024\/wp-json\/wp\/v2\/formation\/20242\/revisions"}],"predecessor-version":[{"id":27527,"href":"https:\/\/middleweb.ovh\/asfo_2024\/wp-json\/wp\/v2\/formation\/20242\/revisions\/27527"}],"wp:attachment":[{"href":"https:\/\/middleweb.ovh\/asfo_2024\/wp-json\/wp\/v2\/media?parent=20242"}],"wp:term":[{"taxonomy":"categorie-formation","embeddable":true,"href":"https:\/\/middleweb.ovh\/asfo_2024\/wp-json\/wp\/v2\/categorie-formation?post=20242"},{"taxonomy":"etiquette-formation","embeddable":true,"href":"https:\/\/middleweb.ovh\/asfo_2024\/wp-json\/wp\/v2\/etiquette-formation?post=20242"},{"taxonomy":"types-formation","embeddable":true,"href":"https:\/\/middleweb.ovh\/asfo_2024\/wp-json\/wp\/v2\/types-formation?post=20242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}