Exploring Data in SQL and Tableau | Cohort Retention Analysis | Data Analyst Projects | SQL Projects

[@flyeagle320]

Nobody would have explained concept in such a easy way like you . Even though there was involvement of writing such a long query , i didnt feel stuck anywhere . Please keep doing this type of Sql and python real world project . Thank you Angelina.

[@franciscoloncq2820]

Can't thank you enough for sharing this type of knowledge. I am trying to become a data analyst and your tutorials have been the best I have found accross all KZbin. I hope you keep on sharing your insights because they are super valuable!

[@Humble10]

for me import flat file option has worked. Just change the nvarchar(100) and allow null. BTW, great work.

[@paulrhee-h1k]

Another way to import the flat file without going through visual studio is to use power query on the data range in the Online Retail file and remove blanks from each column. When importing, I had to change the data types on the smallint's to INT and it all loaded great. Your combined SQL and tableau projects are the best on youtube and hope to see many more of them

[@nitaenwereji733]

Thank God I came across this video. Very insightful! I love how you were straight to the point, but also knowing when to chip in some explanations for clarity sake. Thank you so much!

[@JamesBrogan-w5t]

Thank you for this video. I know this video has been out a while, but I have only just discovered it. You explain this concept in such a clear and concise way and I really appreciate that !

[@hoosier-daddy465]

truly excellent video. I ended up have 2 more records in the cleaned dataset. Not sure why but it didn't matter that much.

[@vishalbiyer4063]

I usually don't comment on videos but your tutorials are great. Kindly continue to share your expertise / knowledge with us. Waiting for your next video. Many thanks :)

[@rupanjoybardhan]

I can't thank you enough Ma'm....seriously speaking , both your projects are very well done and helped me a lot.

[@jeanvitola]

Hi i'm Data Analyst in colombia, it´s video is amazing

[@xtyandone.2252]

i love your explanation and tutorial, can you do 1 with risk analysis or A/B testing technique?

[@ayushsingh6435]

Fantastic tutorial, followed it through the end

[@akshayhalande]

It was the great session i have seen ever.....

[@muktigupta5914]

Such an amazing video. Thankyou so much. I learnt a lot. More power to you!

[@sharangan112]

I had to come back again and say thank you again. I love your content and it’s really useful as someone who has started a data analyst role.

[@AngelinaFrimpong]

You are so welcome! Glad to know you find my content useful.

[@HobbitFamily]

Your video is awesome. I can’t wait to watch the new project on End to End project please.

[@kambalasantosh]

Very good way to explain it 👌 Thank you so much for you effort for us. ❤

[@unedited3598]

Content mu nyinaa madam!! Keep it up👍

[@AngelinaFrimpong]

Medaase 🙂

[@shrutishah2028]

Thank you for posting this one. Easy to understand👍thank you again.😊

[@CaribouDataScience]

Thanks, That is some fancy SQL.

[@MaximusKale]

Thank you, this was very helpful and well explained!

[@tuananhdo6006]

Wow this is just what I needed, I was struggling how to get started with retention analysis and tableau. Luckily I found this video, what a gem! Thank you Angelina! I just have one question, in 40:59, you did something that instantly generate the code for the 13 unique indexes, how did you do it?

[@BảoĐoàn-j1z]

Thanks to the informative videos with much knowledge. But in 17:28 when you checked duplicate values and executed SELECT * FROM dup_check WHERE dup_flag = 1 The result was 392,667 rows but you noted that it had 397,667 rows. I am not sure that you are wrong, but can you check again this point?

[@xcc7437]

this is amazing. keep going!

[@mario-s3m3b]

Your video is amazing

[@ammarirsyad6018]

It is a very useful and helpful video. I love how you explain every step you do. I try to mimic you by using MySQL, but in MySQL cant inserting forward to temporary tables using #, Do you have any suggestion how to do it in MySQL? Thanks

[@sarpongphilemon342]

Welcome back madam😘 😊

[@AngelinaFrimpong]

Thank you! 😃

[@victor_peral]

Always dishing out amazing stuffs. Thank you as always

[@telugupadyalu...6927]

great

[@danielpanda88]

Amazing explanation, keep up the good work!

[@adilmajeed8439]

Thanks for sharing a content. Could you explain the Cohort Index in little bit detail? How you come to such a calculation?

[@ganeshgautam1500]

The cohort index represents the tenure in months, indicating how long the customer has been with the retailer or engaged with the product since their first purchase. A value of 1 means the customer made a purchase in the same month as their first purchase. This value was added when converting the first purchase date into months.

[@sharangan112]

Thank you so much

[@AyobablosCorner]

Amazing video Angelina. When are you coming back please?

[@sidiqcarew7836]

Lovely thank you, Can you please explain the cohort index formulae ?

[@sakshikothari7689]

Hi, it is a great video. Thank you for sharing the practical knowledge with us. However, I would like to bring to your notice that I am unable to download the data sheet from the website mentioned in the video. Can you please help me in this regard, so that I can also perform the practical analysis.

[@Blablabla-rq3to]

Love it!!

[@Arrow665]

Hi, Angelina thanks for posting such an insightful video. Can we connect on Microsoft teams? I have a data set where I need to perform weekly cohort retention analysis.

[@apexsmart6337]

Amazing content always! I've gone over this but I still need clarity; If a customer's Cohort_index is 1, does that mean they made their second next purchase(s) in the month they made the first purchase or the second month?

[@victor_peral]

Yes it means they made their second purchase in the first month, Try to study the concepts of customer retention, net dollar retention, life time value You’d understand things clearly

[@RishabSg]

Is this an insight into how SQL and tableau is used in real life? Or it is more complex?

[@moviemusicmash4899]

In the beginning do you need specifically Visual Studio 2019 ? Or can you use an older version like 2015 or 2013?

[@juriszikmanis]

Nice voice

[@danbello4728]

please I don't get the part of the visual studio code, what's that for please, can I just start at the sql point? is it just to import the data into SSMS?

[@rondraughon5572]

Very informative video. May I suggest getting a better microphone? It's hard to hear you sometimes.

[@ShokhinaBadrieva]

Hi, please help! When I do percent of total in tableau it doesnt treat the first column as 100%. What can I do to fix this? It takes the whle row and finds the percent each col is in the row.

[@souravsaha7751]

Hello Angelina, it is a wonderful project but I can insert CSV data sit in SQL it shows me this error can you help me with it? Error inserting data into table. (Microsoft.SqlServer.Prose.Import.SDS) Column 'Description' does not allow DBNull.Value. (System.Data)

[@symoncanary1762]

Chevk out stackover flow

[@anjaliunnikrishnan5814]

Change the data types of Quantity to bigint since it contains one big number and unit price into numeric since it contains negatives in the destination table .Then it works

[@sammyanalyst]

Please come back! Please!

[@AngelinaFrimpong]

I am coming back soon

[@rubynguyen6323]

Some part when I followed you and it showed an error and the data returned also different

[@HobbitFamily]

I am waiting for you to come back with the tutorial.

[@AngelinaFrimpong]

Very soon!

[@the_imposter_analyst]

Please what if I am analysing for two years? How do I go about the indexing? Because I am getting negative values when I subtract the months. 🙏🙏

[@the_imposter_analyst]

Nevermind, it works still. Thanks for such an insightful video.

[@CaribouDataScience]

What have you been upto for the last two years?

[@TheMapleSight]

You are great, but please make the code a bit wider

[@OsaroEmovon]

cannot download dataset

[@felixmirekudanquah3562]

Hello I am an upcoming data scientist. I would really love it if you can mentor me

[@AngelinaFrimpong]

Absolutely!

[@moviemusicmash4899]

Unfortunately I never got past executing the task.

[@rondraughon5572]

Just so you know, Camille Johnson stole this from you and made a short video on it. She even used the exact same color schemes.

[@AngelinaFrimpong]

Thanks for the heads up, do you please mind sharing the link?

[@rondraughon5572]

kzbin.info/www/bejne/nojSnnatnbKKm5I

[@DonBoogaloo72]