Power BI DAX transition from SQL

Power BI DAX step by step approach parallel with SQL. A practical approach to learn DAX in Power BI.

4.25 (106 reviews)

Udemy

platform

English

language

Data & Analytics

What you will learn

You will learn how to write Power BI DAX expressions against SQL queries.

How to import raw data into SQL server for comparisons

Data Validation

How to write complex filters

Use of Select & Evaluate to fetch the Data

Selectcolumns function in DAX and SQL

How to sort results in DAX and SQL

How to create calculated column in DAX and SQL

Distinct records in DAX and SQL

How to fetch unique records using Summarize function

Power BI Coalesce function in DAX and SQL

Custom column using Summarize and Selectcolumns function

Countrows with Summarize for grouping

Naturalinnerjoin and Inner join in DAX and SQL

Having clause in DAX and SQL

Cross join in dax and SQL

Summarizecolumns in DAX and SQL

IN operator in DAX and SQL

Search string in DAX and SQL

TopN results in DAX and SQL

Generate with TopN in DAX and SQL

Why take this course?

During my more than 10 years of experience in the area of Data Analysis & Business Intelligence, I see people feel not comfortable when they move from SQL track to Power BI DAX. Anyone can take this course who want to learn Power BI DAX in a practical way. People who have experience with SSRS reporting services and if they want to learn what will be the equivalent of SQL in DAX, this course will help you understand Power BI DAX in a very easy step by step approach.

This course is purely based on DAX studio and SQL. First, we write SQL query and then we try to achieve the same results in DAX studio. I updated all of the courses available on Udemy regularly with the latest updates from Microsoft.

This is one of the unique courses available on Udemy that takes SQL and DAX Power BI together.

This course includes the following topics.

- How to import data into SQL from Excel?

-Data Validation

-Use of Select & Evaluate to fetch the Data

-Selectcolumns function in DAX and SQL

-How to sort results in DAX and SQL

-How to create calculated column in DAX and SQL

-Distinct records in DAX and SQL

-How to fetch unique records using Summarize function

-Power BI Coalesce function in DAX and SQL

-Custom column using Summarize and Selectcolumns function

-Filtering record set in DAX and SQL

-Multiple logical conditions with Filter and Selectcolumn

-Countrows with Summarize for grouping

-Use of Addcolumns to achieve aggregation

-Addcolumn with Selectcolumn

-Addcolumns with Summarize function

-Calculatetable to filter recordset

-Calculatetable vs Filter function

-When to use calculatetable and filter function

-Naturalinnerjoin and Inner join in DAX and SQL

-Naturalinnerjoin and no physical relationship

-Alternatives of Natural Inner join in DAX

-Having clause in DAX and SQL

-Left outer join in dax and sql

-Cross join in dax and SQL

-Summarizecolumns in DAX and SQL

-Summarizecolumns with measure

-IN operator in DAX and SQL

-Search string in DAX and SQL

-Search string from left or right in DAX and SQL

-TopN results in DAX and SQL

-Generate with TopN in DAX and SQL

About me

I am your instructor Muhammad Asif Microsoft certified solutions expert in data management & Analytics. I have more than 10 years of experience in Microsoft BI stack with world-leading financial Firm. You will learn what exactly is used in the industry.

Screenshots

Power BI DAX transition from SQL - Screenshot_01

Power BI DAX transition from SQL - Screenshot_02

Power BI DAX transition from SQL - Screenshot_03

Power BI DAX transition from SQL - Screenshot_04

Reviews

Fredrick

July 7, 2022

The explanations and videos are straightforward, no more no less. It demonstrates the procedure right away, well recommended.

Mathew

June 14, 2022

Good course, and I appreciate the SQL then DAX. The only detractor is that last lesson, while super interesting, unnecessarily complex and disjointed. Also, would have been helpful for a review or summary for each section and course. These are criticisms to improve a good course, and if you know SQL but just starting your journey with PowerBI/DAX I highly recommend it!

Daniël

December 5, 2021

The content of the course is good and as expected. The sound is terrible and would have been nice to get "final" code for the SQL and DAX.

Steven

December 1, 2021

The premise of this course is fantastic for someone used to SQL and wanting to translate it into DAX. The sections cover these offer. Where it is let down is in both the silly mistakes in typing, errors in execution and saying the wrong column names when typing something different. I would also expect some more time spent on why the specific DAX functions are used and the values as they are glossed over rather than explaining their benefit, as well as what is trying to be achieved. Just re-recording it with more comfort in the material and being more prepared would quickly improve this course and remove the issues that distract from the teaching. Adding the explanations would propel it to a must do course. And a cheat handout at the end would be the cherry on the top. A great first attempt.

Adolfo

May 29, 2021

recomendaria ajustar la pantalla para evitar mover tanto las imagenes y simplificar tb los ejemplos de sql en algunos casos inicialmente me parece hay explicacion redudante

Brian

March 10, 2021

Complete focus and no distraction to other topics. Plain demonstrations of SQL and DAX. Solid material

Jorge

August 13, 2020

If you are coming from SQL Server and need to learn about Table Expressions in DAX this is a good course. I didn't give it 5 stars because the author wastes a lot of time typing the code. On top of that, the code is a bit messy for my taste: no indentations, uppercase, lowercase, extra spaces... Also, the author spends more time explaining the SQL queries than the DAX code. A little bit more of DAX theory and organization would have made this course much better. Don't get me wrong, there is a lot to learn from these lessons, recommended!

Alex

May 5, 2020

Another unique course from you to learn dax in parallel with sql. I would say this course build strong base to dive into power bi dax world from SQL. thanks dude

Charts

Price

Rating

Enrollment distribution

Power BI DAX transition from SQL - Distribution chart