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!
@mo-chenАй бұрын
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!
@Vows_ViewsАй бұрын
Please tag me with the video you talked about pls🙏
@anisaiche958722 күн бұрын
can you please share the tutorial i really wanna learn and get my dream job
@martynoyotv10349 күн бұрын
Please help me! I need this skills
@loose.electricity9 күн бұрын
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.
@mo-chen8 күн бұрын
I’m glad you liked the video!
@uchindamiphiri138126 күн бұрын
I love people who are fast at teaching like you and it makes me become more busy and occupied and i learn quick
@mo-chen25 күн бұрын
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.
@vipersorcАй бұрын
Not a data analyst but my approach for quick data work in excel to answer some questions is practically identical. Nice!
@mo-chenАй бұрын
Nice one! You don't have to be a data analyst to be great at analyzing data.
@debrawest4859Ай бұрын
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.
@Earthtrendstv21 сағат бұрын
Mo, you did it. The kind of formulas you're doing there is unheard of😮 Super amazing tuts
@mo-chen9 сағат бұрын
Glad it was helpful!
@himawarisunflower87Күн бұрын
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!
@mo-chen22 сағат бұрын
You'll smash that interview next time!
@AJ-fd3yjАй бұрын
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
@mo-chenАй бұрын
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.
@jhadinger6 күн бұрын
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.
@mo-chen5 күн бұрын
I'm glad you liked the video!
@homelander9148Ай бұрын
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.
@mo-chenАй бұрын
Glad the video helped! Thanks for watching!
@kometsikhotlele7816Ай бұрын
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.
@mo-chenАй бұрын
Happy to hear that! Thanks so much for watching!
@ElinorLaneАй бұрын
Thank you for doing such interesting lessons. They are always useful to me!
@mo-chenАй бұрын
Glad you like them!
@quiroganАй бұрын
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.
@mo-chenАй бұрын
Thanks so much for watching. I hope your sons find value in my content too!
@TheCraftyboy11Ай бұрын
Wanting to break into data analytics as a job, so this video was great! Thank you!
@mo-chenАй бұрын
Nice, I'm glad I could help!
@jeff_techАй бұрын
It was a very interesting video. It’s valuable to see how you approach an analysis. Thanks for the free content!
@mo-chenАй бұрын
I’m so glad you liked it! Thanks for watching!
@EugeneWashington-y9jАй бұрын
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️
@TobiluminousАй бұрын
Well detailed, I have been using Excel for several tasks , glad to watch this
@jimmycabutotan975Ай бұрын
This is great sharing MO, thanks a lot!
@Shinya-Arai23 күн бұрын
This is good to learn dynamic tables and compare data, thx for share this knowledge!
@albertocustodiojr.4629Ай бұрын
This was a very good learning experience. Thank you so much!
@mo-chenАй бұрын
Glad you enjoyed it!
@martinng370Ай бұрын
You're amazing man. Thank you for all the tips!
@mo-chenАй бұрын
I’m glad you found this useful!
@WilliamsChimdubem25 күн бұрын
O love your.teaching pattern, so rewarding and understandable 😊
@mo-chen20 күн бұрын
Glad you enjoy it!
@ifeanyinwobodo8530Ай бұрын
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.
@mo-chenАй бұрын
I’m glad you liked it. Even though the calculations are on the fly, trust me, I prepared before hitting the record button!
@ifeanyinwobodo8530Ай бұрын
@@mo-chen Nice. I appreciate your honesty
@itsmeazizi80872 күн бұрын
This is very good
@ssj557Ай бұрын
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 .
@mo-chenАй бұрын
Please check out my portfolio project playlist for end to end projects.
@toji11Ай бұрын
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
@mo-chenАй бұрын
It's in the description.
@MrDhunpaglaАй бұрын
Thanks for sharing .. nicely explained
@breakoutgaffe4027Ай бұрын
Great content! Please zoom in though please the text is tiny on any screen size
@mo-chenАй бұрын
I’m glad you liked it!
@aleksandarrandjelovic2545Ай бұрын
thanks, would be great to see more such videos...something like real world excel
@mo-chenАй бұрын
Glad you liked it!
@6EBEN98903 күн бұрын
Dear Mo, what was the short cut for pivot table please
@ItsLrenzoАй бұрын
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?
@mo-chenАй бұрын
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...
@ItsLrenzoАй бұрын
@@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.
@okpolalinto1900Ай бұрын
Insightful, Thank you
@Daniel-qe8zzАй бұрын
ur video really helps alot, thanks!
@mo-chenАй бұрын
I’m glad you found it useful! Thanks for watching!
@jsnl5682Ай бұрын
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.
@Madly-ChilledАй бұрын
Can you make a dedicated video on data cleaning where data is really messed up and big in size?? KZbin really lacks in perfect data cleaning video where all the data cleaning steps are shown.
@mo-chenАй бұрын
Great video idea! I will definitely make something along those lines. Not sure when, but I will!
@vonsalamera376611 күн бұрын
I suggest Python Pandas when it comes to data cleaning.
@AryanGlobalCollegeАй бұрын
helpful, Nice and easy. thnks pal
@mo-chenАй бұрын
Glad it helped
@nessie41315 күн бұрын
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?
@mo-chen14 күн бұрын
You can generate your own mock dataset for practicing. Mockaroo is a good website for that.
@Plasmatek8715 күн бұрын
bravoooo! thumbs up for you!
@king0fw0rld69Ай бұрын
Great video, please zoom in next time to the data..lot of empty white space
@gsroshan20049 күн бұрын
Hi, where can I find the dataset used in the video?
@leoCarCamposАй бұрын
Great point of view
@mo-chenАй бұрын
Glad you liked it, thanks for watching!
@user-rj3cg4iy7w5 күн бұрын
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?
@arneshguru4263Ай бұрын
In finding market share part, while inserting slicer of category category names are not visible in the slicer widget. HELP NEEDED!
@shakeelahmedhussain5208Ай бұрын
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
@michelleedward8755Ай бұрын
Thank you. ❤
@MikeJones-ql3dbАй бұрын
The 🐐 dropped a video 🔥
@mo-chenАй бұрын
HAHA thank you for watching!
@norianekrouf7279Ай бұрын
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Ай бұрын
Not sure about all softwares because there are thousands out there but I can certainly try and combine more than one! Thanks for watching!
@flouw87339 күн бұрын
Great information! Tks a lot! ❤ I'd like to become Data analyst. Could u help me?
@CaribouDataScienceАй бұрын
Thanks
@muhammedadheen456Ай бұрын
Please provide the excel file link , so that we can practice what you taught
@jazonadriano4400Ай бұрын
is it possible to have multiple clients on this field of data analytics?
@dothework2989Ай бұрын
Do you have anyone that QAs/reviews your quant work in your team?
@irandisАй бұрын
I love this
@mo-chenАй бұрын
I'm glad you loved it!
@KrantikumarCashCornerАй бұрын
bro how to analyse internation debt on sql
@ZevYTАй бұрын
I’m just starting off but I’m learning with spreadsheets. Would you say there’s a difference? Which one would employers use more?
@mo-chenАй бұрын
My preference is always Microsoft Excel.
@BeeCrzcrzАй бұрын
what does profit MAT stands for?
@adepejuonilu4574Ай бұрын
Hi, please repost the ultimate data portfolio link. I couldn't get in in the description.
@mo-chenАй бұрын
It’s in the description:)
@revockzhdАй бұрын
nice vid!
@mo-chenАй бұрын
I’m glad you liked it!
@SohailAhmad-n5hАй бұрын
Hello i am Sohail from Pakistan.can we analyze data only in excel.can we get a job only with excel😊
@mrbartuss1Ай бұрын
We can see some numbers. Great, but what would are the next steps? Any conclusions/recommendations etc. Is that also your job?
@mo-chenАй бұрын
The point of this analysis was to get quick insights. What do you think would be good next steps?
@mrbartuss1Ай бұрын
@@mo-chen I don't know that's why I ask. What are the quick insights then?
@Jack4alltradesАй бұрын
@@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 KZbin video. Chill out son
@mrbartuss1Ай бұрын
@@Jack4alltrades No, I’m not rude. I’m just curious how this job looks in a real world
@Jack4alltradesАй бұрын
@@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.
@mayankdobhal31108 күн бұрын
how do i crack my first data analytics job, please help!
@mo-chen6 күн бұрын
As a start, you could land your first interviews using my Ultimate Data Portfolio -> mochen.info/ultimate-data-portfolio-lp/
@jayjayjay176620 күн бұрын
How do you revert the original data so that it’s no longer a table?
@mo-chen19 күн бұрын
Convert to range is what you’re looking for
@ranjeeta6231Ай бұрын
ALT+VT is not working for Pivot table MO
@mo-chenАй бұрын
It’s ALT N V T 😃
@GigaChadRealingtonАй бұрын
Mo Chen. Mo Problems.
@uzomaonyenanu3068Ай бұрын
Nice video but the view is small cant really see what you're clicking
@ragulmarley4900Ай бұрын
Data set
@rumeeburu3648Ай бұрын
Can I get the dataset?
@mo-chenАй бұрын
Of course, the link is in the description
@clarencevega752618 күн бұрын
do you apply python?
@Rapha_CarpioАй бұрын
What software do you use to record these videos, OBS?
@mo-chenАй бұрын
Yes, that's right!
@SahilPatel-vw4nfАй бұрын
Do you use windows or Mac for your work?
@mo-chenАй бұрын
Windows
@SothearithKONGMrMuyKhmer18 күн бұрын
❤
@FreewisemanАй бұрын
Hi
@JoeffereySumpkins6 күн бұрын
Bro Mo u sound Swedish
@mo-chen6 күн бұрын
I've never been to Sweden in my life haha
@uchiha_sasuke_48Ай бұрын
It would be better, if you start the video from cleaning the data.
@mo-chenАй бұрын
Watch my newest video on data cleaning with power query please
@emmanuelameyaw6806Ай бұрын
But this is not a financial data analysis. Why not show us what you actually do as a data analyst in the financial services industry.
@StopWhining491Ай бұрын
Great video, but stop saying "yeah" so much.
@mo-chenАй бұрын
Thanks!
@dalesmf4310Ай бұрын
He knows his stuff, but trying to follow him? he's way too quick in showing/explaining what he is doing. so his stuff only good if you are already on his level. especially with all the 'shortcuts' he know/uses.
@Jack4alltradesАй бұрын
You don’t have to follow Mo at all. This is just him showing how he uses Excel. As you can see by the title of the video, it’s not a “tutorial for moving averages.” He does that and gives you more tips, like shortcuts. You can see by this entire comment section that people engaged with it. “When everybody says it’s raining and you say it’s sunny, you’ll get wet.”
@Martinrd723 күн бұрын
You lost me when you said six point ninety one percent. It’s lazy and totally incorrect. If you had 4 decimal places would you say six point nine thousand one hundred? Makes zero sense.
@hammamahmed2610Ай бұрын
I feel you are being arrogant for no reason. For evidence: you called yourself a fool twice if the formula didn’t work, and said "simple equation." I agree that this is basic math and basic skills, but you make it seem as though they are difficult and smart. If you were really smart, you wouldn't show off with simple skills and math. For a while, I thought you were programming one of the learning modules to be used for AI. Stay humble
@Jack4alltradesАй бұрын
It looks like you have a simple choice that won't make you say things like that: the unsubscribe button. Maybe you should use it, for it does wonders when you waste your (everybody’s) time making comments like these.
@Anubis1010-tx1evАй бұрын
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
@Jack4alltradesАй бұрын
Woow a different perspective. What do you do at your job as a Data Analyst? Curious to hear your thoughts
@mo-chenАй бұрын
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.
@ciscasaclang3378Ай бұрын
obviously the data set Mo used was clean and organized already. he just wants to show some "flow of his analyzing process" which is the title of the video (im still learning data analytics and im not mislead by any means)
@MadzicPlays26 күн бұрын
First time I have come across your channel and I must say this is some quality content. Nice and slow explanation of every step!