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 with lecturer

Term
Language
Place
Form
?
How and where the course takes place.
Price without VAT
31. 1. 2025 09:00 - 17:00
Language
Place
Praha
Form
classroom
?
The course with an instructor in classroom.
Code of the course: KT22010053-0019
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

News with the course

Náhledový obrázek novinky
Microsoft 365 7. 3. 2024
Microsoft 365 Adoption

Microsoft 365 adoption represents the process of a company's digital transformation. It assists employees in acclimating to new technology, establishing usage rules, and fostering collaboration. Mere tool installation is not sufficient.

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

News with the course

Náhledový obrázek novinky
Microsoft 365 7. 3. 2024
Microsoft 365 Adoption

Microsoft 365 adoption represents the process of a company's digital transformation. It assists employees in acclimating to new technology, establishing usage rules, and fostering collaboration. Mere tool installation is not sufficient.

Why with us