Learning DAX [M-DAX]

Tijdsduur
Locatie
Op locatie, Online
Startdatum en plaats
Logo van Global Knowledge Belgium BV
Opleiderscore: starstarstar_halfstar_borderstar_border 4,5 Global Knowledge Belgium BV heeft een gemiddelde beoordeling van 4,5 (uit 2 ervaringen)

Tip: meer info over het programma, prijs, en inschrijven? Download de brochure!

Startdata en plaatsen

placeMechelen (Battelsesteenweg)
11 feb. 2022
computer Online: VIRTUAL TRAINING CENTRE
11 feb. 2022
placeMechelen (Battelsesteenweg)
8 apr. 2022
computer Online: VIRTUAL TRAINING CENTRE
8 apr. 2022
placeMechelen (Battelsesteenweg)
17 jun. 2022
computer Online: VIRTUAL TRAINING CENTRE
17 jun. 2022

Beschrijving

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…

Lees de volledige beschrijving

Veelgestelde vragen

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Nog niet gevonden wat je zocht? Bekijk deze onderwerpen: Power BI, Business intelligence, Splunk, Microsoft Power Platform en Data Analyse.

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 

 

Blijf op de hoogte van nieuwe ervaringen

Er zijn nog geen ervaringen.

Deel je ervaring

Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Download gratis en vrijblijvend de informatiebrochure

Aanhef
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)

Heb je nog vragen?

(optioneel)
We slaan je gegevens op om je via e-mail en evt. telefoon verder te helpen.
Meer info vind je in ons privacybeleid.