Loading…
Brussels Power Platform World Tour has ended

Sign up or log in to bookmark your favorites and sync them to your phone or calendar.

Academy (separate registration required) [clear filter]
Tuesday, December 3
 

9:00am PST

Academy Training - Power BI Modeling & DAX fundamentals ( € 530)
Register to attend the class or follow the instructions below to include registration for the Power Platform World Tour.

Please Note: Academy workshops are training sessions that will build your skills through hands-on, deep dive education. Our Academy Courses do require a separate registration. If you are registering for the Power Platform World Tour, you will have the option to add on Academy classes during the registration process.

If you have already registered, it's not too late to add on a class!

To edit your registration, please click here and follow these steps:
This will bring you to the Registration page – you will see a message stating "You are currently Registered." Click on Edit Registration (right side of screen).
When you see your registration, click Edit.
On the next screen, click Add Activities.
Check the box next to the class title you're interested in.
Follow the prompts to complete the process of adding this class to your registration.


Power BI Modeling & DAX fundamentals

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

Audience
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.

Topics
• 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

Speakers
avatar for Michiel Rozema (MVP)

Michiel Rozema (MVP)

Microsoft MVP, Quanto
Michiel Rozema is a data platform MVP focusing on Power BI. Working as a Data Insight Lead for Microsoft in The Netherlands for 8 years, he 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, founder and... Read More →
avatar for Henk Vlootman

Henk Vlootman

CEO, Quanto
The top in Europe on professional Power BI from the view of the business


Tuesday December 3, 2019 9:00am - 5:00pm PST
TBA

9:00am PST

Academy Training: Demystifying DAX - Take your DAX to the next level ( € 530)
Register to attend the class or follow the instructions below to include registration for the Power Platform World Tour.

Please Note: Academy workshops are training sessions that will build your skills through hands-on, deep dive education. Our Academy Courses do require a separate registration. If you are registering for the Power Platform World Tour, you will have the option to add on Academy classes during the registration process.

If you have already registered, it's not too late to add on a class!

To edit your registration, please click here and follow these steps:
This will bring you to the Registration page – you will see a message stating "You are currently Registered." Click on Edit Registration (right side of screen).
When you see your registration, click Edit.
On the next screen, click Add Activities.
Check the box next to the class title you're interested in.
Follow the prompts to complete the process of adding this class to your registration.

Demystifying DAX - Take your DAX to the next level


Course Description:
DAX is the data modelling language of Power BI and Power Pivot for Excel. It is reasonably easy to get started with DAX, however sooner or later most people hit a wall where they get stuck and can't move forward. Have you ever typed a DAX formula, pressed enter and then crossed your fingers hoping you will get the right answer? If this sounds like you, then chances are there are some deeper concepts that you don't fully understand, and these gaps are stopping you from moving forward.
In this full day pre-con session, Matt Allington (author of the book Supercharge Power BI) will clearly explain how the DAX language really works under the hood. At the end of the session you will fully understand filter propagation, evaluation contexts and some of the harder to understand concepts and functions. The session will use real world examples to explain the concepts. This is not a beginner’s course – you should already know the basics of DAX and have been using the language for at least 6 months before attending.

Course Objectives:
Fill gaps in understanding of how the DAX Language works in order to underpin future learning and understanding.

Course Audience: Users of Power BI and Power Pivot for Excel who already have a base understanding and experience using DAX

Course Level: Intermediate

Course Pre-Requisites: Bring your own laptop with Power BI Desktop and DAX Studio installed.

Speakers
avatar for Matt Allington

Matt Allington

Principal Consultant, Excelerator BI Pty Ltd
Matt Allington is a full time professional Power BI Consultant and Trainer with more than 30 years' practical business and IT experience. Matt works primarily with Business people who want to get more out of their data, by providing coaching and mentoring support on their Power BI... Read More →


Tuesday December 3, 2019 9:00am - 5:00pm PST