How to Solve a DATA ANALYTICS CASE STUDY

[@mo-chen]

🎉 Sign up to enroll for a 7-day free trial with Coursera now! ➡︎ imp.i384100.net/googleDACert #Coursera #CourseraPartner @Coursera

[@noelmoran9436]

I just finished this course. I have no other experience in this field. I'm beginning to look for a job. I'm worried about the interview process and case studies in the interview process. I was thinking of starting a page where I can showcase my work and get more practice before actually applying for real jobs. Any advice would be greatly appreciated.

[@Nicole_TC13]

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]

Thank you for the kind words! I'm very glad you liked the content 😁

[@itsMarcosBotello]

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]

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 😃

[@LoveLight9]

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! 😊

[@kapur.betzy2023]

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]

Thanks for watching! I have lots more end to end portfolio projects on the channel. Check some out here kzbin.info/aero/PLodYDTuHA29aa_5UPCNg_g5fyleHxTZPU&si=LvCeV3HK-7LjMtSC 😃

[@chrisrandall2443]

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]

Fantastic! Taking it a step further is music to my ears 😃 Well done!

[@aramayis]

This is actually just the final step of data analytics, often referred to as "data visualization." In reality, most of a Data Analyst's workday involves wrangling and transforming raw data to get the analytics friendly data-like the file you get from Kaggle. 😊

[@estebandiaz4405]

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]

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

[@settyspace]

Damn mo Chen looking fine talk data 2 me lmaoo

[@richardenriquezjr.9868]

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]

I'm glad you liked it 😁 Thanks for watching!

[@Kamalfayadh]

Thank you. Is it possible to have Tablue free demo for training purposes?

[@sourach6325]

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 😭😭😭

[@ericae.2258]

Hi I have a question for you, can you tell me what is the application that you use to explore the data set, thanks 👍

[@ddt9978]

Hi Mo, thank you so much for the video. I'm just wondering how do you come up with all the questions to be answered (e.g. churn rate by age group, churn rate by satisfaction score...) given a set of data in any project (or even in real life). Like, are these questions from the top executives or are there any specific metrics or guideline that help you to do this? Thank you Mo, wish you all the best!

[@mo-chen]

It'll be a mixture of stakeholder interaction and using your own domain knowledge. So basically it boils down to your own experience and knowledge, combined with working with other people/teams.

[@ddt9978]

@@mo-chen Thank you so much Mo, it's more clear for me now

[@nyakehkallon6597]

Mo at it again lol nice one my Guy .

[@mo-chen]

Haha I try my best 😃

[@damilolaakinbo6512]

I love your content Mo.

[@mo-chen]

I’m glad to hear this! Great to have you here on the channel 😃

[@seththedatanerd1743]

Love it, Mo

[@mo-chen]

Nice, thanks a lot for watching 😃

[@Dreamerzk2023]

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]

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]

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]

Try read the books under the soft skills section to structure your thoughts datawithmo.com/data-roadmap/ 😁

[@ezehconfidenceadaeze6189]

@@mo-chenthe site is not active

[@khushisharma4694]

Mo love it and thank-you please make more case study like this

[@mo-chen]

I will for sure! Meanwhile, I have a portfolio project playlist here kzbin.info/aero/PLodYDTuHA29aa_5UPCNg_g5fyleHxTZPU&si=WaWp42GCJCUlkvbE. Feel free to check it out 😃

[@khushisharma4694]

Thankyou mo🤗

[@CaribouDataScience]

How long did the entire project take you to complete?

[@mo-chen]

This took me about 2 hours from the moment I first looked at the dataset

[@zabashhd459]

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]

I have lots of end to end portfolio projects on my channel kzbin.info/aero/PLodYDTuHA29aa_5UPCNg_g5fyleHxTZPU&si=nN1fKP9bVNGXYFGs 😁

[@sarkerdeep6466]

Mo thank you so much.Would to tell me the area of prompt engineering..

[@mo-chen]

Sorry, I didn't get your question. Would you mind rephrasing it please?

[@kafkawanter.]

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]

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 😃

[@boriska22sokolov32]

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]

I'm glad you liked the video! All links are in the description 😃

[@sardik9158]

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?

[@badmind9293]

What software is he using

[@kthm4095]

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]

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 😁

[@souravpaul6858]

Please use time stamps . It will be appreciated. Great work done thanks!! 🙏

[@mo-chen]

Glad you liked it, thanks a lot for watching 😁

[@DhanyaShetty-j6x]

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]

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.

[@DhanyaShetty-j6x]

Okay. Thank you@@mo-chen

[@gourabsarker9552]

Sir how much a data scientist in your position earns in UK? Plz reply. Thanks a lot.

[@mo-chen]

Depends on your experience / company / exact role. Can fluctuate widely - anywhere between 30k to 150k

[@mo-chen]

Join the Data With Mo Discord Community ➡︎ discord.gg/Ay7gQTXE. Connect with other like-minded data people and make friends 😁

[@Coconut-bentoAsmr]

🙌🙌👏👏

[@mo-chen]

😃

[@Anubis1010-tx1ev]

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]

I don't believe in this path. Data science is dead. Only protective kids do this job.