Тёмный

How to Solve a DATA ANALYTICS CASE STUDY 

Mo Chen
Подписаться 106 тыс.
Просмотров 41 тыс.
50% 1

🎉 Sign up to enroll for a 7-day free trial with Coursera now! ➡︎ imp.i384100.net/googleDACert #Coursera #CourseraPartner @Coursera
Get access to my exclusive content by joining my mailing list ➡ mochen.info/
Support me on Patreon ➡ / mo_chen
Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python ➡ • Portfolio Projects
┋Community & Socials┋
/ discord ⬅ Join our Discord Data Community
/ mo_chen1 ⬅ My IG is personal -- only follow if you're interested in non-data stuff as well
/ mo-chen1 ⬅ Daily tips & advice on how to enhance your data analysis skills
/ mo_chen_1 ⬅ Figuring out what I want to do in this space...
┋Professional Certificates┋
CourseCareers ➡ coursecareers.com/a/mochen
DataCamp Courses & Certifications ➡ datacamp.pxf.io/c/4216860/111...
Google Data Analytics Professional Certificate ➡ www.coursera.org/google-certi...
Google Advanced Data Analytics Professional Certificate ➡ www.coursera.org/google-certi...
Tableau Business Intelligence Professional Certificate ➡ imp.i384100.net/TableauBIAnalyst
Microsoft Power BI Data Analyst Professional Certificate ➡ www.coursera.org/professional...
IBM Data Science Professional Certificate ➡ imp.i384100.net/IBMdataScience
Google Project Management Professional Certificate ➡ imp.i384100.net/GoogleProject...
┋Timestamps┋
00:00 What is a case study?
01:06 Why is customer churn analysis so popular?
02:01 Analyzing churn rates
07:12 Communicating insights
┋The project┋
Story ➡︎ public.tableau.com/app/profil...
Workbook & Dataset ➡︎ github.com/mochen862/customer...
Thanks so much for taking a little time out of your day to watch this!

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

 

21 июл 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 61   
@mo-chen
@mo-chen 10 месяцев назад
🎉 Sign up to enroll for a 7-day free trial with Coursera now! ➡︎ imp.i384100.net/googleDACert #Coursera #CourseraPartner @Coursera
@Nicole_TC13
@Nicole_TC13 10 месяцев назад
Oh wow! Looks like Mo’s stepped up his editing game! Great video, understanding types of analysis beforehand can really help you figure out a problem that’s presented to you. Great advice, thanks!
@mo-chen
@mo-chen 10 месяцев назад
Thank you for the kind words! I'm very glad you liked the content 😁
@Whiskeydame
@Whiskeydame 3 месяца назад
Thanks so much for this video but also all of your other content. I am currently taking an online DA bootcamp and had a similar project. And all the student examples that were posted only took into account proportions of the same group (current or exited customers) but not the retention or churn rates which takes into account of total customers at the start. I was baffled if I was doing my calculations incorrectly, but it seems like we used the same dataset. I found this set to be a good example of Simpon’s Paradox. Looking forward to more content! Maybe someday I will post too! 😊
@mo-chen
@mo-chen 9 месяцев назад
Join the Data With Mo Discord Community ➡︎ discord.gg/Ay7gQTXE. Connect with other like-minded data people and make friends 😁
@itsMarcosBotello
@itsMarcosBotello 10 месяцев назад
Awesome storytelling! I have been taking the Coursera course for about two weeks now and I can definitely recommend it to anyone looking to check this field out. Thank you Mo! Really appreciate seeing an experienced Data Analyst's steps taken in this process.
@mo-chen
@mo-chen 10 месяцев назад
I'm so glad you enjoyed the storytelling part of it! I'm trying to make more entertaining and engaging content, whilst keeping it simple and educational! Great to have you here on the channel and good luck with the course 😃
@ericae.2258
@ericae.2258 5 месяцев назад
Hi I have a question for you, can you tell me what is the application that you use to explore the data set, thanks 👍
@chrisrandall2443
@chrisrandall2443 10 месяцев назад
Very cool case study! Took this as inspiration and created my own but took it one step further in Rstudio and added a logistic regression.
@mo-chen
@mo-chen 10 месяцев назад
Fantastic! Taking it a step further is music to my ears 😃 Well done!
@estebandiaz4405
@estebandiaz4405 9 месяцев назад
Great video Mr. Mo, just saw this one and immediately hit suscribe. Greetings from Medellín, Colombia and thanks for your content. Already watching more of your videos.
@mo-chen
@mo-chen 9 месяцев назад
Welcome aboard! Great to have you here on the channel 😁 Feel free to join the Data With Mo Discord Server as well if you want to connect with others discord.gg/WveQ2gGh
@sourach6325
@sourach6325 5 месяцев назад
hi, i have enrolled in data analyses course with coursera and now i am doing the case study project BUT i have a question about how the case study should look like when i attach it to the portfolio or the notebook? now from your video i understand that the every function i write and analysis is what i am going to paste in the notebook so is that it ? is that how i should write the study case? i am a little bit lost when i started writing the study case i am not sure how it should look like and i am not sure how to attach it. hope you answer me ASAP 😭😭😭
@richardenriquezjr.9868
@richardenriquezjr.9868 10 месяцев назад
Thank you so much for making this video. I first saw this topic on your last Q and A video, and it is fascinating to talk about and to learn about. Please keep making videos like this. Thank you so much.
@mo-chen
@mo-chen 10 месяцев назад
I'm glad you liked it 😁 Thanks for watching!
@sardik9158
@sardik9158 7 месяцев назад
Hi Mo, I got it very useful, I have question for you, I want to translate your videos into my native language, how can I contact you?
@kapur.betzy2023
@kapur.betzy2023 10 месяцев назад
We'd love to see more advanced end-to-end projects in Excel, SQL, and Power BI on your channel. Your content is fantastic, and we're eager for even more challenging projects.
@mo-chen
@mo-chen 10 месяцев назад
Thanks for watching! I have lots more end to end portfolio projects on the channel. Check some out here ru-vid.com/group/PLodYDTuHA29aa_5UPCNg_g5fyleHxTZPU&si=LvCeV3HK-7LjMtSC 😃
@badmind9293
@badmind9293 2 месяца назад
What software is he using
@seththedatanerd1743
@seththedatanerd1743 10 месяцев назад
Love it, Mo
@mo-chen
@mo-chen 10 месяцев назад
Nice, thanks a lot for watching 😃
@nyakehkallon6597
@nyakehkallon6597 10 месяцев назад
Mo at it again lol nice one my Guy .
@mo-chen
@mo-chen 10 месяцев назад
Haha I try my best 😃
@settyspace
@settyspace 5 месяцев назад
Damn mo Chen looking fine talk data 2 me lmaoo
@khushisharma4694
@khushisharma4694 10 месяцев назад
Mo love it and thank-you please make more case study like this
@mo-chen
@mo-chen 10 месяцев назад
I will for sure! Meanwhile, I have a portfolio project playlist here ru-vid.com/group/PLodYDTuHA29aa_5UPCNg_g5fyleHxTZPU&si=WaWp42GCJCUlkvbE. Feel free to check it out 😃
@khushisharma4694
@khushisharma4694 10 месяцев назад
Thankyou mo🤗
@Dreamerzk2023
@Dreamerzk2023 10 месяцев назад
Really like your case study video Mo ! I actually just did case study on the same dataset you used here two weeks ago.Right now I am trying to find dataset and do Risk related projects in finance industry ,since you had experience working in the Risk field ,can you please give me some direction or advice that I should focus on? Looking forward to your future case study contents :) .
@mo-chen
@mo-chen 10 месяцев назад
Glad it was helpful! You can go to Kaggle and just search credit risk under the datasets section. That should give you lots of financial industry datasets and projects to choose from 😁
@unfff
@unfff 10 месяцев назад
Would love to see the ending presentation of this story to the stakeholders as that is the section of data analysis I have trouble with, especially when it comes to communicating with non-technical stakeholders.
@mo-chen
@mo-chen 10 месяцев назад
Try read the books under the soft skills section to structure your thoughts datawithmo.com/data-roadmap/ 😁
@ezehconfidenceadaeze6189
@ezehconfidenceadaeze6189 2 месяца назад
@@mo-chenthe site is not active
@damilolaakinbo6512
@damilolaakinbo6512 10 месяцев назад
I love your content Mo.
@mo-chen
@mo-chen 10 месяцев назад
I’m glad to hear this! Great to have you here on the channel 😃
@boriska22sokolov32
@boriska22sokolov32 10 месяцев назад
Mo, thank you so much for video. It’s really cool format. Where did you take data for analysis? Can you give me a link? Because I am a beginner and I want to practice my knowledge for other databases.
@mo-chen
@mo-chen 10 месяцев назад
I'm glad you liked the video! All links are in the description 😃
@kafkawanter.
@kafkawanter. 10 месяцев назад
Hey bro, ty for guiding me cuz i kinda seem to like this field than other coding jobs, i wanna ask a question it may be dumb😅 Im totally new to this job placements and job hunting, do they usually keep interviews for data analytics job or do they first keep entry tests like aptitude and technical etcc for freshers in this field ??
@mo-chen
@mo-chen 10 месяцев назад
Not a dumb Q at all! There is no standardized approach, it'll really just depend on which company you're applying to. Great to have you here on the channel 😃
@sarkerdeep6466
@sarkerdeep6466 10 месяцев назад
Mo thank you so much.Would to tell me the area of prompt engineering..
@mo-chen
@mo-chen 10 месяцев назад
Sorry, I didn't get your question. Would you mind rephrasing it please?
@zabashhd459
@zabashhd459 10 месяцев назад
Hey Man Big fan, i just completed Data Analytics certification from Google now i am currently doing the SQL from UC Davis but can you make a series explaning everthing step by step how to get a Job as a junior Data Analyst i mean i need some portfolio projects from start to finish, like getting the data, cleaning , analyzing and make viz on Tableau that may showcase to employers !!!
@mo-chen
@mo-chen 10 месяцев назад
I have lots of end to end portfolio projects on my channel ru-vid.com/group/PLodYDTuHA29aa_5UPCNg_g5fyleHxTZPU&si=nN1fKP9bVNGXYFGs 😁
@kthm4095
@kthm4095 10 месяцев назад
Should I get an internship experience as a data analyst or similar field? I'm starting my final year of uni this September in London studying data analysis. How did you kick off your career?? Need your advice Mo!!
@mo-chen
@mo-chen 10 месяцев назад
If you're in your final year, getting on a graduate scheme is probably your best choice. I started out on a grad scheme as well 😁
@user-ox4zj8xx7o
@user-ox4zj8xx7o 10 месяцев назад
Thank you for another useful video Mo. Can you please tell me how to get londitude and latitude in Churn by Country. Is it automatically generated? I'm a beginner, so please guide.
@mo-chen
@mo-chen 10 месяцев назад
I simply used the country name column to generate the map. Just double click on it and Tableau should generate the map. As long as Tableau recognizes the country column as a geolocation column.
@user-ox4zj8xx7o
@user-ox4zj8xx7o 10 месяцев назад
Okay. Thank you@@mo-chen
@s.845
@s.845 10 месяцев назад
can you tell us more the difference between BI and Data Engineer? :) love ur videos
@mo-chen
@mo-chen 10 месяцев назад
BI engineers will be more focused on business intelligence data whereas data engineers would build pipelines and define the data architecture for all data. I’m very glad you like the content 😃
@CaribouDataScience
@CaribouDataScience 10 месяцев назад
How long did the entire project take you to complete?
@mo-chen
@mo-chen 10 месяцев назад
This took me about 2 hours from the moment I first looked at the dataset
@gourabsarker9552
@gourabsarker9552 10 месяцев назад
Sir how much a data scientist in your position earns in UK? Plz reply. Thanks a lot.
@mo-chen
@mo-chen 10 месяцев назад
Depends on your experience / company / exact role. Can fluctuate widely - anywhere between 30k to 150k
@souravpaul6858
@souravpaul6858 10 месяцев назад
Please use time stamps . It will be appreciated. Great work done thanks!! 🙏
@mo-chen
@mo-chen 10 месяцев назад
Glad you liked it, thanks a lot for watching 😁
@Chanezk
@Chanezk 7 месяцев назад
🙌🙌👏👏
@mo-chen
@mo-chen 7 месяцев назад
😃
@Anubis1010-tx1ev
@Anubis1010-tx1ev 4 месяца назад
Are you crazy 🤣🤣 is it this simple do data analysis 🤣🤣 even kids can do it without putting any effort...you are hiding something from to make sure that your real works stay to be hidden
@zdenekdanko4729
@zdenekdanko4729 7 месяцев назад
I don't believe in this path. Data science is dead. Only protective kids do this job.
Далее
What does a Data Analyst actually do? (in 2024) Q&A
14:27
ПОЮ НАРОДНЫЕ ПЕСНИ🪗
3:19:41
Просмотров 1,9 млн
This is how I ACTUALLY analyze data using Excel
24:05
Learn how to SOLVE a data analytics case study problem
14:21
Performing Customer Churn Rate Analysis in Excel
19:40
The Harsh Reality of Being a Data Analyst
7:39
Просмотров 566 тыс.
#Tableau - Calculate Customer Churn Rate
6:58
Просмотров 15 тыс.
3 Essential Excel skills for the data analyst
18:02
Просмотров 1,5 млн
How I'd Learn Data Analytics in 2024 | 3 Month Plan
11:42
EASIEST WAY TO BECOME A DATA ANALYST
15:10
Просмотров 37 тыс.