DAX course

DAX course will help you become a Microsoft Business Intelligence Expert!

The DAX course is intended for everyone who wants to learn how to create advanced calculations within the PowerBI system (or modern pivot tables within the Excel tool).

With the knowledge of DAX language, it is possible to write fast and dynamic calculations that were previously extremely difficult, sometimes impossible to make with classic Excel calculations.

After the DAX course, participants will have a  knowledge of the most important concepts of the language and will be able to write DAX calculations themselves with a clear understanding of the background processes.

Courses most often taken in combination with the DAX course:

Course goals

Introduce the participants with advanced capabilities of the DAX language. Participants will learn basic concepts and formula writing standards of the DAX language. Participants will also learn some of the more advanced concepts like iterators, row to filter context transitions, table functions, etc.

Participants

This course is intended for all the advanced PivotTable and PowerPivot users (whether they work in Excel or PowerBI environment) who would like to improve PivotTable capabilities, or they need to process and analyze a vast amount of data (several mil. rows and more).

Notes

Course can be lectured through PowerBI or Excel interface. In case of using Excel option, participants need to have at least Excel 2016 installed or PowerPivot add-on in case of prior versions. It is advisable to use Excel 365 if possible.

Course content

• Why is PowerPivot/Tabular used as a Microsoft BI pillar?
• PowerPivot – what is the difference vs PivotTable
• What is DAX and how to learn it?

• DAX data types and operators
• Error types
• Code formatting

• Calculated columns – why, where and when to use them
• Measures – basics and difference vs columns
• Propagation through columns
• Var vs obsolete EARLIER
• Columns vs measures examples

• Basic functions- MIN, SUM, DISTINCTCOUNT
• Iterators - SUMX, FILTER
• Table functions – ALL, VALUES, DISTINCT, SUMMARIZE

• Row context
• Filter context
• Evaluation context
• Context vs model propagation
• FILTER vs ALL

• Evaluation order
• CALCULATE rules
• Original filter context manipulations
• ALL vs ALLSELECTED
• Time intelligence functions - YTD, MTD, QTD, LY...

For more guidance about general course structures and ways of course handling please follow this link.

Why choose us?

Experience in advanced DAX programming has opened the door for us into working with large multinational clients, where our calculations pass challenging speed and accuracy tests on models as large as several hundred million rows of data.

Our inspiration are SQLBI guys (who are also our role models), and everything we have learned through years of working on advanced data models, we have translated into this course.

In the course, we teach you not only how to make DAX calculations, but also how to create sustainable data models, which is also extremely important in creating quality PowerBI systems.

We try to make our knowledge of DAX coding and data modeling as transparent as possible by sharing it through our blog and YouTube channel.

Course information
Course duration

8h

Course difficulty
Intermediate to advanced
Minimal attendees
3
Maximal attendees
20
Price per attendee (netto) *

260,00 €

Course first time held:
2017.

*Additional discount is offered for each new attendee. If you have more attendees to apply for the course, or you would like to combine multiple courses, please contact us through the form below. Based on your inquiry, we will send you a more personalized offer.

Lecturer

Krešimir Ledinski

More than 6 years of experience with PowerBI.
Holds Microsoft MCSA Certificate in the field of BI reporting.
Learn more about Krešimir

Contact form for more questions

By submitting a form you accept Exceed's Privacy Policy
+
Users
+
Workshops
+
Educational videos
+
Educational blogs
Scroll to Top