7.5 Things I Wish I Knew Before Becoming a Data Analyst

In this video I go over everything I wish I knew before becoming a data analyst which will include some parts of how I'd learn data analysis again if I could start over alongside key tips and tricks to aspiring and new entering data analysts.
▬ Contents Of This Video ▬▬▬▬▬▬▬▬▬▬
00:00 - Intro
00:43 - You Will Stay In Tutorial Hell Until You Start Building
04:18 - Learn Python Specifically For Data Analysis Anything Else Is A Bonus
06:58 - Learn To Like Meetings. You're Going To Need To Sit In On Many Of Them
08:31 - The Internet Is Your Best Friend Use It
10:40 - Excel Is More Important Than You Think
12:01 - Documentation Might Be Boring, But It Needs To Be Done
12:49 - The Internet Is Also Where You Will Find Datasets To Start Your Practice
13:30 - Your Mindset Is Core To Be A Successful Data Analyst
▬ Resources ▬▬▬▬▬▬▬▬▬▬
Kaggle Datasets: www.kaggle.com/datasets
GitHub Datasets: github.com/search?q=datasets&...
FiveThirtyEight Datasets: data.fivethirtyeight.com/
▬ Courses ▬▬▬▬▬▬▬▬▬▬
1) Good For SQL - www.w3schools.com/
2) Good For Python - www.datacamp.com/
3) Good for Overall Data analysis (including Power BI & Tableau) - bit.ly/3XsCU5Z
4) Google Data Analytics Professional Certificate - bit.ly/3Xp7H3t
5) Official Power BI Certificate - learn.microsoft.com/en-us/cer...
▬ 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
Please note I may earn a small commission from some of these links - thanks for helping out
Thanks for Watching :)

[@EnVideoZone]

.... Yea, I am following you all over the place. I am growing with real-world data and you are making sense!

[@johnsonobioma3463]

You will stay in tutorial hell until you start building. I can relate to this. Thanks for this awesome video

[@UnorthodoxChange]

Glad it was helpful!

[@ZwaneML]

I'll revisit this video a couple of times. It is loaded. Thank you.

[@UnorthodoxChange]

Yeah a lot of information in this one deffo one to keep in a list or just take down the key points as notes

[@honeyshamotiani5438]

Great video!

[@UnorthodoxChange]

Glad you enjoyed it

[@honeyshamotiani5438]

Please add englist titles in video we are from different regions and we all have different accent

[@UnorthodoxChange]

Will potentially try this in the future. Thanks.

[@jacksonmcintire3813]

Loved this video, thanks man. I'd love to know more about exactly how you use python for work with examples and how you'd recommend learning it specifically for data analysis?

[@UnorthodoxChange]

Thanks for the kind words. A great place to practice python for data analysis free of charge for the most part is using datacamp (I've added a link in the description). The most often use cases is for more advanced data analysis work like predictive analysis piece of work (so example linear regression and time forecasting) which also starts to seep into the data science role. However most often as an analyst you will use it to make your life easier interacting with csv files, spreadsheets and sometimes databases to do repeatable work via scripts you write using relevant data science libraries pandas matplotlib etc. Hope this provides some insight.

[@yoahkjett10]

Hello. Do you do mentoring? Im currently taking the IBM data analyst professional certificate.

[@UnorthodoxChange]

Will start mentoring in the new year just watch this space.

[@vishalgoswami7512]

hey I have been learning data analyst for a long time and now I am practicing excel, sql and then I am gonna revise the tableau. then i am gonna build the project to add it on my resume Ii am leaving Python for now cus many of them said I don't need Python a a beginner I can learn it m after. what do you say?

[@UnorthodoxChange]

While its true you shouldn’t need python as a beginner and if I’m being completely honest wont have to use it as much as SQL, a BI tool or Excel for most roles with the current job market being horrible you want to showcase as much skill as possible to separate yourself from others (making it easier to get a job) so learn the others as a priority but deffo make sure python is included somewhere on your roadmap so you can at least be aware of the libraries used etc when potentially questioned in your interviews. Good luck 👌🏾

[@VAIBHAVMALHOTRA19]

Hi there I want to get into an entry level job. I am at my last semester of btech cse but I don’t have any skills of data except some basics of python and using some of the functions of numpy, pandas, matplotlib and seaborn. Now I am more interested in excel and power bi so I want to know how much skills I require to get a job. My semester exams wil come after 4 months and I need to prepare for it as well. Good thing is the syllabus is small. I hope you give me some tips. Thanks.

[@UnorthodoxChange]

If you go through the courses mentioned specifically for Power BI and Excel they can provide the help you need but you also need to factor in SQL as its very important as a data analyst. Use the resources mentioned plus other provided by other creators and you should be well equipped in terms of what you need to learn. Hope this helps

[@santiagobardelli5675]

I like your videos sir, I am subscripted now...

[@UnorthodoxChange]

Welcome aboard and thanks a lot