Hi Viorel, first, thank you for sharing your precious videos and for your detailed clarification, however, In this video, I couldn't get how you segment customers into 11 categories. Thank you in advance for your assistance.
Hi Rania. Thank you for the appreciation. The categories in the Segment Scores Table are subjective. They depend on you business type and needs. You may only need 4 segments or 20 and you can name the segments however you want. I hope this helps.
Could I ask another question, please? The M value measure from the link you provided doesn't seem accurate to me. Maybe I missed something. Could you please clarify this point?
Yeah, I caught that too. The M Score formula should have [M Value} instead of [F Value]. I think this is causing a lot of the issues other people are having.
Hi At 4:30, I noticed for getting M value you are dividing sum of sales by sum of quantity. Why is that? Can't we just sum the sales amounts for each customer to get the highest contributing customer? PS: Can you provide a link to the dataset? Thanks
Hi, this is the formula for the Monetary value, meaning the value per unit. If you want total sales amount, you can create a dedicated formula and then rank customers by it. Many thanks!
Hello sir I need your In fact when I do the pythpn implementation I have all the segments, but with power bi I have 7 segments I have the same chosen in power with what you are doing. Can you know the problem?
Thanks a lot for the feedback! You have already the Segment table data in this link. The way it is created is subjective, depending on your situation. But the general idea is that is a way to rank the importance of the 3 KPI's (R, F & M). docs.google.com/document/d/11yNDgWdX_Rohb1851H_SQm9aTitrIMZMFt4OnOtfsjM/edit
Hi, thanks for the video. Very helpful. The M Score formula should have [M Value} instead of [F Value]. I think this is causing a lot of the issues other people are having.
Hello and first of all: Thanks a lot for your great videos & useful content. You've got a new subscriber! I am struggling at minute 5:00 because if I use this DAX formular (for sure with my table names and columns instead of scanner_data) I receive the following error message: "The expression references multiple columns. Multiple columns cannot be converted to a scalar value." Any ideas whats my mistake? Anyway, I will try further to find my mistake. Many thanks again and all the best to you! Update: My mistake :) I created a new measure in "RFM table" instead of updating the table. Anything is fine, so thanks again for your great content! Best
Hello and thanks a lot for your kind words! I am glad that this video was useful. And kudos for correcting your own mistake, this is the fastest way to learn! 💯
@@Data.Analytics.Central I am completely lost! I was also getting the same error initially because I was trying to create a new measure "RFM Table" instead of creating new table. But when I clicked option 'New Table', and wrote this dax, after 3-4 minutes of processing, I got error that memory is not enough, and table is not created. I got this multiple times even when I restarted power bi and laptop. Could you kindly help me anyhow in this regard. I said I am lost, because I calculated last order date, days since last order, total orders between last order date and selected date and revenue between these dates, after that I am lost what to do. Somewhere it was written that I have to do R1,R2... based on value. I will be extremely thankful for your help.
@@prsh1989 Hi Priyank. For the memory issue please try the following: 1. Try increasing the Maximum allowed to 16000 under File / Options and Settings / Options / Global / Data Load. Data Cache Management Options. The default is 4096. 2. File --> Options --> Current File --> Data Load. Turn off Background data. 3. PBIX file --> Query Editor --> Right Click on Table --> Un-check Enable Load.
@@Data.Analytics.Central Okay, while I try this, could you also help me to understand logically, that why we are doing this step, this step of creating a new table with summarize.
@@prsh1989 To have in one place the RFM values and scores and then to create relationship from this RFM table to the lookup Segment_scores table. This keeps things organized and easy to analyze with DAX.
Thank you, this has been very helpful. I will be using live data from our CRM system, is there a way I can track the changes to the RFM score as customers place more orders? Thank you
Hi Gemma. Thank you very much for the feedback. For tracking the changes I would create a calculated column where I would store the concatenation of customer, score and date.
@@Data.Analytics.Central Thank you so much that's really helpful. I don't suppose by chance you have a video on how to do that? (I'm still at the early stages of my Power BI learning) Thank you for your time.
Hey man, I used the data and the given DAX code, I ended getting all the RFM = 555 why is that so in the RFM Table? is there something wrong with the DaX code?
am i know why when i typed in teh RFM table it pop up msg - The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value. What can i do?
The DAX code and the Segmentation table:
docs.google.com/document/d/11yNDgWdX_Rohb1851H_SQm9aTitrIMZMFt4OnOtfsjM/edit?usp=sharing
Please provide all the data sets for practice. Very Very Important
Hi Viorel, first, thank you for sharing your precious videos and for your detailed clarification, however, In this video, I couldn't get how you segment customers into 11 categories. Thank you in advance for your assistance.
Hi Rania. Thank you for the appreciation. The categories in the Segment Scores Table are subjective. They depend on you business type and needs. You may only need 4 segments or 20 and you can name the segments however you want. I hope this helps.
Could I ask another question, please? The M value measure from the link you provided doesn't seem accurate to me. Maybe I missed something. Could you please clarify this point?
@@raniasaleh3999 What is exactly the concern about the M Measure?
Your M score formula is just the same as F score formula 6:16
Yeah, I caught that too. The M Score formula should have [M Value} instead of [F Value]. I think this is causing a lot of the issues other people are having.
Hi
At 4:30, I noticed for getting M value you are dividing sum of sales by sum of quantity. Why is that? Can't we just sum the sales amounts for each customer to get the highest contributing customer?
PS: Can you provide a link to the dataset?
Thanks
Hi, this is the formula for the Monetary value, meaning the value per unit. If you want total sales amount, you can create a dedicated formula and then rank customers by it. Many thanks!
Amazing! Greeting from Perú.
Gracias, Juan! Saludos desde Rumania! 🇷🇴
Hello sir I need your
In fact when I do the pythpn implementation I have all the segments, but with power bi I have 7 segments
I have the same chosen in power with what you are doing.
Can you know the problem?
Thank you so much!
Can you share how to create SegmentScores table?
Thanks a lot for the feedback! You have already the Segment table data in this link. The way it is created is subjective, depending on your situation. But the general idea is that is a way to rank the importance of the 3 KPI's (R, F & M).
docs.google.com/document/d/11yNDgWdX_Rohb1851H_SQm9aTitrIMZMFt4OnOtfsjM/edit
Hi, thanks for the video. Very helpful. The M Score formula should have [M Value} instead of [F Value]. I think this is causing a lot of the issues other people are having.
Thank you for sharing your know how!😀
Dear Catalin, I am very glad that you found it useful! 🙂
how do we create the rfm chart if we have the value all sorted out
That was so Great.TNX❤
thank you so much for sharing this knowledge
Thank you for the feedback. I am glad that it helped you!
That so important thanks a lot
I am glad that it helped you!
Very helpful, thank you!!! :)
Hi Carol, I am glad that you have found it useful!
Hello and first of all: Thanks a lot for your great videos & useful content. You've got a new subscriber! I am struggling at minute 5:00 because if I use this DAX formular (for sure with my table names and columns instead of scanner_data) I receive the following error message: "The expression references multiple columns. Multiple columns cannot be converted to a scalar value." Any ideas whats my mistake? Anyway, I will try further to find my mistake. Many thanks again and all the best to you!
Update: My mistake :) I created a new measure in "RFM table" instead of updating the table. Anything is fine, so thanks again for your great content! Best
Hello and thanks a lot for your kind words! I am glad that this video was useful. And kudos for correcting your own mistake, this is the fastest way to learn! 💯
@@Data.Analytics.Central I am completely lost! I was also getting the same error initially because I was trying to create a new measure "RFM Table" instead of creating new table. But when I clicked option 'New Table', and wrote this dax, after 3-4 minutes of processing, I got error that memory is not enough, and table is not created. I got this multiple times even when I restarted power bi and laptop. Could you kindly help me anyhow in this regard.
I said I am lost, because I calculated last order date, days since last order, total orders between last order date and selected date and revenue between these dates, after that I am lost what to do. Somewhere it was written that I have to do R1,R2... based on value.
I will be extremely thankful for your help.
@@prsh1989 Hi Priyank. For the memory issue please try the following:
1. Try increasing the Maximum allowed to 16000 under File / Options and Settings / Options / Global / Data Load. Data Cache Management Options. The default is 4096.
2. File --> Options --> Current File --> Data Load. Turn off Background data.
3. PBIX file --> Query Editor --> Right Click on Table --> Un-check Enable Load.
@@Data.Analytics.Central Okay, while I try this, could you also help me to understand logically, that why we are doing this step, this step of creating a new table with summarize.
@@prsh1989 To have in one place the RFM values and scores and then to create relationship from this RFM table to the lookup Segment_scores table. This keeps things organized and easy to analyze with DAX.
where can I find the dataset?
Thank you, this has been very helpful. I will be using live data from our CRM system, is there a way I can track the changes to the RFM score as customers place more orders? Thank you
Hi Gemma. Thank you very much for the feedback. For tracking the changes I would create a calculated column where I would store the concatenation of customer, score and date.
@@Data.Analytics.Central Thank you so much that's really helpful. I don't suppose by chance you have a video on how to do that? (I'm still at the early stages of my Power BI learning) Thank you for your time.
@@GemmaJohsnon Hi Gemma, I will put your suggestion on the content list and I will let you know when a video will be available.
Thanks for your explanation!
Where can I access the scanner_data table (if that's possible)?
Hi Owen, Thanks for the feedback! The dataset is here on Kaggle:
www.kaggle.com/datasets/marian447/retail-store-sales-transactions
Hey man, I used the data and the given DAX code, I ended getting all the RFM = 555 why is that so in the RFM Table? is there something wrong with the DaX code?
Hope you can advise thank you!
am i know why when i typed in teh RFM table it pop up msg - The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value. What can i do?
This seems to be an error when you try to put the formula in a new Measure instead of a new table. Use Modeling -> New table and type the expression.
@@Data.Analytics.Central thank you may i know in what situation i need to place in new table ?
@@maggiechan297 The model is that you need to create this RFM table, not a measure.
Useful. Thank you.
Thanks a lot for the appreciation!
918 Kohler Stravenue
thank you
Thanks for watching! 🙏
Dillon Lights