Power BI DAX Super User: DAX for Power Nerds [2024]
Delve deep into the DAX functional language and learn to build complex DAX formulas to retrieve the answers you need!
What you will learn
Understand Database Normalization and Relationships
Learn why you need a Rolling Calendar when you have date fields
Learn a multitude of functions in six DAX Category types
Install and create new stunning visuals with unique slicers
Why take this course?
Welcome to my intermediate level for Power BI users who want to delve deeper into the DAX functional language. After taking my Power BI Data Analysis Course (for beginners) you now will be ready to take your skills to the next level and really get a grasp on the DAX language that is used in Power BI formulas.
In this course we will implement over 30 DAX functions from across nine different categories:
Conditional & Logical Functions
IS Functions
Date & Time Functions
Conversion Functions
Math & Stats Functions
Text Functions
Iterator Functions
Time Intelligence Functions
Table & Filter Functions
Infamous CALCUALTE Function
I will teach you how to problem solve your formulas and how to build them in pieces, so they are easier to understand and use that knowledge to have your measures call other measures. Not to mention learn to build a measures table to hold all the measure you will create for your report to keep them organized and all in one place.
You will also learn the need to have a rolling calendar and the benefits it provides for those people who have a multitude of tables with date fields and how the table will auto adjust its dates as new data is added.
All that combined with installing appealing new visuals from the marketplace and using stunning slicers to make your reports more interactive for your user. By the end of this course, you will have the confidence to build out your formulas to get the results you need and the visually appealing new visuals on your reports that show the results of your data analysis for the company!