RFM Analysis in Excel Tutorial | Simple Segmentation Analysis

In this video, we'll be conducting some RFM analysis to show you how you can use segmentation analysis to go beyond the basic Business Intelligence processes to dive deeper into your data and gain better insights into your customers, subscribers or users. I'll be showing you an RFM analysis example.

**** RECOMMENDED WATCHING ****

Business Intelligence For Beginners Playlist

**** TOOLS AND SERVICES I RECOMMEND ****

✅ SKILLSHARE - Get a 30-day free trial of Skillshare Premium!

✅ DATA HUBS FOR GOOGLE DATA STUDIO:

✅ Navicat

**** MY FREE EBOOKS TO DOWNLOAD ****

7 Steps to Landing Your First BI Analyst Job
7 Top Tips For Better Dashboard Design
The Skills You Need To Succeed In Business Intelligence

🎥 MY YOUTUBE GEAR

Disclaimer: Some of these links go to one of my websites and some are affiliate links where I'll earn a small commission if you make a purchase at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏

✅ LET'S CONNECT:

Sign up for my mailing list to be the first to hear about new videos and special offers

#segmentation #businessintelligence #dataanalysis

[ExcelPro.]

Awesome explanation.. i understood RFM Analysis 👍

[definitelynorandomvideos]

I just landed a job as a data analyst and your content has helped me greatly prepare! Thanks Adam!

[hyferxd]

Thanks 🙏 I hope you are providing daily a valuable content

[mahikamathur-oxyq]

Big Thank you! very nicely explained. Thank you

[mwlammbi]

Super helpful, thanks. am working on something similar this week.

[jelledaelmans]

Great video!
Just one tip, you can double click in the bottom right corner of a cell to copy the formula. (So you don’t have to drag)

[tarelakentebe]

I do this! Been doing this for years and had no clue how to explain it on my CV 😂🤦🏾‍♂️

[ldiva]

Hi, I love the new 'Learn BI' re-branding. It makes sense for more reach. Although I thought it was quite witty to have 'Vitamin' in the old title; I can see you still kept a slice of the old 'V' in the tablet!! 😉

[hyferxd]

Could you provide a Every Data set for practice purpose, 🙏👍 It's a humble request to you

[everesth]

Really great video, clear and concise, thank you!

[bhavinitanna]

Cost analysis, google analytics website attribution modeling, klaviyo customer segmentation analysis, customer retention analysis etc would be helpful. Subscribed to your channel.

[niteshmittal]

You sound exactly like the narrator from the youtube channel Kurzgesagt

[travelsizearchitect]

question: how did you give a R score to a customer if you have not converted the Date column into Number of Days From Last Order?

[makavli]

i am confused. please why are my RFM columns having the same values after dragging to autofill?

[jroobz]

I find this hard to sequence... how do you plan out your rfm analysis and what should you be looking for first?

[sagnikchakraborti]

The link given to download the data is not working