PUGML14 - The secret of Power BI: understanding context

Tuesday, April 24
14:00 - 15:30
Liffey Meeting Room 4

Level: Intermediate
Presentation Type: Presentation

The Tabular modeling concepts in Analysis Services and Power BI are tremendously powerful, but to become really successful you’ll need to understand the fundamental differences between these technologies and SQL-based environments. The secret to unleash all the power of Power BI is to thoroughly understand the concept of context. In this session, we will introduce you to the different forms of context within a Power BI or Analysis Services Tabular model, and how to work with these to understand and create advanced DAX calculations.

The secret to unleash the power of Power BI is to thoroughly understand the concept of context. In this session, we’ll introduce you to the different contexts within a Power BI model, and how to work with these to create advanced DAX calculations. The use of different contexts will be presented in a life made Power BI model.

Michiel Rozema

Founder & CEO
Quanto B.V.

Michiel Rozema is one of the top Power BI experts in Europe. Working as a Data Insight Lead for Microsoft in The Netherlands for 8 years, he was responsible for the Microsoft Data & Analytics platform, and launched Power Pivot for Excel and Power BI in the country. He is author of two Dutch books on Power Pivot and Power BI modeling (Praktijkboek Power Pivot in Excel, 2013, Pearson/Microsoft Press; Handboek Power Pivot, 2016, Vakmedianet), is founder and board secretary of the Dutch Power BI User Group, and founder and CEO of Quanto.

With a master’s degree in Mathematics and Operations Research, everything related to analyzing data has Michiel’s interest. He has worked in the IT industry for over 22 years in positions in consulting, pre-sales, management, marketing, and business development. One of his qualities is to combine in-depth analytical skills with the ability to have valuable conversations with managers and end-users; always trying to connect stakeholders and looking for pragmatic solutions.

Michiel works in roles like consultant, architect, trainer, and coach for individuals and teams working with Power BI, DAX, SQL Server Analysis Services, and related technologies.


Send Email for Michiel Rozema

Henk Vlootman

Quanto B.V.

Henk Vlootman is working since 1992 as Excel trainer. In 2010, with the introduction of the self-service tools in Excel, his interest has changed from the die-hard Excel surroundings to the flavors of the Power tools.

Microsoft Power BI, which also uses Power Query and Power Pivot as engine to create reports and dashboards, is now, with Excel, his favorite tool . He is chairman of the Foundation Power BI Gebruikersgroep (Usergroup), The Netherlands. Henk has been an Excel MVP since 2013. In 2016 he was awarded with a double nomination: Excel and Data Platform MVP. In 2017 Henk was awarded Data platform MVP.

Henk presented on several Excel and PowerBI congresses, such as the Dutch Techdays, Excel Experience Day’s, Excel modelling days in Surinam, the ModelOff congress in London, the Bulgarian Excel days in Sofia and several PowerBI meetings in The Netherlands, Germany and Canada.Henk wrote several Excel and Power Pivot books in the Dutch language. His newest book on Power Pivot (with co-author Michiel Rozema) hit the market in 2016.

Henk and Michiel Rozema started in 2018 a new company: Quanto, Collective Analytics. We wants to spread throughout all companies our philosophy: “Quanto works from the vision that everyone in your organization should be able to form their insights. And it is precisely from joint insights that you can continuously improve your organization. We call this Collective Analytics.“


Send Email for Henk Vlootman


The secret of Power BI: understanding context

Attendees who have favorited this

Send Email for The secret of Power BI: understanding context