Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Writing DAX Queries

DAX is much more than a language for writing measures. It's also a powerful and full-featured query language
4.8
4.8/5
(224 reviews)
1,626 students
Created by

8.9

CourseMarks Score®

7.9

Freshness

9.4

Feedback

8.9

Content

Platform: Udemy
Video: 3h 20m
Language: English
Next start: On Demand

Table of contents

Description

As a DAX developer you’ve probably written many measures, expressions and code for calculated columns. But, DAX is 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 DAX developer than just writing measures.
The goal of this course is to teach the student what a complete DAX query is and how to read and write one. You’ll learn how a query is constructed, the tools available to execute your queries, exporting data and all the various DAX table functions available to help you create and manipulate data. We’ll then help make the transition from being a T-SQL developer to a DAX developer a bit easier by comparing common query scenarios.
Finally you’ll have a change to test your knowledge with 15 questions and exercises.

You will learn

✓ The difference between a DAX measure and a full DAX query
✓ The tools available to write full DAX queries
✓ How to construct a DAX query
✓ The importance of data lineage and the TREATAS function
✓ How to write common T-SQL queries as DAX queries
✓ The most common and useful DAX table functions when writing DAX queries
✓ How to export the results of your DAX queries to CSV and SQL Server
✓ 15 questions and exercises to test your knowledge

Requirements

• Some DAX experience will be helpful

This course is for

• DAX developers
Data Engineer / Business Intelligence / Power BI / Snowflake
Microsoft Certified Professional:
Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI (January 2019 – 80% score)
Snowflake Core Certification Exam (April 2021 – 90% score)
Seasoned database engineer (OLTP, data warehouses, operational data stores), tabular modeling, business intelligence. Power BI and Snowflake. 20 years of software development using a variety of Microsoft technologies, mostly C#.
2016 Nominee for the First Solar Business Enablement CEO Award for Analytics Tools & Methods Infrastructure.StackOverflow reputation of 44,000 (top 1%)
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 3h 20m
Language: English
Next start: On Demand

Students are also interested in