We have created a great program for you. All our speakers are experienced Power BI speakers on conferences and well-known trainers. You get the most out of Power BI. Below you will find the abstracts of the sessions.
On the Power BI Summer School page, you find the schedule of the event.
Don’t forget, all our speakers are available during this event to answer all of you questions in our Q&A sessions.
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.
Even when we live in a global world your end-users might expect to get their reports in their own local language. This session is guiding you through the available options and necessary steps to give the report user full control over the display language:
• Content of textual columns
• Headlines
• Currency
• Model (names of tables, columns and measures)
• Power BI Desktop and Power BI service
You will learn how to extend Power BI’s data model to allow for support of column content and headlines in multiple languages (and how you can automate the translation of the texts with Azure Cognitive Services). The implementation uses DAX and either Power Query or SQL. The final solution is fully data-driven: New languages (and translations) can be added without any change to the data model or report – no developer is needed to add languages.
I will show you how you can implement currency conversion and how to translate the model’s meta data. Finally, we look at how to change the language for Power BI Desktop in Power service.
Power BI visual reports depend on interaction to focus on the most important insights, while enabling users to dive deeper into detailed information. The challenge with many Power BI models is that they offer many different insights, which easily leads to an overkill of interaction options in a report. How do we help report users to keep their focus while offering lots of interaction?
Using storytelling principles can be an effective approach in this. In this session, I will discuss data storytelling and how to combine storytelling concepts and advanced interaction in Power BI visual reports. I will also cover several techniques to help users navigate all insights provided. These include field parameters, conditional button actions and dynamic drill through, among others.
One could say that DAX is one of the more stable parts of the Power BI platform: it is not too often that changes and new functions are added to the DAX language.
Lately however, DAX has been extended with functions that allow for a new approach to analytical challenges.
An example of this is the new WINDOW function. In this session, we take a thorough look at new capabilities of DAX and the ways you can leverage these.
The tabular model is the core of the reporting process. Cleaning and reshaping data with Power Query is one of the best parts of designing and delivering analytics reports with Power BI.
The correct definition of entities and attributes is vital for data analysis processes. We will look through the lens of the models looking for excellent or wrong designs, discuss the available options and solve the challenges.
The most important task is to reshape the data for the tabular model. This workshop will cover several scenarios where Combine Queries could be the perfect solution for the optimal tabular model.
It covers some tasks like:
• Respect the design of the star model
• Protect the fact table model
• Data quality tasks
This session is suited to those new or getting started with Power Automate. We will walk through a Power Automate driven solution to capture images from an email inbox, apply multiple Cognitive Services algorithms and analyse the output in a Power BI report.
We will walk through a Flow, covering Loops, Conditions, Variables, 3rd Party actions, API calls & more.
With the data captured by the Flow, we’ll do some analysis in Power BI.
We all work in Power Query to transform our retrieved data. The best part in this proces is the ability to automatically perform tasks, which previously required a lot of manual work. This is of course what you want, but it is not always obvious how to get to that situation. In some cases, a custom function can help you solve this problem.
In this session I am going to explain how to create and use custom functions. I start with the basics of custom functions and how to embed these functions in your code. Power Query has a standard set of automatically created functions, but they produce clean code. In this session you will learn how to use functions in the M-Language code.
Registration and finding your hotel room.
Introductions and sunset on the beach
By Michiel Rozema & Henk Vlootman
Data Lakes, dataflows, data on the beach. "The times are a changing". This statement by Bob Dylan also applies to the current ICT and BI landscape.
In this session we'll discuss the need of DataWareHouses (DWH) versus Data Lakes and other Micosoft's Power Platform toolings.
by Henk Vlootman
Do more with ETL in Power Query by hacking the M language.
There is so more possible in Power Query (the Extract, Transform and Load aka ETL tool in Power BI), if you know a bit more about the M language. Henk makes an introduction on this language and together we make the code more flexible. We also take a deeper look at the Try function to perform Error handling in your M script.
Answers to all your questions on whatever subject in Power BI.
by Jeroen Ter Heerdt
What's new, what's cool, and what else.
For those who have never heard of Jeroen Ter Heerdt, he is the Dutch Data Dude and a Microsoft Program Manager, responsible for Power BI desktop. Live from Redmond USA, Jeroen will tell you everything on the new features in Power BI and, maybe, a glimps of what you can expect in the near future of Power BI.
Do we need to say more?
by Michiel Rozema
This session will go deep. As deep as you can get with DAX.
Performance in DAX can be an issue. You want your production model to be fast. Fortunately you can optimize your DAX code. Michiel will learn you DAX tuning techniques. The aim is to optimize a DAX statement that, in it's former state, needs nearly a minute to recalculate, into in a faster DAX equivalent that needs less then 2 seconds to recalculate.
by Coen Ruys
Get insights in what will happen using Power BI and Microsoft's machine learning possibilities.
Sun (we hope), fun and quality relax time.
Get yourself energized for the last Power BI Summer School day!
by Henk Vlootman
From insights, to action, to innovation.
For those who never have worked with these Power Platform tools, we start with a short introduction. We are going to build a PowerApp with full control of the input by validations.
Don't leave without getting all your questions answered!
by Michiel Rozema
The ugly truth - made beautiful by the hand of the Master.
The strength of Power BI reports is in the combination of visualizing insights and interactivity. You can create interactivity within visuals, between visuals on the same report page, between pages in a report, and even between reports. Drillthrough from one page to another provides a highly dynamic experience to the report user, but it’s easy to lose track of what you’re actually looking at. In this session, we’ll guide you through the options and pitfalls of drillthrough interactivity, and show you how to deal with users getting lost.
Good bye...
We hope to see you again in 2021!