Still remember how excited when I first learned how to do Cohort analysis in Tableau using LOD back then... It's insanely HELPFUL! As someone who oversees several EC stores' BI analytics, Cohort & Retention analysis is one of the essential I run regularly... at the end of the day, it all comes down to RETENTION, RETENTION, RETENTION!
@@vizwiz Hi Anthony, just wondering what subject matter I could buy a book on that would teach me the overview of concepts that this idea fits inside of. How can I learn more about these types of analyses?
Thanks Andy, do you have a way of analyzing the cohort from the first day they started? In my instance, I'm using term (Education), so date difference wouldn't work here. The cohort's first term is their cohort name like 202008 which I'm trying to compare against 202108's first term. I'm thinking a partition might be necessary but wanted to reach out first.
Hey Andy, I want to thank you for this super helpful video! Your instructions were very clear. I have an enhancement to the retention rate line graph that makes it more accurate by taking the average of the retention rates for each cohort at the given length of time from when they first purchased. AVG( { FIXED [Customers First Purchase Quarter],[Elapsed Quarters]: COUNTD([Email]) / sum([Customers per First Quarter])} )
Beautiful channel and I wish you the best in your life for spreading the knowledge in such a beautiful way, I just did not understand the elapsed quarters part, Could someone please explain?
This is probably overly specific, but you have different customers with the same name as evidenced by customers with the same name having different customer ID codes. To be truly accurate, wouldn't we than do the count distinct on customer ID instead of customer name?
@@vizwiz I only discovered that when I normalized the SuperStore excel file for use in Access. I make use of different customers having the same name when I am driving home the importance of a primary key. Only when my students mess up a query do that truly get what a primary does and why I went on and on about it. Different products also have the same product description as well.
Hey Andy, I understand the Retention Rate graph but I am getting lost on the point of the Elapsed Quarters Graph. What exactly is the graph is trying to relay? it seems the exact same as the retnetion graph except now the triangle is angled another way with the same results. the top header shows 1,2,3 etc instead of the Quarter names. Is that the only point of showing the retention graph as an elapsed graph?
Thanks for the video - super clear and helpful! I was wondering what should be done when cells show up as blanks because no users visited the app during that period?
Hi Andy,if I want to highlight the quarters when the customer make use the product by using another graph when I can select the single customer how should I implement that? I tried to add the customer as attribute but doesn't work
In terms of an employee retention cohort chart. I would like to do difference between hire date and termination date for the elapsed months. It does the calc correct for the ones who have termination dates but doesn’t display the months that don’t have any terminations. I’d like to show all months across the top regardless of if they have a termination. Any thoughts?
Thankyou Andy, what if I want to add a new table at last of cohort table that explain the average of retention rate through out the year? Is it possible? If yes then how to make it? Thankyouuu
Dear Andy. Thank you very much. But you have exact order date as information. How to do if I have several purchase by one customer in a different dates. How could I sort it as a first purchase date ?
HI... I have a question. In filters (wildcard search) , we have to give certain constraint that the user needs to select a minimum of 3 to 4 chars/nums in the wildcard search. then only the related info needs to display in the dashboard. Issue:- if the user enters 1 char also then the data is displaying and there will be large info.... starts with and ends with will not work out here because there will be multiple id's which starts with different numbers.
Very good lesson. Just one question: The line chart you created at the last, is it telling the cumulative retention rate or the average retention rate?
Andy! You are very helpful for me i have learnt lots of things to watching your videos. Now please give me some advice for the interview and tell me about the best company were i can join as an experience Data Analyst, Thanks