Data Analysis Expressions (DAX) is a query and modelling language for SQL Server Analysis Services (SSAS) Tabular, Power-BI, and Excel Power Pivot. Calculated columns, tables, and user-defined Measures can be created at a very sophisticated level.
How useful DAX is in business practice is impressively illustrated by a development in the area of the Development in Pay Act. This relatively new law provides employees with the right to demand valid proof from their employer for the commensurability of their own remuneration in comparison to employees with similar activities. With the help of the HR-Analytics solution of noventum, which also relies on the DAX formula language, companies can comply with this obligation.

WHAT IS DAX?

With the help of Data Analysis Expressions (DAX), very powerful, yet intuitively usable Measures can be created in SSAS Tabular models, e.g. allowing to nest aggregations with respect to different dimensions, store complex calculation formulas, use time-intelligence functionalities, and modify and/or set filter contexts. Despite the complex definitions made possible, end users and/or analysts can work with these Measures intuitively due to the good design, without running risk of producing materially wrong results.
One of the implementations for the implementation of the Transparency in Pay Act in the noventum solution HR-Analytics is a beautiful example for the power, elegance, simplicity, and intuitive use of DAX-based Measures within an SSAS Tabular model. Put simply, the Transparency in Pay Act stipulates that companies must provide their employees – under certain circumstances – with information on the average wage. [For material details regarding the Transparency in Pay Act, see the white paper by noventum consultant Dr. Benjamin Klör .] From a technical point of view, this wage information is, strictly speaking, not an “average”, but rather a “median” of the salaries in a certain comparison group consisting of employees with similar characteristics. But the following example can be implemented just as well with average, minimum, and maximum.

EXAMPLE: TRANSPARENCY IN PAY ACT WITH HR-ANALYTICS

Based on an already existing data model, only three additional DAX Measures had to be defined for the analyses with respect to the Transparency in Pay Act.
The first Measure extrapolates the gross salary components from the corresponding table of facts fact_Salaries with the help of the corresponding degree of employment from the dim_CapacityLevel to a “Full Time Equivalent” (FTE). With this, for example, USD 2,000 of an employee with a degree of employment of 50 % are converted to USD 4,000 (per FTE):

Read the complete article on novum online, the newsdesk of noventum consulting

Über die noventum consulting GmbH

noventum consulting GmbH is an international IT management consultancy.

Founded in 1996 in Münster, today noventum is represented in Münster and Düsseldorf with more than 100 employees. Independent noventum partner companies work in Istanbul and Luxembourg.

The managing partner is Uwe Rotermund.

noventum consulting supports its customers in their IT challenges and in their efforts for a modern corporate culture.

Customers are predominantly DAX companies as well as medium-sized companies and organizations with a large IT infrastructure.

Firmenkontakt und Herausgeber der Meldung:

noventum consulting GmbH
Münsterstraße 111
48155 Münster
Telefon: +49 (2506) 9302-0
Telefax: +49 (2506) 9302-23
http://www.noventum.de

Ansprechpartner:
Thorsten Schmidt
Director
Telefon: +49 (2506) 93020
Fax: +49 (2506) 930223
E-Mail: thorsten.schmidt@noventum.de
Marco Nielinger
Senior Consultant
Telefon: 02506 93020
Für die oben stehende Pressemitteilung ist allein der jeweils angegebene Herausgeber (siehe Firmenkontakt oben) verantwortlich. Dieser ist in der Regel auch Urheber des Pressetextes, sowie der angehängten Bild-, Ton-, Video-, Medien- und Informationsmaterialien. Die United News Network GmbH übernimmt keine Haftung für die Korrektheit oder Vollständigkeit der dargestellten Meldung. Auch bei Übertragungsfehlern oder anderen Störungen haftet sie nur im Fall von Vorsatz oder grober Fahrlässigkeit. Die Nutzung von hier archivierten Informationen zur Eigeninformation und redaktionellen Weiterverarbeitung ist in der Regel kostenfrei. Bitte klären Sie vor einer Weiterverwendung urheberrechtliche Fragen mit dem angegebenen Herausgeber. Eine systematische Speicherung dieser Daten sowie die Verwendung auch von Teilen dieses Datenbankwerks sind nur mit schriftlicher Genehmigung durch die United News Network GmbH gestattet.