Category: Scenario Analysis

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. This is connected to a tutorial I previously conducted about supply chain management. It involves a technique on managing a particular operational scenario about multiple dates. I also went through best practice tips on building the right model.

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. 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