Community Course

Discovering the Power of Excel 2010-2013 PowerPivot Data Analytic Expressions (DAX)

55108BC (Class Pack)
Based on student feedback via 'Metrics that Matter'
Discovering the Power of Excel 2010-2013 PowerPivot Data Analytic Expressions (DAX)
This course is intended to expose the students to the technology of DAX and to familiarize them with functionality of DAX at an advanced level to produce sophisticated DAX calculations by use of the functions of DAX. This course is based on Excel Professional 2013 or higher.
Please contact your Learning Partner in order to take this course
Author: BlueBuffaloPress

Course Duration: 2 Days

SATV: Yes

About This Course

This course is intended to expose you to PowerPivot Data Analytic Expressions (DAX) concepts such as the Data Model and evaluation context, DAX functions, operators, and constants. This release adds a module on the Data Model, an introduction to patterns, and has lab versions for both Excel 2010 and 2013.

Audience Profile

This course is intended for Power Users, Business Intelligence Developers, and IT Professionals that will be involved with the development of Excel PowerPivot queries and tabular modeling.

At Course Completion

  • Understand the differences between Excel 2010 & 2013.
  • Understand and activate the PowerPivot for Excel Add-in.
  • Understand the PowerPivot Data Model.
  • Understand VLOOKUP vs relationships.
  • Understand relationships.
  • Explain and utilize DAX syntax.
  • Explain and utilize DAX data types and operator overloading.
  • Explain and utilize DAX operators.
  • Explain and utilize DAX values.
  • Explain error handling.
  • Explain and utilize mathematical functions.
  • Explain statistical functions.
  • Explain and utilize logical functions.
  • Explain information functions.
  • Explain text functions.
  • Explain and utilize conversion functions.
  • Explain and utilize aggregation functions.
  • Explain and utilize relational functions.
  • Explain and utilize the CALCULATE function.
  • Explain and utilize filter functions.
  • Explain and utilize single table evaluation context.
  • Explain and utilize multiple table evaluation context.
  • Create and configure calculated fields.
  • Create and configure calculated columns.
  • Explain and utilize date functions.
  • Explain working with calendars.
  • Explain using multiple calendars.
  • Create and configure date calculations.
  • Explain many-to-many relationships.
  • Explain banding.
  • Explain EVALUATE.
  • Explain and utilize advanced DAX capabilities.
  • Explain the benefits of DAX Studio.
  • Explain and utilize patterns.