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
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
WEEK 1-2
1.Excel :
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
2.Math and Statistics:
Topics:
▪ Basic Math: Arithmetic, Weighted average, Cumulative sum, Percentile.
▪ Basic Statistics: Mean, Median, Mode, Standard deviation, Normal distribution.
Next step:
- Create a professional LinkedIn profile
- Add professional photo, headline, summary and educational details
- Make full Excel project and add to your resume/LinkedIn profile
20% complete👍👍
WEEK-3,4,5
3.SQL:
Topics :
Basic Queries: SELECT, WHERE, DISTINCT, LIKE, BETWEEN, ORDER BY, LIMIT, GROUP BY,
HAVING CLAUSE, INSERT, UPDATE, ALTER, IMPORT, Data types
- Advance Queries: Date time function, Window function, Sub query, Case statement, CTE,
query optimizations'.
JOINS: Inner, Outer, Left, Right
20% complete👍👍
WEEK-3,4,5
3.SQL:
Topics :
Basic Queries: SELECT, WHERE, DISTINCT, LIKE, BETWEEN, ORDER BY, LIMIT, GROUP BY, HAVING CLAUSE, INSERT, UPDATE, ALTER, IMPORT, Data types
JOINS: Inner, Outer, Left, Right
