Excel Training
Excel DAX for PowerPivot
Course Objectives
This course is designed for people who need to understand how to use the Data Access Expression language (DAX) to create formulas to add further analysis to the Data Model or the Pivot Table.
Who Should Attend
This course is suitable for any existing Excel user who has to manipulate, analyse and report on massive amounts of data.
Course Syllabus
GETTING STARTED WITH DAX FOR POWERPIVOT
- Overview of connecting to data sources
- Overview of creating the Data model
- What Is DAX?
- Where to Write DAX
- Introduction to creating Calculated Columns
- Introduction to Measures (Calculated fields)
- How to write DAX
- Operators and Operator Precedence
- Data Types
DAX AGGREGATE FUNCTIONS IN POWERPIVOT
- Sum, Average, Min, Count, Counta and Max functions
- Sumx, Averagex, Minx, Countx, Countax and Maxx functions
- Statistical functions and Sum(), Sumx() functions
DAX FUNDAMENTAL FUNCTIONS FOR POWERPIVOT
- Filter, Logical and Miscellaneous functions
- All Function
- AllExcept function
- Calculate function
- Calculatetable function
- Related function
- Relatedtable function
- Filter function
- IfError function
- Distinct function
- Earlier function
DAX DATE AND TIME FUNCTIONS FOR POWERPIVOT
- Date function
- Hour function
- Month function
- Year function
- Day function
- Weekday function
- Weeknum function
DAX TEXT FUNCTIONS FOR POWERPIVOT
- Concatenate function
- Left function
- Right function
- Trim function
- Substitute function
DAX MATH ADN TRIG FUNCTIONS FOR POWERPIVOT
- Int function
- MOD function
- Round function
- Roundup function
- Rounddown function