UEL-4

Building a data model using PowerPivot and DAX language

Form of participation
Form of training
Length of training
  • 1 day (1×8 Lessons)
  • daily 9:00 - 17:00
Available languages
  • Hungarian
Dates
Would you like a custom made solution, group training on this topic?
Find out more about our customised training services here.

Trainer recommendation

Gémes Brigitta

Gémes Brigitta trainer

The primary target audience for this training consists of business analysts, logistics analysts, controllers, and management reporting professionals. The training is useful for those who are already familiar with and use PowerQuery and PowerPivot add-ins and wish to apply DAX functions more extensively in their reports to present deeper insights through complex calculations. The main goal of the training is to provide a structured overview and mastery of DAX functions. Since DAX functions are only available in English, a basic knowledge of English is a significant advantage.

Description

During the training, the student will get to know in more detail the Excel "self-service BI" tools such as the PowerPivot extension and the powerful analysis language DAX. Building on the material of the previous module, the student will learn how to use the DAX language in order to perform even more advanced analyses in the data model.

Outline

  • PowerPivot and DAX language introduction
  • Data model structure and queries (by rows, columns)
  • Using FILTER, ALL, ISFILTERED, ISCROSSFILTERED, VALUES
  • Using CALCULATE
  • DAX date functions
  • Use of hierarchies
  • Creating reports
Outline (PDF)

Prerequisites

Advanced knowledge and experience of Excel is required to successfully complete the training.