DAX for SQL Developers
Learn how to transfer your knowledge of SQL to DAX and vice versa, and how to operate 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
Here's What You'll Get
With The Course
Over 4 hours of intensive training videos
Resource pack
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
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 Power BI
- 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
Your Instructor
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 On-Demand Subscription.
- Can I purchase a single course instead of the Enterprise DNA On-Demand? The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full On-Demand Subscription 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 On-Demand Subscription or For Business access to receive support.
- What if I need to train my team? We recommend exploring Enterprise DNA For Business. To learn more, see here.
Get full access to unparalleled training
& skill-building resourcess
For Individuals
Enterprise DNA
On-Demand
Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities
For Teams
Enterprise DNA
For Business