Tag: Power BI Customer 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

Power BI Analysis Using DAX: How Many Unique Products A Customer Bought

In this Power BI analysis example, we’re going to generate a unique insight where we’re going to evaluate all our customers and see how many unique products they bought. I’ll show you how to analyze this over time and use anything in the data model. You may watch the full video of this tutorial at the

Continue reading

RANKX Considerations – Power BI And DAX Formula Concepts

RANKX is a very unique DAX function that requires a deeper level of thinking around its logic and in how it actually works when running a calculation in a particular context (for example a table or chart inside Power BI). You may watch the full video of this tutorial at the bottom of this blog. What

Continue reading

How To Implement Cohort Analysis In Power BI – Advanced DAX Concepts

In this blog, I am introducing Power BI cohort analysis. This was one of the topics that I went through in detail in a Learning Summit, where I demonstrated what cohort analysis is and how you can do it in Power BI. In this tutorial, you will learn how to set it up inside your

Continue reading

Power BI Customer Segmentation: Showcasing Group Movement Through Time

This tutorial is all about customer insights. I will demonstrate an advanced Power BI customer segmentation technique using DAX formulas and a secondary table. You may watch the full video of this tutorial at the bottom of this blog. Identifying or segmenting customers is a technique in itself, but comparing customer segments in the current

Continue reading