Program overview
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.
Session 1
What is new in 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
Markus Ehrenmueller - Jensen
Multi-lingual reports in Power BI and Analysis Services
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.
Session 3
Advanced Interaction in Power BI Visual Reports
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.
Madzy Stikkelorum
Session 4
Michiel Rozema
New ways of doing DAX
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.
Session 5
Solving tabular model scenarios with Power Query
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
Ana Maria Bisbe York
Session 6
Ben Watt
Power Automate your way to Cognitive Services and Power BI
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.
Session 7
Custom functions in Power Query
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.
Henk Vlootman