Oct 25 2021 10:28 AM
Oct 25 2021 12:47 PM
You could begin by explaining what you mean by "retention matrix" and how such a matrix is built in the first place.
(Your question seems to imply that the data available is inadequate, but for those of us (and I even worked a full career in HR) who don't recognize the term "retention matrix" it would help if we defined terms.)
Oct 25 2021 12:53 PM
Oct 25 2021 12:57 PM
Oct 25 2021 01:15 PM
Oct 25 2021 01:24 PM
Nope, sorry, first time in my life I knew that such exists that's from your post.
Oct 25 2021 03:06 PM
Oct 25 2021 05:45 PM
You can dispense with the "bro" label, please.
May I ask you a question: Is this a school assignment? It's beginning to look like it might well be. If so, then this is not a place where we do people's homework for them. Go talk to fellow students or your teacher.
If that's NOT the case, then you need to do a far better job of defining what you need from that data. Several of us have asked you to explain what a retention matrix is; that means we don't know. So if you have it as a work assignment (not a school assignment) then that would suggest you also have some sense of the meaning of the term, what it is you want to learn from the data, or how you want the data summarized. If that's not the case, do some research. And share a link that would explain it.
Oct 25 2021 08:35 PM
Oct 25 2021 10:08 PM
The prerequisites and the weight of the KPIs are not clearly defined.
Here is some information and questions that I was able to fish out on the Internet,
maybe this information will help you further.
How to measure Retention Rate using Cohort Analysis in excel
How To Build A Cohort Analysis in Excel [with template]
Excel template for cohort analysis and customer lifetime value
Oct 26 2021 01:10 PM