Tag: Scenario Analysis

A Deep Dive Into The TREATAS Function In Power BI

In this tutorial, we’ll dive into one of the most advanced DAX functions in Power BI called the TREATAS function. If you can understand TREATAS, you’ll see that it has so many applications for you across all reports and dashboards which you’ll be creating inside Power BI. TREATAS allows us to simplify our model but

Continue reading

Power BI Data Model For Advanced Scenario Analysis Using DAX

I want to show here how incredible Power BI is as an analytical tool. I’ll teach you how to develop a Power BI data model for an advanced scenario analysis. With Power BI, we can achieve so much that we might never have thought possible. Developing scenario analysis logic within a Power BI data model

Continue reading

Getting Started With The “What If” Parameter In Power BI

The possibilities of using the What If parameter in Power BI is deemed endless. It gives users and businesses the flexibility to design a solution for the critical answers and insights that they need. In the recent Enterprise DNA learning summit, we had a successful session regarding the usage and implementation of What If Parameter

Continue reading

Forecasting Product Demand Using Power BI Analysis Techniques

In this tutorial I run through some great scenario analysis techniques and demonstrate how you can combine several of them in Power BI. I’m talking about forecasting product demand. Power BI is an amazing tool for data analysis when you can implement techniques like this one. Take a situation where you want to analyze future

Continue reading

Analyzing Average Results Per Month Using DAX In Power BI

In this tutorial, I go through an average results analysis technique. I dive into some types of procurement & purchasing analysis that you can do with Power BI. Specifically, we’re going to look at the average monthly purchases a business may make. I go through which DAX formula combination you need to be able to

Continue reading