Category: Data Modeling

Advanced Tips To Optimize Your Power BI Table

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

Continue reading

Budgeting Performance Segmentation Using DAX In Power BI

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

Continue reading

Data Segmentation Techniques Based On Any Measure – Advanced DAX

Data Segmentation Techniques Based On Any Measure - Advanced DAX

This tutorial will outline a few data segmentation techniques based on any measure that you can easily apply to your reports. Data segmentation is a unique way of looking at your data. When you use this technique, you can easily break out your top and worst sales data. Several courses and downloadable resources on segmentation

Continue reading

Creating A Gantt Chart In Power BI Using Matrix

Creating A Gantt Chart In Power BI Using Matrix

In this blog, I’m going to go over some project management insights and specifically talk about creating a Gantt chart in Power BI using matrix in Visual Studio. I’m going to show the logic behind creating this Gantt chart, which is very useful when it comes to project management. A Gantt chart is a very

Continue reading

Effective Ways To Use The GROUPBY Function In Power BI

In this insightful tutorial, I want to feature the GROUPBY function in Power BI. I’ll demonstrate the different ways that you can use this DAX function. Honestly, I haven’t used the GROUPBY function too often, mainly because there are several ways to solve things in Power BI using other table functions. For instance, I’ve used

Continue reading