Category: Scenario Analysis

Supply Chain Management Techniques In Power BI

Managing Your Supply Chain Data w/Power BI - Analysis Techniques

I recently ran a workshop on Supply Chain Management and I want to discuss the key insights from the session. This tutorial can be of great help if you have exposure to this kind of analysis in Power BI. Supply chain management happens within a certain business operation that involves the flow of goods and

Continue reading

Top Customer Per Product – Power BI Analysis

This tutorial involves finding out your top customer per product using an advanced Power BI analysis. This example perfectly shows how Power BI can generate practical insights once you utilize it effectively. There’s just no other tool out there that’s as versatile and flexible as Power BI. In Power BI, you can quickly and easily

Continue reading

Creating A Pareto Chart In Power BI – Advanced DAX

Creating A Pareto Chart In Power BI - Advanced DAX

This blog tutorial showcases a really interesting example around Pareto analysis. I’m going to teach you how to create a Pareto chart using advanced DAX formulas. I’ll show you how to use a combination of formulas to be able to generate a visualization like this one. The first thing that I always recommend when working

Continue reading

Using Advanced DAX For Multiple IF Statement In Power BI

In this article, I’m going to give you a tutorial about utilizing multiple IF statements in Power BI. This short tutorial is from a specific thread in the Enterprise DNA Support Forum. In the Enterprise DNA Support Forum, members ask questions and get assistance about everything and anything related to Power BI. It’s great to

Continue reading

Optimizing Your Power BI Formula Using Advanced DAX Functions

I’ll go over some interesting concepts that involve using several table functions to optimize your Power BI formula. I’m going to use an example from the Enterprise DNA Support Forum where one of the members asked if it’s possible to add a filter while using the SUMMARIZE function. This is quite common for scenarios when

Continue reading