![Mo Chen](/img/default-banner.jpg)
- 160
- 3 830 579
Mo Chen
United Kingdom
Приєднався 25 гру 2022
👋 Hey there, my name is Mo Chen. I'm a Data Analytics Professional / Content Creator. I make videos covering 📊 data 🏢 career and 🏠 life in general
Відео
Job Interviews: The best candidate may not be the IDEAL candidate
Переглядів 818День тому
How to actually learn AI skills in 2024? #ai #CourseraPartner #artificialintelligence
Переглядів 1 тис.День тому
Learning how to leverage the power of AI is becoming increasingly more important. If you're not sure where to start, check out the Google AI Essentials course on Coursera ➡️ imp.i384100.net/mo-chen-google-ai-essentials. Happy learning!
How to get your next data job? | Q&A Sunday | June 2024
Переглядів 1,2 тис.День тому
GET YOUR DATA JOB ➡ mochen.info/ ULTIMATE DATA PORTFOLIO: Everything you need to get your data job ➡ mochen.info/ultimate-data-portfolio-lp/ 1:1 MENTORSHIP PROGRAM: I put my heart and soul into this program. I'm here to help you succeed ➡ mochen.info/1-1-mentorship-lp/ AI JOB QUEST: Change the way you apply to jobs ➡ mochen.info/ai-job-quest-lp/ PATREON ➡ www.patreon.com/mo_chen CourseCareers: ...
This is how I ACTUALLY analyze data using Excel
Переглядів 8 тис.6 днів тому
GET YOUR DATA JOB ➡ mochen.info/ ULTIMATE DATA PORTFOLIO: Everything you need to get your data job ➡ mochen.info/ultimate-data-portfolio-lp/ 1:1 MENTORSHIP PROGRAM: I put my heart and soul into this program. I'm here to help you succeed ➡ mochen.info/1-1-mentorship-lp/ AI JOB QUEST: Change the way you apply to jobs ➡ mochen.info/ai-job-quest-lp/ PATREON ➡ www.patreon.com/mo_chen CourseCareers: ...
Don't limit yourself to the DATA ANALYST title
Переглядів 2,7 тис.7 днів тому
Excel & SQL Advice for Data Analysis
Переглядів 4,5 тис.9 днів тому
Consistency Beats Talent
Переглядів 2,3 тис.11 днів тому
Know Your Market Value to Set Realistic Job and Pay Expectations
Переглядів 1,4 тис.18 днів тому
Communication and Stakeholder Management Matter. So Much. More Than You Think.
Переглядів 1,6 тис.19 днів тому
Don't Become a Data Analyst: Unlock Your Competitive Edge
Переглядів 11 тис.20 днів тому
GET YOUR DATA JOB ➡ mochen.info/ ULTIMATE DATA PORTFOLIO: Everything you need to get your data job ➡ mochen.info/ultimate-data-portfolio-lp/ AI JOB QUEST: Change the way you apply to jobs ➡ mochen.info/ai-job-quest-lp/ PATREON ➡ www.patreon.com/mo_chen 1:1 MENTORSHIP PROGRAM: I put my heart and soul into this program. I'm here to help you succeed ➡ mochen.info/1-1-mentorship-lp/ CourseCareers: ...
How to become a great manager?
Переглядів 2 тис.21 день тому
How Much SQL Do You Need?
Переглядів 6 тис.23 дні тому
What Does Working Under Pressure Actually Mean?
Переглядів 1,7 тис.24 дні тому
How to Write Better Emails at Work
Переглядів 2,2 тис.25 днів тому
How to Communicate Effectively in your Workplace
Переглядів 99826 днів тому
At this point, Ill just absorb whatever content, because he is very engaging with his content updates.
This is the best explanation for Window Functions, even for courses where you need to pay. Thank you <3
Don’t fool yourself with “and it’s an entry level role.”
That is very bad for the company. It sounds very personal than professional. The company HR needs to get involved in this kinds of unprofessional act.
Where is the excel data set ? I want to practise along the video pls ?
i have a question at 12:16. 1 crime may be have many records ( for many type crime). So Is his code True?
Thanks
We need more vids like this
I havent watched this video but it was sponsored so I just thought I'd turn up to say that anything done in 10 minutes is probably unoriginal and you're likely just copy+pasting others peoples code, using others peoples servers and this video probably pushes a money making product. If you want to learn about AI, you gotta go through the boring stuff ;)
This is a kid work 😂 this guy misleading everyone do you actually believe data analysis is tha much easy sorry guys reality is far away from thia
Woow a different perspective. What do you do at your job as a Data Analyst? Curious to hear your thoughts
I think you may have missed the point of this video. My intention was not to show off, but to make content that people can actually relate to and understand. Sure, I could've cleaned a super messy dataset like the one you'd get at work and spent 3 hours on that, and then move on to the analysis bit - but I thought I'd skip that and simplify my messaging to give people a glimpse of how a real-life data analyst would think.
love the content by the way, my question is I have a data set that doesn't have a primary key or foreign key the rows repeat so when I try to link it to another data set it is impossible because i don't know how to create a primary key or foreign. Do you have anything like this?
My best bet would be to create a composite key that is unique
@@mo-chen i have been working on it for years and I can't do it...lol..I tried making a table with unique primary Id and when I link it to the other tables ..it doesn't work. I guess One day I will find a video on this. I am currently going to look at your playlist on SQL..I really like your voice and can sit through a video. There are other voices that are to high pitch and I just can't watch. I am so glad I found your channel.
Thank you so much, you took me from 0 to 100% knowledge on tableau.
Glad to hear that!
Hi, can you tell me how I can separate a full name with no spaces just capital letters at the beginning of first and last name 👍 Excel 2021 version🫡
Mo Amazing Video love it but I request you to Plz make Videos on these topics and things that are technical and how to extract and analyze data in Sql and also in python because this is very important and no one is making that type of videos on technical aspect We will be waiting for it Plz Mo Thankyu
I have a full SQL Tutorial course on YT, and I have an entire portfolio project playlist covering lots of technical projects. Please check them out!
I am a data analyst with a passion yo investment. Please create a video on hiw to start and continue investment routine and do reasonable savings for data analysts who think of future.
may you share your portfolio
What software do you use to record these videos, OBS?
Yes, that's right!
Thank you for being honest about the reality of the role as a Data Analyst. It is very insightful!
Glad you enjoyed it!
That is all what I am absolutely focused on. Be profecient enough to query the database and retrieve stored data that meet my requirements and use excel or R (dplyr) or Pyton (pandas) for the relevant analysis to spot trends and patterns. You just read my mind. Thank you for such an amazing timely advise.
I'm glad being precise helped you!
After reporting connections between every charts, when I am adjusting the timeline, the formatting of the 'Top 5 customers' are getting changed, does anyone know why and how to fix this?
Wow after 10 minutes of this I am losing my mind lol
In a good way?
@@mo-chen no im just getting frustrated, I keep putting the formulas in slightly wrong. I'm getting it just taking a while, but this is a great project for me thank you
@@mo-chen Hello, I'm getting stuck with the loyalty card function at 38 minutes in. Every time I put the formula in I get an error that says "SPILL". This is the exact formula I'm putting in =XLOOKUP(customers!$A$1:$A$1001,customers!$A$1:$A$1001,customers!$I$1:$I$1001,,0)
Hi mo chen, I am interested to take your advice of focusing my data analysis skills and critical thinking. However what the data analysis skills that are transferable you mentioned.
All data analysis skills are transferable. Any technical skills, techniques, methods, etc
It was a very interesting video. It’s valuable to see how you approach an analysis. Thanks for the free content!
I’m so glad you liked it! Thanks for watching!
ur video really helps alot, thanks!
I’m glad you found it useful! Thanks for watching!
Hi, mate! My name's Vlad. I'm from Ukraine. Three months ago, I became a data analyst. This is my first job as an analyst. You mentioned Tableau in this video, and I just want to say that a few months ago I watched your video wheere you bilt a dashboard. I learned a lot from that tutorial and it actually helped me to nail the test task for my current job. Just wanted to say thank you for these tutorials. Keep going!
Hi Vlad, I just wanted to say that I’m super happy a piece of my content directly helped in some actual step in your job application process. Congrats on the job and thanks for watching!
Thanks for this again Another simple but wonderful resource. I like how you can create these function on-the-go. I know I'd make a lot of mistake before arriving at the formula for MAT if I was in your shoes.
I’m glad you liked it. Even though the calculations are on the fly, trust me, I prepared before hitting the record button!
@@mo-chen Nice. I appreciate your honesty
I recently just learned how to use the pivot tablet and this is a great insight on how to use them in real-time. I'm new to data but I'd love to learn. Curious, do you cleanse the data first before using the pivot table or do you use pivot table to find anomalies for cleaning?
Good question. Data in real-life will never be this clean. I made up this fictitious dataset and I made it clean for this video because I wanted to focus on quick analysis, rather than quick data cleaning. Who knows, maybe I'll make a quick data cleaning video next...
@@mo-chen Dude you should! You'll add another flavor to the ice cream. Also appreciate the key "shortcuts." I'm all for increasing efficiency.
Thank you so much for starting the video by simply answering the question. I don't need an introduction or to be told to like and subscribe (which I did).
Thanks so much, I'm glad you liked it! Actually somewhere in the middle of the video I did ask for a little favor in the form of subscribe please, but I guess you just skipped it -- which is absolutely fine haha.
How can I get this data to follow along?
The link is in the description : )
@@mo-chen is it free?
I am a medical technologist too. And now wanting to become an analyst. Do you guys have an opening? 😅 I’m trainable lol #imserious
Haha no openings but please check out my other videos or go to my website at mochen.info if you're really looking to become an analyst fast!
@@mo-chen thank you guys! Watching your video today alongside with your wife knowing she used to be a med tech made me feel so much better!
Do you use windows or Mac for your work?
Windows
Can I get the dataset?
Of course, the link is in the description
Where do u learn the basic of python? Until u r ready for essential libraries such as numpy and pandas?
Thanks
Thank you Mo! I work in the same field and you inspire me to be a better professional at what I do. I'm also passing along your videos to my sons, so they'll get to improve their work strategies.
Thanks so much for watching. I hope your sons find value in my content too!
Well detailed, I have been using Excel for several tasks , glad to watch this
The 🐐 dropped a video 🔥
HAHA thank you for watching!
Nice video but the view is small cant really see what you're clicking
Not a data analyst but my approach for quick data work in excel to answer some questions is practically identical. Nice!
Nice one! You don't have to be a data analyst to be great at analyzing data.