Mo Chen
Mo Chen
  • Видео 157
  • Просмотров 3 781 273
This is how I ACTUALLY analyze data using Excel
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/
PATREON ➡ www.patreon.com/mo_chen
CourseCareers: Start the FREE Data Analytics Introduction Course Now ➡ coursecareers.com/a/mochen?course=data-analytics
Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python ➡ ruclips.net/p/PLodYDTuHA29aa_5UPCNg_g5fyleHxTZPU
DataCamp Certifications ➡ datacamp.pxf.io/c/4216860/2053564/13294
┋Community & Socials┋
discord.gg/EBh7j9uRJ...
Просмотров: 1 697

Видео

Don't Become a Data Analyst: Unlock Your Competitive Edge
Просмотров 10 тыс.14 дней назад
GET YOUR DATA JOB ➡ mochen.info/ ULTIMATE DATA PORTFOLIO: Everything you need to get your data job ➡ mochen.info/ultimate-data-portfolio-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: Start the FREE Data Analytics Introduction Course Now ➡ coursecareers.com/a/mo...
The Only Power BI Portfolio Project You Need
Просмотров 7 тыс.21 день назад
GET YOUR DATA JOB ➡ mochen.info/ ULTIMATE DATA PORTFOLIO: Everything you need to get your data job ➡ mochen.info/ultimate-data-portfolio-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: Start the FREE Data Analytics Introduction Course Now ➡ coursecareers.com/a/mo...
This is what you should do to have a long-lasting, successful data career
Просмотров 4,7 тыс.28 дней назад
This is what you should do to have a long-lasting, successful data career
How To Get An Unfair Advantage In Data Analytics
Просмотров 12 тыс.Месяц назад
How To Get An Unfair Advantage In Data Analytics
Ultimate Home Office Setup of an Analyst
Просмотров 3 тыс.Месяц назад
Ultimate Home Office Setup of an Analyst
5 TIPS to BUILD a DATA ANALYTICS PORTFOLIO that STANDS OUT
Просмотров 9 тыс.Месяц назад
5 TIPS to BUILD a DATA ANALYTICS PORTFOLIO that STANDS OUT
How to Hack Your 20s: 100K+ Data Career, Money Mastery, Marriage
Просмотров 5 тыс.Месяц назад
How to Hack Your 20s: 100K Data Career, Money Mastery, Marriage
My Ultimate Home Office as a Data Analyst / Content Creator | Desk Setup, Accessories, Organization
Просмотров 6 тыс.2 месяца назад
My Ultimate Home Office as a Data Analyst / Content Creator | Desk Setup, Accessories, Organization
Fastest Way to a $100K Data Analytics Career
Просмотров 5 тыс.2 месяца назад
Fastest Way to a $100K Data Analytics Career
How to actually get a job in data analytics?
Просмотров 4,5 тыс.2 месяца назад
How to actually get a job in data analytics?
How to ACTUALLY become GREAT ANALYSTS
Просмотров 7 тыс.2 месяца назад
How to ACTUALLY become GREAT ANALYSTS
The Truth About Data Analyst Roles
Просмотров 6 тыс.2 месяца назад
The Truth About Data Analyst Roles
Life of a Data Analyst in the UK
Просмотров 8 тыс.3 месяца назад
Life of a Data Analyst in the UK
EASIEST WAY TO BECOME A DATA ANALYST
Просмотров 35 тыс.3 месяца назад
EASIEST WAY TO BECOME A DATA ANALYST
How to build a SUCCESSFUL DATA CAREER
Просмотров 5 тыс.3 месяца назад
How to build a SUCCESSFUL DATA CAREER
How to get your FIRST DATA ANALYST JOB?
Просмотров 13 тыс.4 месяца назад
How to get your FIRST DATA ANALYST JOB?
How I'd learn to be a DATA ANALYST in 2024 (IF I HAD TO START OVER)
Просмотров 70 тыс.4 месяца назад
How I'd learn to be a DATA ANALYST in 2024 (IF I HAD TO START OVER)
Business Analyst Interviews Data Analyst: Career, Data, Life and Youtube
Просмотров 7 тыс.4 месяца назад
Business Analyst Interviews Data Analyst: Career, Data, Life and RUclips
The TABLEAU PORTFOLIO PROJECT to make you STAND OUT from the crowd
Просмотров 40 тыс.4 месяца назад
The TABLEAU PORTFOLIO PROJECT to make you STAND OUT from the crowd
How can you be AI-ready? What is AI?
Просмотров 1,3 тыс.4 месяца назад
How can you be AI-ready? What is AI?
AI Portfolio Project | I built a MACHINE LEARNING MODEL using AI in 10 MINUTES
Просмотров 248 тыс.5 месяцев назад
AI Portfolio Project | I built a MACHINE LEARNING MODEL using AI in 10 MINUTES
GET A DATA ANALYST JOB by Optimizing Your LinkedIn Profile
Просмотров 29 тыс.5 месяцев назад
GET A DATA ANALYST JOB by Optimizing Your LinkedIn Profile
How to start your data analytics career in 2024 | Google Data Analytics Professional Certificate
Просмотров 9 тыс.5 месяцев назад
How to start your data analytics career in 2024 | Google Data Analytics Professional Certificate
How I got ahead of 99% of people | Learn how you can do it too
Просмотров 13 тыс.6 месяцев назад
How I got ahead of 99% of people | Learn how you can do it too
Data Analyst / Content Creator Life
Просмотров 7 тыс.6 месяцев назад
Data Analyst / Content Creator Life
Data Analyst/Husband Interviews Business Analyst/Wife
Просмотров 21 тыс.7 месяцев назад
Data Analyst/Husband Interviews Business Analyst/Wife
5 Tips if You're a Beginner to Data Analytics
Просмотров 5 тыс.7 месяцев назад
5 Tips if You're a Beginner to Data Analytics
Fastest Way To Become a Data Analyst
Просмотров 107 тыс.7 месяцев назад
Fastest Way To Become a Data Analyst
Data Engineers vs Data Analysts vs Data Scientists | What's right for you?
Просмотров 30 тыс.8 месяцев назад
Data Engineers vs Data Analysts vs Data Scientists | What's right for you?

Комментарии

  • @quirogan
    @quirogan 5 часов назад

    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.

  • @Tobiluminous
    @Tobiluminous 5 часов назад

    Well detailed, I have been using Excel for several tasks , glad to watch this

  • @MikeJones-ql3db
    @MikeJones-ql3db 6 часов назад

    The 🐐 dropped a video 🔥

  • @uzomaonyenanu3068
    @uzomaonyenanu3068 9 часов назад

    Nice video but the view is small cant really see what you're clicking

  • @vipersorc
    @vipersorc 10 часов назад

    Not a data analyst but my approach for quick data work in excel to answer some questions is practically identical. Nice!

    • @mo-chen
      @mo-chen 10 часов назад

      Nice one! You don't have to be a data analyst to be great at analyzing data.

  • @martinng370
    @martinng370 13 часов назад

    You're amazing man. Thank you for all the tips!

    • @mo-chen
      @mo-chen 13 часов назад

      I’m glad you found this useful!

  • @norianekrouf7279
    @norianekrouf7279 14 часов назад

    please make video to combine all software to make project in data analyst i mean workflow of process and for each software what we can do with it ?

    • @mo-chen
      @mo-chen 13 часов назад

      Not sure about all softwares because there are thousands out there but I can certainly try and combine more than one! Thanks for watching!

  • @revockzhd
    @revockzhd 14 часов назад

    nice vid!

    • @mo-chen
      @mo-chen 13 часов назад

      I’m glad you liked it!

  • @dothework2989
    @dothework2989 15 часов назад

    Do you have anyone that QAs/reviews your quant work in your team?

  • @mrbartuss1
    @mrbartuss1 15 часов назад

    We can see some numbers. Great, but what would are the next steps? Any conclusions/recommendations etc. Is that also your job?

    • @mo-chen
      @mo-chen 13 часов назад

      The point of this analysis was to get quick insights. What do you think would be good next steps?

    • @mrbartuss1
      @mrbartuss1 12 часов назад

      @@mo-chen I don't know that's why I ask. What are the quick insights then?

    • @Jack4alltrades
      @Jack4alltrades 9 часов назад

      @@mrbartuss1Man, you're just being rude. MO just gave a step-by-step quick analysis approach, and you want him to give you a job in a RUclips video. Chill out son

  • @KrantikumarCashCorner
    @KrantikumarCashCorner 15 часов назад

    bro how to analyse internation debt on sql

  • @Ishbaba07
    @Ishbaba07 16 часов назад

    Hi

  • @nurinirdina212
    @nurinirdina212 19 часов назад

    Thanks a lot! Very easy to understand for a beginner like me. I hope you can make a video about tableau's pivot data after this. I want to learn more about tableau.

    • @mo-chen
      @mo-chen 13 часов назад

      Great video idea and please check out my other tableau portfolio projects as well. Just search Mo Chen portfolio project playlist!

  • @user-kp2uk8ei3d
    @user-kp2uk8ei3d 21 час назад

    I completed your excel portfolio project .could you pls make a series for fresh analyst who just got job and explain some stuff for them.also is there some discount for asians in your course as dollar is very high in comparison to rupee

    • @mo-chen
      @mo-chen 13 часов назад

      Well done on completing the project! I don’t have such discounts.

  • @williamshelukindo7149
    @williamshelukindo7149 21 час назад

    what an amazing project, i have to say i have learnt alot in this guide

    • @mo-chen
      @mo-chen 13 часов назад

      Great to hear!

  • @MichelleLe-om3fv
    @MichelleLe-om3fv День назад

    What do you mean by switch ?

    • @Nicole_TC13
      @Nicole_TC13 15 часов назад

      SWITCH functions allow us to switch between multiple values/fields/measures - here I’m using SWITCH functions to switch between the sales/gp/volume measures 😊

  • @vishalraj8902
    @vishalraj8902 День назад

    Subscribed 😊

    • @mo-chen
      @mo-chen День назад

      Nice thanks!

  • @ifeanyinwobodo8530
    @ifeanyinwobodo8530 День назад

    I recently lost an interview because I was advertising myself as a data analyst. We were in a group interview and we were asked about our academic background. After responding that I am an econ graduate, I doubled on the fact that Econ was just glorified stats (tho untrue, I thought it'd give me an advantage). The interviewers lost interest in me immediately and focus on other candidates from "other backgrounds". I asked one of the interviewer what just happened, they mentioned almost the same you thing you did and they also added your ability to move from your past experience to learn and execute data skills is testament of your passion, resilience and curiosity.

    • @mo-chen
      @mo-chen 23 часа назад

      Always make sure you present yourself as a well rounded candidate. Please watch the longer videos of mine, they will help even more! Try the podcasts!

    • @ifeanyinwobodo8530
      @ifeanyinwobodo8530 23 часа назад

      @@mo-chen ok, I would do just that

  • @chandraprakash-oo5lp
    @chandraprakash-oo5lp День назад

    Hey mo chen , can you do a project on banking or finance data

    • @mo-chen
      @mo-chen День назад

      Check out my portfolio project playlist please.

  • @cr30723
    @cr30723 День назад

    I watched your video and I really appreciated all the insight and knowledge you provided! I am a someone who is trying to break into the field and I’ve been learning technical skills such as excel, sql, tableau and r programming whilst also trying to hone on my soft skills such as stakeholder management, communication skills, and being able to work in a timely manner! Thank you for sharing your experience and passion as it is always insightful and I always manage learn something new or get better understanding on the subject!

    • @mo-chen
      @mo-chen День назад

      I’m glad you liked it! Thanks for watching!

  • @dailytechhelp
    @dailytechhelp День назад

    Thank You... You made my day

    • @mo-chen
      @mo-chen День назад

      I try my best! Thanks for watching!

  • @Edward-do7ut
    @Edward-do7ut День назад

    "Consistency is the key." You're absolutely right. I am struggling with the consistency most. As an economics undergraduate, I can resonate with you. I am following you on LinkedIn, can you recommend some projects I can do with my technical skills and academic knowledge that will help me to build economic understanding. Thank you for the honest opinion that really matters in today's world.

    • @mo-chen
      @mo-chen День назад

      Honesty above all! Thanks for being present here and on LinkedIn as well!

  • @Tupagzus
    @Tupagzus День назад

    Thank you so much! Now I had more confidence to work on excel project than before

    • @mo-chen
      @mo-chen День назад

      Fantastic, I’m glad I could help!

  • @maximielos
    @maximielos День назад

    I've only recently discovered that I really lean towards data analytics. I'm about to graduate as a software engineer, and I probably have enough knowledge to become a data engineer, but would that be good enough to also become a data analyst? (I'm also good at maths.) Or do I need to study further for that?

    • @mo-chen
      @mo-chen День назад

      Please watch the video I made on data analyst vs data scientist vs data engineer. That should help!

  • @samadritashaw3352
    @samadritashaw3352 2 дня назад

    On converting the range as table, I am getting #SPILL! error in the customer name, email and country column. What's the reason for the occurrence of this error and how to fix this? Kindly help. Edit: Fixed this error, after surfing on yt, watching couple of videos, I found this one very useful: ruclips.net/video/hpLYALCK9CU/видео.htmlsi=kEBHE17W-42LoNMj Basically, In in XLOOKUP() 's Lookup value part, I selected the entire column instead of one cell, it's nothing wrong but actually it may lead to Spillage i.e. #SPILL error. Hope that someone finds this useful, if you ever get stuck like me :D

  • @tikkki25
    @tikkki25 2 дня назад

    Wonderful video! Great way to get an overview on how NLP works. So much better than some "paid instructors"

    • @mo-chen
      @mo-chen День назад

      I’m glad you thought my free stuff is better than the paid stuff from others!

  • @oscarpr91
    @oscarpr91 2 дня назад

    Many thanks for your tips Mo. I also have a finance/economics background. It's getting more and more difficult to gain working experience in data analysis jobs without having math/computer science/engineering background. Most companies almost only want people who have these type of backgrounds, unless you do a Master's degree of Big data/Data Science afterwards. I've been learning technical skills on my own for a long time now, and have some BI experience. I hope all this effort ends up paying off in the end

    • @mo-chen
      @mo-chen День назад

      Keep it up! I wish you all the best!

  • @yashsingavi5167
    @yashsingavi5167 2 дня назад

    simple yet efficient than scraping.. thank you so much man !!

    • @mo-chen
      @mo-chen 2 дня назад

      Glad it helped!

  • @arneshmaity7743
    @arneshmaity7743 2 дня назад

    I absolutely agree with your words, lad. In order to achieve something, one must be consistent and work without giving up on that specific achievement. Nonetheless, thanks for the great vid!

    • @mo-chen
      @mo-chen 2 дня назад

      I’m glad you liked it!

  • @SocialPanicMan
    @SocialPanicMan 2 дня назад

    This video just changed my life

    • @mo-chen
      @mo-chen 2 дня назад

      Thank you for watching! I really hope you gained much, much value out of this video.

  • @vinothkumars7421
    @vinothkumars7421 2 дня назад

    Just facts

  • @SocialPanicMan
    @SocialPanicMan 2 дня назад

    Honestly, I’ve watched hours of RUclips content from creators that make similar content for how to be a data analyst. This is by far the most in depth. You’ve condensed everything in one video, which as a viewer made me subscribe. I respect your honesty, transparency, and experience. I feel like you really know what you’re talking about. Just found your channel today and I’m transiting to data analysis from a 6 year career as a Personal Trainer with minimal related experience. If I can do this, you guys can too. I’ll try to keep updates in the comments to let everyone know how I’m going. Trying to land a job by late this year

    • @mo-chen
      @mo-chen 2 дня назад

      I wish you all the best. I'm so glad this type of honest, actually useful content resonates with you!

  • @AndeeLee-yi4ot
    @AndeeLee-yi4ot 3 дня назад

    uSMART offers up to 6% interest on your readily available USD cash in your brokerage account, with no need to invest in managed funds!

    • @AndeeLee-yi4ot
      @AndeeLee-yi4ot 3 дня назад

      Pocket change to potential growth, uSMART's 6% interest on my instantly accessible USD could be a sweet deal!

  • @delwarhossain4501
    @delwarhossain4501 3 дня назад

    Thank you very much Mr. Mo

    • @mo-chen
      @mo-chen 2 дня назад

      You are very welcome. Thanks for watching!

  • @sallyho146
    @sallyho146 3 дня назад

    True. Title doesn’t matter exact pays and gives options to staff’s performance evaluation. I have accounting background that real helps with my current role of preparing statistical data reports, clean up data, qa/qc the data manually. The best way to learn is to do the work and keep doing it to improve skills. Questions: i built overview/dashboard of data in excel manually. How hard to transfer that overview data into power BI data visualization?

    • @mo-chen
      @mo-chen 2 дня назад

      How hard depends on how good your power bi skills are :)

    • @sallyho146
      @sallyho146 2 дня назад

      @@mo-chen we can still transfer the excel dashboard into power BI correct?

  • @Clinthon007
    @Clinthon007 3 дня назад

    Short and straight to the point. Thanks boss. I know data analysis jobs are highly competitive now, but I hope I get one when I venture into job search. Still learning more for now.

    • @mo-chen
      @mo-chen 2 дня назад

      Just keep on learning! All the best!

  • @VishalSingh-jj4hc
    @VishalSingh-jj4hc 3 дня назад

    Precise & Sweet 💪👏

  • @abdulhafizebahru3761
    @abdulhafizebahru3761 3 дня назад

    Thank you form 🇪🇹

    • @mo-chen
      @mo-chen 3 дня назад

      I'm glad you liked the video!

  • @CarlosAlbertoRamirez-uj3mr
    @CarlosAlbertoRamirez-uj3mr 5 дней назад

    Yo todavía tengo granadas Mohawk ❤

  • @Whitegreendevkota
    @Whitegreendevkota 5 дней назад

    its simple and easy to understand about data analtics

    • @mo-chen
      @mo-chen 4 дня назад

      I'm glad you liked the video!