Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

---

Course Overview

This course is intended for Power Users, Business Intelligence Developers and IT Professionals who will be involved with the development of Excel PowerPivot queries and tabular modelling. The course is intended to expose the delegates to the technology of DAX and to familiarise them with functionality of DAX at an advanced level.

 Prior experience with Excel and Microsoft SQL query writing is useful.

Duration: 2 day course

---

Course Content

Introduction to DAX
Introduction to DAX
Explaining Syntax
Exploring Data Types
Utilizing Operators
Understanding Values
PowerPivot Data Model
Handling Errors

Using DAX Functions
Mathematical Functions
Statistical Functions
Logical Functions
Information Functions
Text Functions
Conversion Functions
Aggregation Functions
Relational Functions

Understanding Evaluation Contexts
The CALCULATE Function
Filter Functions
Single Table Evaluation Context
Multiple Table Evaluation Context

Working with Dates
Date Functions
Working with Calendars
Using Multiple Calendars

Utilising Advanced DAX Functionality
Many-to-Many Relationships
Banding

Email us about this courses


Telephone on 01952 938014