Tag: Power BI Customer Analysis

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.  For this Power BI analysis, we’ll evaluate the data in

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). What you don’t want with RANKX DAX function is to start receiving results and not really

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. Identifying or segmenting customers is a technique in itself, but comparing customer segments in the current period and in a prior period is another great technique. We can get some real

Continue reading

Evaluating Customer Margin Contraction Using Power BI

Here we’re going to look at customer margin contraction. We’re going to try and work out what customer margins are contracting and why are they contracting. Is it because of their purchasing frequency? Is it because of the products they’re buying? Or because of some other reason? We’re going to solve this analytical problem with

Continue reading