I’m going to show how you can create compelling Power BI dashboards and reports that give you high quality insights. There are a lot of individual techniques that you can use in creating great Power BI dashboards, but for now, I just want to focus on an overall technique. This is a technique that I
I’ll go over some interesting concepts that involve using several table functions to optimize your Power BI formula. I’m going to use an example from the Enterprise DNA Support Forum where one of the members asked if it’s possible to add a filter while using the SUMMARIZE function. This is quite common for scenarios when
This tutorial showcases some advanced tips to optimize your Power BI table. I’ll show you how to break out your large table into multiple ones. This concern is quite common across legal database systems with huge flat files of information. Huge tables need to be broken down into simpler tables for easy information management. Most
Budgeting performance analysis might sometimes require us to segment the results we currently have to different groups. This is to analyze which performers were better than others versus their targets. Power BI can manage performance segmentation, and understand their differences and effects on the total budget. In this tutorial, I’m going to discuss how to
In this example, we’re going to get quite advanced in Power BI using DAX. We are going to focus on segmenting dimensions based on its ranking on that particular table. This is an amazing concept of how you can utilize calculated columns within Power BI. This can bring additional insights that would have never been
