Webinar
This webinar is held in German.
KPIs (Key Performance Indicators) are at the heart of every analysis and therefore every report. In Power Pivot data models, these are created with the help of the DAX function library (Data Analysis Expressions). This module provides basic knowledge of how to use DAX functions to create aggregations, e.g. for status reports. You will also familiarize yourself with the control of report content. These are made possible via data slices and timelines in reports created with Power Pivot.
Contents
Choose 4 Excel snacks!
- Get to know the differences between calculated columns and measures.
- Aggregate values in Power Pivot reports.
- Understand and efficiently use the filter context of Power Pivot reports.
- Flexibly calculate shares of an overall result and use them in different report layouts.
Please note:
The module is part of the webinar series "Excel Snacks in Controlling" and cannot be booked individually. Select a total of four "Excel snacks" and improve your Excel knowledge in a targeted manner.
Learning environment
Once you have registered, you will find useful information, downloads and extra services relating to this training course in your online learning environment.
Your benefit
- You will receive a brief and concise overview of the topic and compact knowledge of the special functionality of the DAX functions.
- You will learn how to create simple aggregations and use them in multivariable reports.
- You will learn how to expand a status report with additional DAX functions, for example to calculate percentages of totals and subtotals.
- The webinar will take place live and you will have the opportunity to ask your questions and benefit from the discussions in the group.
Methods
Live online webinar with presentation, discussion of sample solutions, tips and tricks, question and answer session.
Recommended for
The webinar is suitable for controllers who have a sound knowledge of Excel and would like to expand their Excel knowledge in a targeted and customized manner.
Joint online training
Start dates and details
18.09.2025
Live-Online
Booking number:
35324
€ 172,- plus VAT.
€ 204.68 incl. VAT.
Course

zoom
Days & Times
1 module of 1.5 hours each.
Thursday, 18.09.2025
2:00 pm - 3:30 pm
Booking number:
35324
€ 172,- plus VAT.
€ 204.68 incl. VAT.
Details
1 module of 1.5 hours each.
Booking number:
35324
€ 172,- plus VAT.
€ 204.68 incl. VAT.
Details
1 module of 1.5 hours each.
No suitable date?
You are welcome to be notified by e-mail as soon as new dates are released.
Please note: We use third-party tools for selected events. Personal data of the participant will be passed on to them for the implementation of the training offer. You can find more information in our privacy policy.