Category: Scenario Analysis

Customer Analysis In Power BI; Reviewing Performance Over Time

How we can create some compelling customer analysis overtime Power BI Video Tutorial

Customer analysis is a crucial thing to do for any business specially if you have a large number of customers. In this particular tutorial, I work through how we can create some compelling customer analysis overtime. I’m looking at customer’s purchasing behaviour between different timeframes and put those into a visualisation, highlighting the information in

Continue reading

Predict Future Profitability within Power BI DAX Functions

In this blog post, I will showcase some of the analytical work I enjoy doing the most… and that is working on future predictions using Power BI DAX functions. I am always fascinated with trying to understand what could happen in the future. I’ll show you a technique around how you can almost predict future

Continue reading

Power BI ‘What-If’ Parameter Feature

Power BI New Feature What If Parameters

Power BI What-If parameters are a really powerful feature to implement in your models for scenario analysis. Scenario analysis is immensely important from an analytical perspective in Power BI and ‘What-If’ parameters allow you to quickly implement tables and measures for this type of analytics. Once you select the What-If parameter icon, it opens a

Continue reading

Using Multi-Layered Scenario Analysis in Power BI

I’m huge on scenario analysis in Power BI. Being able to input variables inside your calculations that you can ‘shock’ to effectively predict outcomes is so powerful when trying to make decisions. In Power BI you can complete this really efficiently, and you can combine many of the formula techniques with your data models and

Continue reading