Course Icon Excel Training

Excel DAX for PowerPivot

Designed for Excel versions 2016,2013,2010

0800 1337 401

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.

Experience Required

This course is suitable for any existing Excel user who has attended the PowerPivot Introduction course or has a good working knowledge of PowerPivot.

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
See all of the available Seven Institute Excel Courses