03 Dec

Academy - Power BI Modeling & DAX Fundamentals (World Tour - Brussels, Belgium)

Academy - Power BI Modeling & DAX Fundamentals (World Tour - Brussels, Belgium)

Tuesday, December 3, 2019 (3:00 AM) to Tuesday, December 3, 2019 (11:00 AM) (Eastern Time)

Crowne Plaza Hotel Brussels Airport - Da Vincilaan 4 - 1831 Diegem - Room: Egmont+Leopold+Soignes
Henk Vlootman, Michiel Rozema


You're Registered!
Valuable Insights with Power BI Models
A Power BI data model, or analytical model, is the core of a Power BI solution. Each Power BI report is based on a data model that combines data and provides aggregations and all sorts of calculated results. The concepts of Power BI data models may seem easy and familiar, but make no mistake: building a well-performing data model requires a different way of thinking from working with relational databases or Excel. In this course, you'll learn about building Power BI data models and how to use the DAX language.

The concepts and techniques of Power BI data models are identically available in other tools like Power Pivot in Excel, SQL Server Analysis Services Tabular, and Azure Analysis Services. So, the knowledge acquired through this course can be applied in many ways.

Learning Goals

• Being able to build efficient analytical models with different types of tables and relationships
• Being able to add calculations to models with DAX
• Knowing best practices to develop models that are fast and easy to maintain


Everyone who wants to acquire a solid basis for building analytical models in Power BI or similar tools. The target audience includes BI consultants, members of BI teams, business analysts, business controllers, senior Excel users, and database developers who want to switch to modern BI.

• Basics of Power BI data modeling: tables, relationships, data types, metadata
• Building analytical models
• Introduction to DAX: calculated columns and measures
• Basic DAX functions
• DAX context
• Filters in DAX
• Time Intelligence functions, like year-to-date and rolling total

Henk Vlootman
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.“

Michiel Rozema
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.