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%
View full outline in PDF formatDetailed Outline Bookmark and Share

print  |  top of page