Udemycoupon.id

Free deals, coupons, discounts for learners

Post Top Ad

Friday, May 14, 2021

Power BI DAX transition from SQL [Free 100% off premium Udemy course coupon code]

Image for course Power BI DAX transition from SQL

Discount FREE 100% Off

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.

What you'll learn?

  • IN operator in DAX and SQL
  • Generate with TopN in DAX and SQL
  • Countrows with Summarize for grouping
  • How to create calculated column in DAX and SQL
  • Power BI Coalesce function in DAX and SQL
  • Summarizecolumns in DAX and SQL
  • Use of Select & Evaluate to fetch the Data
  • Having clause in DAX and SQL
  • How to import raw data into SQL server for comparisons
  • Search string in DAX and SQL
  • Data Validation
  • How to fetch unique records using Summarize function
  • How to write complex filters
  • Selectcolumns function in DAX and SQL
  • Naturalinnerjoin and Inner join in DAX and SQL
  • TopN results in DAX and SQL
  • Custom column using Summarize and Selectcolumns function
  • Cross join in dax and SQL
  • You will learn how to write Power BI DAX expressions against SQL queries.
  • How to sort results in DAX and SQL
  • Distinct records in DAX and SQL

Requirements and What you should know?

  • Prerequisites are not mandatory but it is helpful to know little bit about SQL queries and Power BI

Who is this course for?

  • SQL Developers
  • Business Intelligence consultants
  • Data Analyst
  • BI Developers
  • Data Scientists
  • Power BI users

What is this course about?

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.


To get a course with a coupon code given by the instructor, you can click or touch the following button.

If the coupon code above doesn't work, check the FAQ page to find out more about coupon codes.

course-id:af06fdfd-26ac-44f0-9013-e19432a05a51
course-coupon-id:1dce849a-94d5-43ce-96aa-946fea70e7e0
blogpost-id:ebf61451-ddc7-4134-b070-c53b8b7fb077
100%
off
Free discount
Friday, May 14, 2021

We’ll never share your email address with a third-party.