Category: Business Intelligence

Show Days Before Or After A Selected Date Using Power BI

Show Days Before Or After A Selected Date Using Power BI

As we work through this tutorial I will show you some truly powerful analytics that you can complete inside of Power BI. It is amazing how flexible you can make your solutions in Power BI if you get the set up right. When I say set up, I mean your data model first and foremost

Continue reading

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