Microsoft BI SSAS Tabular: on the power of DAX Measures
How noventum HR-Analytics with DAX enables the implementation of the Transparency in Pay Act (EntgTranspG? Entgelttransparenzgesetz)
(PresseBox) - 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 Klmum, 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
noventum consulting GmbH is an international IT management consultancy.
Founded in 1996 in M
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.
Themen in dieser Pressemitteilung:
Unternehmensinformation / Kurzprofil:
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.
Datum: 19.04.2018 - 08:49 Uhr
Sprache: Deutsch
News-ID 1535021
Anzahl Zeichen: 2584
contact information:
Contact person:
Town:
Münster
Phone:
Kategorie:
Manufacturing & Production
Typ of Press Release:
type of sending:
Date of sending:
Anmerkungen:
Diese Pressemitteilung wurde bisher 629 mal aufgerufen.
Die Pressemitteilung mit dem Titel:
"Microsoft BI SSAS Tabular: on the power of DAX Measures
"
steht unter der journalistisch-redaktionellen Verantwortung von
noventum consulting GmbH (Nachricht senden)
Beachten Sie bitte die weiteren Informationen zum Haftungsauschluß (gemäß TMG - TeleMedianGesetz) und dem Datenschutz (gemäß der DSGVO).
