Tag: Power BI Analytics

Data Modeling In Power BI Using Supporting Tables

Data Modelling Supporting Tables

When doing an analysis on our model, we might want to find an insight that’s unrelated to anything within our tables. That’s where the concept of using supporting tables for Power BI data modeling comes in. Supporting tables don’t have any relationship with our tables, but we can use them to support the visualizations in

Continue reading

Tips In Using The Performance Analyzer Feature In Power BI

Using The Performance Analyzer In Power BI - Model Optimization Tips

The Performance Analyzer feature is now available in the Power BI desktop and that’s what I’m going to show you in this tutorial. Using the Performance Analyzer, you can find out how your report elements, such as visuals and DAX formulas, are performing. You may watch the full video of this tutorial at the bottom

Continue reading

Power BI Analysis Using DAX: How Many Unique Products A Customer Bought

In this Power BI analysis example, we’re going to generate a unique insight where we’re going to evaluate all our customers and see how many unique products they bought. I’ll show you how to analyze this over time and use anything in the data model. You may watch the full video of this tutorial at the

Continue reading

Calculating Profit Leakage Using Power BI Analytics

In this blog post, I want to hone into a real world application of Power BI – How can we discover how much profit we are missing out on? There are probably a few ways that you can work out solutions to profit leakage. The way I have done it with this example is to

Continue reading

Budgeting Analysis On Best & Worst Performers Using Power BI

I run through a lot of budgeting analysis because I think using Power BI for this type of analysis is extremely effective. You may watch the full video of this tutorial at the bottom of this blog. Power BI as a tool covers a lot of the analytical components that need to be executed well

Continue reading