Learning DAX with PowerBI [M-DAX]

Durée totale
Localisation
En ligne
Date et lieu de début

Learning DAX with PowerBI [M-DAX]

Global Knowledge Belgium BV
Logo Global Knowledge Belgium BV
Note du fournisseur: starstarstar_halfstar_borderstar_border 4,5 Global Knowledge Belgium BV a une moyenne de 4,5 (basée sur 2 avis)

Astuce: besoin de plus d'informations sur la formation? Téléchargez la brochure!

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…

Lisez la description complète ici

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.

Vous n'avez pas trouvé ce que vous cherchiez ? Voir aussi : Microsoft Power, Microsoft Access, Microsoft Sharepoint, Data management et Data Science.

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

NA

CONTENT

  •  
  • 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

Pas encore d'avis.

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.

Recevoir une brochure d'information (gratuit)

(optionnel)
(optionnel)
(optionnel)
(optionnel)
(optionnel)
(optionnel)

Vous avez des questions?

(optionnel)
Nous conservons vos données personnelles dans le but de vous accompagner par email ou téléphone.
Vous pouvez trouver plus d'informations sur : Politique de confidentialité.