Category: Business Intelligence

How You Can Predict Profitability In The Future Using Power BI

How You Can Predict Profitability In The Future Using Power BI

What I want to cover with this tutorial is an example of how you can predict profitability in the future using Power BI. I wanted to focus more on the concepts of what can be achieved here. In order to actually achieve this in Power BI, what you need is a number of different modelling

Continue reading

How You Can Re-Use Moving Averages In Power BI

How You Can Re-Use Moving Averages In Power BI

In this particular tutorial, we are going to dive into how to showcase trends in your data using moving averages. I want to show you here though how to take this further.¬†How we can re-use the moving averages formula technique in a number of different ways. What’s great about this formula combination or formula pattern

Continue reading

Using Great Color Schemes In Your Power BI Data Visualization

Using Great Color Schemes In Your Power BI Data Visualization

Creating a high-quality colour palette inside of Power BI is essential to making your reports look compelling and very professional. I’m constantly seeing reports out there which use the generic colour palette for Power BI, which to me is a huge negative. I personally can’t stand these colours as they just don’t do your work

Continue reading

Allocate Monthly Forecasts Across Daily Results In Power BI Using DAX

Allocate Monthly Forecasts Across Daily Results In Power BI Using DAX

In this example, we’re doing a deep dive into budgeting and forecasting inside of Power BI. Specifically, I want to show you how you can allocate budgets (or forecasts) which might be at a monthly or a yearly level, and you need to allocate them to a daily level. This scenario is very common when

Continue reading

Create Dynamic Cumulative Totals Using DAX In Power BI

Create Dynamic Cumulative Totals Using DAX In Power BI

In this tutorial, we’re going to do a deep dive into the cumulative total formula combination that can be used in Power BI. Cumulative totals are a great way of showing trends over time and then also showcasing differences in trends between different timeframes. There is a common combination of DAX functions to use that

Continue reading