Roadmap on how to become a Data Analyst in 2024
HTML-код
- Опубликовано: 25 июн 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. 
Наука
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.
Nyc
Thank you
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
Hi Ashwani bhaiya, currently I am in my 2nd year pursuing an online degree in DS, I have almost covered most of the skills required for data analyst role, I have also done projects on SQL and Power BI currently doing an unpaid internship. I really want to apply for analyst jobs right now as I can manage both my college and jobs. Are there chances of me getting hired and could u give me few tips how to apply for these jobs if I have no degree.
I am from Michigan, Ann Arbor
Awesome!
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
ruclips.net/video/3-we_O0v6UM/видео.html
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.
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
Sorry for delayed response.
Here are several websites where you can find free datasets to practice and improve your data analysis skills:
1. **Kaggle**:
- **URL**: [Kaggle Datasets](www.kaggle.com/datasets)
- **Description**: Kaggle offers a vast collection of datasets across various domains. You can also participate in competitions and see how others approach data analysis problems.
2. **UCI Machine Learning Repository**:
- **URL**: [UCI Machine Learning Repository](archive.ics.uci.edu/ml/index.php)
- **Description**: A popular source for machine learning datasets, ranging from small, clean datasets to larger, more complex ones.
3. **Google Dataset Search**:
- **URL**: [Google Dataset Search](datasetsearch.research.google.com/)
- **Description**: A tool that helps you find datasets stored across the web, covering a wide range of topics.
4. **data.gov**:
- **URL**: [data.gov](www.data.gov/)
- **Description**: The U.S. government’s open data portal offers datasets on a variety of topics, including agriculture, education, energy, and more.
5. **FiveThirtyEight**:
- **URL**: [FiveThirtyEight Data](data.fivethirtyeight.com/)
- **Description**: Datasets used in FiveThirtyEight’s data journalism articles, covering topics like politics, sports, science, and economics.
6. **World Bank Open Data**:
- **URL**: [World Bank Open Data](data.worldbank.org/)
- **Description**: Provides access to global development data, including economic indicators, population statistics, and environmental metrics.
7. **Awesome Public Datasets**:
- **URL**: [Awesome Public Datasets GitHub](github.com/awesomedata/awesome-public-datasets)
- **Description**: A GitHub repository with a curated list of high-quality public datasets, organized by category.
8. **The European Union Open Data Portal**:
- **URL**: [European Union Open Data Portal](data.europa.eu/euodp/en/home)
- **Description**: Offers datasets published by EU institutions and other bodies, covering various sectors.
9. **UNdata**:
- **URL**: [UNdata](data.un.org/)
- **Description**: Provides a wide range of datasets from the United Nations on global issues such as health, education, and economic development.
10. **IMDb Datasets**:
- **URL**: [IMDb Datasets](www.imdb.com/interfaces/)
- **Description**: Contains data related to movies, TV shows, and other content from the IMDb database.
### Tips for Using These Datasets:
1. **Read the Documentation**: Understanding the context and structure of the dataset is crucial for effective analysis.
2. **Start with Small Projects**: Begin with smaller datasets and simpler analyses to build your confidence.
3. **Experiment with Different Tools**: Use various tools and libraries (e.g., SQL, Python, R) to analyze the data.
4. **Join Communities**: Engage with communities like Kaggle or Reddit's r/datasets to get feedback and inspiration.
Feel free to ask if you need guidance on a specific dataset or project idea!
💯
Ashwani broo !!😖😖Please suggest some good online certification courses (Or institute) that cover from foundation to moderate level of all important skills and also there will some kind of placement through them.
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.
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
Sir i am form non tech background its hurdle to get job in data analytics??
Hi, it is not difficult to get into data analytics if you are from a non-tech background, the only requirement is that you should like and enjoy the data analytics and its learning journey. Start by enrolling in a free online course. There are a lot of options on RUclips.
Is python needed for data analyst ?
yes, to be a good data analyst who stands out you need to know Python.
Can you suggest projects
1. Real Estate Market Analysis:
• Objective: Analyze real estate market trends using publicly available data.
• Tasks:
• Collect data on property prices, sizes, locations, and other relevant attributes.
• Clean and preprocess the data.
• Perform exploratory data analysis (EDA) to uncover trends and patterns.
• Create visualizations to present your findings.
• Build a predictive model to forecast property prices.
• Tools: SQL, Python (pandas, matplotlib, seaborn, scikit-learn).
2. Customer Segmentation for a Retail Business:
• Objective: Segment customers based on purchasing behavior to improve marketing strategies.
• Tasks:
• Gather transaction data from a retail business.
• Clean and preprocess the data.
• Use clustering techniques (e.g., K-means) to segment customers.
• Analyze each segment’s characteristics.
• Provide recommendations for targeted marketing campaigns.
• Tools: SQL, Python (pandas, matplotlib, seaborn, scikit-learn).
3. Sales Performance Dashboard:
• Objective: Create an interactive dashboard to monitor sales performance.
• Tasks:
• Collect sales data from a business.
• Clean and preprocess the data.
• Design and develop an interactive dashboard using a tool like Tableau or Power BI.
• Include key performance indicators (KPIs), trends, and drill-down capabilities.
• Tools: SQL, Python (pandas), Tableau or Power BI.
4. Social Media Sentiment Analysis:
• Objective: Analyze public sentiment on a specific topic or brand using social media data.
• Tasks:
• Collect social media data using APIs (e.g., Twitter API).
• Clean and preprocess the data.
• Perform sentiment analysis using natural language processing (NLP) techniques.
• Visualize sentiment trends over time.
• Tools: Python (pandas, NLTK or spaCy, matplotlib, seaborn).
5. Financial Data Analysis:
• Objective: Analyze financial data to provide investment insights.
• Tasks:
• Collect historical stock price data and financial reports.
• Clean and preprocess the data.
• Perform EDA to identify trends and patterns.
• Develop a model to predict stock prices or evaluate investment portfolios.
• Tools: SQL, Python (pandas, matplotlib, seaborn, scikit-learn).
@@AshInTech dayum thank u so much
Bro i m a mac user can i use excel in the browser??
Yes, you can. login into your Microsoft online account using www.office.com/, then from the application list, click on Excel.
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
How can I learn sql?
here is the video covering step by step instructions on how to learn SQL
ruclips.net/video/3-we_O0v6UM/видео.html
Posted today, like and subscribe. Thank you
Where do u work ? I didn't get u in LinkedIn?
You should be able to find me using my name Ashwani Panwar
Is there any years gap problem?
A gap year should not be a big issue, do a project and show that.
Can you make a detailed resume video for data analyst role
Definitely, I will be making a video about that soon.
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 RUclips.
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✅
Hi sir i am commerce background. Can i go for data analytics or
Yes, definitely
Can you send me the source to learn Excel
sure, here are couple of options
support.microsoft.com/en-us/office/excel-video-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb
www.youtube.com/@ExcelCampus
bro ....!!! whats wrog with your nossels they are just flashing in video
very distractiong....😑😒😔
Hahaha, good catch I also realized that after recording. I have switched to better equipment, this will not happen again.
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...
Sir Hindi me hi samjha detaa
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.
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
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.
English language not understanding please try Hindi
bilkul, mein hindi mein banounga video. thank you