Loading...

Power BI - Dax Essentials

Course code: MBI0012

2 days £1,100.00
+ VAT

Hands on Power BI DAX training to enable attendees to create complex calculations in DAX

Course content >

Who Should Attend?

Business Analysts Financial Analysts Data Analysts Existing Power BI who now want to use DAX

Prerequisites

An working knowledge of Power BI or,

Power BI Fundamentals

Course Contents

Hands on Dax training course designed for Power BI users who now want to harness power of DAX formulas within Power BI.

Attendees will work through pracitical hands on session to create complex calculations to enable attendees to take data analysis well beyond that available within the standard toolset.

Learn how to use variables, create write time intelligence calculations, cumulative totals, dynamic titles, DAX studio to debug and increase performance  ​​​

For those wanting to take this course in house, iTrain tailor content to your specific to your organisation's business and projet objectives.




DAX Fundamentals
Commonly Used DAX Functions
Sum, Average, Count, DistinctCount
Create a measure table
Copying and Moving Measures
Use Variables in calculation
Different granularity: calculate allocated weight

DAX STUDIO
Dax as a query language
Dax Studio - capturing and debugging queries
Power BI referencing

CONTEXT
Filter context
Evaluation Contexts and Relationships
Understand the use of CALCULATE
Table Functions: ALL, ALLEXCEPT, FILTER
Table Functions: DISTINCT, VALUES
Advanced Evaluation Context DAX  
Context transition
Iterator -> nested row context
Row context and Totals
Row context and cumulative total

TIME INTELLIGENCE
Time Intelligence prerequisites
Time intelligence functions MTD, QTD, YTD, SamePeriodLastYear
YTD, MTD with CALCULATE
Rolling totals for different periods
IF, HasOneValue
Using a Safe Divide Function
Using the Blank() Function
Creating Dynamic titles
Using parameter table
What is scenarios






Contact us for more information