FASTEST Way to Become a Data Analyst and ACTUALLY Get a Job

Learn how I escaped the 9-5 through freelancing:
courses.stfnvic.com/freedom-f...
Today, I'll share how to learn Data Analysis fast and how to get your first full-time Data Analyst job - step by step. As a self taught Data Analyst, if you want to learn data analysis to get a job at FAANG, this video is for you.
This video covers the following:
1. What tools do you need as a Data Analysis?
2. How to learn Data Analysis fast?
3. How to get a Data Analyst job?
Shoutout to the best Data Analyst on KZbin! @Luke Barousse
Best place to learn SQL: learnsql.com/?ref=stefanmasni...
Here are all the resources I mentioned in the video:
1. Learn Excel: excel-practice-online.com/
2. Learn SQL: www.w3schools.com/sql/
3. Learn PowerBI: www.datacamp.com/courses/intr...
4. Learn Python: www.learnpython.org/
5. Practice Projects at home: • Data Analysis with Pyt... & • Data Analyst Portfolio...
Subscribe if you want to support me.
#dataanalytics #datascience #data
►FOLLOW MY JOURNEY:
Instagram: / stefanovic92
►I TWEET ABOUT TECH, CRYPTO & POLITICS (and much more):
/ stfnvic
►GEAR I USE IN MY VIDEOS:
Main Camera: amzn.to/3fW5Pf7
Cinematic Zoom Lens: amzn.to/33FULAt
Ultra Wide Lens for Vlogging: amzn.to/3rG2gzi
Microphone I use for everything: amzn.to/3fPxXRb
Fastest Laptop ever for Video Editing: amzn.to/343egTa
My Favourite Backpack That Fits My Camera AND Laptop: amzn.to/3LJfox7
►WHERE I GET MY MUSIC:
Epidemic (30 Days For Free!): epidemicsound.com/referral/cmxato

[@Stefanovic92]

⮕ I try to respond to all DM's on instagram: instagram.com/stefanovic92 & Twitter: twitter.com/stfnvic

[@RP-vq4wd]

Hvala brate moj! Samo napred, puna podrska! Zavidim ti na nekim uspesim!

[@user-xx2dh8kp9u]

I have messaged you there as well

[@lorenamandrade9792]

You’re the sexiest data analyst I’ve ever seen… now I want to become a data analyst

[@reyshelpascua1677]

@Goofy Music lbbbv

[@sciji3118]

Can you do a soft/base skills video possibly? As far as like what math's should you work on or be good at, it's hard for me to request the right content as an absolute beginner, however possibly practice ideas for Excel or project ideas for all required programs?

[@cofi9659]

Started my first data analyst job today 💪

[@Stefanovic92]

Congrats mate!👊

[@levos2007]

How long does you take you to learn and master? Do you have previous experience before? Thanks in advance

[@cofi9659]

I started an excel-heavy job in finance a year ago, and have been teaching myself SQL. I dont have a relevant degree. This video is a really good guide so I'd suggest sticking to it, I will be

[@cofi9659]

I still haven't mastered anything except excel, also learning and using R at the moment

[@cabovalo]

@@cofi9659 what was your degree in?

[@noties2559]

“Don’t quit” is definitely one of the biggest pieces of advice for people wanting to break into the field. Took me a year and a half of that horrible trial and error learning, quitting, starting again, and networking to finally land my DA role, and I don’t regret a second of that journey.

[@Stefanovic92]

That's awesome man, congrats!

[@a2n19kekw]

@@Stefanovic92 I want to ask a question. In my university I have only big data analysis, but I want to be scientist.Will I get some welcome information to be more closer to my scientist?

[@skimpylemon8034]

Congratulations! I agree, someone also told me the exact same thing and I don't regret it either.

[@KyleWilliamsMusic1]

Did you have a degree or are you completely self taught?

[@skimpylemon8034]

@@KyleWilliamsMusic1 I'm self-taught. From my experience, I would start with Microsoft Excel. Almost every company uses this to do their data analysis. Many people claim they know how to use it, but I beg to differ. There is so much to learn with MS Excel. Another important aspect is your analytical and communication skills. If you master these two skills, you will thrive in any workplace and potentially increase your earnings. If your starting out, don't be afraid to make mistakes, we ALL make mistakes. The important thing is to learn from those mistakes. Don't be frustrated at it though, try to chuckle at it and think back as to why something hasn't worked (problem solving). Just work hard and never give up! Life works out in the end if you stay patient and persistent! All the best Internet friend! 🙂

[@balqeesyusuf1]

I don't think I have ever since a channel that tells its audience not to subscribe to the channel. But this shows that you don't do things because of others. Thank you so much for this, you just got a subscriber from an aspiring data analyst

[@jamespossible2601]

Much respect Stefanovic, this is a brilliant vid. You literally hit all the points from start to entry to exit...WOW! Much appreciated.

[@AJuresic]

The difference between a senior and junior data analyst: how well you’re able to formulate your question on stack overflow. Perhaps I should make a video about this.

[@dj8398]

Hahahaahha so true

[@Stefanovic92]

ULTRA Senior Data Analyst: Drink beer

[@EldhoseJoseph]

U had me till "on stack overflow". :)

[@sandeepsolomon0]

😂😂😂😂😂😂🤣🤣🤣🤣🤣

[@tosinomuse9251]

6:13 Recommended learning resources

[@LukeBarousse]

My dude, humbled by the shoutout! 🙏🏼 I disagree though... 10:29 your videos are the ones that are on a whole other level! 🙌🏼

[@Stefanovic92]

Haha thanks bro ..but you're the real MVP when it comes to data analysis!

[@smudgepost]

Like many, I stumbled on this video half enthused half tired from researching data analysis along side current tools, jobs, 50 open tabs, cold coffee... Thank you. I really enjoyed how you summarised this and gave an overview on your experience. It helps to be given a few good choices to work with instead of all the choices and no guidance.

[@elirods2786]

Excellent video, I've seen tons of this "starting" videos and you actually gave practical and specific tips to start. Thank you!

[@szkfury7041]

Brilliant advice to become a data analyst. No-one give me such a clear vision on how to learn new tools. Thanks.

[@WaymondJr]

Your videos show so much depth, not just in this subject. But, for life in general. What a gem to stumble upon your channel on KZbin. Fantastic work. 💪😎

[@Stefanovic92]

Thanks for the kind words bro👊

[@abhishekchaudhary2675]

Thanks man just stumbled on your video and it just solved the problem i was banging my head for months. You don't even know the value you have provided. Thank you

[@nami_chwaaan]

Thank goodness you're the first video i clicked when i searched for a data analysis video. Very straight forward on what to learn first. Very helpful for a learner like me .

[@VitorCunha]

What an amazing video. I started my career as Data Analytics with Excel, today I consider myself advanced in Power Bi. As in the video I highly recommend learning SQL and solving problems. Solving customer problems is the big deal to succeed in Data Analytics.

[@joshk7051]

You nailed it with the don't quit tip brother. Took me more than 6 months of learning and another 6 month of job searching to land my first business analyst gig. Now, the recruiters reach out to me.

[@Stefanovic92]

That’s awesome man!

[@mindpower3922]

Hi, Could you please tell me how many hours a day on average you spent to learn, that it took 6 months? I know that it is not an appropriate question, and it depends on many factors, but just curious to know.

[@joshk7051]

@@mindpower3922If I average it out, I'd say about 4 hours. Once I found a structured, supportive, and rigorous (beginner to advanced) training course, my training was more meaningful. I bought my own license for pbi, used real data sets, and set goals on what I could extract/ visualize. If I'd go back, I'd first get really good with excel. You'd be surprised how many companies value that. But I'm a ba, not a da. I do some etl, but very limited dev stuff. I'm more the stats and numbers guy that work with managers and stakeholders.

[@mindpower3922]

@@joshk7051 Many thanks for the answer. Would you mind telling me the name of the training course you had?

[@upskill8585]

Do they ask for python also in data analysis job is it necessary to learn python?

[@shreyashruti1549]

You are the best! Can't even tell you how useful and precise this video was

[@elineboer9049]

Dankjewel voor de duidelijke uitleg! Ik ben momenteel aan het onderzoeken hoe ik datajournalist kan worden, dus dit komt zeker goed van toepassing 😊

[@abdullahjaffrey7750]

Hi Stefan, thanks for making this video. I was quite curious about data analysis, but I had no idea where to start. You have now solved my biggest problem with great ease. Thankyou, once again! ❤

[@chrisoconnell3943]

Awesome video! I stumbled onto bioinformatics as a field because I needed to learn how to analyze RNA-sequencing data during graduate school. I fell in love with the discipline and I'm going to look for a data science job after I graduate!

[@oryana2023]

I love your sense of humor and your direct advice.

[@joeysaipan]

Straight to the point..i didn't notice the mistakes..love it!

[@chovittz9480]

This is an amazing video with all the details required to a newbie in the Data Analyst Field. Thanks for this. I learned a lot from your error.

[@samanthajoanna72]

You are an incredible content creator. Thanks for this helpful and still entertaining video!

[@manojsinghaswal9478]

You Opened my eyes, Man!!!!!!!!! Thanks for your Advice, Especially that Don't Quit Line.

[@KingslayerX]

As a 40 yrs old trying to career shift from being a garage manager, thank you SO much for the detailed information! Everyone wants to fill videos with useless knowledge and boasting instead of actually being helpful with straight up information 🎉

[@itscrewston6684]

Thanks for making this really easy to follow. This has really given me the confidence to keep it pushing.

[@H99x2]

Amazing explanation of the required steps needed to achieve a Data Analyst position, but also a great transition when you mentioned that you're on a new, different path now!

[@arnabsarkar3737]

How well have you progressed?

[@fernandomendoza3876]

Starting my journey as Data Analist. I will do my best. Thank you for the video! it helped me a lot!

[@arahmanniazi3241]

I continued to watch the video till the end for one reason: The quality of the editing and the genuineness of the humour is above the roof.

[@leod1740]

i'm a data analyst/engineer even though I studied something totally different at university. Because the demand is so large right now anybody can become one

[@juanisidrodiaz3093]

LET ME GUESS, INDUSTRIAL ENGINEERING?

[@jasskaurkailey4108]

Can u plzz plzz plzz help me 🙏🏻

[@jasskaurkailey4108]

I really wanna learn data analysis

[@lavatr8322]

Whats the situation today .... coz its been 9months...

[@quincyadams8190]

Could you please teach me

[@hardikshetty14]

Dude....this guy's humility and humor 💯💯💯!!

[@emilnikolov9851]

Another great video, Stefan. Thank you very much. So many and so clear messages!!!

[@jmuniz2104]

Nice job with the tips. I'm switching careers from sales to business analyst, so this helps a lot. The personal project tip on building something with data is golden. 👍

[@vasQpr2]

This was the most useful video I've watched in a long time. So well structured and honest.

[@AldoGalan-ml6cc]

Justo estoy aprendiendo diversas herramientas y con este vídeo veo que voy por buen camino, actualmente me encuentro perfeccionando SQL para luego avanzar con PowerBi y Tableau, muchas gracias por la información

[@feiwong70]

Super helpful! Thanks for all the links to learn.

[@prathamsolanki742]

probably the best video I have ever watched on how to become a data analyst thanks man cheers

[@sergchannel3708]

Very uplifting. I've got over thinking that I need to study a lot and was feeling rather apprehensive, but now I've cleared out that I know a lot and just need to go with more practical task!

[@dianacollins6732]

I have been stuck on a project and saw your video...thank you for making it, now I feel like I need to keep at it. I'm just leaning data analytics after being a bartender for 15 years. I feel confident enough to work on my resume and start putting myself out there!

[@jasher.sheriff]

Very inspiring. Yes, just keep at it.

[@ailuvmie]

You can do it! 🎉

[@brianjosh377]

Hi Diana. How long have you been learning Data Analytics

[@theoguerrero2975]

Go on. You can do it o/ trust in yourself

[@dianacollins6732]

@@theoguerrero2975 thank you, I actually took my CompTiaA+ Core 1 exam today because I have 3 job offers! I can't believe how much can change with hard work and positivity. I can't wait for what comes next :)

[@FireLight-India]

You have reduced lot of efforts and time of mine to find the right path and resources... Tons of Thanks 🙏

[@user-cq1hu7ur1m]

I'm an absolute first timer and this is soooo cohesive and comprehension. Really awesome explanation - love it! Thanks

[@shimayobi]

I understand your personal goal and it's awesome. Even if you made few videos about data analysis they're really thorough. I follow your channel for your wisdom in every aspect (life, work and ect.). I can't wait for your next video. Cheers.

[@paulette9086]

Thank you very much for sharing! I have learned a great deal from you. I love your sense of humour! You are seriously good! 😘

[@chideraobineme2919]

Just stumbled on this channel. I'm totally new to data analysis, but im currently considering a career in it...although I studied something completely unrelated. I was really confused on what steps to take first. Thanks for this eye opening video

[@fugazi1440]

What a great video. Started with Excel and brought the idea of PowerBi to my first company. Python is the next step

[@abrahamcastellanos3281]

Thanks for sharing this video, this is just what I needed. I am currently in a process to become in a Data Analyst. Greetings from Mexico.

[@damienphoenix1554]

I've been planning to switch my career to become a data analyst, but I didn't really know where to start, and then this video appeared on my recommendation, it's such a blessing! Thank you so much for the information and knowledge you share!

[@dwaipayanroy3232]

awesome video!!! lots of thanks for the guidance stefan !!!

[@Thegracelyn]

Thank you so much, this is the first video I’ve watched that has been helpful 😭💗

[@sreejaganguly3596]

I just started my career as a QA analyst and currently trying to figure out how to become a Data Analyst for my career growth. You just showed me the path vividly. Thank you for your help. 😊

[@okechukwuonyeukwu6055]

One day, I'll land a data analyst role. Needed this video for direction. Thanks so much.

[@saniyakhan9711]

Thanks for packaging your experience and learnings so well here! Definitely helped. Also, you're really funny haha!

[@CaribouGoMeow]

That was clear and concise, thank you so much !

[@carlosvengal264]

I cannot tell you how much I appreciate this video. Nowhere else I've seen someone "telling it like it is" in such a concise way. THANK YOU! Subscribed to Luke's Channel following your recommendation as I also see data analysis as a stepping stone.

[@Stefanovic92]

Glad it was helpful!

[@realmheart3751]

Stepping stone for what?

[@carlosvengal264]

@@realmheart3751 you’d know if you watch the video.

[@mikecripps2011]

Been a data analyst for 12 years. He is right on with what skills to gain if this is the field you want to get into.

[@Music-xr6ir]

Hey Mike. I just wanna ask you if it is ok be a data analyst? In my country Pakistan, the growth of this field is not so good and i'm worried if i'll get the job or not.

[@julianbonilla4017]

Hook a brother up

[@parkeroof4705]

@@Music-xr6ir I'm curious about the same. However you don't have to have the necessary job in Pakistan because it will pay very less. You gotta apply to overseas american, european companies like google, IBM etc.

[@kyanamaaf6314]

I love this video so glad I found this! Hate my degree and I'm stuck on what to do after graduation, this gave me the motivation to start this journey after months of negative self-doubt.

[@DavidVanAllenB]

dont quit. thanks, very helpful

[@you-fongwu7763]

Hi Stefan, thanks for making this video. I got to confess that I was totally inspired by it and interested in knowing more about your journey. Honestly, I am one of those who are spending astronomical amount of time and money on watching data analysis tutorials online. Glad that I found you when I felt a bit lost in what the next stage of my life is. Can't wait to watch more of you and your thought-provoking life. :)

[@oak3785]

really appreciate the honesty; lots of videos here romanticize the role and the journey without actually saying anything, and this helped focus my vision a lot

[@marceljunioregondi5594]

Thanks for the advice, let me get started on the journey.

[@anthonyzavala7173]

Great video now I know what to do next, just started watching and am really loving it.

[@robertpearce7795]

Great video! And it appears I'm on the right track in terms of stuff to learn. I really like Enterprise DNA for learning Power BI - And if I remember correctly, their "stack" of software is almost the same as yours, except that they have a 5th system: PowerPoint - For effective communication of the analysis that you've done. And given how well PowerPoint and Power BI are now starting to integrate, I'm inclined to agree. But anyway, love what you've said and you have a new subscriber :)

[@wtchths1234]

Thanks, Stefan. Exactly what I needed to hear. I'm going to take time off from my 9-5 as a technician in a battery research lab to travel with my computer and learn these skills. Onward and upward. Cheers

[@mahaakhan1787]

Why did I just find this? This video is the BEST so far! Not kidding I was so confused about where to start. Awesome job explaining everything so well to a beginner like me.

[@apronsandmagnolias]

Your channel is exactly what I need. Thank you!

[@afonsocruz7330]

I was already thinking of becoming a Data Analyst before discovering your channel! I'm going to my last year as an Economics student at university and will be studying data analyses as you recommended meanwhile! And yes, it will be a stepping stone, to what? I don't know yet. Once again great content, keep it up!

[@dalkeiththomas9352]

Haha same, I just finished my Bsc in Economics and Statistics.. Starting Msc in Econ.. But planning to opt for this

[@subhasish_lmaoo]

Stepping stone to a Data Scientist ?

[@Carl-FriedrichWelker]

Cinematography, editing, and storytelling/content on point man. Not bad🙌🏻

[@AhmedMostafa-so2jp]

this was really helpful man, thank you!

[@rauscaca5376]

Love the video, thanks I currently start to master Excel and begin to start SQL. And this video help me a lot to which path to step.

[@KhaiTran-se7sn]

Amazing content Stefan. I’m currently a student at a university in Florida, majoring in business analytics and information systems (which yeah basically trained you to become a data analyst). I’m a senior now but i feel like i learned shit in the last 3 years (despite getting all A and paying tons of money). I learned from your videos way more than in the college classroom.

[@chi2om]

Lol literally same but I guess a master's degree would look good on the cv

[@Must_77785]

Can you suggest me a cheap laptop for data analytics and software development

[@petrona3049]

Graduated last year 3.8 gpa in IS and have nothing in my brain. Haven't had the guts to apply to any jobs because I know I don't have the knowledge or skills. Now I'm on YT learning what I should've in college.

[@rqrjq4iari4]

@@petrona3049 i'm a second yr IS student too and i don't even learn a thing 😂

[@bennydavid623]

I am a health analyst graduate student, and know pretty much nothing. I guess I'm paying for the piece of paper.

[@brosjay2131]

Hey man. I just watched your video. Its been so helpful. Plus the way you create humor as well to is very nice. God bless you. I'm going to start from the excel practice!

[@brosjay2131]

I just enrolled in a masters programme in a UK university and been thinking same. I actually want to use data analytics as a stepping stone as well

[@chinezeobiako1367]

Thank you so much. This is the best advice and encouragement I have received

[@nisk7142]

Thank you so much ! Exactly what I needed! 🙏

[@sarangpratapchamola9388]

I am actually working with python but when he said "if i could go back into time" Here my heartbeat paused for a moment...&.then continued after he said "i would choose python"😂😂

[@AzzaButter]

This is spot on, great video to help people get on track.

[@NkemUwaje]

Honestly the most useful video I've watched so far on switching to data analysis

[@AstronautElvis]

I currently spend most of my day in Excel, SQL, and Tableau as an Analyst. They all have their own learning curves, but it's the best feelings when you understand and conquer a new piece of the puzzle. Python is next on the list... Great Video!

[@LM-ch8rh]

@AstronautElvis hi. was experience with Excel, SQL and Tableau enough to get a job as an Analyst?

[@jasskaurkailey4108]

Can u plzz plzzz teach me plzz🙏🏻🙏🏻🙏🏻i really wanna learn

[@TaLeng2023]

So how are things going? Have you landed a job already?

[@KK-kc1mf]

I agree, but after Excel I started PowerPivot+Power Query and then the whole PowerBI, that helped me transform multiple excell files and other data sources. That was much easier for me to start learning SQL after them and with the only functions i needed. Now I'm developing my SQL and DAX. Excel, PBI and SQL are easy to learn comparing to the power they offer while using together.

[@missmg6610]

Thanks for your recommendation how to start and your great mood , love it

[@andyjm7122]

Fantastic guidance. Thank you Stefanovic!

[@maahisingh381]

The best Video EVER found about DATA ANALYSIS. ! Undoubtedly. Loads of Love for ya

[@Stefanovic92]

Glad you liked it!

[@imamamansoor5174]

Thanks Stefanovic for such motivation. I am on career reviving stage after 12 years gap. Struggling so hard for last 2 years but couldn’t make it up. I am a mom of three kids but keenly passionate about my career. Hope i will be succeeded in establishing my freelancing career as a DA. Thanks once again.

[@ilikedeadlift2739]

Best of luck !!

[@Pritha879]

Amazing !

[@napvanvuegt]

... wishing you all the best! mom here too (of two, tho) checking out new career possibilities.

[@mojoallen3725]

I am starting over again, too, after a long journey of caregiving for our parents. Good luck!!!

[@0x007A]

I am in a similar situation after helping care for my parents, albeit I regret not spending more time with them as they are both deceased 5 years and 9 years ago respectively.

[@giftnicholas3554]

The best video i have watched on youtube in a very long while. THANK YOU SO MUCH. 👏👏👏👏🤜

[@snipernan7448]

Thank you so much Stefanovic!

[@whycantwecontainit]

The job search has been long, painful, and dehuminizing since being laid off. Working on my excel, R, SQL skills while looking to pickup Python and it still feels like not enough while having a bachelors. Thanks for discussing this topic

[@age_of_reason]

There aren't nearly enough jobs in the market to keep all the people in it gainfully employed; plus all those millions graduating each year. Economy is finished.

[@mehere2872]

My beginning with Excel and Power BI was through some Create and Learn book series, and LinkedIn learning. material very fast to consume. Now I am doing some more advanced books like Guide to Dax and courses on linkedIn as well.

[@akeemogunkoya8920]

The best video I have ever watched on my journey to becoming a data analyst

[@Deraj_]

bruh, this is probably the best video I have ever seen when it comes to actually finding a career... omg

[@uso.8156]

This was so wholesome and so funny.😄 I was getting frustrated at my progress(almost quit)as I am learn python for data science. This helps a lot. I'll continue with python then to sql and power bi.

[@ericbawm]

going through the same thing and I'm blessed to have seen this video on KZbin tonight

[@YahToldMe]

I'm pretty sure you are already working on this type of content....but I'd love to see more about your journey as a Freelance Data Analyst too!

[@hectorortega9481]

Thank you so much for the information, I want to start in this career and your video it has been so helpful, showing us the path to follow

[@vishalverupanda986]

Best video for venturing Data Analysts. Thankyou so much stefanovic.

[@youngd352]

I needed this video. I've been on the journey since the start of 2022 on becoming a Data Analyst. I would say that I'm extremely well in Excel, and I would rate myself as an intermediate in SQL (I actually enjoy using SQL). I'm actually a bit nervous about using python since I've attempted to learn using it in the past and it was just a tough language to learn. I know that a lot of jobs don't require it, but I also know that it is a preferred skill to use, and that it'll help with the job search faster. Once I'm really comfortable with SQL, Python will be my next move. Hopefully I'm able to land a job soon! I already have a couple portfolio projects done thanks to Alex and Coursera. Just needed something to kick me back into gear.

[@adepejuabdulrahmon6398]

Good to hear this from you, I would like to seek more guidance on data analysis from you if you don't mind .

[@himaj7173]

Hey,hows it going with your studies?did you get job as da?

[@zr2ee1]

great intro, I've dipped my toe into the subject and one thing I'll note is that Google sheets query function has a lot of SQL like syntax so for me at least that helped with the transition. also scripts inside of sheets is a pretty good Segway into coding languages like python from what I've experienced.

[@leen7055]

Fantastic advice, THANK YOU!!!

[@mundial2223]

You have made a very generous gesture with this video for those who want to better understand what this profession is about. That's why I want to thank you. Greetings!

[@Superfmrs]

Todavía no he terminado de verlo y ya te voy a escribir el comentario. Increíble contenido!!! Buenísima edición, centrado en el tema, sin irte por las ramas. Sigue así!! Saludos!

[@Stefanovic92]

Gracias amigo!

[@Abhi_Nav]

Thanks a ton brother! That was really resourceful and the exact advice I was looking for 👏🏻 Also, if you could suggest any useful certifications to consider that would add up well in the profile, that would be great. Thanks again 🙏🏻

[@anthonydenis9933]

Thank you for this content ! Amazing video, very inspirational!

[@jorgprod]

Dudeeee, love your content! Thanks for all the tips, like, for real when you said in a couple of videos ago that you studied industrial engineering (I just wrapped up the major) man, that gave me hope that I can be a data analyst as well so yep haha you rock Saludos desde Mexico wey

[@Stefanovic92]

Yea man with an Industrial engineering degree you can go a lot of ways. Gracias for watching hermano!