Training: Power BI – DAX Formulas – Data Analysis Expression

Ref. MPB-32
Duration:
5
 days
Exam:
Not certifying
Level:
Advanced

Description

This course allows participants to deepen their knowledge of PowerPivot and Power BI training by addressing the 120 most important functions (formulas) of the formula expression language and DAX queries (Data Analysis eXpressions) to create pivot tables. more complex with elaborate statistical measures or time-intelligence measures, or create DAX queries.

Participant profiles

  • Analysts who need to make the PowerPivot’s native capabilities more complex by using DAX

Objectives

  • Be prepared for Power BI Desktop trainings

Prerequisites

  • Participants should have completed the training: Excel – PowerPivot for End-Users

Course content

  • Number and category of DAX functions
  • Overview of current problematic limitations
  • DAX in Models (Column) VS DAX in PVT (Measures)
  • Difference between DAX context, DAX context line, DAX context filter and DAX queries
  • Converting PowerPivot into cube formulas
  • TRIM text function to remove unwanted spaces
  • SUBSTITUTE text function to replace characters
  • LEFT and FIND text functions to extract a text from the left
  • UPPER or LOWER text functions to change the case
  • RIGHT, FIND and LEN text functions to extract a text to the right
  • CONCATENATE text function to merge texts
  • FORMAT text function for rendering texts or numbers
  • IF, AND, OR Logical functions for logical tests
  • SWITCH and TRUE logical functions to condense IF writing
  • IFERROR logic function to handle errors
  • YEAR date function to extract the year
  • MONTH date function to extract month
  • DAY date function to extract the day
  • HOUR time function to extract time
  • ISTEXT information function to identify whether the returned value is a string
  • PATH link function to retrieve parent elements
  • PATHITEM link function to target one of the parent elements
  • HASONEVALUE and VALUES link functions
  • RELATED link function for repatriating data
  • COUNTROWS statistic function to count rows
  • RELATEDTABLE link function to handle links implicitly
  • USERELATIONSHIP link function to select the inactive link
  • LOOKUPVALUE filter function for textualizing an item
  • DISTINCT filter function
  • DISTINCTCOUNT filter function
  • ALL filter function
  • ALLEXCEPT filter function
  • CALCULATE filter function
  • Logical filter operators
  • LN math function to calculate natural logarithm
  • CEILING math function for upper rounding
  • FLOOR math function for lower rounding
  • MROUND math function for rounding to the nearest given multiple
  • SUM and SUMX statistical functions
  • AVERAGE and AVERAGEX statistical functions
  • COUNT and COUNTX statistical functions
  • MIN, MINX and MAX, MAXX statistical functions
  • RANK.EQ and RANKX statistical functions
  • STDEV.S / STDEV.P and STDEVX.S / STDEVX.P statistical functions
  • VAR.S / VAR.P and VARX.S / VARX.P statistical functions
  • EVALUATE with CALCULATETABLE reverse DAX functions
  • EVALUATE with SUMMARIZE reverse DAX functions
  • ADDCOLUMNS reverse DAX function for aliasing
  • Using multiple tables
  • EVALUATE with ORDER and FILTER reverse DAX functions
  • EVALUATE with SUMMARIZE and ROLLUP reverse DAX function
  • Référence de pattern DAX
  • Time Intelligence Functions
  • DAX Patterns
  • Power Query vs DAX queries (speed factor)
  • Plus a lot of other functions

Documentation

  • Digital courseware included

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.
Prix de l'inscription
CHF 3'650.-
Inclus dans ce cours
  • Training provided by an industry expert
  • Digital documentation and materials
  • Achievement Badge

lun08Avr(Avr 8)09:00ven12(Avr 12)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMPB-32

lun08Avr(Avr 8)09:00ven12(Avr 12)17:00VirtuelVirtual Etiquettes de sessionMPB-32

lun13Mai(Mai 13)09:00ven17(Mai 17)17:00VirtuelVirtual Etiquettes de sessionMPB-32

lun13Mai(Mai 13)09:00ven17(Mai 17)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMPB-32

lun17Juin(Juin 17)09:00ven21(Juin 21)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMPB-32

lun17Juin(Juin 17)09:00ven21(Juin 21)17:00VirtuelVirtual Etiquettes de sessionMPB-32

lun22juil(juil 22)09:00ven26(juil 26)17:00VirtuelVirtual Etiquettes de sessionMPB-32

lun22juil(juil 22)09:00ven26(juil 26)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMPB-32

lun26Aoû(Aoû 26)09:00ven30(Aoû 30)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMPB-32

lun26Aoû(Aoû 26)09:00ven30(Aoû 30)17:00VirtuelVirtual Etiquettes de sessionMPB-32

lun30Sep(Sep 30)09:00ven04Oct(Oct 4)17:00VirtuelVirtual Etiquettes de sessionMPB-32

lun30Sep(Sep 30)09:00ven04Oct(Oct 4)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMPB-32

lun04Nov(Nov 4)09:00ven08(Nov 8)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMPB-32

lun04Nov(Nov 4)09:00ven08(Nov 8)17:00VirtuelVirtual Etiquettes de sessionMPB-32

lun09Déc(Déc 9)09:00ven13(Déc 13)17:00VirtuelVirtual Etiquettes de sessionMPB-32

lun09Déc(Déc 9)09:00ven13(Déc 13)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMPB-32

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.

Contactez-nous

Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request

X
X
X
X