Category: Business Intelligence

Customer Segmentation Techniques Using The Data Model – Power BI & DAX

In this video tutorial I’m going to show you how you can segment your customers in an efficient way via the data model in Power BI. Sometimes your raw data will not have all the information you require to showcase something in Power BI. But don’t let this stop you. All you require is an

Continue reading

Show Only Top Or Bottom Results Using Ranking Formula Techniques – Power BI & DAX

In this tutorial, we are going to dive into on how to utilize the RANKX function effectively in Power BI. Sometimes you don’t want to show all of the results from your data in your visualization. Sometimes you only want to see the top or the bottom results, for example the top five or the

Continue reading

How To Calculate Budget Or Forecast Results Cumulatively In Power BI

Recently I ran an entire workshop as part of the Enterprise DNA webinar series on Advanced Budgeting Techniques. I know for a fact that there’s a huge requirement for this type of analysis in Power BI. Very often we have our actual results and we want to compare them to a forecast or a budget

Continue reading

Segmentation Of Your Data Based On Rankings – Advanced Analytical Technique For Power BI

In this example we’re going to get quite advanced in Power BI using DAX. We are going to try and segment our dimensions. We will segment some table in our data by the ranking of a dimension in that particular table. There’s a little bit to this but it’s a really amazing concept of how

Continue reading

Analyze Margin Changes Overtime – Analytics with Power BI and DAX

Through this really unique and specific example I’m going to dive into how you can combine lots of the techniques that I’ve described in many tutorials and posts in the past. These are techniques like Measure Branching, Trend Analysis, and DAX formula combinations. What we are going to do is analyze the changes to profits

Continue reading