Program overview
A great program is waiting for you. All our speakers are experienced Power BI speakers on conferences and well-known trainers. The garantee you get the most out of Power BI.
A schedule of the sessions can be found on the Power BI Summer School Home page.
Don’t forget, all our speakers are available to answer all of you questions in our Q&A sessions.
Session 1
What is new around Power BI
Exciting things are happening in the Power BI platform! As Microsoft keeps investing in the leading platform for data analytics, it can be easy to lose track of the big picture. In this session, we share the latest developments in Power BI not just on a feature level, but positioned within a framework that will help you understand where Power BI is going and why.
Michiel Rozema & Henk Vlootman
Session 2
Reza Rad
Built to Last; the Right Power BI Architecture
Building a Power BI solution is one thing; keeping it working for a long time is another. If you want to build a solution that is reusable, easy to maintain, and easy to modify whenever needed, then you have to think about building the right architecture for the Power BI solution. The right architecture includes a multi-layer design of Dataflows and Shared Semantic models, considerations of version control, deployment pipelines, and many other things. In this session, Reza will take you through some of these features and show you how to use them in real-world scenarios.
Session 3
Optimization and debugging of Power BI.
Everybody who has made some more complex solutions in Power BI is familiar with the one big enemy that comes in a later stage of the development: performance issues. These issues prevent your users from actively using your beautiful report, putting all your hard work through the drain. So, what can you do about that?
In this session, we will dive into optimization and debugging of your Power BI semantic model and report. First, we’ll take a look at the Power BI engine and storage modes: what is optimal for Power BI, and how can you make use of this to store your data in an optimized way? We’ll discuss some best practices and some external tooling, like DAX Studio and Tabular Editor, that you can use to find the problem areas in your own models.
When you have the optimal model structure, the next step is to look at your calculations. How can you find out which DAX measures are not performing, and what kind of changes can you make in measures to make them perform better? This is where the new DAX Query View comes in: in this session we’ll see how you can use this to debug your model, and to find badly performing DAX measures using DAX Query View and other external tools. Finally, we’ll discuss the influence of the chosen visuals on the performance of your solution.
Madzy Stikkelorum
&
Ana Maria Bisbe York
Session 4
Michiel Rozema
Field parameters and calculations groups
Complex and feature-rich semantic models in Power BI typically contain a large number of DAX measures. Even more so when advanced interaction patterns in visual reports demand a high level of flexibility; like users wanting to choose what types of result they want to see.
Over the past few years, some new features were introduced in Power BI that address these challenges: field parameters enable a report visual to dynamically select different fields (columns or measures) from the model, while calculation groups allow for reusing DAX logic for different base calculations.
In this session, we will dive into these two concepts. You will learn how to use both field parameters and calculation groups, and of course, we will cover more advanced uses, how the two work together, and caveats in report design that come with their use.
Session 5
The future of DAX is visual
This is it. The day that the way that DAX became easier. After this, how you write DAX changes forever. Learn all about it in this session! The Power BI team has been working on exciting things related to DAX calculations, specifically targeted at making it easier to add typical business-type calculations (such as running totals or vs-first). Would you believe it if we told you that you don’t even have to type DAX anymore and still be able to get complex calculations done quickly? In this session, we will dive deep into visual calculations, covering everything there is to know about them including the lower-level window functions.
Get ready to get your mind blown! See the future, today. After this session you are an expert on visual calculations and ready to tackle any challenging calculation that comes your way!
Jeroen Ter Heerd
Session 6
Data preparation with dataflow Gen2
Working with Dataflows gen2 feels like working with the Dataflows gen1. Microsoft kept the full Power Query experience in the new version of Dataflow. But obvious there are differences. To start with the Dataflows gen2 stores the result tables in Fabric.
In this session we will take a deep dive in the differences between both generations. For instance, where is the output stored? But we will also look at the integration with Data pipelines and the other new functionalities.
Henk Vlootman