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
4. Building the first report
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
DAY 2
REPORTS – what and how does it work?
1. Introduction
Summary of day one
Work plan for the second day
Where to look for materials for development in the Power BI area
2. Power BI Services
The report and its functionalities from the PBI
Services level
Dashboards
Apps
Workspaces
3. Navigating the report
Dynamic buttons in Power BI
Publication of the report
Power BI Mobile
4. Extensive visualizations
Conditional formatting
Parameters
Switching within a report
Filter synchronization between sites
Small multiples
Unichar
Target
Mother
Speedometer
Drill down to detail
RLS permissions
DAY 3
DAX CALCULATIONS AND ADVANCED VISUALIZATIONS
1. DAX calculations
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
2. Advanced visualizations
Bullet Chart
Lollipop Chart
Others depending on remaining time