Learning DAX with PowerBI [M-DAX]
Dates et lieux de début
computer En ligne: VIRTUAL TRAINING CENTER 22 mai 2024 |
computer En ligne: VIRTUAL TRAINING CENTER 6 sept. 2024 |
computer En ligne: VIRTUAL TRAINING CENTER 18 déc. 2024 |
Description
Vrijwel iedere training die op een onze locaties worden getoond zijn ook te volgen vanaf huis via Virtual Classroom training. Dit kunt u bij uw inschrijving erbij vermelden dat u hiervoor kiest.
OVERVIEW
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.
OBJECTIVES
Learn to:
- Decide when to use a me…
Foire aux questions (FAQ)
Il n'y a pour le moment aucune question fréquente sur ce produit. Si vous avez besoin d'aide ou une question, contactez notre équipe support.
Vrijwel iedere training die op een onze locaties worden getoond zijn ook te volgen vanaf huis via Virtual Classroom training. Dit kunt u bij uw inschrijving erbij vermelden dat u hiervoor kiest.
OVERVIEW
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.
OBJECTIVES
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
AUDIENCE
Everyone who performs data analysis, including: Risk Managers, Financials, Analysts, Controllers, HR-Advisors, Customer Journey Experts, etc
CERTIFICATION
NACONTENT
- 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
Rester à jour sur les nouveaux avi
Partagez vos avis
Avez-vous participé à cours? Partagez votre expérience et aider d'autres personnes à faire le bon choix. Pour vous remercier, nous donnerons 1,00 € à la fondation Stichting Edukans.Il n'y a pour le moment aucune question fréquente sur ce produit. Si vous avez besoin d'aide ou une question, contactez notre équipe support.