;%20}%20%3c/style%3e%3clinearGradient%20id='linear-gradient'%20x1='2.99'%20y1='29.35'%20x2='127.75'%20y2='101.39'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20offset='0'%20stop-color='%23f2b347'%20/%3e%3cstop%20offset='.5'%20stop-color='%23ca5a8b'%20/%3e%3cstop%20offset='1'%20stop-color='%236654f5'%20/%3e%3c/linearGradient%3e%3c/defs%3e%3cg%20id='Layer_1-2'%20data-name='Layer%201'%3e%3cpath%20class='cls-1'%20d='M83.56,0H47.18C21.12,0,0,21.12,0,47.18v36.38c0,26.06,21.12,47.18,47.18,47.18h36.38c26.06,0,47.18-21.12,47.18-47.18V47.18C130.74,21.12,109.62,0,83.56,0ZM20.62,48.64c2.84-2.84,6.59-4.23,10.32-4.17,3.82,.07,7.55-1.1,10.25-3.8l.56-.56c2.7-2.7,3.86-6.43,3.8-10.25-.07-3.73,1.32-7.47,4.17-10.32,6.18-6.18,16.66-5.48,21.88,2.11,3.18,4.62,3.27,10.96,.19,15.64-3.02,4.6-7.92,6.78-12.72,6.54-3.51-.17-6.95,.99-9.43,3.48l-1.24,1.24c-2.48,2.48-3.65,5.92-3.48,9.43,.24,4.8-1.94,9.7-6.54,12.72-4.68,3.08-11.03,2.99-15.64-.19-7.6-5.23-8.29-15.7-2.11-21.88Zm33.7,34.25c-2.7,2.7-3.86,6.43-3.8,10.25,.07,3.73-1.32,7.47-4.17,10.32-6.18,6.18-16.66,5.48-21.88-2.11-3.18-4.62-3.27-10.96-.19-15.64,3.02-4.6,7.92-6.78,12.72-6.54,3.51,.17,6.94-.99,9.43-3.48l1.24-1.24c2.48-2.48,3.65-5.92,3.48-9.43-.24-4.8,1.94-9.7,6.54-12.72,4.68-3.08,11.03-2.99,15.64,.19,7.6,5.23,8.3,15.7,2.11,21.88-2.84,2.84-6.59,4.23-10.32,4.17-3.82-.07-7.55,1.1-10.25,3.8l-.56,.56Zm55.8-2.93c-2.96,2.96-6.91,4.35-10.79,4.15-3.51-.17-6.96,.99-9.44,3.48l-1.23,1.23c-2.49,2.49-3.65,5.93-3.48,9.44,.19,3.88-1.19,7.82-4.15,10.79-6.18,6.18-16.66,5.48-21.88-2.11-3.18-4.62-3.27-10.96-.19-15.64,3.02-4.6,7.92-6.78,12.72-6.54,3.51,.17,6.95-.99,9.43-3.48l1.24-1.24c2.48-2.48,3.65-5.92,3.48-9.43-.24-4.8,1.94-9.69,6.54-12.72,4.68-3.08,11.03-2.99,15.64,.19,7.6,5.23,8.3,15.7,2.11,21.88Z'%20/%3e%3c/g%3e%3c/svg%3e)
DAX for SQL Developers
Learn how to transfer your knowledge of SQL to DAX and vice versa
Trusted by 220,000+ people worldwide.
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
Course Overview
Installing Necessary Software
SQL vs DAX
Conclusion
Your Feedback
Certification
Your
Instructor
Antriksh Sharma
Enterprise DNA Expert
- 3+ years of experience in Power BI, Power Pivot, Power Query and SSAS
- 3+ years of experience in DAX, optimizing DAX, and SQL language. Likes to read DAX blogs, articles, and books in free time.
- 1+ years of experience in Core Python and approx. 6 months of experience in Pandas/NumPy/Matplotlib/Seaborn etc. Python libraries for Data Analytics.
- Super User at Microsoft’s Power BI community platform with over 80 solutions, 50 PBI solutions at Enterprise DNA’s community, and approx. 30 PBI solutions on other platforms. Passionately believes in sharing everything he knows.
- 4+ years of experience in Excel automation through VBA, likes to read VBA blogs in free time.
Frequently Asked
Questions
What’s the difference between a free account and a paid plan?
Do I need to know anything about data science or data analytics to get started with Enterprise DNA?
How will I be charged?
Can I get an invoice for my company?
Are refunds available?
Will AI take over the world and make data skills worthless?
Recommended
Courses
Understanding the Schism: The Separation of the Catholic and Orthodox Churches
Get full access to unparalleled
training & skill-building resources
FOR INDIVIDUALS
Enterprise DNA
For Individuals
Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities.
Learn MoreFOR BUSINESS
Enterprise DNA
For Business
Training, tools, and guidance to unify and upskill the data analysts in your workplace.
Learn More