Forum Discussion
Customer Vintage Analysis ?
Hi.
is there an article that makes a customer vintage analysis? I want to track customer that booked for a particular month then what is the average balance during the months the customers are in books? Thanks!
Coulmn A - Month Booked
Column B to S - Months on Book
2 Replies
- amitchandak
Super User
Anonymous , need data for that. But I have explained a similar analysis on
Customer Retention Part 3: Period Of Stay – Cohort Analysis: https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-3-Period-Of-Stay-Cohort-Analysis/ba-p/1393410
Hi amitchandak, I already used this for my customer cohort analysis. The message that I want to impart on this analysis is different from the cohort analysis you pointed out. But I guess I will use the same method and try it out again.
To further explain it, the data that is constructed like a PANEL data:
I want to visualize the behavior of the balances of accounts over time.
So, I will create a multiple line graph. The lines are the booking dates. The x-axis Report Month (MOB). The y axis is balance.
