Advocate IVRFM model for customer segmentation
In this report, we use a simple R-F-M (Recency-Frequency-Monetary) model to categorize customers into different segments. This model helps sales team to identify customer shopping behavior or marketing team to find the best campaign for each customer segment. We use data in AdventureWorks database and based on the Sales Order to identify the segments for each customer.
- Number of Current Client in each Segment
- Customer Analysis based on R-F-M Score and detail by Last Order, total Orders, total Sales
- Monthly Trend of total Orders and Total Sales
- Total Sales by Product Subcategory and Product
Please let me know how do you think about this design. I would love to hear your feedback. Thank you and happy analyzing!
@demo @Datavisualization @PowerBI @AdventureWorks @Dashboard @Sales @RFMmodel
----------------------------------------------------------------------------------------------------------------------------------------------
Youtube Channel: https://www.youtube.com/channel/UCSHfZGEUUduNp6_fP1oh6rg
Facebook Group: https://www.facebook.com/groups/2708071549299410/
LinkedIn: https://www.linkedin.com/company/kpim/
Instagram: https://www.instagram.com/kpim.vn/
Twitter: https://twitter.com/kpim_vn
29 Replies
- Aamir_khan
Kudo Collector
Nice work. It is possible to share the pbix file with me ?
- KPIM
Hi, thank you for letting us know. The public link was broken so I just update it. Thank you.
MAAbdullah_47Helper V
Dear I have some notes :
1-There is no date period for filter , which is very important.
2-How to make dynamic RFM scores that adapt according to a chosen period?
I have doubt it gives the same score results.
Waiting your comment.Well done! I like this design style.
Can i download the pbix file?
Great job! I really admire this design style.
The R-F-M model provides excellent insights, which helps us to understand customer behaviors and identify effective, possible opportunities. Overall, great job!
Thank you for conveying me that RFM analysis can be done so well with Power BI.
