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
course image

Writing DAX Queries

DAX is much more than a language for writing measures. It's also a powerful and full-featured query language
via Udemy

4052 Courses


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
  • Overview of DAX as a Query Language
    Comparison with SQL
    Use Cases for DAX Queries
  • Fundamentals of DAX Query Syntax
  • Understanding EVALUATE
    The CALCULATETABLE Function
    Using FILTER, SUMMARIZE, and ADDCOLUMNS
  • Working with DAX Functions for Querying
  • Aggregation Functions in DAX Queries
    The Role of Iterator Functions
    Time Intelligence in Queries
  • Advanced DAX Query Techniques
  • Querying Complex Data Models
    Using Variables in DAX Queries
    Implementing Row-Level Security
  • Optimizing DAX Queries
  • Best Practices for Performance Improvement
    Understanding Query Plans and Storage Engine
  • Practical DAX Query Scenarios
  • Building Reports with DAX Queries
    Real-world Scenarios and Challenges
  • Tools and Resources for DAX Developers
  • DAX Studio for Query Analysis
    Power BI and DAX Integration
  • Conclusion and Next Steps
  • Efficient Query Writing Strategies
    Expanding into Advanced DAX Topics

Taught by

Randy Minder


Subjects

Business