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

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 KZbin 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 :)

[@Saif_Khan313]

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

[@ivantonny8337]

Excel is too complicated in the first place

[@Saif_Khan313]

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

[@360soccer.]

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

[@Gaby-cq8pr]

​@@ivantonny8337thanks for the video😊

[@Gaby-cq8pr]

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

[@ZwaneML]

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

[@UnorthodoxChange]

Thanks for the kind words and 100% will do

[@paulomorogbe2875]

The entire process is well explained. Well done sir

[@jedijazzy6643]

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

[@UnorthodoxChange]

Thanks for the kind words. Will ensure quality stays consistent

[@cnowledge]

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

[@benruns6151]

Thanks for the simplified information.

[@Gamesoldier68]

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!

[@courageiroro5604]

Such a sincere explanation!

[@lanesh7245]

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

[@UnorthodoxChange]

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

[@brendaortiz5055]

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]

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

[@yolandaosad3115]

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

[@UnorthodoxChange]

No worries at all - happy it helped you out

[@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]

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

[@user-jp9mg1gj5e]

This was an awesome video. Great resource recommendations!

[@UnorthodoxChange]

Appreciate the kind words and no worries at all.

[@vonnpowell3844]

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

[@UnorthodoxChange]

Thank you and good luck

[@chrisreisinger5002]

Thank you. The whole video is great.

[@hopeful806]

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

[@UnorthodoxChange]

You're very welcome

[@geekatari4391]

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

[@erinintech]

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]

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.

[@AM-Boluke1210]

Love the visuals 🤩👍

[@MohamedElHarras]

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

[@UnorthodoxChange]

My pleasure!

[@balford2112]

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]

No worries at all and you got this!

[@thegracemarie]

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

[@UnorthodoxChange]

Much appreciated :)))

[@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

[@MrCologneMusic]

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

[@UnorthodoxChange]

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

[@abdulazeezadetunbi-br2ww]

INSIGHTFUL! 👏🏼 Thank you!

[@UnorthodoxChange]

Glad it was helpful

[@iamteja03]

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.

[@jryner]

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

[@UnorthodoxChange]

Glad it was helpful!

[@mizzemotionz4074]

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]

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]

@@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]

Back with another banger 🎉 happy new year 👊🏾

[@UnorthodoxChange]

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

[@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]

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

[@sorosfox3801]

Great job! Keep up the good work.

[@UnorthodoxChange]

Thanks, will do!

[@zizoh3993]

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

[@abdidirir3372]

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

[@UnorthodoxChange]

Glad to hear this and good luck on your journey

[@sibusisotwala6420]

Subscribed! All the way from South Africa!

[@UnorthodoxChange]

Happy to have you onboard brother 👊🏾

[@yunekfindz]

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]

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

[@janegathiaka4490]

Very helpful information and guide to resources. Thanks, subscribed

[@UnorthodoxChange]

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

[@beardydaddy1394]

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

[@UnorthodoxChange]

Thanks a lot and happy to have you

[@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

[@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]

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

[@avwatajudith4346]

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

[@UnorthodoxChange]

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

[@mzuhara8182]

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

[@UnorthodoxChange]

Happy to hear the video provided value

[@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]

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 👌🏾👌🏾

[@rurbleburble]

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]

You are welcome!

[@caetano.santana]

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

[@UnorthodoxChange]

My pleasure!

[@armana1]

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

[@UnorthodoxChange]

Thanks a lot 😊

[@Hassann1]

Very Helpful, Thanks Man

[@UnorthodoxChange]

No problem!

[@user-ux4ct7nv3y]

Fantastic video, well said, succinct, motivational.

[@UnorthodoxChange]

I appreciate that!

[@chloefourte3413]

great video man! thank you!

[@UnorthodoxChange]

Thanks a lot

[@LukeBarousse]

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

[@UnorthodoxChange]

No worries Luke - Keep up the great videos

[@killersongs7906]

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]

Informative content and great delivery 👍

[@UnorthodoxChange]

Much appreciated!

[@gtgpic4679]

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

[@UnorthodoxChange]

Glad to hear it was valuable to you

[@emmanuelolukayodeayedun2709]

Thank you for the information.

[@UnorthodoxChange]

Any time!

[@FauziFayyad]

Thanks man

[@sumaraFrames]

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

[@UnorthodoxChange]

Happy to hear the video was helpful

[@SummerTime-de3sd]

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]

No worries at all. More than happy to help

[@PeterOlubayo-VisaPathfinders]

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

[@UnorthodoxChange]

Happy to hear you enjoyed the video :)

[@Ella-pearl-]

Subscribed ❤

[@AK-fr8sy]

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

[@UnorthodoxChange]

👌🏾👌🏾

[@abhisekgupta1543]

Do you need DSA to be a data engineer

[@AK-fr8sy]

@@abhisekgupta1543 what’s DSA?

[@leonardezeigbo6583]

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]

@@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

[@yohannaagbanaji8012]

Yes, I will start and finish. Thanks man.

[@UnorthodoxChange]

No worries at all. Make it happen

[@jopadfoot]

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]

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

[@Fuldn]

Great video very informative and much needed advice

[@UnorthodoxChange]

Appreciate the kind words

[@EnVideoZone]

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

[@UnorthodoxChange]

Welcome aboard and good luck

[@mikehamweene5649]

I will be watching this beyond data analytics lessons

[@tess1136]

Thank you for the useful info

[@UnorthodoxChange]

Happy to help

[@adamsarwar]

Great video, thank you!

[@UnorthodoxChange]

Glad you liked it!

[@jimiikomi573]

Thanks boss for this great road map

[@UnorthodoxChange]

No problem :)

[@RawShogun]

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

[@UnorthodoxChange]

Amazing journey 👌🏾👌🏾

[@horacioparraguirre7486]

Magnificent video 👌Cool !!! Greetings

[@UnorthodoxChange]

Greetings and glad to hear the video provided value

[@audreya3127]

Thank you 🙏🏾

[@UnorthodoxChange]

No problem 😊

[@samiaamin43]

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]

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 👌🏾

[@UserAbdullahT]

Keep Going My Brother

[@UnorthodoxChange]

Always

[@chandlerghayes2]

Great resources to learn

[@marie-vb3vg]

great video, thank you!

[@UnorthodoxChange]

Glad you liked it!

[@mwasgophul1813]

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]

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

[@user-np3mc2xo3m]

Very useful, thank you

[@UnorthodoxChange]

No worries at all

[@sbrady1068]

Thank you brother 💪

[@UnorthodoxChange]

No problem at all

[@ebenezersam788]

Thanks for sharing

[@UnorthodoxChange]

My pleasure

[@_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.

[@kbodyshaperstv3436]

Thank you ❤

[@UnorthodoxChange]

You're welcome 😊

[@ddp2049]

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

[@UnorthodoxChange]

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

[@kristiandoychev2449]

Great video, thanks

[@UnorthodoxChange]

My pleasure!

[@sabiahamid6224]

Happy I found your channel 🎉

[@UnorthodoxChange]

Glad the video was valuable :)

[@eminencearrey1756]

🎉Great advice

[@UnorthodoxChange]

Thanks man

[@yohannaagbanaji8012]

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

[@UnorthodoxChange]

You're welcome

[@solomonndungu2011]

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

[@UnorthodoxChange]

Much Appreciated

[@Abir.laib232]

Thank you

[@xmanncoko4639]

Thank you Sir for great informative roadmap for DA

[@UnorthodoxChange]

No worries at all :)

[@johnthomasii943]

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

[@UnorthodoxChange]

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

[@georgesi.n4759]

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]

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

[@ck1583]

Great l will get to work!

[@piromaniaco3579]

I'm saving this video ❤

[@UnorthodoxChange]

Glad it was valuable

[@angelamorgan3399]

Great job.

[@UnorthodoxChange]

Thanks

[@aderonkeojomo772]

Thanks for inspiring me.

[@UnorthodoxChange]

It's my pleasure

[@mamt0m]

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]

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.

[@Jorsten]

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]

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

[@eparama]

Subscribed☑️ watching from Fiji

[@UnorthodoxChange]

Thanks for the sub and oooo nice nice

[@mohammadal-gebaly7028]

I am really was confused, i want to thank you about all the informations her, really really thank you ❤❤❤

[@UnorthodoxChange]

I'm glad it was valuable to you 👌🏾

[@gstar2112]

Thank you sir

[@UnorthodoxChange]

You are welcome

[@itsmeakram8481]

All doubts clear