Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
RFM analysis will demonstrate which customers need to be retained at the moment, whose loyalty should be maintained, and who are not worthy of the marketing efforts you put.
How we do that?
1) we will segment your customer base into 3 categories: Recency (How recently did the customer make a purchase?), Frequency (How often do they purchase), and Monetary Value (How much do they spend?)
2) next step is the building of matrix that contains 25 segments, each having a transparent name ("perspective", "in the risk zone", etc.)
As a result you get the analysis in the form of an interactive dashboard. You can choose any segment and explore the data.
eyJrIjoiMDk4ZWQzOTUtNjI3ZS00MmRmLWE1NmUtMDY5NmJlYWZlNWJiIiwidCI6ImU3N2EyNjdjLWE1ZjctNDQyNi1iYTA4LWM2ZTU5OWE2ZDExYiIsImMiOjl9
Hey, DatmarkLLC.
I really liked your model, especially the second page.
If possible, can you clarify how you calculated the revenue estimations on the second page? I wish to apply something similar in a dashboard I'm building.
Kind Regards,