This is how I ACTUALLY analyze data using Excel
Рет қаралды 14,350
Күн бұрынGET YOUR DATA JOB ➡ mochen.info/
ULTIMATE DATA PORTFOLIO: Everything you need to get your data job ➡ mochen.info/ultimate-data-por...
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 ➡ / mo_chen
CourseCareers: Start the FREE Data Analytics Introduction Course Now ➡ coursecareers.com/a/mochen?co...
Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python ➡ • Portfolio Projects
DataCamp Certifications ➡ datacamp.pxf.io/c/4216860/205...
┋Community & Socials┋
/ discord ⬅ Join our Discord Data Community
/ mo_chen1 ⬅ My IG is personal -- only follow if you're interested in non-data stuff as well
/ mo-chen1 ⬅ Daily tips & advice on how to enhance your data analysis skills
/ mo_chen_1 ⬅ Figuring out what I want to do in this space...
┋Professional Certificates┋
CourseCareers ➡ coursecareers.com/a/mochen
DataCamp Certifications ➡ datacamp.pxf.io/c/4216860/205...
Google Data Analytics Professional Certificate ➡ www.coursera.org/google-certi...
Google Advanced Data Analytics Professional Certificate ➡ www.coursera.org/google-certi...
Tableau Business Intelligence Professional Certificate ➡ imp.i384100.net/TableauBIAnalyst
Microsoft Power BI Data Analyst Professional Certificate ➡ www.coursera.org/professional...
IBM Data Science Professional Certificate ➡ imp.i384100.net/IBMdataScience
Google Project Management Professional Certificate ➡ imp.i384100.net/GoogleProject...
Excel File ➡ github.com/mochen862/excel-da...
┋Timestamps┋
00:00 The data analysis exercise
03:44 Suppliers, Brands, Categories
05:22 Year on Year Growth
08:40 Market Share
12:13 YTD Profit and Moving Annual Total Profit
Thanks so much for taking a little time out of your day to watch this!
@HorbachenkoVlad 8 күн бұрын
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 8 күн бұрын
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!
@vipersorc 9 күн бұрын
Not a data analyst but my approach for quick data work in excel to answer some questions is practically identical. Nice!
@mo-chen 9 күн бұрын
Nice one! You don't have to be a data analyst to be great at analyzing data.
@Tobiluminous 9 күн бұрын
Well detailed, I have been using Excel for several tasks , glad to watch this
@jimmycabutotan975 Күн бұрын
This is great sharing MO, thanks a lot!
@martinng370 9 күн бұрын
You're amazing man. Thank you for all the tips!
@mo-chen 9 күн бұрын
I’m glad you found this useful!
@jeff_tech 7 күн бұрын
It was a very interesting video. It’s valuable to see how you approach an analysis. Thanks for the free content!
@mo-chen 7 күн бұрын
I’m so glad you liked it! Thanks for watching!
@quirogan 9 күн бұрын
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 8 күн бұрын
Thanks so much for watching. I hope your sons find value in my content too!
@Daniel-qe8zz 8 күн бұрын
ur video really helps alot, thanks!
@mo-chen 7 күн бұрын
I’m glad you found it useful! Thanks for watching!
@leoCarCampos 2 күн бұрын
Great point of view
@mo-chen 2 күн бұрын
Glad you liked it, thanks for watching!
@homelander9148 3 күн бұрын
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 3 күн бұрын
Glad the video helped! Thanks for watching!
@CaribouDataScience 9 күн бұрын
Thanks
@ifeanyinwobodo8530 8 күн бұрын
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 8 күн бұрын
I’m glad you liked it. Even though the calculations are on the fly, trust me, I prepared before hitting the record button!
@ifeanyinwobodo8530 8 күн бұрын
@@mo-chen Nice. I appreciate your honesty
@MikeJones-ql3db 9 күн бұрын
The 🐐 dropped a video 🔥
@mo-chen 9 күн бұрын
HAHA thank you for watching!
@ItsLrenzo 8 күн бұрын
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 8 күн бұрын
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 8 күн бұрын
@@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.
@revockzhd 9 күн бұрын
nice vid!
@mo-chen 9 күн бұрын
I’m glad you liked it!
@arneshguru4263 Күн бұрын
In finding market share part, while inserting slicer of category category names are not visible in the slicer widget. HELP NEEDED!
@norianekrouf7279 9 күн бұрын
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 9 күн бұрын
Not sure about all softwares because there are thousands out there but I can certainly try and combine more than one! Thanks for watching!
@dothework2989 9 күн бұрын
Do you have anyone that QAs/reviews your quant work in your team?
@KrantikumarCashCorner 9 күн бұрын
bro how to analyse internation debt on sql
@Madly-Chilled 3 күн бұрын
Can you make a dedicated video on data cleaning where data is really messed up and big in size?? KZfaq really lacks in perfect data cleaning video where all the data cleaning steps are shown.
@mo-chen 3 күн бұрын
Great video idea! I will definitely make something along those lines. Not sure when, but I will!
@Rapha_Carpio 6 күн бұрын
What software do you use to record these videos, OBS?
@mo-chen 5 күн бұрын
Yes, that's right!
@GigaChadRealington 2 күн бұрын
Mo Chen. Mo Problems.
@mrbartuss1 9 күн бұрын
We can see some numbers. Great, but what would are the next steps? Any conclusions/recommendations etc. Is that also your job?
@mo-chen 9 күн бұрын
The point of this analysis was to get quick insights. What do you think would be good next steps?
@mrbartuss1 9 күн бұрын
@@mo-chen I don't know that's why I ask. What are the quick insights then?
@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 KZfaq video. Chill out son
@mrbartuss1 9 күн бұрын
@@Jack4alltrades No, I’m not rude. I’m just curious how this job looks in a real world
@Jack4alltrades 9 күн бұрын
@@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.
@SahilPatel-vw4nf 8 күн бұрын
Do you use windows or Mac for your work?
@mo-chen 8 күн бұрын
Windows
@Freewiseman 9 күн бұрын
Hi
@rumeeburu3648 8 күн бұрын
Can I get the dataset?
@mo-chen 8 күн бұрын
Of course, the link is in the description
@ranjeeta6231 3 күн бұрын
ALT+VT is not working for Pivot table MO
@mo-chen 3 күн бұрын
It’s ALT N V T 😃
@uzomaonyenanu3068 9 күн бұрын
Nice video but the view is small cant really see what you're clicking
@Anubis1010-tx1ev 4 күн бұрын
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 4 күн бұрын
Woow a different perspective. What do you do at your job as a Data Analyst? Curious to hear your thoughts
@mo-chen 4 күн бұрын
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 3 күн бұрын
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)
Maven Analytics
Рет қаралды 30 М.
Maven Analytics
Рет қаралды 63 М.