Course Code: 18966

55108 Discovering the Power of Excel PowerPivot Data Analytic Expressions (DAX)

Class Dates:
5/27/2021
7/29/2021
Length:
2 Days
Cost:
$995.00
Class Time:
Technology:
Business
Delivery:
Instructor-Led Training

Overview

  • Course Overview
  • 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
  • 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.

Prerequisites

Course Details

  • 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.
  • Module 1: Course Overview
  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing
  • Module 2: Exploring Data Modeling
  • Differences Between Excel 2010 & 2013
  • PowerPivot for Excel Add-in
  • PowerPivot Data Model
  • VLOOKUP vs Relationships
  • Relationships
  • Module 3: Introduction to DAX
  • Introduction to DAX
  • Explaining Syntax
  • Exploring Data Types
  • Utilizing Operators
  • Understanding Values
  • Handling Errors
  • Lab 1: Introduction to DAX
  • Module 4: Using DAX Functions
  • Mathematical Functions
  • Statistical Functions
  • Logical Functions
  • Information Functions
  • Text Functions
  • Conversion Functions
  • Aggregation Functions
  • Relational Functions
  • Lab 1: Using DAX Functions
  • Module 5: Understanding Evaluation Contexts
  • The CALCULATE Function
  • Filter Functions
  • Single Table Evaluation Context
  • Multiple Table Evaluation Context
  • Lab 1: Understanding Evaluation Contexts
  • Module 6: Working with Dates
  • Date Functions
  • Working with Calendars
  • Using Multiple Calendars
  • Lab 1: Working with Dates
  • Module 7: Utilizing Advanced DAX Functionality
  • Many-to-Many Relationships
  • Banding
  • EVALUATE
  • Simplifying Your Life with DAX Studio
  • Lab 1: Utilizing Advanced DAX Functionality
  • Module 8: Examining Patterns
  • Walkthrough a Basic Pattern
  • Lab 1: Examining Patterns