Hello Everyone!

I have just launched a new Class Unleashing Excel Power Pivot & DAX

Click here to go to the class (You can also get 1-month free premium membership if you're not a premium member)

In this 7.5 hours class, we take you from a complete beginner to a well-rounded intermediate user of Power Pivot & DAX, where you will learn the following:

How to load data into the data model using Power Query
How to build a data model, create relationships and the types of relationships
We explain Measures & Calculated Columns and the difference between them
we explain Row vs Filter context
How to use RELATED() & RELATEDTABLE() functions
How to use DAX Studio to troubleshoot your formulas and verify your results
We explain Iterator functions where we explain SUM() vs SUMX(), AVERAGE() vs AVERAGEX()
We also dedicate a few videos to explain the FILTER() function in DAX with different case scenarios
We also explain how to use table functions such as ALL(), ALLSELECTED(), VALUES() & DISTINCT() to manipulate your filter context
And of course we explain the most important function in DAX which is the CALCULATE() function in depth. we explain the different case scenarios for using it and how to manipulate the filter context in any way you like to achieve your desired results.
And Last, we explain Time Intelligence in DAX, where we explain how to build a calendar table from scratch, and perform Time Intelligence calculations such as YTD, Previous Periods, Moving Running Total, Moving Average & Weekly Time Intelligence Calculations
You will also be getting all the needed Example files to follow along and you will be having exercises along with answers throughout the course in order to get hands-on practice!

I'm confident that you would be getting immense value out of this class and that you would feel a remarkable boost in your Excel skills after taking the course!

Regards,

Abdelrahman

Abdelrahman Abdou

Experienced Excel & Power BI Trainer

634

69