Contact
Comarch Training

DAX – creating advanced formulas

Power BI, SQL Server Analysis Services and PowerPivot in Excel
    Duration
    Start hour
    Level

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

      DAX Training for Power BI, SQL Server, PowerPivot

      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.  

      DAX – Creating advanced formulas

      Goals of the DAX training

      The aim of the DAX 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
      Profile of participants
      The DAX 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.
      Detailed training program
      1. The essence of the data model
      2. Contexts of performance
      3. Calculated column vs measure
      4. Data types
      5. Operators
      6. Selected functions review:
      • aggregators and iterators
      • VALUES and DISTINCT
      • RELATED and RELATEDTABLE
      • CALCULATE and CALCULATETABLE
      • filters and modifiers
      1. Displaying messages - use of information functions
      2. Selected  time analysis functions
      3. Rankings
      • using the RANKX function
      • preparation of the "top N" analysis
      10.  Complex DAX expressions
      • syntax
      • code optimization
      • use in calculations and analyzes
      11.  Tables functions
      • defining calculated tables
      • grouping of data
      12.  Advanced relationship handling using the DAX functions
      • using inactive relationships
      • virtual relationships
      • multi-column relationships
      13.  Defining the tree hierarchy
      DAX training delivery method

      The DAX (Data Analysis Expressions) training is carried out in the form of alternating lectures and practical exercises, performed individually or together.

      Duration

      2 days, 8 teaching hours each

      Price - 400 euro

      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.

      Similar training

      Consultant:

      Kacper Wiech
      Kacper Wiech

      kacper.wiech@comarch.com

      +48 12 687 78 11

      +48 726 460 695