Курс M55108: Excel PowerPivot DAX in Depth

Цена для физических лиц, р.: 12950
Цена для юридических лиц, р.: 12950

Продолжительность курса (дней): 2

Даты (день):

Даты (вечер):

Цель:

Необходимая подготовка:

Формат обучения, регистрация на курс:

План курса:

• Module 1: Course Overview
• Module 2: Introduction to DAX
• Module 3: Using DAX Functions
• Module 4: Understanding Evaluation Contexts
• Module 5: Working with Dates
• Module 6: Utilizing Advanced DAX Functionality

Module 1: Course Overview

• Introduction
• Course Materials
• Facilities
• Prerequisites
• What We'll Be Discussing

Module 2: Introduction to DAX

• Introduction to DAX
• Explaining Syntax
• Exploring Data Types
• Utilizing Operators
• Understanding Values
• PowerPivot Data Model
• Handling Errors
• Lab : Introduction to DAX
  • DAX Syntax
  • DAX Data Types and Operator Overloading
  • DAX Operators
  • DAX Values

Module 3: Using DAX Functions

• Mathematical Functions
• Statistical Functions
• Logical Functions
• Information Functions
• Text Functions
• Conversion Functions
• Aggregation Functions
• Relational Functions
• Lab : Using DAX Functions
  • Mathematical Functions
  • Logical Functions
  • Conversion Functions
  • Aggregation Functions
  • Relational Functions

Module 4: Understanding Evaluation Contexts

• The CALCULATE Function
• Filter Functions
• Single Table Evaluation Context
• Multiple Table Evaluation Context
• Lab : Understanding Evaluation Contexts
  • Calculated Fields
  • Calculated Columns
  • Evaluation Contexts

Module 5: Working with Dates

• Date Functions
• Working with Calendars
• Using Multiple Calendars
• Lab : Working with Dates
  • Date Calculations

Module 6: Utilizing Advanced DAX Functionality

• Many-to-Many Relationships
• Banding
• EVALUATE
• Simplifying Your Life with DAX Studio
• Lab : Utilizing Advanced DAX Functionality
  • Advanced DAX