Тёмный

RFM Analysis in Excel Tutorial | Simple Segmentation Analysis 

Adam Finer - Learn BI Online
Подписаться 97 тыс.
Просмотров 47 тыс.
50% 1

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
• BI For Beginners
*** TOOLS AND SERVICES I RECOMMEND ***
✅ SKILLSHARE - Get a 30-day free trial of Skillshare Premium!
geni.us/skillshare30day
✅ DATA HUBS FOR GOOGLE DATA STUDIO:
Power My Analytics: geni.us/YLc9Re
Supermetrics: geni.us/5SNn
✅ Navicat
geni.us/navicat
*** MY FREE EBOOKS TO DOWNLOAD ***
7 Steps to Landing Your First BI Analyst Job
geni.us/7stepstobi-ebook
7 Top Tips For Better Dashboard Design
geni.us/dashdes-ebook
The Skills You Need To Succeed In Business Intelligence
geni.us/biskills-ebook
🎥 MY RU-vid GEAR
My Camera - amzn.to/3J5lbeo
Most Used Lens - amzn.to/3hXoE2Q
B-Roll Lens - amzn.to/3pSUeDh
Main Tripod - amzn.to/3pSUeDh
Vlogging Tripod - amzn.to/3tOpJPZ
Main Key Light - amzn.to/366KaPI
Softbox - amzn.to/35HrR46
LED Panel Kit - amzn.to/35K3Lpf
Teleprompter - amzn.to/3hWGT8p
Main Microphone - amzn.to/3t1n1aK
Mic Boom Arm - amzn.to/3hUHzuX
Lavelier Microphone - amzn.to/3vVUi8V
C-Stands - amzn.to/3vZMoLN
Computer - amzn.to/3KB3RhU
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:
For business inquiries visit www.learnbi.online/contact
Sign up for my mailing list to be the first to hear about new videos and special offers
geni.us/PSgRsF
Join the Facebook Group: / 816317545978660
Download dataset: geni.us/segmentationdata
#segmentation #businessintelligence #dataanalysis

Опубликовано:

 

31 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 50   
@ExcelPro.
@ExcelPro. 12 дней назад
Awesome explanation.. i understood RFM Analysis 👍
@user-hy6fe9rx6d
@user-hy6fe9rx6d 2 месяца назад
Thanks 🙏 I hope you are providing daily a valuable content
@definitelynorandomvideos24
@definitelynorandomvideos24 2 года назад
I just landed a job as a data analyst and your content has helped me greatly prepare! Thanks Adam!
@LearnBI
@LearnBI 2 года назад
Fantastic news, congratulations! If my content helped even just a little bit then it makes it all worthwhile. Thanks for letting me know. You’re going to crush it! 👏🏻
@mahikamathur-ox1yq
@mahikamathur-ox1yq 3 месяца назад
Big Thank you! very nicely explained. Thank you
@LearnBI
@LearnBI 3 месяца назад
You’re welcome
@ss_051
@ss_051 2 года назад
Big thanks for this video !
@LearnBI
@LearnBI 2 года назад
You’re welcome!
@LUCASLOKY0
@LUCASLOKY0 2 года назад
Congrats! Great content ;)
@LearnBI
@LearnBI 2 года назад
Thanks!
@mwlammbi2650
@mwlammbi2650 Год назад
Super helpful, thanks. am working on something similar this week.
@LearnBI
@LearnBI Год назад
My pleasure
@pvgffac
@pvgffac 2 года назад
Thanks a lot! I subscribed it!
@LearnBI
@LearnBI 2 года назад
Thanks!
@fatimazahrazhaymi7182
@fatimazahrazhaymi7182 2 года назад
Thank you very useful video great job
@LearnBI
@LearnBI 2 года назад
Thanks!
@jelledaelmans9380
@jelledaelmans9380 2 года назад
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)
@LearnBI
@LearnBI 2 года назад
Thanks!
@EduardMerc
@EduardMerc Год назад
Amazing! Thanks
@LearnBI
@LearnBI Год назад
You’re welcome
@everesth2104
@everesth2104 2 года назад
Really great video, clear and concise, thank you!
@LearnBI
@LearnBI 2 года назад
You're very welcome!
@andresfelipehiguera785
@andresfelipehiguera785 4 месяца назад
Excellent video. just subscribed
@LearnBI
@LearnBI 4 месяца назад
Thanks! 🙏🏻
@l8diva
@l8diva 2 года назад
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!! 😉
@LearnBI
@LearnBI 2 года назад
Glad you like it! I'll be honest though, I didn't even think about the V for Vitamin. I was just messing around with the pie chart and turned it up that way. Guess it must have been subconscious! I got your email as well about setting up your data file for a pivot table. It basically needs to be in a tabular format with every column containing a unique metric or dimension and every row containing a record of the data. I have a video about pivot tables if you need it: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-wHmTDXrpsDc.html . Hope this helps!
@bradleyrowlett2032
@bradleyrowlett2032 2 года назад
Brilliant! Just what I need!
@LearnBI
@LearnBI 2 года назад
Great!
@user-hy6fe9rx6d
@user-hy6fe9rx6d 2 месяца назад
Could you provide a Every Data set for practice purpose,🙏👍 It's a humble request to you
@opeyemiadeyemi3387
@opeyemiadeyemi3387 Год назад
Thank you very much
@LearnBI
@LearnBI Год назад
You’re welcome
@bhavinitanna1925
@bhavinitanna1925 2 года назад
Cost analysis, google analytics website attribution modeling, klaviyo customer segmentation analysis, customer retention analysis etc would be helpful. Subscribed to your channel.
@LearnBI
@LearnBI 2 года назад
Lots of great ideas, thanks!
@HiteshAdventure
@HiteshAdventure 3 месяца назад
Thanks a lot
@LearnBI
@LearnBI 3 месяца назад
You’re welcome
@tarelakentebe465
@tarelakentebe465 2 года назад
I do this! Been doing this for years and had no clue how to explain it on my CV 😂🤦🏾‍♂️
@LearnBI
@LearnBI 2 года назад
Glad to help!
@travelsizearchitect
@travelsizearchitect 6 месяцев назад
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?
@LearnBI
@LearnBI 4 месяца назад
The dates are ranked
@makav3li665
@makav3li665 2 месяца назад
i am confused. please why are my RFM columns having the same values after dragging to autofill?
@LearnBI
@LearnBI 2 месяца назад
Without seeing your spreadsheet and how you are filling the cells, I cannot help. Sorry.
@niteshmittal4645
@niteshmittal4645 10 дней назад
You sound exactly like the narrator from the youtube channel Kurzgesagt
@LearnBI
@LearnBI 10 дней назад
You’re not the first person to say that. I take it as a compliment and wish I had that many subscribers!
@jroobz
@jroobz 3 месяца назад
I find this hard to sequence... how do you plan out your rfm analysis and what should you be looking for first?
@LearnBI
@LearnBI 3 месяца назад
You need sales data with columns for date of purchase and sales amount. Then you have your recency data using the date and the monetary with the sales amount. Frequency is the number of sales made.
@jroobz
@jroobz 3 месяца назад
@@LearnBI thanks. So you do you purchasing rfm. Then complaints/queries. Is there anything else to look at?
@sagnikchakraborti2415
@sagnikchakraborti2415 2 года назад
The link given to download the data is not working
@LearnBI
@LearnBI 2 года назад
It is, I just tested it with 2 separate addresses. Please check your spam folder.
@sagnikchakraborti2415
@sagnikchakraborti2415 2 года назад
Checked. Not yet received. Can you please suggest some alternative?
@LearnBI
@LearnBI 2 года назад
You could try with a different email address
Далее
RFM Analysis With Excel
19:24
Просмотров 44 тыс.
Master Data Analysis on Excel in Just 10 Minutes
11:32
Cleaning Data in Excel | Excel Tutorials for Beginners
21:04
Using Excel to Segment Customer in an RFM Framework
44:37