Advanced DAX Language Training

Catalogue index: IFS/49

  • In stock
  • Delivery: free
  • Dedicated training:
  • Producer:
  • Training level:
    • Zaawansowany
  • Type of training:
    • stacjonarnie; online
PLN993.33 net / particip. PLN14,899.95  net for 1 workshop PLN1,221.80 gross incl. 23% VAT / particip.

product- line 1

Features

Features
Additional materials:
  •  
Certification:
  • TAK
Dedicated training:
Number of training hours:
  • 16
Producer:
Training language:
  • polski
Training level:
  • Zaawansowany
Type of training:
  • stacjonarnie; online

Description

Company Description

InfoShare Academy is a leading IT academy offering comprehensive educational programs in new technologies for companies. Since 2015, we have supported organizations in developing technology teams through dedicated courses in Machine Learning, DevOps, Data Engineering, Python, UX/UI Design, AWS, and Kubernetes. Our training is based on practical skills and real business cases. We collaborate with over 300 industry practitioners, ensuring that our programs are tailored to current market needs. We specialize in reskilling and upskilling employees. With us, you will build effective teams implementing new technologies that will accelerate innovation and strengthen your company's competitiveness in the market. Check out our training offerings designed for companies, created to develop your employees' competencies in the IT field.

Training Description

The DAX (Data Analysis Expressions) language is a special programming language created by Microsoft. It is primarily used in data analysis tools such as Microsoft Power BI, Microsoft Excel Power Pivot, and Microsoft Analysis Services. The DAX language allows for advanced calculations and expressions that aid in the analysis, modeling, and visualization of business data.

Who is the Training For

The DAX language is essential for individuals working with Microsoft data analysis tools and enables advanced calculations and analyses that are crucial in business data analysis.

Objectives

 

Benefits

The training in DAX (Data Analysis Expressions) aims to teach participants various aspects of this language to enable them to work effectively with data analysis tools such as Microsoft Power BI, Excel Power Pivot, and Analysis Services.

Training Program

  • Understanding contexts in DAX – row context, filter context, evaluation context, context transition

  • Time intelligence functions in complex scenarios

    • Analysis to "today"

    • Working with weeks

    • Custom time intervals

  • Advanced calculations using DAX

    • Advanced filtering in the CALCULATE function

    • Using virtual relationships (TREATAS)

    • Building rankings based on DAX

    • Using variables when working with DAX

  • Calculated tables in DAX

    • Understanding the concept of "Filter as Table"

    • Creating calculated tables in DAX

    • Creating virtual tables for a specific calculation

  • Calculated groups in DAX

  • Using calculations at the visualization level

    • Creating calculations at the visualization level

    • When is it worth using them?

  • Creating queries in DAX

  • Proper use of DAX

    • Query performance analysis

    • Best practices for DAX

Duration

16 h/2 days

Price Includes
  • Certificate of completion
  • Monthly access to the training recording (for online format)
  • Customization of the training program to client needs

Zamów szkolenie