Description

This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code.

This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references.

This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables.

1 The query editor

Split by row delimiter
AddDays to determine deadlines
Advanced query editor

2 Fuzzy matching joins

Matching inconsistencies by percentage
Matching with transformation table

3 Logical column functions

Logical functions IF, AND, OR
Using multiple conditions
Including FIND in functions

4 Editing DAX measures

Make DAX easier to read
Add comments to a measure
Using quick measures

5 The anatomy of CALCULATE

Understanding CALCULATE context filters
Adding context to CALCULATE with FILTER
Using CALCULATE with a threshold

6 The ALL measure

Anatomy of ALL
Create an ALL measure
Using ALL as a filter
Use ALL for percentage

7 DAX iterators

Anatomy of iterators
A closer look at SUMX
Using RELATED in SUMX
Create a RANKX
RANKX with ALL

8 Date and time functions

Overview of functions
Create a DATEDIFF function

9 Time intelligent measures

Compare historical monthly data
Create a DATEADD measure
Creating cumulative totals
Creating cumulative measures
Visualising cumulative totals

10 Visualisations in-depth

Utilising report themes
Create a heatmap
Comparing proportions
View trends with sparklines
Group numbers using bins
Setting up a histogram

11 Comparing variables

Visualising trendlines as KPI
Forecasting with trendlines
Creating a scatter plot
Creating dynamic labels
Customised visualisation tooltips
Export reports to SharePoint

12 User level security

Setting up row level security
Testing user security

Course Images

Power BI - advanced (1 day) (In-House)

By The In House Training Company

Booking options

Highlights