Tag: DAX Calculations

Implementing 80/20 Logic in Your Power BI Analysis

Have you ever heard of the Pareto Principle? Another name for it is the 80/20 Rule. The rule stipulates that for every 20% of something, you’ll generally receive 80% of the results. So if we look at this from a business perspective, we’re saying that 20% of our customers should make up 80% of our

Continue reading

Customer Attrition Analysis – Advanced DAX in Power BI

We’re going to get advanced today. We’re going to really dive deep into customer churn: new customer and lost customer analysis. Now another name for this is attrition analysis because we want to see how our customer are churning, how many of our customers are coming on board and buying our products, how many are

Continue reading

Create Compelling Insights In Power BI Fast – Financial Analysis

In this particular example we’re going to work through, I’m going to show you how you can discover profit insights very, very fast with Power BI. Now, profits are key, right? In any business, you want to understand how your profits are being derived, where they’re coming from, and why you’re getting the results that

Continue reading

Create Dynamic Lists of Dimensions using DAX in Power BI

Have you ever wanted to showcase the top three, five, or ten best results across a particular dimension? Well, in this video I’m going to show you exactly how you can do that with a specific example. The example we’re going to work through is one where I want to find my top three salespeople

Continue reading