DATA ANALYST ROADMAP - 2023
Start your career to data science in just 3 months, this roadmap will help you to
learn data science skills from scratch. This is a structured and detailed roadmap
which includes:
tech skills + resources, projects, soft skills + resources, resume template + tips
and interview preparation guide
➢ Role of a Data Analyst
A data analyst collects, cleans, and interprets data sets in order to answer a question
or solve a problem
Six steps of data analysis:
1. Business Question: Define what problem you want to solve
2. Get Data: Collect the data required for analysis
3. Explore Data: Explore data with visual exploration to understand what is in a
dataset
4. Prepare Data: Data cleaning, calculated fields and data validation
5. Analyze Data: Use data analysis techniques to understand, interpret, and
derive conclusions based on the requirements
6. Present Findings: Share insights with stakeholders
< In just 3 months you can START your career to data science >
Let’s Start!
, Week – 1, 2
1. Excel
o Topics
▪ Basic formulas: SUM, AVERAGE, MEAN, MEDIAN, SUMPRODUCT, CONCATENATE
▪ Advance formulas: VLOOKUP, INDEX, MATCH, IF, COUNTIF, SUMIF
▪ Remove duplicates and conditional formatting
▪ Charts, filters, sort and slicers
▪ Pivot tables and pivot charts
▪ Ignore VBA, Macros, etc
o Resources
▪ Complete Excel Tutorial in one video: https://www.youtube.com/watch?v=OX-iyb-21tk
▪ Excel for beginner’s playlist:
https://www.youtube.com/playlist?list=PLdOKnrf8EcP1Y1XRUVSUc0g-WfeiBigbd
▪ Google Template Gallery: https://docs.google.com/spreadsheets/u/0/?ftv=1
▪ Full Excel Project: https://www.youtube.com/watch?v=gTK5rNhWJyA
2. Math and Statistics
o Topics
▪ Basic Math: Arithmetic, Weighted average, Cumulative sum, Percentile
▪ Basic Statistics: Mean, Median, Mode, Standard deviation, Normal distribution
o Resources
▪ Note: just learn basics, initially don’t go for phd
▪ Complete Statistics For Data Science In 6 hours By Krish Naik (watch only above mentioned
topics): https://www.youtube.com/watch?v=LZzq1zSL1bs
▪ Statistics Tutorial for Beginners by Simplilearn:
https://www.simplilearn.com/tutorials/statistics-tutorial
Rishabh Mishra
Start your career to data science in just 3 months, this roadmap will help you to
learn data science skills from scratch. This is a structured and detailed roadmap
which includes:
tech skills + resources, projects, soft skills + resources, resume template + tips
and interview preparation guide
➢ Role of a Data Analyst
A data analyst collects, cleans, and interprets data sets in order to answer a question
or solve a problem
Six steps of data analysis:
1. Business Question: Define what problem you want to solve
2. Get Data: Collect the data required for analysis
3. Explore Data: Explore data with visual exploration to understand what is in a
dataset
4. Prepare Data: Data cleaning, calculated fields and data validation
5. Analyze Data: Use data analysis techniques to understand, interpret, and
derive conclusions based on the requirements
6. Present Findings: Share insights with stakeholders
< In just 3 months you can START your career to data science >
Let’s Start!
, Week – 1, 2
1. Excel
o Topics
▪ Basic formulas: SUM, AVERAGE, MEAN, MEDIAN, SUMPRODUCT, CONCATENATE
▪ Advance formulas: VLOOKUP, INDEX, MATCH, IF, COUNTIF, SUMIF
▪ Remove duplicates and conditional formatting
▪ Charts, filters, sort and slicers
▪ Pivot tables and pivot charts
▪ Ignore VBA, Macros, etc
o Resources
▪ Complete Excel Tutorial in one video: https://www.youtube.com/watch?v=OX-iyb-21tk
▪ Excel for beginner’s playlist:
https://www.youtube.com/playlist?list=PLdOKnrf8EcP1Y1XRUVSUc0g-WfeiBigbd
▪ Google Template Gallery: https://docs.google.com/spreadsheets/u/0/?ftv=1
▪ Full Excel Project: https://www.youtube.com/watch?v=gTK5rNhWJyA
2. Math and Statistics
o Topics
▪ Basic Math: Arithmetic, Weighted average, Cumulative sum, Percentile
▪ Basic Statistics: Mean, Median, Mode, Standard deviation, Normal distribution
o Resources
▪ Note: just learn basics, initially don’t go for phd
▪ Complete Statistics For Data Science In 6 hours By Krish Naik (watch only above mentioned
topics): https://www.youtube.com/watch?v=LZzq1zSL1bs
▪ Statistics Tutorial for Beginners by Simplilearn:
https://www.simplilearn.com/tutorials/statistics-tutorial
Rishabh Mishra
