Learning DAX
- Kursuskode M-DAX
- Varighed 1 Dag
Leveringsmetoder
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
Beskrivelse
ToppenEvery 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.
Kursusdato
ToppenMålgruppe
ToppenEveryone who performs data analysis, including: Risk Managers, Financials, Analysts, Controllers, HR-Advisors, Customer Journey Experts, etc
Kursets formål
ToppenLearn 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
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
Forudsætninger
ToppenBasic knowledge of Power BI. The M-DA100 would fufill the basic requirements. Some previous DAX experience is nice-to-have but not a requirement.