RFM Analysis With Excel

This video is a complete tutorial on performing RFM analysis with Excel. Recency, frequency, monetary analysis is an established, simple, and powerful techniques traditionally used for customer segmentation.

I've personally used RFM analysis as the inspiration for all kinds of powerful analyses, including categorizing geographic areas of the US as part of my marketing analytics work.


⚠ NOTE - There was a bug in the original Customer Recency calculation. This has been fixed in the Excel workbook. ⚠


☕ If you found this content useful and would like to support the channel, you can buy me a coffee: https://www.buymeacoffee.com/DaveOnData


★★★ My online data analysis courses ▶ https://school.daveondata.com


-----------------------------------------------------------------------------------------------------------------------
Video Resources
-----------------------------------------------------------------------------------------------------------------------
💻 Get the Excel workbook for this video:
https://github.com/DaveOnData/DataAna...

📺 Want to learn more about using US Census Bureau data?
   • A Real-World Data Cleaning Project - ...  


-----------------------------------------------------------------------------------------------------------------------
Excel Analytics Training
-----------------------------------------------------------------------------------------------------------------------
👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺    • Introduction to Business Analysis wit...  



Stay healthy and happy data sleuthing!

#RfmAnalysisWithExcel #RfmAnalysis #Rfm