D.O.T.S. Power BI DAX Intermediate

£485.00£13,500.00

In this one-day Power BI DAX Intermediate, which is suitable for experienced Power BI users who are already familiar with DAX fundamentals, delegates will delve deeper into the DAX functional language. The main topics covered are Dynamic Titles; Interacting with the User; Dynamic Formatting; Ranking with DAX; DAX Time Intelligence and Semi-Additive Measures.

Clear
SKU: GCOM-DAXDT-102 Category:

Description

This is the Dual Online Training Solution (D.O.T.S.) version of our Power BI DAX Intermediate. This course is suitable for experienced Power BI users who are already familiar with DAX fundamentals, delegates will delve deeper into the DAX functional language. The main topics covered are Dynamic Titles; Interacting with the User; Dynamic Formatting; Ranking with DAX; DAX Time Intelligence and Semi-Additive Measures.

Our Dual Online Training Solution provides your staff with two modes of training: live instructor-led training is followed with three year’s access to the self-paced version of the same course. The material covered in the live training will be very similar to that covered in the self-paced video training. So, the self-paced training provides a very effective form of post-training reinforcement.

Course Outline

Dynamic Titles

Using the SELECTEDVALUE Function
Nesting the SELECTEDVALUE Function
Using CONCATENATEX with Dynamic Titles

Interacting with the User

The USERNAME Function
Displaying the last refresh date and time
Creating dynamic Accessibility Alt tags

Dynamic Formatting

Creating Measures which Return RAG Colours
Creating Measures which Return Images

Ranking with DAX

The RANKX Function
Ranking Within a Group
Using the TOPN Function

DAX Time Intelligence

Power BI Auto Date/Time Feature
Calendar Tables
Automatic vs Manual Time Intelligence
The TOTALYTD, TOTALQTD and TOTALMTD functions
The SAMEPERIODLASTYEAR Function
Using the DATEADD Function for Maximum Flexibility
The PARALLELPERIOD Function
Calculating Running Totals
Using DATESINPERIOD for MAT and 3MMA

Semi-Additive Measures

What is a Semi-Additive Measure?
Creating a Semi-Additive Measure
Non-Additive Visualization
Additive Visualization

Additional information

Date

3 Feb 2022(Tutor-led, Online), ; 12 Apr 2022(Tutor-led, Online), ; 9 Jun 2022(Tutor-led, Online), ; 11 Aug 2022(Tutor-led, Online), ; 27 Oct 2022(Tutor-led, Online), Private Training for up to 10 Users, Private Training for up to 20 Users, Private Training for up to 30 Users, Private Training for up to 40 Users, Private Training for up to 50 Users, Private Training for up to 60 Users, Private Training for up to 70 Users, Private Training for up to 80 Users, Private Training for up to 90 Users, Private Training for up to 100 Users