topic Re: RFM model for customer segmentation in Data Stories Gallery

RFM model for customer segmentation

KPIM — Tue, 05 Apr 2022 10:55:33 GMT

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

Re: RFM model for customer segmentation

Aamir_khan — Sun, 28 Jun 2020 10:20:20 GMT

Nice work. It is possible to share the pbix file with me ?

Re: RFM model for customer segmentation

Anonymous — Sat, 26 Dec 2020 11:20:26 GMT

This looks like it's offline as well...

Re: RFM model for customer segmentation

KPIM — Mon, 28 Dec 2020 06:55:54 GMT

Hi, thank you for letting us know. The public link was broken so I just update it. Thank you.

Re: RFM model for customer segmentation

Anonymous — Mon, 11 Oct 2021 11:26:15 GMT

Great work, is it possible to get the pbix file?

Re: RFM model for customer segmentation

Anonymous — Tue, 29 Mar 2022 11:16:11 GMT

Can you share the pbix file please?

Re: RFM model for customer segmentation

MAAbdullah_47 — Mon, 06 Jun 2022 12:15:41 GMT

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.

KPIM

Re: RFM model for customer segmentation

VoBaTung — Wed, 14 Jun 2023 04:00:51 GMT

Well done! I like this design style.

Re: RFM model for customer segmentation

NguyenDucDuy — Wed, 14 Jun 2023 04:14:22 GMT

Can i download the pbix file?

Re: RFM model for customer segmentation

gianghnq218 — Wed, 14 Jun 2023 04:20:28 GMT

Great job! I really admire this design style.

Re: RFM model for customer segmentation

danng123 — Wed, 14 Jun 2023 04:24:31 GMT

The R-F-M model provides excellent insights, which helps us to understand customer behaviors and identify effective, possible opportunities. Overall, great job!

Re: RFM model for customer segmentation

Hoang_Thien — Wed, 14 Jun 2023 04:44:14 GMT

Thank you for conveying me that RFM analysis can be done so well with Power BI.

Re: RFM model for customer segmentation

tungpham13 — Wed, 14 Jun 2023 09:00:33 GMT

Such a great dashboard! I love how the report effectively utilizes the RFM model and AdventureWorks database to provide insights into customer segmentation.

Re: RFM model for customer segmentation

minhtnh — Wed, 14 Jun 2023 15:39:20 GMT

This report is very detailed and clear. The style is amazing!

Re: RFM model for customer segmentation

huyhoang2409 — Mon, 19 Jun 2023 04:13:38 GMT

That's all I need. Thanks for Publishers very much!!

Re: RFM model for customer segmentation

hamy — Mon, 19 Jun 2023 04:24:42 GMT

This report is very detailed and understandable. Thank you!

Re: RFM model for customer segmentation

giangpk — Mon, 19 Jun 2023 04:27:14 GMT

The report is understandable. The style is amazing

Re: RFM model for customer segmentation

quynhlnn — Mon, 19 Jun 2023 04:29:28 GMT

What an impressive dashboard!

Re: RFM model for customer segmentation

minhtam75 — Mon, 19 Jun 2023 04:31:49 GMT

This report is very insightful and informative!

Re: RFM model for customer segmentation

mailan39 — Mon, 19 Jun 2023 04:36:25 GMT

Nice job, it helps me a lot!