Visual Calculations: Simplifying DAX

Visual Calculations are still in preview in Power BI, so maybe you have not used this feature yet. But you should! It makes DAX a lot easier for every user, which is what most people struggle with when they are working with Power BI.
In this session, I will tell you all about visual calculations, show how easy it is to use them, and what you can do with it. Join this session to become an expert in visual calculations. Get ready and excited to use them in your own reports!

All about Calculation 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 and the format in which they want to see it.
In this session, we will dive into calculation groups: one of the features in Power BI to reuse DAX logic. You will learn how to use calculation groups, how to set a dynamic format and how to deal with some of the caveats in report design that come with their use.

This session can be given in English or in Dutch.

Value level security in Power BI

The use of Power BI is increasing rapidly. More and more organizations use Power BI, and the number of users per organization grows. Data security has always been an important topic but becomes more prominent with an increasing number of users. How do you ensure that users have access to the information they need?
In Power BI, security within a data model can be implemented through row-level security (RLS). With RLS, complete parts of the model can be hidden from a user. But what to do when only certain attributes must be secured, like social security numbers or paygrade levels? In this session you will learn how to implement value-level security in Power BI.

Make your data shine - Data storytelling with Power BI visual reports

To get insights from data, insights need to be shown somehow. Power BI visual reports are all about showing results in a visual way. But users also need to understand and act upon the insights. How can insights be provided in such a way that users can take action? Applying storytelling principles turns out to be an effective approach to this.
In this session, I discuss data storytelling and how to apply storytelling concepts to the design of Power BI visual reports. We will also take a look at Power BI features that specifically support data storytelling.

Fresh produce: using Power BI as a calculation engine for BC

Power BI is the leading platform for business intelligence. The core of the Power BI platform is formed by datasets with DAX calculation capabilities that enable interactive reporting on large sets of data. Join this session to learn about another way to use this technology: perform hugely complex aggregations and calculations to enrich business processes.
In this session, we present a Power BI solution based on a real-life use case involving BC and the Power Platform. We deal with inventory analysis and financial settlements for perishable goods, like tomatoes, for which the age of inventory is relevant. The Power BI model requires recursive calculations over a period of one week, which is the base unit for the client’s business process. The calculation results are fed back to BC using Power Automate and Power Apps. The same set-up is used to run scenario analyses over extended periods of time. We discuss the solution architecture and do a deep dive on the specifics of the calculation engine implemented in Power BI.

AI in the Power platform: a case study

Microsoft runs an Azure Cognitive Service called Face Recognition. In this session we show a model that uses PowerApps, Power Automate flows and Power BI together with the Azure Face recognition. It is a real business project, made for a customer in the congress industry.
This case study uses a PowerApps model to get three photos of a participant, while he/she is looking at different colored pictures: blue, green or red. A Power Automate flow transfers the photos to the Face recognition, which will return the metrics of each photo. Based on the metrics the PowerApps model finds which color -picture- returns the highest “happiness” metric.
Based on this highest “happiness” factor and the color of the shown picture, the participant gets a lemonade in his/her “happiness” color. In the meantime, a Power Automate flow pushes the -aggregated- metrics, including gender and age into a live Power BI dashboard. The complete cycle takes less then a minute.
In this session we do a live demonstration of the model and show you the key elements in the PowerApp, the Power Automate flows and the Power BI dashboard to give you an idea of the real Power of the Power platform.

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, we will discuss data storytelling and how to combine storytelling concepts and advanced interaction in Power BI visual reports. We 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.