Skip to main Content

Learning DAX

  • Kursuskode M-DAX
  • Varighed 1 Dag

Leveringsmetoder

Åbent kursus (Virtuelt) Pris

DKR5,000.00

Ekskl. Moms

Anmod om gruppetræning Køb

Go to:

Leveringsmetoder

Kurset er tilgængeligt i følgende formater:

  • Firma kursus

    Et lukket firma kursus

  • Åbent kursus

    Traditionel klasserumsundervisning

  • Åbent kursus (Virtuelt)

    Live klasserumsundervisning du tilgår virtuelt

Anmod om dette kursus Med en anden leveringsløsning

Download fuld kursusbeskrivelse

Beskrivelse

Toppen

Every Power BI user who needs to add analytical power to a Power BI model not available in the data as-is requires DAX skills. DAX is not a language that can be learned by just starting in practice and building from there; theoretical knowledge is a requirement! That is why this 1 day training is offered. Questions like “when do I use a calculated column, when do I use a measure?”, “how does row- and filter context work exactly?”, “How do I create a table in DAX”, and much more. All parts of the DAX language that are required to be able to write DAX will be covered, including sufficient exercises in order to obtain hans-on experience.

 

Virtuel deltagelse

Et V&C Select kursus indholder nøjagtig det samme som et almindeligt kursus. Før kursusstart modtager man kursusmaterialet. Dernæst logger man på kurset via internettet og ser via sin pc den selvsamme præsentation som de øvrige deltagere, man kommunikerer via chat med underviseren og de øvrige deltagere på kurset. Denne uddannelsesmodel er både tids-og omkostningsbesparende og kan være et oplagt alternativ til almindelig klasseundervisning, hvis man f.eks. har et begrænset rejsebudget.

Kursusdato

Toppen

Kontakt os Til datoer

Anmod om gruppetræning Datoer i andre lande

Målgruppe

Toppen

Everyone who performs data analysis, including: Risk Managers, Financials, Analysts, Controllers, HR-Advisors, Customer Journey Experts, etc

 

mere…

Kursets formål

Toppen

 Learn to:

  • Decide when to use a measure and when to use a calculated column 
  • Aggregate a column in a measure 
  • Aggregate an expression in a measure 
  • Use the different groups of functions within DAX 
  • Create relationships between tables 
  • Filter a table by another table 
  • Use normal -and bidirectional filtering 
  • Apply table functions 
  • Understand the difference between row- and filter context 
  • Ignore filter context using ALL 
  • Use variables in order to make DAX code easier to read 
  • Use variables in order to use the correct evaluation context 
  • Use CALCULATE in order to manipulate the filter context 
  • Use CALCULATE in order to trigger evaluation context transition 
  • Use Semi-Additive measures to adjust the summative filter context 
  • Use Time Intelligence functions 
  • Set up and Use Row-Level-Security to ensure the highest level of security on your data 

 

mere…

Kursusindhold

Toppen
  •  
  • Decide when to use a measure and when to use a calculated column 
  • Aggregate a column in a measure 
  • Aggregate an expression in a measure 
  • Use the different groups of functions within DAX 
  • Create relationships between tables 
  • Filter a table by another table 
  • Use normal -and bidirectional filtering 
  • Apply table functions 
  • Understand the difference between row- and filter context 
  • Ignore filter context using ALL 
  • Use variables in order to make DAX code easier to read 
  • Use variables in order to use the correct evaluation context 
  • Use CALCULATE in order to manipulate the filter context 
  • Use CALCULATE in order to trigger evaluation context transition 
  • Use Semi-Additive measures to adjust the summative filter context 
  • Use Time Intelligence functions 
  • Set up and Use Row-Level-Security to ensure the highest level of security on your data 

 

mere…

Forudsætninger

Toppen

Basic knowledge of Power BI. The M-DA100 would fufill the basic requirements. Some previous DAX experience is nice-to-have but not a requirement.

 

mere…

Certificeringstest

Toppen
NA
mere…