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
eyJrIjoiZjliNWQwOGYtN2I1My00YmNhLThkODEtNDY1ZmFmZTRmM2QwIiwidCI6IjQxYWI0MmE5LTM4MWItNDhjZi04YTg1LTcyMDQ2NDkyMjk3NiIsImMiOjEwfQ%3D%3D
