Advance your DAX calculations skillsOptimize Power BI modelsImprove reporting accuracy
DURATION
16 hours / 2 days
LEVEL
Advanced
LANGUAGES
Croatian, English
LOCATION
Solvership educational center, client premises, or online (virtual)
Overview
This training is designed for Power BI users who want to deepen their knowledge of data modeling and DAX. Whether you’re new to writing DAX functions, unsure about best practices, or looking to enhance your existing skills, this course will help you understand how DAX works and how to apply it to create more effective reports.
Over two days, you’ll explore the fundamentals of data modeling, best practices for DAX queries, and advanced techniques such as scalar, iterator, and time intelligence functions. You’ll gain the confidence to write optimal DAX code and take your Power BI skills to the next level.
Audience
This course is designed for Power BI users with experience in data modeling (star schema, dimensional modeling, measures, evaluation context) and basic DAX functions who want to expand their knowledge and improve their reporting.
Syllabus
01
Overview of Modeling and DAX Basics
Review core concepts such as the star scheme, evaluation context, filter flow, measures, and calculated columns.
02
Understanding the Data Model
Learn the structure of the data model used in the training to build a solid foundation.
03
Tips and Best Practices
Discover best practices for formatting and commenting DAX queries, using DAX variables, and handling errors.
04
Scalar Functions
Explore common scalar functions like rounding (TRUNC, ROUND), logical operations (IF, AND, OR), and conversions (FORMAT, DATE).
05
Advanced CALCULATE
Learn calculate modifiers, understand the concepts of context transition and extended tables.
06
Table and Filter Functions
Create calculated tables and apply filtering functions like ALL, FILTER, and SUMMARIZE.
07
Merging and Combining Data
Master CROSSJOIN, UNION, INTERSECT, and EXCEPT for combining data from different tables.
08
Relationship Functions
Understand physical and virtual relationships and use functions like RELATED, USERELATIONSHIP, and RELATETABLE.
09
Iterator Functions
Learn about iterator cardinality, nested iterators, and context transition with functions like SUMX, COUNTX, and RANKX.
10
Time Intelligence Functions
Create calendar tables and compare custom time periods with functions like DATESYTD, DATEADD, and CALENDAR.
Sign Up
Training