Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
8 Hour(s) 20 Minute(s)
Language
English
Taught by
ajay parmar
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
DAX learning in BI - From Basic to Advance - Part1/2
What is DAX Measure and Calculated Column (This is Part1 series of DAX)
What is the difference between Measure and Calculated Columns in terms of functioning and fundamentals.
Which one is better or which one to choose while writing DAX Formula in PowerBI
To begin with , Learn first how to write DAX in PowerBI window. How to write SUM,AVERAGE,COUNT,MAX,MIN,DIVIDE . Its different from excel in terms of fundamental.
Learn amazing DAX functions like SUMX, COUNTX,FILTER
How to use One DAX into another DAX ,If situation demands.
What is a DAX Studio and how it can help you in understanding DAX
Most versatile and used DAX in POWERBI - CALCULATE - From basic to advance
Utmost important DAX like - ALL , ALL SELECTED, ALL EXCEPT
Mixing of ALL with CALCUALTE to yield powerful results
How to write IF dax as a calculated column
How to write IF as a measure. Its fundamentals which is important.
Use of DISTINCT and DISTINCTCOUNT and what is the difference between them.
How to handle multiple conditions in a simpler manner using SWITCH Dax. Its alternate to your IF Dax.
What is IN and NOT dax. Check out their use.
Get ready for surprise Tests.
Ask anything on the forum related to DAX. You will have my support .
TEXT Functions like LEFT, RIGHT, MID , FIND, SUBSTITUE - Learn their importance in Data crunching.
How to find out top or bottom scores in a table. For eg, how to find top scorers or sales revenue values . Learn TOPN in full detail.
Course Content
- 1 section(s)
- 19 lecture(s)
- Section 1 Introduction to DAX - This is Part1/2
What You’ll 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.
Skills covered in this course
Reviews
-
PPiyush
course is well and also need to add the interview topics in the course like how an interviewer ask any question on that particular topics. if this thing will add this will be the best course for power bi.
-
PParas Udani
Excellent explanation and best course for understanding the science behind DAX.
-
KKim Mamula
He goes in-depth on a number of DAX functions and gives lots of examples. Great course.
-
AAvinash Ray
It was a wonderful experience. Learn a lot of things in an easy way.
