DAX for SQL Developers

Learn how to transfer your knowledge of SQL to DAX and vice versa

schedule4 hours
play_circle18 videos
unfold_more27 exercises
trending_up508 xp

Let’s create your free account

OR

By continuing, you accept our Enterprise DNA Terms & Conditions , our Privacy & Cookie Policy and that your data is stored.

If you have an account Login here

Trusted by 220,000+ people worldwide.

coca-cola-logouniliver-logonhs-logonestle-logoatt-logoanglo-logomackinsey-logoalbemarle-logojonson-logopanasonic-logo

An outline of this training course

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.

DAX and SQL have a lot of things in common. First of all, both work with a database. SQL works with Relational Database Management System (RDBMS), whereas DAX typically 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.

When you use the import mode in Power BI or SSAS, the internal queries that are executed are called as xmSQL, which is just a pseudo SQL language.By comparing SQL and DAX side by side, you can migrate your knowledge of SQL to DAX and can make your DAX journey much easier.

This is the reason we created this course, DAX for SQL Developers, where Enterprise DNA Expert, Antriksh Sharma, walks you through the many similarities of DAX and SQL.

DAX for SQL Developers is an intermediate level course that expects the attendees to have gone through both DAX and SQL courses; as well as, Antriksh's DAX Studio for Power BI/SSAS and DAX Optimization Masterclass Using DAX Studio courses.


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

What you get with the course

  • Over 4 hours of intensive training videos
  • Resource pack

What our

Students Say
Curriculum
1

Course Overview


2

Installing Necessary Software


3

SQL vs DAX


4

Conclusion


5

Your Feedback


6

Certification


7

Continuous Learning


Your

Instructor
Empty image or helper icon

Antriksh Sharma

We are always looking for the best solution for you

Frequently Asked

Questions

Recommended

Courses
Course Cover: Integration, Analytics, and Governance for MS Fabric
intermediate
Total points: 744 XP clock-blue 6 hours

Integration, Analytics, and Governance for MS Fabric

Covers advanced data management techniques, including workspace setup, pipeline development, and Gen2 data flows, using Microsoft Fabric and Azure for secure, efficient data handling and governance.
Tools
Other Tools
Henry Habib
Henry Habib
See details
Course Cover: Data Management and Processing in Microsoft Fabric
intermediate
Total points: 279 XP clock-blue 2 hours

Data Management and Processing in Microsoft Fabric

Covers OneLake data management, security, workflow shortcuts, lakehouse vs. warehouse architecture, Apache Spark fundamentals, notebook use, and Spark job monitoring, equipping learners with key data analysis skills.
Tools
Other Tools
Skills
Data Transformation
Data Analysis
Henry Habib
Henry Habib
See details
Course Cover: Foundations of Microsoft Fabric
intermediate
Total points: 231 XP clock-blue 2 hours

Foundations of Microsoft Fabric

Provides an in-depth exploration of Microsoft's analytics platform, covering essential topics such as data engineering, warehousing, and analytics. It blends theoretical knowledge with practical applications, focusing on leveraging OneLake, Delta Lake, and Power BI for comprehensive data solutions. This course equips participants with the skills to navigate and utilize Microsoft Fabric for advanced analytics projects.
Tools
Other Tools
Skills
Data Transformation
Data Analysis
Henry Habib
Henry Habib
See details

Get full access to unparalleled

training & skill-building resources
power-bi-custom-visuals

FOR INDIVIDUALS

Enterprise DNA

For Individuals

Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities.

Learn More chevron_right

FOR BUSINESS

Enterprise DNA

For Business

Training, tools, and guidance to unify and upskill the data analysts in your workplace.

Learn More chevron_right
power-bi-custom-visuals