Source
https://www.udemy.com/course/powerpivot-with-dax-basic-to-advance-13-hours/
Category
File Size
9.2 GB
Publisher
udemy
Updated
June 19, 2026
Description
Section1: We are covering Power Pivot with Dax
- What is a PowerPivot and Why do we need it. How it is going to outshine our normal Pivots
- Import data from different sources like Excel, CSV Files or Text files or any other database.
- Get familiar with PowerPivot ribbon and sorting ,filtering options- all basic features
- Know the place to write Measures and Calculated Columns.
- What is DAX – A formula language. It is in very detail.
- Difference between Measures and Calculated Columns – Which one better and which should you choose?
- Basics DAX Functions – SUM,COUNT,COUNTA,COUNTBLANK, – Why they called Aggregate Functions .
- Are they DAX Measure or Calculate columns – All Confusion is cleared.
- Different Types of DAX Functions – ITERATORS – SUMX , COUNTX, AVERAGEX
- Why they are called ITERATORS – Its fundamentals
- Learn the most used and Powerful DAX – CALCULATE – It is also famous as CALCULATE IF, Know why?
- Deep Dive into ALL FAMILY FUNCTIONS – ALL / ALL SELECTED/ ALL EXCEPT with examples
- What is the role of ALL DAX in your Data analysis – Control the data the way you want.
- Practical Time – How to calculate overall percentage of different products based on the Team Total?
Preview
1 image
