Roadmap on how to become a Data Analyst in 2024
ฝัง
- เผยแพร่เมื่อ 7 มิ.ย. 2024
- 00:00 - Intro
The video is divided into 3 parts
00:25 Skills Required to Be a Data Analyst
06:31 Applying for a Data Analyst Job and How to crack the interview
08:47 Things to do in the first few months of your new job
Part 1: Skills Required to be a Data Analyst
00:30 SQL
01:45 Microsft Excel
03:00 Data Visualization Tool
04:00 Soft Skills
Part 2 Cracking the Interview and Applying for a Data Analyst Job
06:35 Building a Data Analyst Resume
06:58 Applying for a particular company
07:36 Mock Interviews
08:05 Actual Interview Prep
Part 3: Things to do in the first few months of your new job
08:58 Schedule a call with Teammates and Manager, look for training and documentation
09:28 Schedule a call with your Stakeholder to Learn about them and their current problems
09:57 Asking questions to learn as much as you can to be successful at your job.
10:30 Learn the life of the data at your company.
#data #dataanalytics #dataanalyst
Flexispot Stand-up Desk - amzn.to/3SwI9kp
Staples Chair - www.staples.com/staples-carde...
Samsung Odessey 49inch Monitor- amzn.to/3SPzF9G
Keychron K6 - amzn.to/3UCeh9f
Logitech MX Anywhere mouse - amzn.to/3HVhxog
BenQ Monitor light - amzn.to/49qVsdi
Logitech 4K webcam - amzn.to/42tG8Km
Apple HomePod - www.apple.com/shop/buy-homepo...
Apple AirPods Max - amzn.to/3SOllxT
Dell Docking Station - amzn.to/3OuUHYE
Table light- amzn.to/3UvDLVG
Desk Mat - amzn.to/48nxZc5
To-Do Cards and Stand - amzn.to/482n7jy
Laptop Stand - amzn.to/49ns8nO
Ikea Bed Side table - www.ikea.com/us/en/p/malm-2-d...
Disclaimer: This is based on my research and experience, please do your research as well. - วิทยาศาสตร์และเทคโนโลยี
How to collect the data for data cleaning
Give me suggestions for collect data where we can used them for analysis as well as cleaning
Hi, brother! Can you make a video in which you would talk individually about what things to cover in these different technical tools?
Sure, I will be making a video soon.
Sir i am form non tech background its hurdle to get job in data analytics??
Nyc
Thank you
Can you send me the source to learn Excel
💯
Bro , my one question is if I skilled myself without skill certification, than will my resume considered on real time project basis skill for companies?
good question, and yes that should be okay, mention the projects that you gained the skills from.
Hi Ashwani ,this roadmap looks super useful .Thank you for this! I have a question to ask .Can I start freelancing in data analysis without any job experience ? I want to learn data analysis to work as a freelancer, I don't to go for jobs 😫
Yes, you can start freelancing but it will be little difficult.
1. Learn the Basics: Understand statistical concepts and tools like Excel, SQL, Python, or R.
2. Build a Portfolio: Create projects using publicly available datasets.
3. Market Yourself & do Networking
4. Begin with smaller projects to gain experience and build your reputation.
6. Stay updated with the latest trends and tools in data analysis and learn.
Yes he is right. I will do the same 🎉
I am a data analyst with almost 2 years experience but I struggle while implementing logic and write SQL query for my business use case at work how can I improve my SQL to fix this.
No worries, Check out this video on my channel to learn and enhance your SQL skills. Subscribe to channel if you like it.
How to learn SQL in 5 Simple Steps #data #sql #learning
th-cam.com/video/3-we_O0v6UM/w-d-xo.html
I am from Michigan, Ann Arbor
Awesome!
Hi Ashwani, I am an Arts Student (Geography Hons), Can I get a data analyst from this field? I have done IBM data Analyst certificate.
Hi, yes you can get in the field of data Analytics, since you have done IBM certification I would recommend doing some projects which you can put on your resume.
Gonna start with data analytics coz no jobs for data engg fresher 😞....
I think the smartest move is to get into analyst then move to data engg in 1 or 2 year
I am not entirely sure about the job market in your location but there should be entry-level data engineering jobs.
Before you apply for your next job work on your resume, and make sure it is ATS friendly. Add key works and make sure you're adding relevant experience. Also if possible get job references. Let me know if you have any questions.
Subscribe and share the video with your friends
Thank you,
Ashwani
@tomaraditya9487 hello bro data analyst job market is like that only I think that job market will be recover soon
@@GagandeepSingh-vd9hd you're right but i see a lot more opening for freshers in data analyst than DE....
Recently EY, IDFC bank, Deloitte, and many more had opening for freshers analysts but for data engineering... only senior level roles are available
Hello. I finished my 12th std now I'm confuse what to choose bsc CS or bsc DS . Can you suggest tell me which is better or which has scope in future
Hi, it totally depends on your interest. if you want to specialize in the field of Data Science then go with Bsc DS else go with CS. Data science is going to be huge in the future. Try doing some basic certification to explore your interest before you enroll full-time in a course.
Is python needed for data analyst ?
yes, to be a good data analyst who stands out you need to know Python.
Hi Sir, I have graduated in 2019 from mechanical engineering branch - I have 2 years of experience in my Core industry after that I made a transation into IT industry as a Front end devloper with 1.5 years of experience but after that I took break for government exam preparation but it didn't worked according to plan,I have 1 year of employment gap now, Can I get a job in data analytics?
Hi, yes you can get a job in Data Analytics if you have basic data analytics skills. I recommend doing a couple of projects and getting a certification.
Thank you.
@@AshInTechThank you sir
Hi sir i am commerce background. Can i go for data analytics or
Yes, definitely
Can i do diploma in data analyst after 12th commerce ?
you can definitely do a certification.
let me know if you have any questions. Like and Subscribe
Where do u work ? I didn't get u in LinkedIn?
You should be able to find me using my name Ashwani Panwar
sir is AI is going to take jobs of data analyst
AI will definitely replace jobs but if you are the best person in your field and you are learning new skills then you will be okay.
@@AshInTechwhat are the new skills that an aspiring data analyst needs to be upskilling in this era?
dandwat parnaam sir g
Hi @MHb789 , sure, you do need to know Sql, python, data visualization tool, Statistics and AI-ML.
Are bhai nahe legi job ai help karne aaya hai oata nahi tumlog kyu darte ho...
Can you make a detailed resume video for data analyst role
Definitely, I will be making a video about that soon.
Is there any years gap problem?
A gap year should not be a big issue, do a project and show that.
How can I learn sql?
here is the video covering step by step instructions on how to learn SQL
th-cam.com/video/3-we_O0v6UM/w-d-xo.html
Posted today, like and subscribe. Thank you
I am 2 nd year student please suggest me a good roadmap to became a data analyst
Hi @sumitagarwal9080 I covered all the points in my video but check below for your reference-
1. Determine your skillset: Like your SQL and Python.
2. if you don't have experience in SQL, or Python then work on learning them. Take a course or watch a tutorial on TH-cam.
3. Work on learning powerBI or Tableau. Since you are a student, you should be able to download and access Tableau for free. Use the test dataset to create reports.
4. Work on your communication skills.
5. Work on several projects to add to your resume.
6. Apply for internships in your 2nd year and 3rd year vacation.
7. Prep for the Interview by solving leetcode questions and giving Mock interviews.
8. Apply for Jobs.
Let me know if you have any other questions. Subscribe and share the video with your friends.
Thank you,
Ashwani
Could you please tell me that what topics in the python should we learn. What are most used topics in the python like everyone say learn python but nobody tells what topics should we go for?
@@AshInTech thanku sir for your suggestion nd tips
Hi @procap1028 before we deep into python make sure your basics about the language are clear.
Second: you need to understand how to manipulate data in python-
learn the use of libraries like NumPy and Panda.
Third: you need to know data visualization using python-
learn the use of libraries like Seaborn, Matplotlib
For AI and ML learn Tensorflow.
www.tensorflow.org/tutorials
pypi.org/project/pandas/
seaborn.pydata.org/
numpy.org/
matplotlib.org/
and to be expert, just find a test dataset and use python to clean it, put some visuals, this way you will learn more.
Let me know if you have any more questions.
Subscribe and share the video
Thank you & kind regards,
Ashwani
@@AshInTech Dil se shukriya bhai 🫶, I have already subscribed to you✅
Where are you from
USA
@@AshInTech I am also from the USA, so I have a question Are there scope and opportunities to be a data analyst?
Yes, there is plenty of scope for the data analyst. A lot of future jobs are going to be related to data.
Sir...
I'm a student and I am doing BCA . So from where I have to start?
Hi, this video covers all the points and steps that you need to know to become a data analyst. Start from SQL.
@@AshInTech Sir, when I have to learn about Excel?
@@akanksha8745 good question, sql excel, python and data visualization tool are the building blocks
@@AshInTech Ok thank you sir so I have to start from learning SQL
Yes
English language not understanding please try Hindi
bilkul, mein hindi mein banounga video. thank you