Roadmap on how to become a Data Analyst in 2024

  Рет қаралды 10,034

Ashwani Panwar

Ashwani Panwar

Күн бұрын

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.

Пікірлер: 80
@shivamraina7644
@shivamraina7644 2 ай бұрын
Hi, brother! Can you make a video in which you would talk individually about what things to cover in these different technical tools?
@AshInTech
@AshInTech 2 ай бұрын
Sure, I will be making a video soon.
@sukumarborman152
@sukumarborman152 Ай бұрын
Nyc
@AshInTech
@AshInTech Ай бұрын
Thank you
@tomaraditya9487
@tomaraditya9487 3 ай бұрын
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
@AshInTech
@AshInTech 3 ай бұрын
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
@GagandeepSingh-vd9hd
@GagandeepSingh-vd9hd 3 ай бұрын
@tomaraditya9487 hello bro data analyst job market is like that only I think that job market will be recover soon
@tomaraditya9487
@tomaraditya9487 3 ай бұрын
@@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
@shubham54312.
@shubham54312. 8 күн бұрын
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.
@kumkumchakraborty2892
@kumkumchakraborty2892 26 күн бұрын
I am from Michigan, Ann Arbor
@AshInTech
@AshInTech 23 күн бұрын
Awesome!
@fermion4945
@fermion4945 2 ай бұрын
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 😫
@AshInTech
@AshInTech Ай бұрын
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.
@ifoodieTV
@ifoodieTV 28 күн бұрын
Yes he is right. I will do the same 🎉
@urvitripathi
@urvitripathi Ай бұрын
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.
@AshInTech
@AshInTech Ай бұрын
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 kzfaq.info/get/bejne/aZOnmMKAldyahYE.html
@SanjeevSingh-ep9hu
@SanjeevSingh-ep9hu Ай бұрын
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?
@AshInTech
@AshInTech Ай бұрын
good question, and yes that should be okay, mention the projects that you gained the skills from.
@bablookumar3942
@bablookumar3942 18 күн бұрын
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
@AshInTech
@AshInTech 9 күн бұрын
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!
@rajsx5
@rajsx5 3 ай бұрын
💯
@rishirajput1780
@rishirajput1780 3 күн бұрын
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.
@kumkumchakraborty2892
@kumkumchakraborty2892 26 күн бұрын
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.
@AshInTech
@AshInTech 23 күн бұрын
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.
@user69561
@user69561 Ай бұрын
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?
@AshInTech
@AshInTech Ай бұрын
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.
@user69561
@user69561 Ай бұрын
​@@AshInTechThank you sir
@Himanshukumar-wo3ii
@Himanshukumar-wo3ii 22 күн бұрын
Sir i am form non tech background its hurdle to get job in data analytics??
@AshInTech
@AshInTech 16 күн бұрын
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 KZfaq.
@ArunKumar-xy5jr
@ArunKumar-xy5jr 2 ай бұрын
Is python needed for data analyst ?
@AshInTech
@AshInTech 2 ай бұрын
yes, to be a good data analyst who stands out you need to know Python.
@hananhidayathulla8623
@hananhidayathulla8623 10 күн бұрын
Can you suggest projects
@AshInTech
@AshInTech 9 күн бұрын
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).
@hananhidayathulla8623
@hananhidayathulla8623 8 күн бұрын
@@AshInTech dayum thank u so much
@avinashgohite9921
@avinashgohite9921 17 күн бұрын
Bro i m a mac user can i use excel in the browser??
@AshInTech
@AshInTech 16 күн бұрын
Yes, you can. login into your Microsoft online account using www.office.com/, then from the application list, click on Excel.
@user-id5ou2ov2c
@user-id5ou2ov2c Ай бұрын
Can i do diploma in data analyst after 12th commerce ?
@AshInTech
@AshInTech Ай бұрын
you can definitely do a certification. let me know if you have any questions. Like and Subscribe
@MHb789
@MHb789 Ай бұрын
How can I learn sql?
@AshInTech
@AshInTech Ай бұрын
here is the video covering step by step instructions on how to learn SQL kzfaq.info/get/bejne/aZOnmMKAldyahYE.html Posted today, like and subscribe. Thank you
@pratikjugantmohapatra18
@pratikjugantmohapatra18 2 ай бұрын
Where do u work ? I didn't get u in LinkedIn?
@AshInTech
@AshInTech 2 ай бұрын
You should be able to find me using my name Ashwani Panwar
@shubhdx
@shubhdx Ай бұрын
Is there any years gap problem?
@AshInTech
@AshInTech Ай бұрын
A gap year should not be a big issue, do a project and show that.
@GagandeepSingh-vd9hd
@GagandeepSingh-vd9hd 3 ай бұрын
Can you make a detailed resume video for data analyst role
@AshInTech
@AshInTech 2 ай бұрын
Definitely, I will be making a video about that soon.
@sumitagarwal9080
@sumitagarwal9080 3 ай бұрын
I am 2 nd year student please suggest me a good roadmap to became a data analyst
@AshInTech
@AshInTech 3 ай бұрын
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 KZfaq. 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
@procap1028
@procap1028 2 ай бұрын
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?
@sumitagarwal9080
@sumitagarwal9080 2 ай бұрын
@@AshInTech thanku sir for your suggestion nd tips
@AshInTech
@AshInTech 2 ай бұрын
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
@procap1028
@procap1028 2 ай бұрын
@@AshInTech Dil se shukriya bhai 🫶, I have already subscribed to you✅
@harshakumari1893
@harshakumari1893 Ай бұрын
Hi sir i am commerce background. Can i go for data analytics or
@AshInTech
@AshInTech Ай бұрын
Yes, definitely
@rayedibabi7320
@rayedibabi7320 23 күн бұрын
Can you send me the source to learn Excel
@AshInTech
@AshInTech 16 күн бұрын
sure, here are couple of options support.microsoft.com/en-us/office/excel-video-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb www.youtube.com/@ExcelCampus
@pravin3870
@pravin3870 2 күн бұрын
bro ....!!! whats wrog with your nossels they are just flashing in video very distractiong....😑😒😔
@AshInTech
@AshInTech 2 күн бұрын
Hahaha, good catch I also realized that after recording. I have switched to better equipment, this will not happen again.
@sumitagarwal9080
@sumitagarwal9080 2 ай бұрын
sir is AI is going to take jobs of data analyst
@AshInTech
@AshInTech 2 ай бұрын
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.
@MHb789
@MHb789 Ай бұрын
@@AshInTechwhat are the new skills that an aspiring data analyst needs to be upskilling in this era?
@satyamraj8139
@satyamraj8139 Ай бұрын
dandwat parnaam sir g
@AshInTech
@AshInTech Ай бұрын
Hi @MHb789 , sure, you do need to know Sql, python, data visualization tool, Statistics and AI-ML.
@FactoSumit
@FactoSumit Ай бұрын
Are bhai nahe legi job ai help karne aaya hai oata nahi tumlog kyu darte ho...
@tarunkashyaprajput4935
@tarunkashyaprajput4935 7 күн бұрын
Sir Hindi me hi samjha detaa
@aswathibaburaj9666
@aswathibaburaj9666 26 күн бұрын
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
@AshInTech
@AshInTech 23 күн бұрын
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.
@akanksha8745
@akanksha8745 Ай бұрын
Sir... I'm a student and I am doing BCA . So from where I have to start?
@AshInTech
@AshInTech Ай бұрын
Hi, this video covers all the points and steps that you need to know to become a data analyst. Start from SQL.
@akanksha8745
@akanksha8745 Ай бұрын
@@AshInTech Sir, when I have to learn about Excel?
@AshInTech
@AshInTech Ай бұрын
@@akanksha8745 good question, sql excel, python and data visualization tool are the building blocks
@akanksha8745
@akanksha8745 Ай бұрын
@@AshInTech Ok thank you sir so I have to start from learning SQL
@AshInTech
@AshInTech Ай бұрын
Yes
@user-bx3zx8yf1t
@user-bx3zx8yf1t Ай бұрын
Where are you from
@AshInTech
@AshInTech Ай бұрын
USA
@user-bx3zx8yf1t
@user-bx3zx8yf1t Ай бұрын
@@AshInTech I am also from the USA, so I have a question Are there scope and opportunities to be a data analyst?
@AshInTech
@AshInTech Ай бұрын
Yes, there is plenty of scope for the data analyst. A lot of future jobs are going to be related to data.
@tofansingh3642
@tofansingh3642 Ай бұрын
English language not understanding please try Hindi
@AshInTech
@AshInTech Ай бұрын
bilkul, mein hindi mein banounga video. thank you
Tier 3 to Data Analyst in 3 months I Complete Roadmap I 2024
32:57
Shivangi Tiwari
Рет қаралды 22 М.
Stupid Barry Find Mellstroy in Escape From Prison Challenge
00:29
Garri Creative
Рет қаралды 20 МЛН
ROCK PAPER SCISSOR! (55 MLN SUBS!) feat @PANDAGIRLOFFICIAL #shorts
00:31
ТАМАЕВ vs ВЕНГАЛБИ. ФИНАЛЬНАЯ ГОНКА! BMW M5 против CLS
47:36
1 Month Roadmap To Become a Data Analyst - 2024
14:45
Aditi Gupta
Рет қаралды 95 М.
FASTEST Way To Become a Data Analyst and ACTUALLY Get a Job In 2024
14:03
Unorthodox Change
Рет қаралды 213 М.
How to create a Perfect Data Analyst Resume
6:54
Ashwani Panwar
Рет қаралды 2,3 М.
Creating a Data Analyst Resume | FREE Templates
13:25
Matt Mike
Рет қаралды 779
How I'd Learn Data Analytics in 2024 | 3 Month Plan
11:42
Rohan Adus
Рет қаралды 305 М.
How to Become a Data Analyst in 2023 (Completely FREE!)
13:59
Alex The Analyst
Рет қаралды 1 МЛН
How I Became a Data Analyst & Got a Job! (No CS Degree)
8:47
How to learn Power BI in 2024 | Step by Step Guide
19:40
Goodly
Рет қаралды 34 М.
Samsung Galaxy 🔥 #shorts  #trending #youtubeshorts  #shortvideo ujjawal4u
0:10
Ujjawal4u. 120k Views . 4 hours ago
Рет қаралды 9 МЛН
How To Unlock Your iphone With Your Voice
0:34
요루퐁 yorupong
Рет қаралды 26 МЛН
Gizli Apple Watch Özelliği😱
0:14
Safak Novruz
Рет қаралды 3,5 МЛН
WWDC 2024 Recap: Is Apple Intelligence Legit?
18:23
Marques Brownlee
Рет қаралды 6 МЛН