Enable Technology

Excel 

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 305730