Szkolenia
Kontakt

DAX – Creating advanced formulas for Power BI, SQL Server Analysis Services ...

    Czas trwania
    Godzina rozpoczęcia
    Stopień trudności

      DAX – Creating advanced formulas for Power BI, SQL Server Analysis Services and PowerPivot in Excel


      Remote and stationary training options

      About training

      During the training, participants will learn to use tables functions, construct messages, prepare rankings and use DAX language for time analysis in a more complex way, that gives the expected results. They will learn how to create tree hierarchies, as well as learn how to handle relationships using functions.

      View the training programme

      What will you gain from the training?

      Goals of the training

      The aim of the training is to familiarize participants with the functions and complex expressions of DAX (Data Analysis Expressions), which can be used for data analysis in Power BI, SQL Server Analysis Services and in the PowerPivot add-in for MS Excel.

      During the training, participants will learn to use tables functions, construct messages, prepare rankings and use DAX language for time analysis in a more complex way, that gives the expected results. They will learn how to create tree hierarchies, as well as learn how to handle relationships using functions.

      Skills 

      Thanks to the training, the participant will be able to:

      • define measures, columns, and calculated tables
      • create simple and complex DAX formulas
      • take care of code optimization
      • use information functions, as well as dates and ranking functions
      • use functions to manipulate tables
      • handle relationships using functions
      • create tree hierarchies
      Is this training for you?

      Profile of participants

      The training is intended for people using the Power BI tool or the PowerPivot add-in for MS Excel, who perform data analysis and create reports based on data from other systems, databases, sheets.   

      Prerequisites

      The training participants are required to have knowledge of the Windows environment, basic knowledge of Power BI or the Excel Power Pivot add-in (importing data, creating relationships, hierarchies and creating basic measures and calculated columns). Earlier participation in the trainings Power BI - data analysis and visualization or Microsoft Excel - data analysis using Power Pivot, Power View, Power Query add-ons may be useful.

      Duration

      Duration:

      • 2 days, 8 teaching hours each
      Detailed training program

      Detailed training program

      The essence of the data model

      Contexts of performance

      Calculated column vs measure 

      Data types

      Operators

      Selected functions review:

      • aggregators and iterators
      • VALUES and DISTINCT
      • RELATED and RELATEDTABLE
      • CALCULATE and CALCULATETABLE
      • filters and modifiers

      Displaying messages - use of information functions

      Selected  time analysis functions

      Rankings

      • using the RANKX function
      • preparation of the "top N" analysis

      Complex DAX expressions

      • syntax
      • code optimization
      • use in calculations and analyzes

      Tables functions

      • defining calculated tables
      • grouping of data

      Advanced relationship handling using the DAX functions

      • using inactive relationships
      • virtual relationships
      • multi-column relationships

      Defining the tree hierarchy

      DOWNLOAD FILE

      Development path
      • Power BI - Data analysis and visualization 
      • Power BI, Power Pivot, Power Query – Analysis of data from spreadsheets and unstructured files
      • Power BI i DAX - Analysis based on dates 
      • Power BI i DAX - Advanced analysis based on dates
      • DAX – Creating advanced formulas for Power BI,  SQL Server Analysis Services and PowerPivot in Excel

      Podobne tematy