DAX course

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

Course goals

Introduce the participants with the 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

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

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
+
GENERATED REPORTS
+
WORKSHOPS
+
YEARS OF EXPERIENCE
+
SATISFIED CLIENTS
Scroll to Top