Event description

Op dinsdag 19 april vindt de tweede bijeenkomst plaats van de Power BI Gebruikersgroep bij Macaw in Schiphol-Rijk. Onze speciale gast van deze avond is Alberto Ferrari. Hij vormt samen met Marco Russo het team achter SQLBI, dat wereldwijd Microsoft BI consultancy en trainingen levert. Bovendien is hij de auteur van onder andere “Expert Cube Development with SSAS Multidimensional Models” (Packt Publishing), “Microsoft Excel 2013: Building Data Models with PowerPivot” en het meest recente uitgebrachte “The Definite Guide to DAX” (Microsoft Press).

We beginnen om 18:30 met een aftrap door Martijn Muilwijk van Macaw en daarna staat Alberto op het podium van 19:00 tot 21:00. De volgende twee sessies staan op het programma:

Handling Relationships in DAX
The Tabular model in Power Pivot for Excel, Power BI and SSAS Tabular seems to offer only plain-vanilla one-to-many relationships, based on a single column. In 2015 there was the introduction of many-to-many relationships, yet the model seems somewhat poor when compared with SSAS Multidimensional. In reality, by leveraging the DAX language, you can handle virtually any kind of relationship, no matter how complex they are. In this session we will analyze and solve several scenarios with calculated relationships, virtual relationships, complex many-to-many. The goal of the session is to show how to solve complex scenarios with the aid of the DAX language to build unconventional data models.

What’s New in DAX
This session is dedicated to the many new DAX features in Power BI Desktop, Analysis Services 2016, and Power Pivot for Excel 2016. You will learn new aggregation and statistical functions, new ways to filter and manipulate tables, new optimized techniques to query data with a table expression, and the syntax to define and use variables in DAX expressions. These new features make DAX easier to read and improve its performance, too.

Speakers