LEARN DAX IN POWERBI DESKTOP – Part 1/2

DAX learning in BI - From Basic to Advance - Part1/2

Created by: ajay parmar
Instructor -Excel,Vba ,Access, Access Vba,BI,PQ,G SHEETS

What Will I Learn?

• You will learn DAX Functions - Data analysis Expression. The formula language used to do calculations on numbers and text in PowerBI.
• We are starting from zero level so if you already know PowerBI Desktop you are good to go.
• There are 15 chapters in this Part1 series. You will learn basic plus other important DAX functions one by one with live examples which can help you in gaining practical understanding.
• Start with Basic DAX Functions like AVERAGE,DIVIDE,PRODUCT,COUNT. It is different in many ways from Excel functions.
• ALL, ALLSELECTED, ALLEXCEPT,SWITCH() WITH REAL EXAMPLES IN A GREAT DETAIL with Surprise Tests as well.
• IF CONDITIONS,SUMX,DISTINCT,DISTINCTCOUNT - From definition to real use - We will have deep dive into all functions.
• COUNTAX,COUNTX, SUM,SUMX,CALCULATE,FILTER DAX. Their meaning and their practical use. Its awesome.
• What if i want to use DAX as a measure and same as calculated column. How can i make sure which is right for me?
• What is row by row context and filter context. Why it is important to know and how it helps in understanding the DAX
• ALL TEXT DAX Functions like LEFT, RIGHT, MID. FIND, SUBSTITUE . Learn how to use them in BI window .
• Surprise Tests for you in the course. Check how well you are understanding the topics.

Requirements

• You should be familiar with BI Desktop. Atleast, you should know the basics like how to create visualizations and import data from excel into Power BI

Target audience

• Wannabe Business Analysts , MIS Analysts. Basically, those who want to make career in Data Analysis.
• All Excel enthusiast and VBA Developers who want to do any sort of analysis on numbers and put them in dashboards via DAX