Layering Multiple ‘What If’ Parameters For Advanced Analytics in Power BI

As you likely know, I am a huge promoter of scenario analysis in Power BI. Scenario analysis is an amazing analytical technique you can use in Power BI that virtually allows you to predict what might happen in the future. In this tutorial, I explain how you can layer multiple scenarios, one on top of

Continue reading

New Customer Analysis with Power BI – Next Member Only Event

The next member only virtual workshop will be an advanced session, drilling down into the make-up of your customers. Enterprise DNA Membership holders can register for the event below. New Customer Analysis with Power BI This type of analysis can be classified as churn analytics. Due to this being a large topic the focus of

Continue reading

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