FASTEST Way To Become a Data Analyst and ACTUALLY Get a Job In 2024

Рет қаралды 178,534

Күн бұрын

The purpose of this video is to provide a fast and simple way to learn data analysis including a step by step guide to get yourself a full-time Data Analyst job with additional pieces of insight that will help you navigate the current and future status of this role.
This video covers the following:
1. What tools/languages you need as a Data Analyst?
2. How to Learn Data Analysis fast?
3. How to prepare for Data Analysis interviews?
4. What are the key mistakes everyone makes when learning Data Analysis?
▬ Resources Mentioned In This Video ▬▬▬▬▬▬▬▬▬▬
1. Learn Excel: excel-practice-online.com/
2. Learn SQL: www.codecademy.com/search?que...
3. Learn Power BI: learn.microsoft.com/en-us/tra...
4. Learn Python: www.kaggle.com/learn
5. To get Datasets to practice or create data projects (Kaggle): www.kaggle.com/datasets
6. To Practice for Technical Interviews (Leetcode) - leetcode.com/problemset/datab...
7. To Practice for Technical Interviews 2 (HackerRank) - www.hackerrank.com/domains/sql
8. CHATGPT - chat.openai.com/
▬ My Other Videos Mentioned ▬▬▬▬▬▬▬▬▬▬
1. Tips & Tricks To Pass The Microsoft Data Analyst Associate (PL-300) Certification - • Tips & Tricks To Pass ...
2. Is The Google Data Analytics Certificate Worth It? | Full Review - • Is The Google Data Ana...
▬ Book a Call With Me ▬▬▬▬▬▬▬▬▬▬
Mentoring sessions with me (Data/Career) - topmate.io/unorthodoxchange
▬ Other KZfaq Channels Mentioned ▬▬▬▬▬▬▬▬▬▬
AI + General Data Analysis Guidance - ⁠@LukeBarousse
▬ Gear I Use In My Videos ▬▬▬▬▬▬▬▬▬▬
Main Camera - amzn.to/48kbDbm
Main Light - amzn.to/49Eetsz
Main Light Softbox - amzn.to/3UKTwrP
Microphone I Use For Everything - amzn.to/3wixAdj
Editing Laptop - amzn.to/3uKxeM7
Noise Cancelling Headphones - amzn.to/49mLr18
#dataanalytics #datasicence #data
Please note I may earn a small commission from some of these links - thanks for helping out
Thanks for Watching and Subscribe if you want to help out :)

Пікірлер: 349

@Saif_Khan313 3 ай бұрын

Learns skills: 1: Excel 2: SQL 3: Power bi 4: Python Keep learning and updates yourself.

@ivantonny8337 3 ай бұрын

Excel is too complicated in the first place

@Saif_Khan313 3 ай бұрын

@@ivantonny8337 it's not much complicated if you start to very basic and starts practice on daily basis.

@360soccer. 3 ай бұрын

⁠@@ivantonny8337you can do it..i’m learning it gradually

@Gaby-cq8pr 3 ай бұрын

@@ivantonny8337thanks for the video😊

@Gaby-cq8pr 3 ай бұрын

And thanks for this list I'm just going to screenshot it 😊

@ZwaneML 23 күн бұрын

"Starting and not finishing" - this stood out for me. Your guidelines are priceless. You are so assuring. Keep it up.

@UnorthodoxChange 17 күн бұрын

Thanks for the kind words and 100% will do

@paulomorogbe2875 3 ай бұрын

The entire process is well explained. Well done sir

@normcandie 18 сағат бұрын

You hit the nail. Starting and Not Finishing….. is the problem. I totally agree.

@jedijazzy6643 2 ай бұрын

Wow you made what could’ve been a boring video SO engaging & great looking! It’s the production quality for me!!

@UnorthodoxChange 2 ай бұрын

Thanks for the kind words. Will ensure quality stays consistent

@benruns6151 2 ай бұрын

Thanks for the simplified information.

@yolandaosad3115 3 ай бұрын

Thanks for this guide! I’ll definitely take it on board

@UnorthodoxChange 3 ай бұрын

No worries at all - happy it helped you out

@vonnpowell3844 3 ай бұрын

I’m getting into data analytics. Glad I came across your video. 😊

@UnorthodoxChange 3 ай бұрын

Thank you and good luck

@Gamesoldier68 5 күн бұрын

Thank you so very much for the great video! Starting a new career in most fields can be overwhelming. The uncertainty of where to start, what to learn, what tools one can use to practice, leads to frustration with no sense of direction. Your honest break down of what to learn, how to learn it to actually get a job in the field is one of the best explanations I have come across. This is information is very helpful. Thanks again!

@brendaortiz5055 3 ай бұрын

I can't stop coming back to your video! You are so good at explaining things. Thank you for sharing your story and all the valuable gems my friend. I happily subscribed and am looking forward to your other amazing content. Cheers! 🥂

@UnorthodoxChange 3 ай бұрын

I really appreciate the kind words and happy to hear the video is providing the value you need. Great to have you onboard 😃

@geekatari4391 2 ай бұрын

I thought Data analysis was all about Excel, so I mastered it, but didn't feel I could do as much as I thought. You opened my eyes, and my next goal is to learn sql, power bi and python. God bless you!

@UnorthodoxChange Ай бұрын

Yeah excel is a great start but its way more than this some roles even get real specific where you find yourself doing really only SQ. It varies company to company but having a hang of a tools (even at a beginner level) will help you the most moving forward

@courageiroro5604 3 ай бұрын

Such a sincere explanation!

@user-ct3de6xl4c Ай бұрын

Thank you so much unorthodox change for this value. Just got across your channel and I'm so glad you provide an end to my search. Thanks for realistic, practical and simplicity tip you provide

@UnorthodoxChange 17 күн бұрын

You are so welcome and no worries at all. Let me know if you have any questions.

@balford2112 3 ай бұрын

Thank you for this video. I have been stuck in course land for way too long! I needed to hear your words of advice.

@UnorthodoxChange 3 ай бұрын

No worries at all and you got this!

@diegomuniz3578 2 күн бұрын

loved this. thank you

@hopeful806 3 ай бұрын

This is a great video. You make the learning process so clear and simple. Thank you for the great advice and guidance.

@UnorthodoxChange 3 ай бұрын

You're very welcome

@user-jp9mg1gj5e 3 ай бұрын

This was an awesome video. Great resource recommendations!

@UnorthodoxChange 3 ай бұрын

Appreciate the kind words and no worries at all.

@thegracemarie 2 ай бұрын

Explained in a very clear and succinct way, great video!

@UnorthodoxChange Ай бұрын

Much appreciated :)))

@chrisreisinger5002 4 күн бұрын

Thank you. The whole video is great.

@erinintech 2 ай бұрын

Thank you for sharing this content. It is very straightforward and concise. I had to watch quite a bit of videos before someone just spelled it all out for me. This was beyond helpful. Please keep sharing. It is much appreciated.

@UnorthodoxChange Ай бұрын

Thank you for the kind words and of course I'm happy to hear that this video hit the mark for you

@BikramGC-xo1vm 4 күн бұрын

thank you boss for your precious information keep uploading these kind of data analytics video and hope i will be one day like you and i want to be. keep motivating and again thank you. lets start these ride.

@MohamedElHarras 3 ай бұрын

Thank you, you have a great style in conveying your thoughts & experience.

@UnorthodoxChange 3 ай бұрын

My pleasure!

@nadsb6170 Ай бұрын

Just stumble upon your video and so far, one of the best on my list. You were clear and provided a lot of resources to access to help. I am now a subby, will continue to be. I may have to get in touch for a career chat going foward. Thanks my brother

@UnorthodoxChange 17 күн бұрын

Happy to hear this video was clear and met what you required. Any questions feel free to drop me a line. Take care

@zizoh3993 2 ай бұрын

I just started n coming across this reminds me importance of practice

@AM-Boluke1210 Ай бұрын

Love the visuals 🤩👍

@abdidirir3372 2 ай бұрын

As someone just starting off this journey, your video made it very clear on the road map required 👏🏾

@UnorthodoxChange 2 ай бұрын

Glad to hear this and good luck on your journey

@jryner 4 ай бұрын

Thank you, one of the most informational and interesing videos out 👍

@UnorthodoxChange 4 ай бұрын

Glad it was helpful!

@iamteja03 2 ай бұрын

Thanks for the Clarification. Learning Numpy and Pandas for Data Analyst job is good. Because i learned, 1. Excel 2. BI Tool (Power BI) 3. SQL 4. Python.

@afcentertainmentgroup456 Ай бұрын

Great breakdown of what one needs to learn and understand toward becoming a data analyst. I have an upcoming interview for a strategy analyst position and this info I believe can help in that area as well. Thank you!!👍

@UnorthodoxChange Ай бұрын

Best of luck just make sure to do practice alongside this video

@sorosfox3801 3 ай бұрын

Great job! Keep up the good work.

@UnorthodoxChange 3 ай бұрын

Thanks, will do!

@lanesh7245 3 ай бұрын

Good content! I love how you took your time explaining! Subscribed.

@UnorthodoxChange 3 ай бұрын

Happy to hear that you enjoyed it and great to have you onboard

@abdulazeezadetunbi-br2ww 3 ай бұрын

INSIGHTFUL! 👏🏼 Thank you!

@UnorthodoxChange 3 ай бұрын

Glad it was helpful

@avwatajudith4346 3 ай бұрын

Thanks for this video. I have been wanting to include data analytics to my portfolio of knowledge as a BA. Very helpful ❤

@UnorthodoxChange 3 ай бұрын

You're so welcome! It's a great addition to your portfolio of knowledge

@mzuhara8182 3 ай бұрын

Good video for aspiring data analyst and Your Clear-Cut points are awesome

@UnorthodoxChange 3 ай бұрын

Happy to hear the video provided value

@cnowledge 2 күн бұрын

13:45 value added! 🔥 love how you didn’t shove your channel in our face … dope content.

@MrCologneMusic 16 күн бұрын

Awesome video man, helped me to understand whats really important for the start of this journey! Thank u for the information and motivation!

@UnorthodoxChange 8 күн бұрын

Much appreciated. Always happy to hear the video helped you and others out 😊

@yunekfindz 3 ай бұрын

Wow. Your vid was both informative and motivating 👏🏾 👌🏾 👍🏾 I'd been stuck in the tutorial hole 🕳 but you've covered great notes on both how to learn and apply the knowledge 🎉 I'm currently pursuing IT to boost my career and I think you just sold me on data analytics! Great work and thank you too!

@UnorthodoxChange 3 ай бұрын

Wasn't planning to bring anyone to data but I'll take it. Thanks for the kind words also👍🏾

@mizzemotionz4074 3 ай бұрын

I just found your channel, and subscribed immediately a few minutes into the video. Also based in the UK and doing a 12 wk Data Analytics boot camp course. Main units covered are python, Microsoft sql, Google sheets, excel and Power BI. Each unit is between 5-7 (2.5hrs) live zoom classes. Done python and sql so far, sometimes I feel like there is so much to learn, as I am doing a whole lot of self study and the classes only cover the basics. Sometimes, I do ask myself if I am biting off more than I can chew and if it will ever be possible to work in a data analytics role, as there just seems to be so much knowledge needed. My intention is to keep doing self study after the 12 week boot camp is over, until I feel confident enough in my skill set to start applying for jobs in data analysis. What would you say is a realistic time frame, for someone who is not from a computer science, Mathematics, IT background to build enough knowledge base needed to start applying for entry level roles? Thank you in advance for your reply, I hope it will be possible to get a reply.

@UnorthodoxChange 3 ай бұрын

Ayy happy to have another person from the UK that's looking into the world of data 👍🏾 Just keep up the work in your own time, like anything technical some elements can be overwhelming especially when there's quite a few tools to learn but overtime it just starts to click. Realistic time frame depends on how many other life commitments you have but to be conservative deffo achievable to learn and feel more comfortable in interviews while also having a decent portfolio to lean on when needed would be 5-6 months (which with the fact you got the bootcamp - if its actually good might be closer to 5 months for you) With that all being said good luck, you got this.

@mizzemotionz4074 3 ай бұрын

@@UnorthodoxChange Thank you ever so much, I really appreciate your reply, encouragement and realistic advise and especially your time. I will stick to try to aim for the time frame you advised of. I wish you an awesome evening and I look forward to watching more of your videos. Thank you for the good work, it is of great benefit to people like myself. 😊

@ab2mak 4 ай бұрын

Back with another banger 🎉 happy new year 👊🏾

@UnorthodoxChange 4 ай бұрын

Appreciate it bro 👊🏾 and happy new year. Still waiting on yours thou 👀

@beardydaddy1394 Ай бұрын

Very, very helpful and friendly dude! Keep it up. I am a new follower!

@UnorthodoxChange 17 күн бұрын

Thanks a lot and happy to have you

@sibusisotwala6420 3 ай бұрын

Subscribed! All the way from South Africa!

@UnorthodoxChange 3 ай бұрын

Happy to have you onboard brother 👊🏾

@jachikesamuelson7425 Ай бұрын

This is nice. I've been looking to get into data analysis with a view to transition to data engineering. This is a good guide to get started. I'll be following it. Thanks for the content.

@UnorthodoxChange 17 күн бұрын

Happy to hear it was helpful and good luck on the journey

@gtgpic4679 2 ай бұрын

Very helpfull, not just about what to do but guiding on how.

@UnorthodoxChange 2 ай бұрын

Glad to hear it was valuable to you

@janegathiaka4490 3 ай бұрын

Very helpful information and guide to resources. Thanks, subscribed

@UnorthodoxChange 3 ай бұрын

Happy to hear it was all useful and thanks good to have you onboard

@armana1 3 ай бұрын

Awesome and so easy to digest presentation.Now i am inspired .well done and thanks for this

@UnorthodoxChange 3 ай бұрын

Thanks a lot 😊

@dashen2058 Ай бұрын

Thank you bro. You are doing a good job, you just inspired me to go ahead bro. I will follow the steps juat as you just listed them. Thanks a million

@UnorthodoxChange Ай бұрын

Good luck on the journey and happy to hear this inspired you to make a start

@caetano.santana 2 ай бұрын

really nice insights, my friend. thank you very much.

@UnorthodoxChange Ай бұрын

My pleasure!

@SummerTime-de3sd 21 күн бұрын

Hi there, newbie in computer science here! This video was extremely helpful and the extra relations to free websites to learn these skills were really helpful. Thank you!

@UnorthodoxChange 17 күн бұрын

No worries at all. More than happy to help

@AK-fr8sy 3 ай бұрын

Data analyst turned data engineer. Everything you mentioned is spot on 💯

@UnorthodoxChange 3 ай бұрын

👌🏾👌🏾

@abhisekgupta1543 3 ай бұрын

Do you need DSA to be a data engineer

@AK-fr8sy 3 ай бұрын

@@abhisekgupta1543 what’s DSA?

@leonardezeigbo6583 2 ай бұрын

I'm a data analyst but I want to switch to being a data engineer because to be honest, data engineers earn better. What do I need to earn to make the switch?

@AK-fr8sy 2 ай бұрын

@@leonardezeigbo6583 1. try and use as much python and sql in your current job as you can 2. Get AWS CCP certificate 3. Apply for DE roles

@user-ux4ct7nv3y Ай бұрын

Fantastic video, well said, succinct, motivational.

@UnorthodoxChange Ай бұрын

I appreciate that!

@austinbobmanuel4065 Ай бұрын

Thank you so very much. I really appreciate the way you narrowed it down and show your understanding of the process of getting job ready. I will confess: I am currently in tutorial hell. But starting now. Actually, I am to dedicate April to EXCEL, May to SQL/Python and then June to the visualization tools in this stage of my self-learning. My goal is to start the Google Certification in July and finish before December! Workable? Your resources will really come in handy and I feel confident. I will follow your channel. And I am certain we will see more of each other going forward. Wish myself luck!

@UnorthodoxChange 17 күн бұрын

Its good to get an understanding of where you are so you know how to move from it. I would give yourself more time with SQL/Python as they generally tend to be trickier to understand than the other tools. Wish you good luck on your journey and any questions feel free to drop me a line 👌🏾👌🏾

@yohannaagbanaji8012 13 күн бұрын

Yes, I will start and finish. Thanks man.

@UnorthodoxChange 8 күн бұрын

No worries at all. Make it happen

@LukeBarousse 3 ай бұрын

12:26 Thanks for the shoutout my dude!! 🤙

@UnorthodoxChange 3 ай бұрын

No worries Luke - Keep up the great videos

@killersongs7906 3 ай бұрын

wow i see you in the coment section of this utuber...actually i started taking interest in your videos & you know i watched all of your videos bro...i really liked your videos...

@VinnyDrones 3 ай бұрын

Informative content and great delivery 👍

@UnorthodoxChange 3 ай бұрын

Much appreciated!

@mikehamweene5649 10 күн бұрын

I will be watching this beyond data analytics lessons

@rurbleburble 21 күн бұрын

Thank you, sir. You saved my time from countless need of resources, and yes shouldn't waste my time lingering on youtube and start putting my knowledge to work. loved the video!

@UnorthodoxChange 17 күн бұрын

You are welcome!

@Hassann1 2 ай бұрын

Very Helpful, Thanks Man

@UnorthodoxChange 2 ай бұрын

No problem!

@chloefourte3413 2 ай бұрын

great video man! thank you!

@UnorthodoxChange Ай бұрын

Thanks a lot

@jopadfoot 21 күн бұрын

Great advice. Thank you. Trying to move into Data from over a decade in a completely unrelated field in the performing arts, so this gives me hope that I can make up for a lack of industry and sector experience by developing a strong skill set with industry recognised certifications.

@UnorthodoxChange 17 күн бұрын

You deffo can do it if you put in the work as we all have to start somewhere

@sumaraFrames 10 күн бұрын

Wow ! Wow !! Wow !!!! Such an insightful Video . Thanks a million

@UnorthodoxChange 8 күн бұрын

Happy to hear the video was helpful

@UserAbdullahT 3 ай бұрын

Keep Going My Brother

@UnorthodoxChange 3 ай бұрын

Always

@EnVideoZone 3 ай бұрын

You were really clear and sensible so I stayed to the end, liked, subscribed and now I am off to practice....

@UnorthodoxChange 3 ай бұрын

Welcome aboard and good luck

@RawShogun 21 күн бұрын

Spot on, started as pt budtender 3 years ago, now I’m a sr analyst for a major MSO in the cannabis industry.

@UnorthodoxChange 17 күн бұрын

Amazing journey 👌🏾👌🏾

@emmanuelolukayodeayedun2709 Ай бұрын

Thank you for the information.

@UnorthodoxChange 17 күн бұрын

Any time!

@jimiikomi573 2 ай бұрын

Thanks boss for this great road map

@UnorthodoxChange Ай бұрын

No problem :)

@Fuldn 3 ай бұрын

Great video very informative and much needed advice

@UnorthodoxChange 3 ай бұрын

Appreciate the kind words

@FauziFayyad 8 күн бұрын

Thanks man

@PeterOlubayo-VisaPathfinders Ай бұрын

Good job bro! You made it super easy & engaging!😂

@UnorthodoxChange Ай бұрын

Happy to hear you enjoyed the video :)

@mwasgophul1813 2 ай бұрын

Well done my brother this is a great run down. Am doing this to the end and I hope you can promise me a connect when am done. I won't disappoint, I promise!

@UnorthodoxChange 2 ай бұрын

Thank you and while I don't actively use my LinkedIn enough I'm very open to accepting professional requests so happy to connect

@_Molley007 Ай бұрын

Thank you for this video. I believe my main problems are sql and interview.

@UnorthodoxChange Ай бұрын

No worries at all and all that requires is practice to get past both obstacles so you got this.

@ddp2049 3 ай бұрын

I have been learning from a lot power query however I want to learn power bi and SQL I enjoyed your video

@UnorthodoxChange 2 ай бұрын

Luckily for you power query is a core part of Power BI so that will be helpful in your learning. Happy to hear you enjoyed it

@solomonndungu2011 3 ай бұрын

I endorse this message. I will share it with all my mentees.

@UnorthodoxChange 3 ай бұрын

Much Appreciated

@sabiahamid6224 2 ай бұрын

Happy I found your channel 🎉

@UnorthodoxChange 2 ай бұрын

Glad the video was valuable :)

@tess1136 14 күн бұрын

Thank you for the useful info

@UnorthodoxChange 8 күн бұрын

Happy to help

@sbrady1068 2 ай бұрын

Thank you brother 💪

@UnorthodoxChange 2 ай бұрын

No problem at all

@adamsarwar 3 ай бұрын

Great video, thank you!

@UnorthodoxChange 3 ай бұрын

Glad you liked it!

@ebenezersam788 Ай бұрын

Thanks for sharing

@UnorthodoxChange 17 күн бұрын

My pleasure

@Ella-pearl- 3 ай бұрын

Subscribed ❤

@johnthomasii943 Ай бұрын

Great job! Thanks for the info! I need a job 😢

@UnorthodoxChange 17 күн бұрын

Just keep working at it, put the spare time in to learn, build and apply for jobs

@audreya3127 25 күн бұрын

Thank you 🙏🏾

@UnorthodoxChange 17 күн бұрын

No problem 😊

@horacioparraguirre7486 3 ай бұрын

Magnificent video 👌Cool !!! Greetings

@UnorthodoxChange 3 ай бұрын

Greetings and glad to hear the video provided value

@georgesi.n4759 3 ай бұрын

Thanks for the guide. Good video. Please could you put the link to that channel you mentioned? The guy who talks about all things AI in data analysis

@UnorthodoxChange 3 ай бұрын

No worries at all and I provided it in the description but his name is Luke Barousse

@xmanncoko4639 2 ай бұрын

Thank you Sir for great informative roadmap for DA

@UnorthodoxChange Ай бұрын

No worries at all :)

@samiaamin43 13 күн бұрын

I really love everything about your video.. you deliver flawlessly ❤❤.. you should have your own tv show and talk about anything and I will be there to listen and follow. To answer your question why I am here.. well, I have been flirting with the idea of becoming a data analyst for a while and almost finished my Google certificate. I have applied for couple of positions and been interviewing but still no offer.. another interview coming up soon.. wish me luck 🍀

@UnorthodoxChange 8 күн бұрын

Really appreciate the kind words. It means a lot. I deffo don’t think I’m good enough at speaking to do all of that 🤣🤣🤣 but thanks. I pray you get a job offer soon 🙏🏾 alongside smashing the upcoming interview 👌🏾

@chandlerghayes2 26 күн бұрын

Great resources to learn

@marie-vb3vg Ай бұрын

great video, thank you!

@UnorthodoxChange 17 күн бұрын

Glad you liked it!

@user-np3mc2xo3m 3 ай бұрын

Very useful, thank you

@UnorthodoxChange 3 ай бұрын

No worries at all

@kbodyshaperstv3436 Ай бұрын

Thank you ❤

@UnorthodoxChange Ай бұрын

You're welcome 😊

@yohannaagbanaji8012 Ай бұрын

I like your video man, thanks a lot. In fact, I have taken down the links. I'm so grateful.

@UnorthodoxChange 17 күн бұрын

You're welcome

@kristiandoychev2449 24 күн бұрын

Great video, thanks

@UnorthodoxChange 17 күн бұрын

My pleasure!

@eminencearrey1756 3 ай бұрын

🎉Great advice

@UnorthodoxChange 3 ай бұрын

Thanks man

@Jorsten 3 ай бұрын

This is a great video offering sound advice. What's the math level you're use at your current job? Any advanced concepts? Coursera also has a power bi data analyst path now. Not sure if it's better than Google's data analyst. Also, what software did you use to edit this video? All the animation effects look great.

@UnorthodoxChange 3 ай бұрын

Thanks and nothing advanced needed tbh with you but knowledge of statistics deffo helps (mode, median, average etc). I also use Davinci Resolve

@mamt0m 3 ай бұрын

nice vdeos, i'm glad to find someone from the UK making data analytics videos. i'm thinking about getting into it this year, but hearing mixed things about the job market in 2024, what do you think about that?

@UnorthodoxChange 3 ай бұрын

Thanks and didn't know I was the first from the UK tbh. I think you should go for it. The market isn't the best right now but use this opportunity now to learn so when the market is better again you are more than ready to excel. You can also at the same time still apply for roles during the down market.