Show all

DAX basics in Power BI - Analysis

Learn how to use Data Analysis Expressions (DAX) to solve a variety of basic calculations and to analyze data.
Level
Designed for participants with basic knowledge and experience
intermediate
Course length
8 hours
Language
 cz  eu
Course code
KT22010053
MS Power BI - reports
Category:
Do you want this tailor-made course to your company? Contact us

Courses on a specific date with a live lecturer

Term
Language
Place
Form
?
How and where the course takes place.
Price without VAT
22. 10. 2024 09:00 - 17:00
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: KT22010053-0016
Price without VAT
8 000 Kč
Open term
?
We will agree on a specific date together. This is a non-binding order.
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: KT22010053-0001
Price without VAT
8 000 Kč
Open term
?
We will agree on a specific date together. This is a non-binding order.
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: KT22010053-0002
Price without VAT
8 000 Kč

Expressions of participants

Petra Š.
Škoda Auto, a.s.
"Great, perfect presentation, absolutely fun, interesting, inspiring, we want to do it again."

Course description

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.

Required knowledge

Knowledge of working in Power BI.

Target audience

Power BI Users.

Course content

  • 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,…)

Materials

Materials are in electronic form.

Lecturers

Jan B.
Jan B.

Do you want this tailor-made course for your company?

Contact us

Previous courses

Follow-up courses

Expressions of participants

Petra Š.
Škoda Auto, a.s.
"Great, perfect presentation, absolutely fun, interesting, inspiring, we want to do it again."

Do you want this tailor-made course for your company?

Contact us

Why with us