{"id":3145,"date":"2024-02-01T19:24:08","date_gmt":"2024-02-01T18:24:08","guid":{"rendered":"https:\/\/newdatalabs.com\/en\/?page_id=3145"},"modified":"2024-02-01T19:39:12","modified_gmt":"2024-02-01T18:39:12","slug":"power-bi-online-course-agenda","status":"publish","type":"page","link":"https:\/\/newdatalabs.com\/en\/power-bi-online-course-agenda\/","title":{"rendered":"Power BI\u00a0online course – Agenda"},"content":{"rendered":"\n

DAY 1<\/strong> <\/p>\n\n\n\n

INTRODUCTION TO POWER BI <\/p>\n\n\n\n

1. Entry <\/strong><\/p>\n\n\n\n

\n

Overview of the training agenda <\/p>\n\n\n\n

Presentation and discussion of target reports created during the training <\/p>\n<\/div>\n\n\n\n

<\/p>\n\n\n\n

2. Data sources <\/strong><\/p>\n\n\n\n

\n

Overview of the types of connections to data sources <\/p>\n\n\n\n

Connection to the first data sources <\/p>\n<\/div>\n\n\n\n

<\/p>\n\n\n\n

3. Modeling in PowerQuery <\/strong><\/p>\n\n\n\n

\n

Filtration <\/p>\n\n\n\n

Transforming data <\/p>\n\n\n\n

Changing the data source <\/p>\n\n\n\n

Calendar in SQL\/PowerQuery\/DAX <\/p>\n<\/div>\n\n\n\n

<\/p>\n\n\n\n

4. Building the first report <\/strong><\/p>\n\n\n\n

\n

Discussion of the functionalities available in PowerBI Desktop <\/p>\n\n\n\n

Basic objects to be used in PBI \u2013 filters, column chart, ribbon chart, line chart, map, card and matrix <\/p>\n\n\n\n

Discussion of relationships between graphs – interactions <\/p>\n\n\n\n

Quick measures <\/p>\n\n\n\n

Styles and Template <\/p>\n<\/div>\n\n\n\n

<\/p>\n\n\n\n

DAY 2 <\/strong><\/p>\n\n\n\n

REPORTS \u2013 what and how does it work? <\/p>\n\n\n\n

1. Introduction <\/strong><\/p>\n\n\n\n

\n

Summary of day one <\/p>\n\n\n\n

Work plan for the second day <\/p>\n\n\n\n

Where to look for materials for development in the Power BI area <\/p>\n<\/div>\n\n\n\n

<\/p>\n\n\n\n

2. Power BI Services <\/strong><\/p>\n\n\n\n

\n

The report and its functionalities from the PBI <\/p>\n\n\n\n

Services level <\/p>\n\n\n\n

Dashboards <\/p>\n\n\n\n

Apps <\/p>\n\n\n\n

Workspaces <\/p>\n<\/div>\n\n\n\n

<\/p>\n\n\n\n

3. Navigating the report <\/strong><\/p>\n\n\n\n

\n

Dynamic buttons in Power BI <\/p>\n\n\n\n

Publication of the report <\/p>\n\n\n\n

Power BI Mobile <\/p>\n<\/div>\n\n\n\n

<\/p>\n\n\n\n

4. Extensive visualizations <\/strong><\/p>\n\n\n\n

\n

Conditional formatting <\/p>\n\n\n\n

Parameters <\/p>\n\n\n\n

Switching within a report <\/p>\n\n\n\n

Filter synchronization between sites <\/p>\n\n\n\n

Small multiples <\/p>\n\n\n\n

Unichar <\/p>\n\n\n\n

Target <\/p>\n\n\n\n

Mother <\/p>\n\n\n\n

Speedometer <\/p>\n\n\n\n

Drill down to detail <\/p>\n\n\n\n

RLS permissions <\/p>\n<\/div>\n\n\n\n

<\/p>\n\n\n\n

DAY 3 <\/strong><\/p>\n\n\n\n

DAX CALCULATIONS AND ADVANCED VISUALIZATIONS <\/p>\n\n\n\n

<\/p>\n\n\n\n

1. DAX calculations <\/strong><\/p>\n\n\n\n

\n

Basics of creating calculations \u2013 SUM, MIN, MAX, AVERAGE, SUMX, AVERAGEX, IF, HASONEVALUE <\/p>\n\n\n\n

CALCULATE function as the main calculation engine \u2013 CALCULATE, USERELAIONSHIP, ALL SWITCH and PARAMETERS as functions that determine and improve the quality and readability of visualization – VAR, change of measure\/dimension from the selector, automatic color dependency <\/p>\n\n\n\n

Building tables using DAX queries, transforming the table using the example of time – CALENDAR, DATE, YEAR, MONTH, DAY, WEEKDAY, WEEKNUMBER, FORMAT, TODAY, NOW, LEFT, RIGHT, MID <\/p>\n\n\n\n

Time operations, comparison between periods \u2013 TOTALYTD, SAMPLEPERIODLASTYEAR, DATEADD (optional) TopN with a parameter changed from the report level \u2013 TOPN, SELECTEDVALUE, KEEPFILTERS, CALCULATETABLE, ALLSELECTED, VALUES <\/p>\n<\/div>\n\n\n\n

<\/p>\n\n\n\n

2. Advanced visualizations <\/strong><\/p>\n\n\n\n

\n

Bullet Chart <\/p>\n\n\n\n

Lollipop Chart <\/p>\n\n\n\n

Others depending on remaining time<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

DAY 1 INTRODUCTION TO POWER BI 1. Entry Overview of the training agenda Presentation and discussion of target reports created during the training 2. Data sources Overview of the types of connections to data sources Connection to the first data sources 3. Modeling in PowerQuery Filtration Transforming data Changing the data source Calendar in SQL\/PowerQuery\/DAX […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"class_list":{"0":"post-3145","1":"page","2":"type-page","3":"status-publish","5":"entry"},"yoast_head":"\nPower BI\u00a0online course - Agenda - NewDataLabs<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/newdatalabs.com\/en\/power-bi-online-course-agenda\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI\u00a0online course - Agenda - NewDataLabs\" \/>\n<meta property=\"og:description\" content=\"DAY 1 INTRODUCTION TO POWER BI 1. Entry Overview of the training agenda Presentation and discussion of target reports created during the training 2. Data sources Overview of the types of connections to data sources Connection to the first data sources 3. Modeling in PowerQuery Filtration Transforming data Changing the data source Calendar in SQL\/PowerQuery\/DAX […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/newdatalabs.com\/en\/power-bi-online-course-agenda\/\" \/>\n<meta property=\"og:site_name\" content=\"NewDataLabs\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-01T18:39:12+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\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:\/\/newdatalabs.com\/en\/power-bi-online-course-agenda\/\",\"url\":\"https:\/\/newdatalabs.com\/en\/power-bi-online-course-agenda\/\",\"name\":\"Power BI\u00a0online course - Agenda - NewDataLabs\",\"isPartOf\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/#website\"},\"datePublished\":\"2024-02-01T18:24:08+00:00\",\"dateModified\":\"2024-02-01T18:39:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/power-bi-online-course-agenda\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/newdatalabs.com\/en\/power-bi-online-course-agenda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/newdatalabs.com\/en\/power-bi-online-course-agenda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Strona g\u0142\u00f3wna\",\"item\":\"https:\/\/newdatalabs.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI\u00a0online course – Agenda\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/newdatalabs.com\/en\/#website\",\"url\":\"https:\/\/newdatalabs.com\/en\/\",\"name\":\"NewDataLabs\",\"description\":\"Tableau - Business Intelligence Tools\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/newdatalabs.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power BI\u00a0online course - Agenda - NewDataLabs","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:\/\/newdatalabs.com\/en\/power-bi-online-course-agenda\/","og_locale":"en_US","og_type":"article","og_title":"Power BI\u00a0online course - Agenda - NewDataLabs","og_description":"DAY 1 INTRODUCTION TO POWER BI 1. Entry Overview of the training agenda Presentation and discussion of target reports created during the training 2. Data sources Overview of the types of connections to data sources Connection to the first data sources 3. Modeling in PowerQuery Filtration Transforming data Changing the data source Calendar in SQL\/PowerQuery\/DAX […]","og_url":"https:\/\/newdatalabs.com\/en\/power-bi-online-course-agenda\/","og_site_name":"NewDataLabs","article_modified_time":"2024-02-01T18:39:12+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/newdatalabs.com\/en\/power-bi-online-course-agenda\/","url":"https:\/\/newdatalabs.com\/en\/power-bi-online-course-agenda\/","name":"Power BI\u00a0online course - Agenda - NewDataLabs","isPartOf":{"@id":"https:\/\/newdatalabs.com\/en\/#website"},"datePublished":"2024-02-01T18:24:08+00:00","dateModified":"2024-02-01T18:39:12+00:00","breadcrumb":{"@id":"https:\/\/newdatalabs.com\/en\/power-bi-online-course-agenda\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/newdatalabs.com\/en\/power-bi-online-course-agenda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/newdatalabs.com\/en\/power-bi-online-course-agenda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Strona g\u0142\u00f3wna","item":"https:\/\/newdatalabs.com\/en\/"},{"@type":"ListItem","position":2,"name":"Power BI\u00a0online course – Agenda"}]},{"@type":"WebSite","@id":"https:\/\/newdatalabs.com\/en\/#website","url":"https:\/\/newdatalabs.com\/en\/","name":"NewDataLabs","description":"Tableau - Business Intelligence Tools","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/newdatalabs.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/pages\/3145","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/comments?post=3145"}],"version-history":[{"count":8,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/pages\/3145\/revisions"}],"predecessor-version":[{"id":3159,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/pages\/3145\/revisions\/3159"}],"wp:attachment":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/media?parent=3145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}