Category: Scenario Analysis

Customer Allocation: Current Vs Selection-based

Customer Allocation- Current Vs Selection-based

In this blog, I’ll compare the existing customer allocation in depots or hubs to a newly-calculated allocation based on a selected distance. This kind of analysis allows businesses to deeply understand customer profitability. There are two similar datasets here which are the Customer data selection and Customer data current. I used these datasets to display

Continue reading

Using Calculate Function Inside Power BI

Using Calculate Function Inside Power BI

For this tutorial, I’ll cover how the CALCULATE function works and why it’s so crucial in Power BI. I’ll also show you some examples of its application. You can easily branch out to time intelligence calculations by using the CALCULATE function. Once you apply this technique, you’ll be able to produce high quality insights inside

Continue reading

DAX Table Functions In Power BI

In this blog post, I’ll introduce you to DAX table functions. Table functions are simply DAX functions that return a table. Some of the most common table functions that you can encounter in Power BI are the FILTER, VALUES, and ALL functions. Using these table functions, you can create virtual tables inside Power BI. Physical

Continue reading

Time-Related Insights From Your Supply Chain Metric

For this tutorial, I’m going to cover some high-quality time-related insights directly from your supply chain metrics. You may watch the full video of this tutorial at the bottom of this blog. This is connected to a tutorial I previously conducted about supply chain management. It involves a technique on managing a particular operational scenario

Continue reading

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. You may watch the full video of this tutorial at the bottom of this blog. Supply

Continue reading