Power BI DAX Intensive Training Course
£1,050.00 – £26,550.00
Our three-day DAX Intensive Training Course is designed for Power BI users who find themselves struggling with Power BI’s Data Analysis Expressions (DAX) formulas and would like to obtain a throrough grounding in this important data modelling formula langauge. It starts from the fundamentals and works through to advanced topics. The course consists of three modules (which can be also taken separately):
DAX Introduction
DAX Intermediate
DAX Advanced
Description
Our three-day DAX Intensive Training Course is designed for Power BI users who find themselves struggling with Power BI’s Data Analysis Expressions (DAX) formulas and would like to obtain a throrough grounding in this important data modelling formula langauge. It starts from the fundamentals and works through to advanced topics. The course consists of three modules (which can be also taken separately):
- POWER BI DAX Introduction
- POWER BI DAX Intermediate
- POWER BI DAX Advanced
POWER BI DAX INTRODUCTION
Getting Started
Welcome to the Course
Downloading the Course Files
DAX Overview
DAX Objects
Calculated Columns
Calculated Columns versus M Computed Columns
Creating Calculated Columns
Calculated Columns versus Measures
Calculated Columns, Measures and Visuals
DAX Syntax
Referring to Objects
DAX Operators
Using Variables
Calculated Tables
Creating Calculated Tables
Creating a Date Table
Cloning a Table
Using the DISTINCT Function
Using the FILTER Function
Measures
Creating a Measures Table
Implicit Measures
Measures and the Filter Context
Basic Aggregation Functions
Logical Functions
Iterator Functions
Implicit and Explicit Iteration
The SUMX Function
The AVERAGEX Function
The COUNTX Function
Calculation Contexts
Understanding Calculation Contexts
The Row Context
The Filter Context
Context Transition
CALCULATE Function Basics
CALCULATE Overview
Using CALCULATE with Booleans
Using CALCULATE with FILTER
Using CALCULATE with ALL
POWER BI DAX INTERMEDIATE
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
POWER BI DAX ADVANCED
Calculation Groups
Overview of Calculation Groups
Overview of Tabular Editor
Creating a Calculation Group
SELECTEDMEASURE and SELECTEDMEASURENAME
Using Calculation Groups with Time Intelligence
Exchanging Measures using Calculation Groups
Defining Format Strings
Making Format Strings Dynamic
Exposing DAX to the User
Using DAX What-if Parameters
The GENERATESERIES Function
Letting the User Control Time Intelligence
Grouping Functions
SUMMARIZE
SUMMARIZECOLUMNS
GROUPBY BY
Combining Tables with DAX
UNION
CROSSJOIN
INTERSECT
EXCEPT
Manipulating Filters
ALL and ALLEXCEPT
ALLSELECTED and ALLCROSSFILTERED
REMOVEFILTERS and KEEPFILTERS
EARLIER and EARLIEST
The USERELATIONSHIP Function
Data Lineage
What is Data Lineage?
Controlling data lineage with the TREATAS Function
Debugging DAX Code
Using the Performance Analyzer
Running Code in DAX Studio
Using Define Measure
Using Define Dependent Measures
Redefining Measures
Additional information
Date | 2-4 Feb 2022(Tutor-led, Online), 11-13 Apr 2022(Tutor-led, Online), 8-10 Jun 2022(Tutor-led, Online), 10-12 Aug 2022(Tutor-led, Online), 26-28 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 |
---|