Power BI online course – Agenda

Overview of the training agenda

Presentation and discussion of target reports created during the training

Overview of the types of connections to data sources

Connection to the first data sources

Filtration

Transforming data

Changing the data source

Calendar in SQL/PowerQuery/DAX

Discussion of the functionalities available in PowerBI Desktop

Basic objects to be used in PBI – filters, column chart, ribbon chart, line chart, map, card and matrix

Discussion of relationships between graphs – interactions

Quick measures

Styles and Template

Summary of day one

Work plan for the second day

Where to look for materials for development in the Power BI area

The report and its functionalities from the PBI

Services level

Dashboards

Apps

Workspaces

Dynamic buttons in Power BI

Publication of the report

Power BI Mobile

Conditional formatting

Parameters

Switching within a report

Filter synchronization between sites

Small multiples

Unichar

Target

Mother

Speedometer

Drill down to detail

RLS permissions

Basics of creating calculations – SUM, MIN, MAX, AVERAGE, SUMX, AVERAGEX, IF, HASONEVALUE

CALCULATE function as the main calculation engine – 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

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

Time operations, comparison between periods – TOTALYTD, SAMPLEPERIODLASTYEAR, DATEADD (optional) TopN with a parameter changed from the report level – TOPN, SELECTEDVALUE, KEEPFILTERS, CALCULATETABLE, ALLSELECTED, VALUES

Bullet Chart

Lollipop Chart

Others depending on remaining time