Category: Business Intelligence

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 you work

Continue reading

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

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

Budgeting Performance Segmentation Using DAX In Power BI

When working on budgeting analysis inside of Power BI, there may be situations in your work where you want to segment the results into different groups, so that you can analyse which performers were better than others, versus their targets for example. This is some very unique analytics that can be done inside of Power

Continue reading

Brand New 30 For 30 Launching This Week – 30 Video Tutorials In 30 Days

Over the last couple of years, the Enterprise DNA TV channel has grown from strength to strength. We’ve gone from a low base of 0 subs up to now almost 20,000 subscribers and over 250 unique videos that can be viewed and watched by all Power BI users around the world. Currently, we average around

Continue reading