Видео

Thank you for the great educational video! I want to ask a question about the RFM chart. If the number of years a customer has been with us falls below one and becomes a decimal (indicating the customer has been with us for less than a year), when we divide it by the number of purchases, it results in a large number. What should we do in this case? One solution I thought of is to round decimal numbers up to one. Is that correct?

Muchas gracias 🙏🏻🙏🏻🙏🏻

Amazing

This is amazing info, this will help me in my business

bahahaha best teacher ive had. Great intro.

What is the point of Calculating the adjustment rating for Gabriel? If you could just sum product her actual ratings with the similarities. And if you wanted to find what the adjustment was you could just subtract the prediction from the mean. I get that it shows how much weight each movie had on the adjustment...but why is that even important? Once you have a predicted rating you can just use that as the basis of a recommendation.

You can also look up the values with Index(match)

First i would like to say thank you so much for your videos, though im having issues with this one given exactly the same steps CLV per customer is coming out as 270.2 and beginning of year as 310.7 and the 2 dimensional table to include for the interest rate is being stuck on showing the same 15% interest rate values for every column so basically just the single dimensional table but treating every interest rate column as if it was 15%. Any correction or help with this would be greatly appreciated.

Hello Ye why we use this formula

Is this for user-user or item-item collaboration?

how to calculate hoy many warehouses i need for next deploy the location analysys?

I wish you were my professor! Such a precise and clear examples!

Thank you! I just got hired as a Marketing Analyst and this Course will surely help me a lot!

Thanks so much for the video. Can you give me a hint how to apply the video to solve my problem? We have a headquarters' location fixed and we want to find optimal location for several branches.

This video deserves more views and your channel deserves much more subscribers. Thank you so much

How did you pull the original data? I am having trouble finding a place to get the statistics from.

Can this strategy be used in a retail business

Great video. This is what I needed for my sales calls to show ROI on investment. Cheers!

This helped me so much thank you!

Is there any way for me to download the data file aside from patreon? I don't have Patreon, but I would like a copy of the data file.

what is total number of shipments sir , without fixing warehouse how can determine total no of shipments

how do you determine the demand equation?

Hello, thank you for your detailed explanations! What about if there are existing warehouses in the network, and you’re trying to solve for where the next warehouse should be?

i need the xls file. ...can you help me..?

It seems kind of pointless to create a bundle when there's no discount involved. What's the point, just buy two separate tickets.

If I was to hypothetically calculate the "cost" of said DC(s) I can use a cost per mile value on top of the distance × #shipments? Also, I could extrapolate this out to 3, 4, 5, DCs by updating new min distance columns, and changing the solver for new line of lat/long?

Thank you a lot for this video! Just one question, if I have the perfect segment. how to chose/shift or create a specific table for the specific segment? Thank you again.

Whether date( column c ) here is last purchase date ?

Very useful . Thanks you

This was really helpful, thank you very much ❤

Hello Ye, Thank you very much for sharing this simplified process of conducting an RFM analysis with us at no cost. I now have a better understanding of the process and feel confident to solve my assignments and even more optimistic about acing my finals. Also, I feel closer to being an Excel power user just by learning from you. Thank you very much, I am delighted because I feel intelligent knowing how to conduct an RFM analysis.

2x speed

good info thanks a lot

Thanks for the info!!

i always suck in this, thanks for video

Never knew how to do this, thanks

I like how your educating your student and people how aren't your student. You give them access to data file through Patreon. That's a very cool model that you created.

Thanks a lot- a comment from two yrs later

So useful! Nice!

Thanks!

Great Video - let's do it

Nice vid solid info!

Very nice and informative too. Nice work.

Helpful stuff! (Don’t sub to this channel please!)

Coool video my friend thank you for sharing ❤😊

I definitely needed to brush up on my excel skills. Thank you for this 🔥🔥

big brain

🧠

excellent video. looking forward to watching more, so keep up the great work!

great timing I was looking for a tool to help advise on next warehouse location.. thanks Ye Hu, great work..