Il corso ha lo scopo di esporre a PowerPivot i Data Analytics Expressions (DAX). Concetti come: il modello di dati, il contesto di valutazione, le funzioni DAX, gli operatori e le costanti. Questa versione aggiunge un modulo sul modello di dati, una introduzione ai modelli, e ha le versioni di laboratorio sia per Excel 2010 che 2013.
E' utile una pregressa esperienza con Excel e con la scrittura di query in Microsoft SQL.
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