{"id":895,"date":"2024-01-26T10:49:06","date_gmt":"2024-01-26T09:49:06","guid":{"rendered":"https:\/\/wordpress.givigroup.net\/nl\/?page_id=895"},"modified":"2025-06-02T13:15:38","modified_gmt":"2025-06-02T13:15:38","slug":"power-bi-data-analyse-en-rapportage","status":"publish","type":"page","link":"https:\/\/wordpress.givigroup.net\/nl\/power-bi-data-analyse-en-rapportage\/","title":{"rendered":"Power BI: Data-analyse &amp; rapportage"},"content":{"rendered":"\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-layout-1 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h3 class=\"wp-block-heading has-text-color has-link-color has-large-font-size wp-elements-3d5c2c9911bd884a8d4f4028657381a8\" style=\"color:#ff6633\">Cre\u00eber dynamische &amp; visueel aantrekkelijke rapporten\/dashboards!<\/h3>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-alpha-channel-opacity has-background\" style=\"background-color:#ff6633;color:#ff6633\"\/>\n<\/div>\n<\/div>\n\n\n\n<p>Op het einde van deze training is de cursist in staat om grote hoeveelheden aan data om te zetten in dynamische rapporten. In deze rapporten zal er gebruik gemaakt worden van verschillende soorten visualisaties. Men leert eveneens om deze rapporten te publiceren en naderhand verschillende elementen van rapporten te combineren in dashboards. Deze training is bedoeld voor mensen die gegevens visueel aantrekkelijk willen kunnen voorstellen. Er wordt verwacht dat de deelnemers een goede kennis van Excel hebben.<\/p>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-layout-2 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:50px\"><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-ea360a1a88bcea869583f375dd20fd89\" style=\"color:#ff6633\"><span style=\"text-decoration: underline\">Inhoud<\/span><\/h2>\n\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ul>\n<li><strong>Power BI kennismaking<\/strong>\n<ul>\n<li>Onderdelen en schermelementen<\/li>\n\n\n\n<li>Wat is de link met de Excel BI onderdelen?<\/li>\n\n\n\n<li>Wat kost Power BI? Licenties?<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Data ophalen en transformeren<\/strong>\n<ul>\n<li>Data importeren vanuit verschillende databronnen<\/li>\n\n\n\n<li>Data transformeren d.m.v. verschillende PowerQuery-technieken<\/li>\n\n\n\n<li>Verschillende bestanden uit \u00e9\u00e9n folder tot \u00e9\u00e9n tabel samenvoegen<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Data modeling<\/strong>\n<ul>\n<li>Relaties beheren<\/li>\n\n\n\n<li>Aangepaste sorteringen instellen<\/li>\n\n\n\n<li>Data categorie\u00ebn instellen<\/li>\n\n\n\n<li>Standaardberekeningen instellen per veld<\/li>\n\n\n\n<li>(Hulp)kolommen\/ hulp tabellen verbergen<\/li>\n\n\n\n<li>Aanmaken van datumtabel<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>DAX-berekeningen<\/strong>\n<ul>\n<li>Calculated columns  VS Measures<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Rapporteren<\/strong>\n<ul>\n<li>Onderdelen van een rapport<\/li>\n\n\n\n<li>Standaardvisualisaties alsook extra visualisaties downloaden<\/li>\n\n\n\n<li>Visualisatietechnieken (Drill down, drill through, tooltip, &#8230;)<\/li>\n\n\n\n<li>Eigenschappen van visualisaties (Opmaak, conditional formatting)<\/li>\n\n\n\n<li>Filtermogelijkheden<\/li>\n\n\n\n<li>Thema&#8217;s<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Power BI Service<\/strong>\n<ul>\n<li>Rapport publiceren<\/li>\n\n\n\n<li>Wat is een workspace<\/li>\n\n\n\n<li>Rapport VS Dashboard<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Extra topics<\/strong>\n<ul>\n<li>Parameters in PowerQuery<\/li>\n\n\n\n<li>Extra PowerQuery technieken<\/li>\n\n\n\n<li>Datumtabel maken in DAX<\/li>\n\n\n\n<li>Extra DAX-functies<\/li>\n\n\n\n<li>Time intelligence &amp; DAX<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-top is-layout-flow wp-block-column-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-thumbnail\"><img decoding=\"async\" src=\"https:\/\/wordpress.givigroup.net\/nl\/wp-content\/uploads\/2024\/01\/power-bi-icon-150x150.png\" alt=\"\" class=\"wp-image-607\" style=\"object-fit:cover\"\/><figcaption class=\"wp-element-caption\"><em><a href=\"https:\/\/wordpress.givigroup.net\/nl\/power-bi-opleidingen\/\">Beschikbare data<\/a><\/em><\/figcaption><\/figure><\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Cre\u00eber dynamische &amp; visueel aantrekkelijke rapporten\/dashboards! Op het einde van deze training is de cursist in staat om grote hoeveelheden aan data om te zetten in dynamische rapporten. In deze rapporten zal er gebruik gemaakt worden van verschillende soorten visualisaties. Men leert eveneens om deze rapporten te publiceren en naderhand verschillende elementen van rapporten te [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/wordpress.givigroup.net\/nl\/wp-json\/wp\/v2\/pages\/895"}],"collection":[{"href":"https:\/\/wordpress.givigroup.net\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/wordpress.givigroup.net\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.givigroup.net\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.givigroup.net\/nl\/wp-json\/wp\/v2\/comments?post=895"}],"version-history":[{"count":10,"href":"https:\/\/wordpress.givigroup.net\/nl\/wp-json\/wp\/v2\/pages\/895\/revisions"}],"predecessor-version":[{"id":2147,"href":"https:\/\/wordpress.givigroup.net\/nl\/wp-json\/wp\/v2\/pages\/895\/revisions\/2147"}],"wp:attachment":[{"href":"https:\/\/wordpress.givigroup.net\/nl\/wp-json\/wp\/v2\/media?parent=895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}