What You Need to Know Before
You Start
Starts 8 June 2025 06:22
Ends 8 June 2025
00
days
00
hours
00
minutes
00
seconds
3 hours 48 minutes
Optional upgrade avallable
Not Specified
Progress at your own speed
Paid Course
Optional upgrade avallable
Overview
As a DAXdeveloper you've probably written many measures, expressions and code for calculated columns. But, DAXis also a full featured and powerful query language for retrieving data in a table format, much like SQL.
There is much more to being a professional DAXdeveloper than just writing measures.
Syllabus
- Introduction to DAX Queries
- Fundamentals of DAX Query Syntax
- Working with DAX Functions for Querying
- Advanced DAX Query Techniques
- Optimizing DAX Queries
- Practical DAX Query Scenarios
- Tools and Resources for DAX Developers
- Conclusion and Next Steps
Overview of DAX as a Query Language
Comparison with SQL
Use Cases for DAX Queries
Understanding EVALUATE
The CALCULATETABLE Function
Using FILTER, SUMMARIZE, and ADDCOLUMNS
Aggregation Functions in DAX Queries
The Role of Iterator Functions
Time Intelligence in Queries
Querying Complex Data Models
Using Variables in DAX Queries
Implementing Row-Level Security
Best Practices for Performance Improvement
Understanding Query Plans and Storage Engine
Building Reports with DAX Queries
Real-world Scenarios and Challenges
DAX Studio for Query Analysis
Power BI and DAX Integration
Efficient Query Writing Strategies
Expanding into Advanced DAX Topics
Taught by
Randy Minder
Subjects
Business