wirtualna klasa
kontakt
kontakt
wirtualna klasa koszyk
Pobierz kartę szkolenia

Microsoft Power BI – Advanced Power BI solutions with DAX

kod szkolenia: PBI_02_DAX / ENG DL 2d

The training Introduces attendees into advanced options of DAX language (Data Analyses Expressions), allowing to create effective and multidimensional analysis. During this training you will learn how to create clear and functional reports allowing detailed analyses of large quantities of data. The practical form of the training will allow you to use this in you day to day tasks.The training Introduces attendees into advanced options of DAX language (Data Analyses Expressions), allowing to create effective and multidimensional analysis. During this training you will learn how to create clear and functional reports allowing detailed analyses of large quantities of data. The practical form of the training will allow you to use this in you day to day tasks.

training assurance
Termin
tryb Distance Learning

poziom Zaawansowany

czas trwania 2 dni |  14h|  15.05 16.05
1 700,00 PLN + 23% VAT (2 091,00 PLN brutto)
Poprzednia najniższa cena:
1 700,00 PLN 2 091,00 PLN brutto

Subjects of the training are aimed at people that already started working with Power BI Desktop and want to find out more about advanced DAX calculations. In the training you will also find many useful tips about data modelling. Aim of the training is also focused on creating clear and informative reports.

  • You will understand DAX language and use its capabilities
  • You will learn how to use time intelligence functions, that allow to analyze data based on many different time intervals.
  • You will see how to apply basic RLS security
  • You will be able to prepare reports using parameters that allow you to change values on demand and get dynamic reports
  • You will learn good practices of how to prepare your formulas
  1. Preparing data model structure and relationships
    1. List tables
    2. Dates table (calendar) – functions CALENDAR(), CALENDARAUTO(), FORMAT()
    3. Calculated columns
    4. Data types
    5. Conversions
    6.  Active and non-active relationships
    7. Hierarchies
    8. Basic transformations with Power Query
  2. Quick measures
    1. Using predefined calculations
    2. Implementing predefined calculations in custom measures
  3. Most commonly used functions
    1. Aggregations: SUM(), SUMX(), AVERAGE(), MIN(), MAX(), RANKX()
    2. Counting: COUNT(), COUNTROWS(), DISTINCTCOUNT(), DISTINCTCOUNTNOBLANK()
    3. Lookup: REALATED(), LOOKUPVALUE()
    4. Error handling: DIVIDE(), BLANK(), SELECTEDVALUE()
  4. Calculations context
    1. CALCULATE()
    2. FILTER()
    3. ALL(), ALLSELECTED(), ALLEXCEPT()
  5. Dates intervals calculations
    1. SAMEPERIODLASTYEAR(), DATEADD(), PARALLELPERIOD()
    2. TOTALYTD(), TOTALQTD(), TOTALMTD()
    3. DATESYTD(), DATESQTD(), DATESMTD()
    4. DATESBETWEEN(), DATESINPERIOD()
    5. LASTNONBLANK(), LASTNONBLANKVALUE()
    6. USERELATIONSHIP()
  6. Logical functions
    1. IF()
    2. SWITCH()
  7. Good practices for creating measures
    1. Creating variables
    2. Comments
    3. Clear code structure
  8. Using parameters with calculations
    1. Creating table with parameter values
    2. Using and referring to parameters in formulas
  9. Filtering data based on sign in data
    1. USERPRINCIPALNAME()

Basic knowledge of Power BI or training PBI_01 or EX PBI

– English