Writing DAX Queries
IC1352

Writing DAX Queries

Data Analysis Expressions (DAX) is the native formula and query language for Microsoft PowerPivot, Power BI Desktop, and SQL Server Analysis Services (SSAS) Tabular models. The goal of this course is to teach you 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.


Course Goal

  • Understand the tools available to write full DAX queries
  • Learn how to construct a DAX query
  • Review how to export the results of your DAX queries to CSV and SQL Server
  • Learn how to write common T-SQL queries as DAX queries
  • Understand the difference between a DAX measure and a full DAX query

Who This Training Is For

  • Developers

Exam/Certificate

  • Certificate of Completion (more certification info)
  • Upon successful completion of this course, receive your Writing DAX Queries certificate

Instructor

Randy Minder

5.0 Average Rating

3 Reviews

4 Students

2 Courses

Randy Minder

Siesta Key Software, LLC - Founder

Microsoft Certified Professional: Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI (January 2019) Seasoned database architect (OLTP, data warehouses, operational data stores), tabular modeling, business intelligence, and Power BI. 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 40,200 (top 1%).


Students Also Bought:

Intermediate SAP System Administration
Intermediate SAP System Administration

Imagine yourself as an SAP System Administrator for a Fortune 500 company. Start your journey today by learning inter...

4.5

Average Rating

Basic SAP System Administration
Basic SAP System Administration

Want to be an SAP System Administrator? The SAP Basis component (BC) is the underlying component that the SAP system ...

4.7

Average Rating

SAP ABAP Working with Data Basics
SAP ABAP Working with Data Basics

Programming alone in SAP ABAP isn't enough to be a developer. This course will teach you the fundamental skills t...

4.5

Average Rating

View All Courses

Student Feedback

5.0

Average Rating

Reviews

Language: English
Level: Intermediate
Duration: 3.5 hours
Type:  Instructor-led
Category: Microsoft

Training 5 or more people?

Unlimited access for your entire SAP team.

SAP Training for Businesses