FASTEST Way To Become a Data Analyst and ACTUALLY Get a Job
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 KZread 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 :)
Пікірлер: 421
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 😊
"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
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
You hit the nail. Starting and Not Finishing….. is the problem. I totally agree.
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
I subscribed because you’ve convinced me. I’ve wanted to be a data analyst long time but struggled how to start
The entire process is well explained. Well done sir
This video just made my day. I appreciate your honesty and willingness to share relevant information.
I’m getting into data analytics. Glad I came across your video. 😊
@UnorthodoxChange
5 ай бұрын
Thank you and good luck
Thanks for this guide! I’ll definitely take it on board
@UnorthodoxChange
6 ай бұрын
No worries at all - happy it helped you out
Thanks for the simplified information.
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.
I just started n coming across this reminds me importance of practice
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 😃
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!
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
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
Subscribed! All the way from South Africa!
@UnorthodoxChange
5 ай бұрын
Happy to have you onboard brother 👊🏾
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
Thanks for the heads up
Thank you. The whole video is great.
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
Thank you, you have a great style in conveying your thoughts & experience.
@UnorthodoxChange
5 ай бұрын
My pleasure!
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
This was an awesome video. Great resource recommendations!
@UnorthodoxChange
5 ай бұрын
Appreciate the kind words and no worries at all.
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 👌🏾👌🏾
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.
Such a sincere explanation!
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
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
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
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👍🏾
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
19 күн бұрын
You're very welcome!
Explained in a very clear and succinct way, great video!
@UnorthodoxChange
3 ай бұрын
Much appreciated :)))
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 😊
Very helpfull, not just about what to do but guiding on how.
@UnorthodoxChange
5 ай бұрын
Glad to hear it was valuable to you
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
Thank you, one of the most informational and interesing videos out 👍
@UnorthodoxChange
6 ай бұрын
Glad it was helpful!
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
13:45 value added! 🔥 love how you didn’t shove your channel in our face … dope content.
@UnorthodoxChange
Ай бұрын
Appreciate it 👊🏾
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
Great job! Keep up the good work.
@UnorthodoxChange
6 ай бұрын
Thanks, will do!
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!
INSIGHTFUL! 👏🏼 Thank you!
@UnorthodoxChange
5 ай бұрын
Glad it was helpful
Good video for aspiring data analyst and Your Clear-Cut points are awesome
@UnorthodoxChange
5 ай бұрын
Happy to hear the video provided value
Yes, I will start and finish. Thanks man.
@UnorthodoxChange
2 ай бұрын
No worries at all. Make it happen
Love the visuals 🤩👍
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
Wow ! Wow !! Wow !!!! Such an insightful Video . Thanks a million
@UnorthodoxChange
2 ай бұрын
Happy to hear the video was helpful
Data analyst turned data engineer. Everything you mentioned is spot on 💯
@UnorthodoxChange
5 ай бұрын
👌🏾👌🏾
@abhisekgupta1543
5 ай бұрын
Do you need DSA to be a data engineer
@AK-fr8sy
5 ай бұрын
@@abhisekgupta1543 what’s DSA?
@leonardezeigbo6583
4 ай бұрын
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
4 ай бұрын
@@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
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?
I will be watching this beyond data analytics lessons
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 👌🏾👌🏾
Fantastic video, well said, succinct, motivational.
@UnorthodoxChange
3 ай бұрын
I appreciate that!
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. 😊
Thank you.
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
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
Very, very helpful and friendly dude! Keep it up. I am a new follower!
@UnorthodoxChange
2 ай бұрын
Thanks a lot and happy to have you
Awesome and so easy to digest presentation.Now i am inspired .well done and thanks for this
@UnorthodoxChange
5 ай бұрын
Thanks a lot 😊
Excellent Lecture. Thanks
Back with another banger 🎉 happy new year 👊🏾
@UnorthodoxChange
6 ай бұрын
Appreciate it bro 👊🏾 and happy new year. Still waiting on yours thou 👀
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
wow! i actually watched everything, thanks bro.
@UnorthodoxChange
Ай бұрын
No worries at all.
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
You were really clear and sensible so I stayed to the end, liked, subscribed and now I am off to practice....
@UnorthodoxChange
5 ай бұрын
Welcome aboard and good luck
Good content! I love how you took your time explaining! Subscribed.
@UnorthodoxChange
5 ай бұрын
Happy to hear that you enjoyed it and great to have you onboard
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...
loved this. thank you
@UnorthodoxChange
Ай бұрын
Glad you enjoyed it!
great video man! thank you!
@UnorthodoxChange
3 ай бұрын
Thanks a lot
Thank lad, it was helpful👍👍
@UnorthodoxChange
19 күн бұрын
Glad it helped 🤗
Magnificent video 👌Cool !!! Greetings
@UnorthodoxChange
5 ай бұрын
Greetings and glad to hear the video provided value
Thank you for the information.
@UnorthodoxChange
2 ай бұрын
Any time!
Very Helpful, Thanks Man
@UnorthodoxChange
4 ай бұрын
No problem!
Thank you for this video. I believe my main problems are sql and interview.
@UnorthodoxChange
3 ай бұрын
No worries at all and all that requires is practice to get past both obstacles so you got this.
great video, thank you!
@UnorthodoxChange
2 ай бұрын
Glad you liked it!
Great resources to learn
Thanks boss for this great road map
@UnorthodoxChange
3 ай бұрын
No problem :)
Great video, thank you!
@UnorthodoxChange
6 ай бұрын
Glad you liked it!
Thanks for the vid, really did change my mind about quitting
@UnorthodoxChange
19 күн бұрын
Glad to hear it 👊🏾
Thank alot
I need a DA entry intern role (remote). I currently learning thru Coursera! Thank you!
Great video, thanks
@UnorthodoxChange
2 ай бұрын
My pleasure!
Informative content and great delivery 👍
@UnorthodoxChange
5 ай бұрын
Much appreciated!
Thanks man
I endorse this message. I will share it with all my mentees.
@UnorthodoxChange
5 ай бұрын
Much Appreciated
Keep Going My Brother
@UnorthodoxChange
5 ай бұрын
Always
Thank you for the useful info
@UnorthodoxChange
2 ай бұрын
Happy to help
Very useful, thank you
@UnorthodoxChange
5 ай бұрын
No worries at all
Thanks for sharing
@UnorthodoxChange
2 ай бұрын
My pleasure
really nice insights, my friend. thank you very much.
@UnorthodoxChange
3 ай бұрын
My pleasure!
Great video very informative and much needed advice
@UnorthodoxChange
5 ай бұрын
Appreciate the kind words
Happy I found your channel 🎉
@UnorthodoxChange
4 ай бұрын
Glad the video was valuable :)
Subscribed☑️ watching from Fiji
@UnorthodoxChange
4 ай бұрын
Thanks for the sub and oooo nice nice
I like your video man, thanks a lot. In fact, I have taken down the links. I'm so grateful.
@UnorthodoxChange
2 ай бұрын
You're welcome
Great job! Thanks for the info! I need a job 😢
@UnorthodoxChange
2 ай бұрын
Just keep working at it, put the spare time in to learn, build and apply for jobs
Great l will get to work!
Good content. Kindly do a video on building a marketable portfolio for an entry level Data Analyst
@UnorthodoxChange
19 күн бұрын
Thank you and at some point I will, but I’ll be honest probably not anytime soon. Not sure the value a portfolio video will bring to people right now
Great job.
@UnorthodoxChange
2 ай бұрын
Thanks
Good job bro! You made it super easy & engaging!😂
@UnorthodoxChange
3 ай бұрын
Happy to hear you enjoyed the video :)