DAX basics in Power BI - Analysis (EN)

Kurzem Vás provede Jan B.

Základní info

Popis kurzu

Learn how to use Data Analysis Expressions (DAX) to solve a variety of basic calculations and to analyze data.

As you learn how to create effective DAX formulas, you can use your data more efficiently and begin to address real business issues that affect your overall business results.

Určeno pro

Power BI Users.

Obsah kurzu


  • DAX theory

  • Syntax / concepts

  • Counted columns vs measures

  • DAX filters

  • DAX sessions

  • Contexts

  • A few tips and tricks for DAX

  • Practice with DAX in Power BI

  • Creating a calendar

  • COUNT, SUM, AVERAGE

  • CALCULATE

  • TIME Function (for analytics YoY, MoM, YTD%)

  • CALCULATETABLE vs FILTER

  • Table functions (UNION, ADDCOLUMNS, CROSSJOIN,…)

Předpoklady

Knowledge of working in Power BI.

Studijní materiály

Materials are in electronic form.

Návaznosti

How to do visuals / reports correctly

DAX basics in Power BI - Analysis (EN)

Vybraný termín:

 Praha

Cena
8 000 Kč + 21% DPH

Termíny kurzu

Kontaktovat dodavatele


Kontrola proti spamu. Kolik je deset a dvě ? Součet zapište číslicemi.