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!
Вітаю! Дуже рада таке читати! Скажи, будь ласка, чи сам навчався? Це були курси чи повністю самостійно дорожня карта? Скільки витратив часу з самого початку? І, якщо можна, скажи будь ласка, як отримав роботу? Як подавався і куди? Я поглибилась в датааналітику, що дуже подобається, але опускаються руки, коли замислююсь про реальність перспектив, мовляв самоучка і т. п. кому потрібно.
There's already a million places where you can find the super basic stuff. I want to teach practical, applicable skills and I'm glad this resonates with you.
I watch a truly embarrassing amount of excel/data analysis videos and you/this one stood out immediately. You have a great style and approach. Short and sweet, and I already picked up a couple of tips I'll be able to use immediately.
Your teaching is quick but very good. I know nothing of data analytics but I understood what you did, except for the formulas. So obviously I need to go back and learn how they work. I just wanted to let you know that I enjoyed watching your video and learned a lot from it. Thank you.
It was really amazing to watch a professional data analyst to do things just the way he does in his regular workflow. I know real work involves much larger datasets, but I got a li'l bit of taste in your clip. Good work, keep it up..
It may be that you have them disabled due to incorrect downloading. Try to find an office key in BNH software or others that you like and perhaps you will be able to solve the problem.
This is gem. Clear and to the point explanation. But I don’t get the part 14:52. If I found your video earlier, I would have passed my interview. It’s not related to data analysts but the test given in the interview was similar. Keep up!
I'm not that Excel unsavy, but I just audibly yelled "oh my god" to myself when you pressed Control and duplicated a sheet like that. It's the little things like that I miss, but this will make my experience with Excel even better now.
Hello! Very good content here in terms of excel skills. However, it would be even more valuable video if you could draw conclusions from numbers, and show the process of writing recommendations because at the end everyone needs concrete recommendation on improvement.
Okay, I have to say this. I've just started learning Data Analytics & completed the Excel, but didn't actually know how to start from, and this video definitely hel;ped me. Thank you so much.
Wonderful video. Refreshing to find something that is not based on BLING and "look-how-complex-i-can-make-stuff-up", but down to the core point. My MO is identical; good information doesnt need complex optics. also THANK YOU i have not heard of the CTRL+Drag-Option to duplicate sheets. I will duplicate the ** out of excel from now on :D
I’m glad you like the practical content. The difference between social media data analysis and real data analysis is that in real life, you have one goal, and that is to solve business problems. Not to build the shiniest things. If you do and solve the business problem, that’s fantastic. But if you just build shiny and useless things, that’s just social media data analysis.
I feel like the double-click on columns to resize them to fit your data is such a well-known hack... so dang, why didn't I know you can double click on rows in the same way?? lol Great video start to finish. the MAT toward the end was especially helpful.
Excellent video and information, Mo! I'm glad your channel popped up as suggested. I've subscribed and will check out your courses. I work for the department of the Treasury and this will come in handy! Thanks again!
Yho bro, 10 minutes into your presentation I am already hooked, you have amazing way of simplifying content and making it easy to follow. Big up to you, you gained yourself a fan for life, as I indulge for more.
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.
It would be cool to have a playlist of "real business problems solved with only Excel" If you do, please consider the fact that many viewers are using Mac so the Excel should ideally also work for Mac users. Thanks.
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 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...
Can you make a dedicated video on data cleaning where data is really messed up and big in size?? TH-cam really lacks in perfect data cleaning video where all the data cleaning steps are shown.
@Mo Chen thanks for the video, i am going for a trainer interview on friday 06/09/2024 and will need you to point me to your tutorials that can help a beginer in excel analysis
100% most important data analysis step is always learning some reproducible programming method like python or R and stop using excel as soon as possible. With excel type tools (click copy paste) one is almost always stuck at the “basically good enough” stage without ever learning new productive practices that can transform your life in analysis.
Hello Mo! this is Azad from Bangladesh. By proffession an engineer but not technical person. So have no knowledge and experience on programming (actually Im bit afraid of it 😀) . But love to work with Excel. Now I want to take another step forward and want to become data analyst. I'm interested in your ultimate data portfolio and mentorship program. Looking forward to hear from you ! Cheers
Do you have any advice for someone really wanna get into the tech industry and have looked into data analytics and data science but is worried about what jobs will be replaced by Ai?
Hello! I am a senior in finance student and I am currently working in a finance department but I realized I deal with a lot of data analysis as well as creating a narrative for the business would. I got interested in data analytics because I see there is a overlap in those skills and needed skills for analyzing data. I know you work for financial services. would a degree in finance be complementary to be a Data analyst as well?
Yes but getting a job has multiple elements to it. Please check out my How to become an analyst playlist here th-cam.com/play/PLodYDTuHA29amu5iUH-8PLGbSiEphe585.html. This will give you all the information you need :)
Please make a video on this. I have a sheet which contains data in rows and columns. And there are 4 blank rows after every data row and I want to fill the 1st blank row with the data of sheet 2 and 2nd row with sheet 3 and 3rd row with sheet 4 and 4th row with sheet 5 please make a video it's getting very difficult
@@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 TH-cam video. Chill out son
@@mrbartuss1 In that case, my man, just soak up all of the information and wait for the next chapters. Your original question basically says that the video is not worth your attention. What if you took this and tried to answer what Mo asked instead? What would you do with the data? That's the only way you'll learn.
![เจ็บที่ยังฮัก - ม่อน วรวิทย์ [ Official Mv ] จอนนี่มิวสิค](http://i.ytimg.com/vi/KALIGSRSjFs/mqdefault.jpg)
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!
Please tag me with the video you talked about pls🙏
can you please share the tutorial i really wanna learn and get my dream job
Please help me! I need this skills
Вітаю! Дуже рада таке читати! Скажи, будь ласка, чи сам навчався? Це були курси чи повністю самостійно дорожня карта? Скільки витратив часу з самого початку? І, якщо можна, скажи будь ласка, як отримав роботу? Як подавався і куди? Я поглибилась в датааналітику, що дуже подобається, але опускаються руки, коли замислююсь про реальність перспектив, мовляв самоучка і т. п. кому потрібно.
I love people who are fast at teaching like you and it makes me become more busy and occupied and i learn quick
There's already a million places where you can find the super basic stuff. I want to teach practical, applicable skills and I'm glad this resonates with you.
I watch a truly embarrassing amount of excel/data analysis videos and you/this one stood out immediately. You have a great style and approach. Short and sweet, and I already picked up a couple of tips I'll be able to use immediately.
I’m glad you liked the video!
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.
Your teaching is quick but very good. I know nothing of data analytics but I understood what you did, except for the formulas. So obviously I need to go back and learn how they work. I just wanted to let you know that I enjoyed watching your video and learned a lot from it. Thank you.
It was really amazing to watch a professional data analyst to do things just the way he does in his regular workflow. I know real work involves much larger datasets, but I got a li'l bit of taste in your clip. Good work, keep it up..
First time I have come across your channel and I must say this is some quality content. Nice and slow explanation of every step!
I'm so glad you liked the content!
I'm trying to do this in my excel and it just won't let me and I really don't know what it's due to, god help meeeee
It may be that you have them disabled due to incorrect downloading. Try to find an office key in BNH software or others that you like and perhaps you will be able to solve the problem.
@@markjam55 It worked for me, but each person's case is different.
@@JohnJacobson555True but it's a good help guide
I'll do some more research, but thank you very much.
Just finished watching and wanna thank you for making this kind of video. Keep up the good work! Subscribed and liked.
Thank you Mo Chen! Your tips helped me to work more seamlessly cleaning up simple dataset job in an E-Commerce company
2 and half minutes in and you already got my subscription. great work!
Welcome to the channel :)
This is gem. Clear and to the point explanation. But I don’t get the part 14:52. If I found your video earlier, I would have passed my interview. It’s not related to data analysts but the test given in the interview was similar. Keep up!
You'll smash that interview next time!
yeah I don't get it either? can someone explain the maths behind it maybe?
I'm not that Excel unsavy, but I just audibly yelled "oh my god" to myself when you pressed Control and duplicated a sheet like that.
It's the little things like that I miss, but this will make my experience with Excel even better now.
Haha little things can make a huge difference!
Hello! Very good content here in terms of excel skills. However, it would be even more valuable video if you could draw conclusions from numbers, and show the process of writing recommendations because at the end everyone needs concrete recommendation on improvement.
Okay, I have to say this. I've just started learning Data Analytics & completed the Excel, but didn't actually know how to start from, and this video definitely hel;ped me. Thank you so much.
Glad the video helped! Thanks for watching!
Thank you for doing such interesting lessons. They are always useful to me!
Glad you like them!
Straight forward is my kind of learning.
Seriously love how you just get right to the point!
I love a straightforward approach!
that's how I like it, straight to the point. I've learned so much in 20 minutes. Thx bro
Drag fields to ROWS module helps a lot for DataTable and start any kind of analysis. Thanks Mo!
You are great. I always learn new shortcuts while watching your videos.
Glad you like the videos!
Wonderful video. Refreshing to find something that is not based on BLING and "look-how-complex-i-can-make-stuff-up", but down to the core point. My MO is identical; good information doesnt need complex optics. also THANK YOU i have not heard of the CTRL+Drag-Option to duplicate sheets. I will duplicate the ** out of excel from now on :D
I’m glad you like the practical content. The difference between social media data analysis and real data analysis is that in real life, you have one goal, and that is to solve business problems. Not to build the shiniest things. If you do and solve the business problem, that’s fantastic. But if you just build shiny and useless things, that’s just social media data analysis.
Wanting to break into data analytics as a job, so this video was great! Thank you!
Nice, I'm glad I could help!
I feel like the double-click on columns to resize them to fit your data is such a well-known hack... so dang, why didn't I know you can double click on rows in the same way?? lol Great video start to finish. the MAT toward the end was especially helpful.
I'm glad you liked the video!
super nice to revise before starting a new role in brand management! many thanks!
Excellent video and information, Mo! I'm glad your channel popped up as suggested. I've subscribed and will check out your courses. I work for the department of the Treasury and this will come in handy! Thanks again!
Yho bro, 10 minutes into your presentation I am already hooked, you have amazing way of simplifying content and making it easy to follow. Big up to you, you gained yourself a fan for life, as I indulge for more.
Happy to hear that! Thanks so much for watching!
thank you for showing how amazing excel is
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!
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!
Wow I liked your tutorial because it was straight to the point and very clear explaining 👏👏👏
So amazing to watch a pro at work!
YO YOU ARE SO GOOD TRADER AND EXPERINCED IN TRADING , I WATCH YOUR ALL VIDEOS AND EVERY DAY I LEARN SOME THING NEW ABOUT TRADING FROM YOU️
I loved the video thanks especially the last 2 calculations
Well detailed, I have been using Excel for several tasks , glad to watch this
It would be cool to have a playlist of "real business problems solved with only Excel"
If you do, please consider the fact that many viewers are using Mac so the Excel should ideally also work for Mac users. Thanks.
This is great sharing MO, thanks a lot!
This is good to learn dynamic tables and compare data, thx for share this knowledge!
Nice workflow, I would check data quality in raw format, say “uniques” to start
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
This was a very good learning experience. Thank you so much!
Glad you enjoyed it!
Well, this made me want to master Excel and pivot tables first then slowly move also to PBI much later
You're amazing man. Thank you for all the tips!
I’m glad you found this useful!
O love your.teaching pattern, so rewarding and understandable
😊
Glad you enjoy it!
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 for this video. I'd appreciate it so much! But I think if we have an exercise file then it'd help much better
It's in the description.
Pls make one video for analyse and make report, dashboard of survey data. It will help us for more practice. Thanks for your video I learned a lot .
Please check out my portfolio project playlist for end to end projects.
Can you make a dedicated video on data cleaning where data is really messed up and big in size?? TH-cam really lacks in perfect data cleaning video where all the data cleaning steps are shown.
Great video idea! I will definitely make something along those lines. Not sure when, but I will!
I suggest Python Pandas when it comes to data cleaning.
Thank you for putting this video.
Glad it was helpful!
thanks, would be great to see more such videos...something like real world excel
Glad you liked it!
@Mo Chen thanks for the video, i am going for a trainer interview on friday 06/09/2024 and will need you to point me to your tutorials that can help a beginer in excel analysis
This is very good
Thanks for sharing .. nicely explained
100% most important data analysis step is always learning some reproducible programming method like python or R and stop using excel as soon as possible. With excel type tools (click copy paste) one is almost always stuck at the “basically good enough” stage without ever learning new productive practices that can transform your life in analysis.
Hello Mo! this is Azad from Bangladesh. By proffession an engineer but not technical person. So have no knowledge and experience on programming (actually Im bit afraid of it 😀) . But love to work with Excel. Now I want to take another step forward and want to become data analyst. I'm interested in your ultimate data portfolio and mentorship program. Looking forward to hear from you ! Cheers
You can check out everything at mochen.info/ 😃
ur video really helps alot, thanks!
I’m glad you found it useful! Thanks for watching!
Great content! Please zoom in though please the text is tiny on any screen size
I’m glad you liked it!
The 🐐 dropped a video 🔥
HAHA thank you for watching!
Insightful, Thank you
This YTD column is it equivalent to the cumulative profit
Hi, great video! Do you perhaps have a trusted website to get sample worksheets for data analysis such as the one you used in the video?
You can generate your own mock dataset for practicing. Mockaroo is a good website for that.
helpful, Nice and easy.
thnks pal
Glad it helped
Can you please elaborate why you put >current month in the MAT formula?
Great point of view
Glad you liked it, thanks for watching!
Thx brother ❤
In finding market share part, while inserting slicer of category category names are not visible in the slicer widget. HELP NEEDED!
hey since you said you work in financial services ..can you tell me how much domain knowledge is required to get in the same field?
I have several data sets from different countries (files), I could create a new Excal file to analyze all data sets and auto post to ppt.
Great video, please zoom in next time to the data..lot of empty white space
In what instances can we apply if statements? Can we do that for every situation ?
Dear Mo, what was the short cut for pivot table please
bravoooo!
thumbs up for you!
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 ?
Not sure about all softwares because there are thousands out there but I can certainly try and combine more than one! Thanks for watching!
Do you have any advice for someone really wanna get into the tech industry and have looked into data analytics and data science but is worried about what jobs will be replaced by Ai?
Thank you, beginners need to slow down the video 🙏😂🧑🎓
I know I have a fast teaching style but like you said, please slow down the video or even better, watch it again if need be!
Thank you. ❤
Hi, where can I find the dataset used in the video?
Hello! I am a senior in finance student and I am currently working in a finance department but I realized I deal with a lot of data analysis as well as creating a narrative for the business would. I got interested in data analytics because I see there is a overlap in those skills and needed skills for analyzing data. I know you work for financial services. would a degree in finance be complementary to be a Data analyst as well?
Yes but getting a job has multiple elements to it. Please check out my How to become an analyst playlist here th-cam.com/play/PLodYDTuHA29amu5iUH-8PLGbSiEphe585.html. This will give you all the information you need :)
would you recommend power bi as the next step in visualising a business' data?
It would be a great progression from Excel, so absolutely yes!
Hello sir how to find customer retention rate in excel and tableau?
I’m just starting off but I’m learning with spreadsheets. Would you say there’s a difference? Which one would employers use more?
My preference is always Microsoft Excel.
Bro can you Share this format for practice Please?
I'm a new learner
Good bro
hello, Please where can I get datas like this, to work with while watching your videos
Kaggle is a great place to start.
Do you ever have to clean survey data? Or clean data?
Thanks
is it possible to have multiple clients on this field of data analytics?
Hi, please repost the ultimate data portfolio link. I couldn't get in in the description.
It’s in the description:)
Can this be done in Libreoffice Calc?
Great information! Tks a lot! ❤
I'd like to become Data analyst. Could u help me?
I love this
I'm glad you loved it!
Please provide the excel file link , so that we can practice what you taught
Please make a video on this. I have a sheet which contains data in rows and columns. And there are 4 blank rows after every data row and I want to fill the 1st blank row with the data of sheet 2 and 2nd row with sheet 3 and 3rd row with sheet 4 and 4th row with sheet 5 please make a video it's getting very difficult
nice vid!
I’m glad you liked it!
do you apply python?
Mo Chen. Mo Problems.
what does profit MAT stands for?
We can see some numbers. Great, but what would are the next steps? Any conclusions/recommendations etc. Is that also your job?
The point of this analysis was to get quick insights. What do you think would be good next steps?
@@mo-chen I don't know that's why I ask. What are the quick insights then?
@@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 TH-cam video. Chill out son
@@Jack4alltrades No, I’m not rude. I’m just curious how this job looks in a real world
@@mrbartuss1 In that case, my man, just soak up all of the information and wait for the next chapters. Your original question basically says that the video is not worth your attention. What if you took this and tried to answer what Mo asked instead? What would you do with the data? That's the only way you'll learn.
Do you have anyone that QAs/reviews your quant work in your team?
What software do you use to record these videos, OBS?
Yes, that's right!