Introduction to DAX with PowerBI
- Code training M-DAX
- Duur 1 dag
Andere trainingsmethoden
Ga naar:
Methode
Deze training is in de volgende formats beschikbaar:
-
Klassikale training
Klassikaal leren
-
Virtueel leren
Virtueel leren
Vraag deze training aan in een andere lesvorm.
Trainingsbeschrijving
Naar bovenEvery 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.
Data
Naar boven-
- Methode: Virtueel leren
-
Datum:
22 mei, 2024
Startgarantie
Last Minute
- Locatie: Virtueel-en-klassikaal
-
- Methode: Klassikale training
- Datum: 06 september, 2024
- Locatie: Nieuwegein (Iepenhoeve 5)
-
- Methode: Virtueel leren
- Datum: 06 september, 2024
- Locatie: Virtueel-en-klassikaal
-
- Methode: Klassikale training
- Datum: 18 december, 2024
- Locatie: Nieuwegein (Iepenhoeve 5)
-
- Methode: Virtueel leren
- Datum: 18 december, 2024
- Locatie: Virtueel-en-klassikaal
Doelgroep
Naar bovenEveryone who performs data analysis, including: Risk Managers, Financials, Analysts, Controllers, HR-Advisors, Customer Journey Experts, etc
Trainingsdoelstellingen
Naar bovenLearn 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
Inhoud training
Naar boven- 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
Voorkennis
Naar bovenBasic knowledge of Power BI. The M-DA100 would fufill the basic requirements. Some previous DAX experience is nice-to-have but not a requirement.
Aanbevolen vereisten:
Examen
Naar boven- /nl-nl/-/media/global-knowledge/rte-images/social-share/certifyforsuccess_button.png /nl-nl/certificeringen/certificeringen/microsoft/certify-for-success #000000
- <p><br data-mce-bogus="1" /></p> /nl-nl/-/media/global-knowledge/rte-images/campaigns-and-promotions/microsoft-elite-total-access-button.png https://www.globalknowledge.com/nl-nl/training/trainingen/technology-providers/microsoft/elite-total-access-collection-for-microsoft?utm_source=website&utm_medium=banner&utm_campaign=Microsoft_Elite&utm_content=course-overview #800080
- #000000
- M-DAX
- Introduction to DAX with PowerBI
- Business Analysis
- M-DAX, Introduction to DAX | Global Knowledge
- Microsoft