How I Would Become a Data Analyst if I had to Start Over in 2024 | 6 Month Plan
Вставка
- Опубліковано 25 гру 2023
- If I had to start over here are the exact steps I would take to become a Data Analyst again!
Analyst Builder Courses: www.analystbuilder.com/courses
Analyst Builder Technical Questions: www.analystbuilder.com/questions
Work with a Recruiter Video: • How to Work with Recru...
Coursera Courses:
Google Data Analyst Certification: coursera.pxf.io/5bBd62
Data Analysis with Python - coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
Python for Data Science - bit.ly/3Z4A5K6
Statistics for Data Science - bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
Tableau A-Z - bit.ly/385lYvN
____________________________________________
RESOURCES:
💻Analyst Builder - www.analystbuilder.com/
📖Take my Full MySQL Course Here: bit.ly/3tqOipr
📖Take my Full Python Course Here: bit.ly/48O581R
📖Practice Technical Interview Questions: bit.ly/46pDqqL
Coursera Courses:
Google Data Analyst Certification: coursera.pxf.io/5bBd62
Data Analysis with Python - coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
Python for Data Science - bit.ly/3Z4A5K6
Statistics for Data Science - bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
BECOME A MEMBER -
Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!
/ @alextheanalyst
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: github.com/AlexTheAnalyst
📱Instagram: @Alex_The_Analyst
____________________________________________
All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for
Summary:
1. Learn Excel, SQL, Tableau or any BI tool and all of these should take around 2 months to learn
2. Do projects on those (2 on SQL, 1 on Excel and 1/2 on Tableau)
3. Build a resume and add projects and skills on the resume
4. Work with a recruiter to get job or to maximize your chance to get interviewed
5. Prepare for both general and technical interviews (tech interviews are mostly on SQL)
6. Lean any Cloud platform and AI if you have more time
What about python
@@aravindalapati5349 Obviously, you can learn many more things as you go but Alex just suggested the tools and skills that can take you to your 1st job as soon as possible.
Thanks, I always understood cql and was really wondering what he is talking about.
Excel, SQL, Tableau or any BI tool in 2 months???? 😂😂😂 funniest thing I've ever heard.
@@speedymr why?
Hello Alex, thank you for all you're doing for the newbies in the data analytics community.
I want to become a data analyst and I've started following tutorials on your channel, especially your 70 videos data analytics bootcamp.
I'm really committed to learning and practicing as much as I can believe before the end of 2024, I will land a role as a data analyst.
I'll come back to quote this comment when I finally land a job.
To everyone who is starting the journey to become a data analyst in 2024, I wish us all good success.
Once again, thank you Alex
I'm rooting for you 💪🏾
Wishing you the best brother. Can we connect? I need an accountable partner in this journey
@@funshoiimam6342 yes brother we can connect. I also need an accountability partner. Are you on Twitter (X)?
@@funshoiimam6342
great idea bro if we could connect it will be a good idea to keep sharing some few stuff
Where you based? I want to do the same.
This video was needed with the new year around the corner and with people thinking about their resolutions
Hello Alex,
I cannot thank you enough for these videos here. Before 5-6 months i was just wondering about Data Analyst job, and started practicing excel and sql with these guides. At that time i was teacher of economics in high school in Serbia, and wasn't satisfied with that. One month ago I've landed a Data Analyst job, and guess what, i'm just starded. I want to learn python and dive into machine learning it's really interesting for me and drives me. Thank you a lot mate. Best regards from Serbia. 👋🇷🇸
Hi can we connect just started my journey in as a data analyst today and I'm really looking for someone to work with I'm based in Cameroon
can you tell what you've learned and how during these 5 months ?
Yes me tooo....Buddy how can we connect....@@anelkasmith5731
Cestitkeee brateeee💪🏼💪🏼💪🏼
1. Research what an analyst does
2. Research the skills : SQL, Excel, Tableau to start. Learn more later.
3. UA-cam University is free. Udemy, Coursera, and *Analyst Builder* for more in depth learning.
4. Create portfolio and projects
5. Create resume
6. Work with a recruiter(s)- better tactic than just submitting many resumes
7. Nail interview and get the job!
The way Alex words things and explains things really just clicks with my brain.
I would love a resume building video that has examples for both the newer individuals to the work force in general, but also for people who are trying to make a career shift after 10yrs of work experience and seeing how to make your previous work still support your career shift. Especially what kind of transferable skills might be worth highlighting.
Thank you Mr. Alex I started following you more than a year ago and I am learning a lot and a lot from you and the most amazing thing is that my English has become very strong by watching and learning from you it's great to develop in many ways by Education, watching and training
but I have a request from you to have a pdf file It includes a roadmap and video links to become a data analyst that you all love and appreciate
i just finished my marketing degree which gave me some exposure to business analytics. im gonna persue that route and this video really helped me with guidance. thank you and i hope we all get our future analytics jobs and self actualise!
Appreciate you making a video about this Alex!
It's been 4 months and I've completed the courses/Projects for PowerBI, Excel, Tableau as well as the Coursera Google Data Analyst Certification.
I'm on a week vacation and I was overthinking and wondering what I should be doing next and this gave me some direction on where to go. Finishing up my portfolio/ resume page and the SQL questions next!
hi jeremy ,how did u find the online projects?
Thank you Alex. Great insights. Woke me up to the need to polish up my SQL.
I started to learn data analytics tools from your chanel and right now i have gained a lot of knowledge like excel,power bi,sql,python.thank you so much ❤️
Thank you for everything you're doing for the community Alex! Im tapped in and will become a data analyst in the next 6 months.
You can do it!
@@AlexTheAnalystI believe I can too with your help
Hi Alex, thanks for the video. It helps to visualize the pathway to start becoming a data analyst. Cheers to you!
Amazing video. I’ve used Power Bi, Python and R and I feel like I need to go back and refresh. This was so needed. Thanks mate.
Oh my! I'm actually trying a change in career, going from the Army to Data Analytics and your channel appearing in my recommended list is just amazing! I'm taking the Google Data Analytics (beginner) and was a little bit confused to where to go after it.
I'm gonna 100% take a look at some of your courses! Thank you, Alex!
This helps me a lot. For someone who wanted to change my carreer, this is a great help. Thank you!
Thank you so much for this video. I was getting frustrated for several days now I feel relaxed.
I'm glad I found this video. I was very confused and trying multiple things together but now I know what to do.
Alex, thanks for that insightful brief on sharpening a career as a Data Analyst
Thank you Alex! I am seeking to transition from technical support roles into data analyst roles. I am going to follow your suggested path of learning SQL and Tableau. I have Excel on my resume already but I need to brush up and create some projects. Thank you very much for these tips!
Loved it !! Thank you ❤
thank you very much for sharing Alex!
God bless you Alex. I have learnt a lot from your channel
Great video. Thanks Alex!
Thank you, Alex. This is detailed
Hello Alex : Thank you very much, you have made it easy for me to learn the next steps. You have given me a path. I have watched a lot of playlists on your channel. Thank you so much
You are the best mentor I could ever ask for.
Great video... simple and straight to the point
Thank you so much Alex for this. 😊
Thanks Alex for well delivered great info.
Alex thanks alot for this video, i have been having difficulty with where to start my learning from. Thanks again
I needed this. Thank you so much
Merry Christmas Alex 🎄 🎄 🎄 🎉🎉🎉
Thank you so much Sir Alex your video inspired me and encouraged me to keep tte candles light
I appreciate your Idea to help with learning The Data Analyst.
❤Alex you are wonderfully made, thanks for this video
Thank you. Liked and subscribed. 😊
Amazing, As always
Thank you for this video. I just bought bundle course on Analyst Builder.What a beautiful way to prepare for 2024!
Nice I will start mine this Jan 2024
GREAT THANKS VERY CLEAR AND INFORMATIVE VIDEO. APPRECIATE IT ALL.
Thanks Alex!
Thank you Alex, just what I am looking for.
A friend recommended me here and I'm ready, focused to take this opportunity and make it a success. 2024 is a good year and i will stay focused on learning data analytics
Thank you Alex....
Thank you Mr Alex for your great work.... please I just get to know about data analytics and I am interested in learning more about it,a beginner....I hope i am able to learn more on your channel.
Hi Alex, I am planning to become a data analyst within the next one year. I am learning Python and R at the moment. I intend to learn SQL, Tableau and power BI as well. I must confess I feel quite overwhelmed sometimes as it feels like there is a lot to learn but I want to keep working at it. I will work through your videos on the data analytics bootcamp. Thank you very much for making many fulfilled across the world
Thank you so much for your tutorial
So good idea to teach the Data Analyst sir.
A Portfolio is something I had never thought of after Graduating. Having a place to showcase my skills has not only been a gamechanger, but has been a way to help boost my own confidence within the Data World. 😁
somehow this video very related to my condition and situation at the moment, unless that "amnesia" for sure 😆 thanks for givning best tips, Alex!
thank you so much alex for the amazing 70 video data analytics course .
Please how can I access the 70 videos data analysis courses
@@akinwaleidayat4083ua-cam.com/play/PLUaB-1hjhk8FE_XZ87vPPSfHqb6OcM0cF.html&si=wY6EwZy610DVe-HU
@@akinwaleidayat4083 THERE IS A PLAYIST ON HIS CHANNEL
Since I saw you last year, I’ve completed the Google Data Analytics Certificate, and I am on the capstone for the Advanced Certificate. First education I’ve completed, hopefully I can get it together to become fluent enough to pass interviews. They were difficult for me to retain enough to pass with aid, but maybe now a second pass will bring me where I need to be.
So how has it been going?
Alright, it's 2024. Let's do this!!!
Thank you Alex for being an inspiration for me as I begin my journey to becoming a data analyst.
I also want to learn data analysis, can we do this together?
Like this video was done for me... Thanks alot
Hey Alex, thanks so much for your vids. Learned so much so far but still scratching the surface. Any thoughts on data analytics skills for specific industries? Healthcare for instance?
Thanks😊
Thank you Alex
Thank you so much for providing such a wealth of resources. I've already signed up for the website and I'm really excited to dive into hands-on projects for SQL and Python. Rest assured, I won't disappoint you!
❤❤❤Thank you !❤❤❤
Thanks for the video and information I’ve been thinking about data analytics for a wile I work as a pre school teacher and looking for a different career path I have no experience in data analytics and just started the google data analytics certification course .
Amnesia Alex is going to love it when he finds a library!
Good video thank you Alex but I started to learn Python them I will learn SQL, Excel and Power Bi or Tablue not sure yet I think python can do all of it and the automation too
Heyyyy your back!!!😅❤
Hi alex! your content is very helpful, and i am waiting for you data analyst using macbook.. coz my blocker right now is using mac... very excited ur upcoming data analyst using macbook! Thank you and Merry Christmas 🎄
Thank you for all your videos, I love your channel. If I may ask you a question please:
As a Non-Tech backgroup professional who wanna do career shift, what is fast/better to get job as data scientist/ analyst? Get bachelor (BS) in analytics or BS in CS with analysts courses/certificates or BS in business administration with CIS/MIS?
Hello Alex happy new year to you and your family i want ask a question those prices on your courses on promo is it for one year duration or for a month i am talking about 4 and 6 courses bundles .
This is exactly the video I was looking for. One question though: What resources do you use to keep up with changes in the industry?
please which laptop do you recommend for someone about to learn or start data science ?
Im gonna leave this here to look back to when i make it.
By july this year. I will have mastered excel, sql, tableau l and python. By the end of this year i will have landed a data analytics role. By the end of 2 years i will be will be a data scientist. Help me God 🙏🏾
Hi Alex. Understand the advantage of joining your analystbuilder is the practice of Technical question. But you also sell just the courses (without the technical questions). May I know how is the courses at analystbuilder different from the bootcamp at your youtube channel?
How about replacing tableau with python dashboards and reports? and having excel but having python alongside it?
i am very new to data analytics. thanks for the video. my 2024 number 1 goal is to learn data analytics.
You on now?
Do Data Analysts work typically alone? Like other than interacting with Data Scientists and stuff?
I’m a Developer and I’m used to working with other devs, so I’m a bit scared about having to work all alone
Its been few weeks since I have started Learning R and I find it interesting but a lot people are pushing me to go for. Python what do you suggest on this?
Hello there ,
So I got data analysis and visualization using power BI nano degree from udacity. If I want to build up from there, what do u think I should do ?
Even if I have to get some affordable courses.
Thanks 🙏
Hey Alex, can you please recommend a good Python DSA course ?
We all gotta nail those DSA interviews for jobs
I know there are 1000+ DSA courses out there but rare any is in Python or just not up to par.
Any recommendations please ?
Thanks for the video. You briefly mentioned verticals like finance or healthcare. I don't think you've done a video on verticals. Would you be able to? 😊
Well you did one on the healthcare vertical, here: ua-cam.com/video/V8TRt-2A0_4/v-deo.html 🙂
if someone is want to become a data analyst after a 6 year of gap, what he/she will do?is it possible?
I’ve heard you and many other experts say “build projects” … can you expand on what that actually means?
Serious question. I’m starting to look more and more into this career pathway. I have no college degree but I’m willing to learn and put in the work. Is it realistic of me getting a job with no degree? Any advice would be greatly appreciated
Thank you for this video, i have learnt data science for beginners, i jump into digital marketing, I'm also doing project management, and i want to come back to data science, hope I'm in the right track?
Hi Alex, I'm working on Discoverant, I hope u know about Discoverant. Is there any tips which u can provide me for my growth?
Thanks for the video. Looking for a data analyst role. I am a Sr Data Engineer with 25 years SQL experience, MS in data science, proficient in python. Will check out Analyst Builder.
@AlexTheAnalyst how long would you estimate it takes to learn those basics (SQL, Excel, Tableau) for someone working full-time ~52 hours a week? The 2 month goal mentioned would be a bit lofty 😊
I started to learn in the weekends (I work 4x8 hours a week), 5 hours two times, Saturday and Sunday. You can cut your costs and you don't have to work so much. Less work = more time to learn. 2 month is only achieveable if you learn EVERY DAY 8 HOURS. I will take 1 month "holiday" from my workplace and in this 1 month I gonna try learn as much as I can. I am 1/3 way in SQL, Excel is done, Tableau/Power BI will be a cake after SQL. In this one month I try to do my portfolio in Linkedin, also some project work.
Good Luck for us! :)
I learn 10 hrs during weekends. Early morning 5hrs then evenings 5hrs
@@tranceformeeer would you mind sharing what you used to learn sql and excel? Thanks so much
I will begin this tomorrow and see if i get a work in a year because i work 7h of work so i have a bit less of time to study
Could you tell me in which way becoming a data analyst differs to a becoming a data scientist?
I agree that the skills are essential but Alex omits the requirement to have a network of people who can speak about your work as a data analyst and even more important is domain knowledge. Interview 1 : Interviewer : ‘Looks great, just give us four names of people you have worked with in data analysis and give us examples of projects from work where you implemented (insert company’s domain here) using SQL, PowerBi, Python and Excel.
Hi. Thank you for the information. Do we need to have a Bachelor Degree first to become a Data Analyst?
Do you have a dedicated video for how to create a portfolio in a particular platform?
I agree with the skills you named in this video to be needed in the jobs, but I see a lot of people who are graduated with computer science degrees, or studied data science in bootcamps and now all of us are applying for the same jobs. Although in reality maybe the job needs only Excel and SQL, I feel like in the competition with those guys we have no chance with only the skills you mentioned.
I speak from experience. I believe his view is flawed. The technical interviews that I have had for data analyst positions are lengthy. I had a good resume with projects in excel and SQL. Had an interview and got all the technical questions right yet didn't move to the next round. Reached out to find out why and they told me they were wanting someone with more experience.
Alex, can you tell me what would be different in health? I work in a health department (finance role, not actual health role) but figure it’d make sense to transition to data analytics in the field I’ve been in.
What would be different in the ‘how to get there?’
You need to learn how to work with “people” data. It’s important to know some basic health/public health terms and calculations. So things like a rate/100,000, mortality rate, incidence rate, how handle blanks (this is not the same as with other types of data). Also familiarize yourself with demographic data, like census data. Too many can’t distinguish between White and White non-Hispanic/Hispanic, these are key to many public health programs.
An Epi curve is a must, it’s really just a time series of cases but too many don’t know what/how to do this.
I'm planning to change my career to this
Hey sir
This video is really helpful for me as I am thinking for majoring big data analytics in the near future it cleared all my doubts and every question I had
Also I would really need your help here as in is there any community of data scientists or like a discord server or something like that where I can meet experienced and skilled data analyst like you and have a good talk about the topic.
Thank you!!
I just purchased the excel course and I’m looking for the files to go along with the tutorials, did I miss something l? Especially for the project or am I supposed to create my own files?
All files are in the course in the resources tab in each lesson :)
But some said now it is the era of MLops rather than data science. unless you have all required skills in MLops it is very difficult to be hired. what do you say?
Hello Alex, firstly: I would like to say thank you so much for your share about how to become DA in fastest way.
secondly: I am really wanting to become a Data Engineer, could you share with me the way to become a Data Engineer in a fastest way, what I would to study. Thank you so much for your help.
I wish you with health and success.
Hey alex please make a playlist with azure devops as well
İ've started today , let's see next 6 months what'll happen
How are u doing?
Tell us how you're doing bro
Yes bro tell us
I'm starting today, bro! After 6 months i'll back here too.
First view and comment ❤
Hello everyone…What would you recommend for a beginner data analyst or cybersecurity to go into? Which pays more and is more marketable?