Home | Trainings | Microsoft 365 | Excel | Excel: Power Pivot (DAX)

Excel: Power Pivot (DAX)

Functions for powerful data analysis

Type: Classical courses, Remote training
Duration: 1 day (09:00-17:00)
Price in-company training (excl. VAT): 1.490 EUR
Price remote training (excl. VAT): 1.425 EUR
Number of people: 1-12p

Description

Excel’s strong data analysis tool Power Pivot? Get to know it better during our training course ‘Excel Power Pivot – (DAX) Functions’!

You may already have noticed that Power Pivot contains a lot of new functions. Some of these functions are fairly intuitive to use, but for most you may need the help of a Power Pivot expert, using explicit examples to show you the true power of these functions in combination with PivotTables.

Sign up now for the course ‘Excel Power Pivot – (DAX) Functions’ and optimize your knowledge.

Objectives

Are you struggling with the functions in PowerPivot?

Register now, to:

  • Acquire an understanding of the different types of functions in PowerPivot
  • Know how to implement the functions for your own analysis solutions

Target Group

Anyone who is already familiar with PowerPivot and wants to learn more about and know how to use the functions.

Prerequisites

It is important to have completed the course ‘Excel PowerPivot – Introduction’.

Content

Repetition of Data model

Context

Basic functions

Iterator functions

Changing Context

Filter functions

Date and Time Intelligence functions

KPI (Key Performance Indicators)

Cube Functions (Optional)

Working with multiple data fields (optional)

Book this training

Let's start a conversation!

Team Xylos is ready to meet you