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

CONTENUTI:

Module 1: Course Overview

Introduction

Course Materials

Facilities

Prerequisites

What We'll Be Discussing

Lab : Course Overview

Module 2: Exploring Data Modeling

Differences Between Excel 2010 & 2013

PowerPivot for Excel Add-In

PowerPivot Data Model

VLOOKUP vs Relationships

Relationships

Lab : Exploring Data Modeling

Module 3: Introduction to DAX

Introduction to DAX

Explaining Syntax

Exploring Data Types

Utilizing Operators

Understanding Values

Handling Errors

Lab : Introduction to DAX

DAX Syntax

DAX Data Types and Operator Overloading

DAX Operators

DAX Values

Module 4: 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 5: 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 6: Working with Dates

Date Functions

Working with Calendars

Using Multiple Calendars

Lab : Working with Dates

Date Calculations

Date Calculations

Module 7: Utilizing Advanced DAX Functionality

Many-to-Many Relationships

Banding

Evaluate

Simplifying Your Life with DAX Studio

Lab : Utilizing Advanced DAX Functionality

Advanced DAX

Module 8: Examining Patterns

Walkthrough a Basic Pattern

Lab : Examining Patterns

Explore the workbook New and Returning Customers Basic Pattern – Modified for 55108