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

4 Reviews

21 Students

3 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 engineer (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#. Experience in forming and managing software development teams having successfully formed and managed development teams for two startup companies in the last 15 years.

An accomplished author of over a dozen courses on Power BI and DAX. Last seven years as a lead database engineer, business intelligence, ETL, Power BI, and Microsoft Azure data architect. 2016 Nominee for the First Solar Business Enablement CEO Award for Analytics Tools & Methods Infrastructure. StackOverflow reputation of 43,000 (top 1%)

Student Feedback

5.0

Average Rating

Reviews

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

Training 5 or more people?

Unlimited access for your entire SAP team.

SAP Training for Business