Home >
Microsoft BI >
DAX Formulas for Microsoft PowerPivot
DAX Formulas for Microsoft PowerPivot
| Course Code: |
BIMDAX |
| Currency: |
Excel 2010 |
| Duration: |
1 day |
| Audience: |
Excel Power Users and BI Consultants/BI Developers. |
| Prerequisites: |
Completion of our course Microsoft PowerPivot for Excel or equivalent knowledge. |
| Summary: |
This hands-on course extends PowerPivot workbook
functionality using Data Analysis Expression language (DAX) to
define calculated columns and measures that perform:
- Dynamic aggregation
- Comparative time/date-based analysis
- Recursive calculations
- Etc.
|
| Objectives: |
Upon completion of this course, the delegate should be able to
construct a variety of DAX formulas to analyse PowerPivot models.
|
| Format: |
Hands-on 70%, lecture 30% |
Detailed Outline |
|