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

Рет қаралды 223,515

Күн бұрын

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/
▬ Full Data Analytics Course ▬▬▬▬▬▬▬▬▬▬
Start the FREE CourseCareers Data Analyst Introduction course TODAY: coursecareers.com/a/Unorthodo...
▬ Book a Call With Me ▬▬▬▬▬▬▬▬▬▬
Mentoring sessions with me (Data/Career) - topmate.io/unorthodoxchange
▬ 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...
▬ 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 :)

Пікірлер: 426

@Saif_Khan313 6 ай бұрын

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

@ivantonny8337 5 ай бұрын

Excel is too complicated in the first place

@Saif_Khan313 5 ай бұрын

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

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

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

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

@@ivantonny8337thanks for the video😊

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

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

@ZwaneML 3 ай бұрын

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

@UnorthodoxChange 2 ай бұрын

Thanks for the kind words and 100% will do

@geekatari4391 4 ай бұрын

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 3 ай бұрын

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 SQL. It varies company to company but having a hang of a few tools (even at a beginner level) will help you the most moving forward

@jedijazzy6643 4 ай бұрын

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

@UnorthodoxChange 4 ай бұрын

Thanks for the kind words. Will ensure quality stays consistent

@normcandie 2 ай бұрын

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

@paulomorogbe2875 5 ай бұрын

The entire process is well explained. Well done sir

@benruns6151 4 ай бұрын

Thanks for the simplified information.

@chrisreisinger5002 2 ай бұрын

Thank you. The whole video is great.

@stopnprintcafe6745 2 ай бұрын

I subscribed because you’ve convinced me. I’ve wanted to be a data analyst long time but struggled how to start

@talentchikobvu-hq9hi Ай бұрын

Thanks for the heads up

@brendaortiz5055 5 ай бұрын

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 5 ай бұрын

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

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

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 2 ай бұрын

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

@courageiroro5604 6 ай бұрын

Such a sincere explanation!

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

This was an awesome video. Great resource recommendations!

@UnorthodoxChange 5 ай бұрын

Appreciate the kind words and no worries at all.

@yolandaosad3115 6 ай бұрын

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

@UnorthodoxChange 6 ай бұрын

No worries at all - happy it helped you out

@MohamedElHarras 5 ай бұрын

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

@UnorthodoxChange 5 ай бұрын

My pleasure!

@hopeful806 5 ай бұрын

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

@UnorthodoxChange 5 ай бұрын

You're very welcome

@balford2112 6 ай бұрын

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 6 ай бұрын

No worries at all and you got this!

@vonnpowell3844 5 ай бұрын

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

@UnorthodoxChange 5 ай бұрын

Thank you and good luck

@zizoh3993 4 ай бұрын

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

@erinintech 4 ай бұрын

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 3 ай бұрын

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

@AM-Boluke1210 4 ай бұрын

Love the visuals 🤩👍

@sibusisotwala6420 5 ай бұрын

Subscribed! All the way from South Africa!

@UnorthodoxChange 5 ай бұрын

Happy to have you onboard brother 👊🏾

@nadsb6170 3 ай бұрын

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 2 ай бұрын

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

@sorosfox3801 6 ай бұрын

Great job! Keep up the good work.

@UnorthodoxChange 6 ай бұрын

Thanks, will do!

@janegathiaka4490 5 ай бұрын

Very helpful information and guide to resources. Thanks, subscribed

@UnorthodoxChange 5 ай бұрын

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

@jryner 6 ай бұрын

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

@UnorthodoxChange 6 ай бұрын

Glad it was helpful!

@bushmaster75 Ай бұрын

Excellent Lecture. Thanks

@MrCologneMusic 2 ай бұрын

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

@UnorthodoxChange 2 ай бұрын

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

@thegracemarie 4 ай бұрын

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

@UnorthodoxChange 3 ай бұрын

Much appreciated :)))

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

INSIGHTFUL! 👏🏼 Thank you!

@UnorthodoxChange 5 ай бұрын

Glad it was helpful

@iamteja03 4 ай бұрын

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.

@yunekfindz 5 ай бұрын

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 5 ай бұрын

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

@abiogbebor8524 11 күн бұрын

This video just made my day. I appreciate your honesty and willingness to share relevant information.

@afcentertainmentgroup456 4 ай бұрын

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 3 ай бұрын

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

@user-ux4ct7nv3y 4 ай бұрын

Fantastic video, well said, succinct, motivational.

@UnorthodoxChange 3 ай бұрын

I appreciate that!

@beardydaddy1394 3 ай бұрын

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

@UnorthodoxChange 2 ай бұрын

Thanks a lot and happy to have you

@avwatajudith4346 5 ай бұрын

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

@UnorthodoxChange 5 ай бұрын

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

@lanesh7245 6 ай бұрын

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

@UnorthodoxChange 6 ай бұрын

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

@chloefourte3413 4 ай бұрын

great video man! thank you!

@UnorthodoxChange 3 ай бұрын

Thanks a lot

@armana1 5 ай бұрын

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

@UnorthodoxChange 5 ай бұрын

Thanks a lot 😊

@dashen2058 4 ай бұрын

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 3 ай бұрын

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

@sandykl Ай бұрын

You’re a phenomenal teacher. So clear and concise. I appreciate your calmness and patience in your presentation. Helps me understand. I’m not overwhelmed.

@UnorthodoxChange Ай бұрын

😊 happy to help

@mzuhara8182 5 ай бұрын

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

@UnorthodoxChange 5 ай бұрын

Happy to hear the video provided value

@gtgpic4679 5 ай бұрын

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

@UnorthodoxChange 5 ай бұрын

Glad to hear it was valuable to you

@lashaesworld777 6 күн бұрын

Thank you.

@ab2mak 6 ай бұрын

Back with another banger 🎉 happy new year 👊🏾

@UnorthodoxChange 6 ай бұрын

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

@sumaraFrames 2 ай бұрын

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

@UnorthodoxChange 2 ай бұрын

Happy to hear the video was helpful

@emmanuelolukayodeayedun2709 3 ай бұрын

Thank you for the information.

@UnorthodoxChange 2 ай бұрын

Any time!

@diegomuniz3578 2 ай бұрын

loved this. thank you

@UnorthodoxChange Ай бұрын

Glad you enjoyed it!

@yohannaagbanaji8012 2 ай бұрын

Yes, I will start and finish. Thanks man.

@UnorthodoxChange 2 ай бұрын

No worries at all. Make it happen

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

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

@UnorthodoxChange 3 ай бұрын

My pleasure!

@SummerTime-de3sd 3 ай бұрын

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 2 ай бұрын

No worries at all. More than happy to help

@jachikesamuelson7425 3 ай бұрын

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 2 ай бұрын

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

@adamsarwar 6 ай бұрын

Great video, thank you!

@UnorthodoxChange 6 ай бұрын

Glad you liked it!

@Hassann1 5 ай бұрын

Very Helpful, Thanks Man

@UnorthodoxChange 4 ай бұрын

No problem!

@chandlerghayes2 3 ай бұрын

Great resources to learn

@marie-vb3vg 3 ай бұрын

great video, thank you!

@UnorthodoxChange 2 ай бұрын

Glad you liked it!

@braydenbergset2236 Ай бұрын

thank you for the video, gained a lot of valuable insight into the exact questions i was looking for, spoke super clear and concise thank you!!

@UnorthodoxChange 23 күн бұрын

You're very welcome!

@bobaiyakubu5910 Ай бұрын

Thank lad, it was helpful👍👍

@UnorthodoxChange 23 күн бұрын

Glad it helped 🤗

@abdidirir3372 5 ай бұрын

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

@UnorthodoxChange 4 ай бұрын

Glad to hear this and good luck on your journey

@Gamesoldier68 2 ай бұрын

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!

@UnorthodoxChange Ай бұрын

You are so welcome and good luck with you journey

@horacioparraguirre7486 5 ай бұрын

Magnificent video 👌Cool !!! Greetings

@UnorthodoxChange 5 ай бұрын

Greetings and glad to hear the video provided value

@VinnyDrones 5 ай бұрын

Informative content and great delivery 👍

@UnorthodoxChange 5 ай бұрын

Much appreciated!

@BikramGC-xo1vm 2 ай бұрын

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.

@UnorthodoxChange Ай бұрын

All the best

@tess1136 2 ай бұрын

Thank you for the useful info

@UnorthodoxChange 2 ай бұрын

Happy to help

@kristiandoychev2449 3 ай бұрын

Great video, thanks

@UnorthodoxChange 2 ай бұрын

My pleasure!

@FauziFayyad 2 ай бұрын

Thanks man

@Fuldn 6 ай бұрын

Great video very informative and much needed advice

@UnorthodoxChange 6 ай бұрын

Appreciate the kind words

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

Very useful, thank you

@UnorthodoxChange 5 ай бұрын

No worries at all

@OjJerry 6 күн бұрын

Thank alot

@jimiikomi573 4 ай бұрын

Thanks boss for this great road map

@UnorthodoxChange 3 ай бұрын

No problem :)

@ebenezersam788 3 ай бұрын

Thanks for sharing

@UnorthodoxChange 2 ай бұрын

My pleasure

@rurbleburble 3 ай бұрын

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 2 ай бұрын

You are welcome!

@RawShogun 3 ай бұрын

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

@UnorthodoxChange 2 ай бұрын

Amazing journey 👌🏾👌🏾

@mizzemotionz4074 5 ай бұрын

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 5 ай бұрын

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 5 ай бұрын

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

@austinbobmanuel4065 3 ай бұрын

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 2 ай бұрын

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

@Abir.laib232 4 ай бұрын

Thank you

@mayowaomoniyi6420 Ай бұрын

wow! i actually watched everything, thanks bro.

@UnorthodoxChange Ай бұрын

No worries at all.

@cnowledge 2 ай бұрын

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

@UnorthodoxChange Ай бұрын

Appreciate it 👊🏾

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

Subscribed ❤

@motunrolaibok2974 2 ай бұрын

Just stumbled on your video and you got me. I am new to data analysis, started my journey less than 2 weeks ago.

@234bellamkonda Ай бұрын

Me too

@234bellamkonda Ай бұрын

Hows your journey going on?

@angelamorgan3399 2 ай бұрын

Great job.

@UnorthodoxChange 2 ай бұрын

Thanks

@EnVideoZone 6 ай бұрын

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

@UnorthodoxChange 6 ай бұрын

Welcome aboard and good luck

@jopadfoot 3 ай бұрын

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 2 ай бұрын

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

@PeterOlubayo-VisaPathfinders 3 ай бұрын

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

@UnorthodoxChange 3 ай бұрын

Happy to hear you enjoyed the video :)

@LukeBarousse 6 ай бұрын

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

@UnorthodoxChange 5 ай бұрын

No worries Luke - Keep up the great videos

@killersongs7906 5 ай бұрын

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

@ck1583 2 ай бұрын

Great l will get to work!

@ddp2049 5 ай бұрын

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

@UnorthodoxChange 5 ай бұрын

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

@audreya3127 3 ай бұрын

Thank you 🙏🏾

@UnorthodoxChange 2 ай бұрын

No problem 😊

@aderonkeojomo772 5 ай бұрын

Thanks for inspiring me.

@UnorthodoxChange 4 ай бұрын

It's my pleasure

@eparama 4 ай бұрын

Subscribed☑️ watching from Fiji

@UnorthodoxChange 4 ай бұрын

Thanks for the sub and oooo nice nice

@sbrady1068 4 ай бұрын

Thank you brother 💪

@UnorthodoxChange 4 ай бұрын

No problem at all

@mwasgophul1813 5 ай бұрын

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 5 ай бұрын

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