Platform Access

DAX for SQL Developers

Learn how to transfer your knowledge of SQL to DAX and vice versa , operates on an internal database that is hosted by Analysis Services, but can also work with data hosted on a relational database in the case of DirectQuery.

Enroll Now
 SQL for Power BI Users

Here's What You'll Get

With The Course

Over 4 hours of intensive training videos

Resource pack

 SQL for Power BI Users

Make your DAX journey easier by upgrading your knowledge of SQL

  • The DAX for SQL Developers course is the mirror image of our SQL for Power BI users. That course was intended to make learning SQL easier for those already with a knowledge of DAX. 
  • This course leverages users’ knowledge of SQL to provide additional insight into how DAX works for the purpose of improving your DAX coding skills.

Details Of What You Will Learn

During This Course

  • Compare - DAX and SQL and determine how you can utilize your SQL knowledge in using DAX
  • Learn - how to perform operations such as SELECT, WHERE, HAVING, GROUP BY etc in DAX
  • Compare - the difference between xmSQL and SQL
  • Practice - getting unique values and adding new columns
  • Apply - the technique of joining tables
  • Learn - how to append and subtract tables
  • Solve - regular business scenarios such as Running Total and % Over Total, etc with both DAX and SQL
 SQL for Power BI Users

This Course Module is Tailored for:

Data Analysts

Reporting Managers

Excel Users

This course is designed for those who have little to no knowledge of Power Apps but are working in data-driven environment.

LEARN HOW TO

Utilize the key features within the DAX

for SQL Developers

 SQL for Power BI Users
  • Perform operations such as SELECT, WHERE, HAVING, GROUP BY etc in DAX
  • Learn to compare SQL and DAX side by side
  • Get unique values and adding new columns
  • Determine how you can utilize your SQL knowledge in using DAX

Course Curriculum

1. DAX for SQL Developers - Course Overview

  • Course Overview
  • Let's Get Started!
  • Resources
  • Introduction

2. Installing Necessary Software

  • Installing SQL Server
  • Installing DAX Studio
  • Creating and Loading Views

3.SQL vs DAX

  • SELECT
  • SQL vs xmSQL
  • DISTINCT VALUES
  • Adding New Columns
  • WHERE
  • HAVING
  • Multiple OR vs IN
  • TOP
  • EXISTS vs ISEMPTY
  • Joining Tables
  • INTERSECT UNION EXCEPT
  • Running Total
  • % Over Total

What our Students Say

Your Instructor

Antriksh Sharma

Antriksh Sharma

  • Extensive expertise in Power BI, Power Pivot, Power Query, SSAS, DAX, optimizing DAX, and SQL
  • Author/instructor of Enterprise DNA courses on Tabular Editor 3, DAX Studio and Optimizing DAX
  • Enterprise DNA Expert, known on our forum as the “go-to guy” for your toughest DAX questions
  • Creator of popular AntmanBI blog and YouTube channel providing in depth info on Power BI, Excel and SQL
  • Experienced in in Core Python and Python libraries for data analytics (e.g., Pandas/NumPy/Matplotlib/Seaborn etc.
  • Super User on Microsoft’s Power BI community platform

Frequently Asked Questions

  • How long do I have access to the course? You have access to this course as long as you have Enterprise DNA Membership Subscription.

  • Can I purchase a single course instead of the full Enterprise DNA membership? The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full membership here.
  • Do you offer one-off support or coaching? All support around Power BI and Enterprise DNA's online training content now occurs at the Enterprise DNA Forum. You must have an Enterprise DNA Membership or CoE access to receive support.

  • What if I need to train my team? We recommend exploring Enterprise DNA Center of Excellence platform. To learn more, see here.

Get full access to unparalleled training

& skill-building resourcess

For Individuals

Enterprise DNA

Membership

Empowering the most valuable Power BI users to expand their analytical thinking and insight generation possibilities

membership enterprise dna

For Teams

Enterprise DNA

Center of Excellence

Training, tools, and guidance to unify and upskill the Power BI analysts in your workplace