🚀 Data Analyst Roadmap 2026

🎯 STEP 1 — Understand the Data Analyst Role

What a Data Analyst does:

• Data Analytics overview

• Data Analyst vs Data Scientist vs Data Engineer

• Types of data: Structured vs unstructured

• KPIs and metrics

• Business questions vs data questions

• Descriptive, diagnostic, predictive, prescriptive analytics

• Data collection, cleaning, transformation, analysis

• Data visualization, reporting, presenting insights

• Stakeholder communication

📊 STEP 2 — Master Excel

⏱️ Time: 2–3 weeks

Level 1 — Excel Basics

Workbook, worksheets, rows, columns, cell references, relative/absolute, formatting, sorting, filtering, freeze panes, find & replace, data validation

Level 2 — Essential Formulas

SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTBLANK, ROUND, ROUNDUP, ROUNDDOWN

Level 3 — Conditional Functions

IF, IFS, AND, OR, NOT, IFERROR, SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, MAXIFS, MINIFS

Level 4 — Lookup Functions

XLOOKUP, VLOOKUP, HLOOKUP, INDEX, MATCH, XMATCH

Level 5 — Text Functions

LEFT, RIGHT, MID, LEN, TRIM, CLEAN, UPPER, LOWER, PROPER, CONCAT, TEXTJOIN, SUBSTITUTE, FIND, SEARCH, TEXT

Level 6 — Date Functions

TODAY, NOW, DATE, YEAR, MONTH, DAY, DATEDIF, EDATE, EOMONTH, NETWORKDAYS, WORKDAY

Level 7 — Advanced Excel

PivotTables, PivotCharts, Conditional Formatting, Named ranges, Dynamic arrays, FILTER, SORT, UNIQUE, SEQUENCE, What-if analysis, Goal Seek

Level 8 — Power Query

Import data, remove duplicates, handle missing values, split columns, merge/append queries, change data types, custom columns, Group By, Basic M

🎯 Excel Project

Sales Performance Dashboard: Total Sales, Total Orders, AOV, Sales by Region/Product, Monthly Trend, Top 10 Customers, Sales Growth, Target vs Actual

🗄️ STEP 3 — Master SQL

⏱️ Time: 4–6 weeks

Level 1 — SQL Fundamentals

SELECT, FROM, WHERE, ORDER BY, DISTINCT, LIMIT, NULL, Aliases, Operators

Level 2 — Aggregations

COUNT(), SUM(), AVG(), MIN(), MAX(), GROUP BY, HAVING

🔗 STEP 4 — SQL Joins

INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN, SELF JOIN

Primary keys, Foreign keys, 1:1, 1:M, M:M relationships

🧠 STEP 5 — Advanced SQL

Subqueries, CTEs, Window Functions: ROW_NUMBER(), RANK(), DENSE_RANK(), LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE(), NTILE()

CASE, Date functions, String functions, UNION, UNION ALL, INTERSECT, EXCEPT, Recursive CTEs, Conditional aggregation, Running totals, Moving averages, Cohort analysis

🎯 SQL Projects

1. E-commerce Analysis

2. Customer Churn Analysis

3. Financial/Sales Performance Analysis

📈 STEP 6 — Statistics

⏱️ Time: 2–3 weeks

Descriptive: Mean, Median, Mode, Range, Variance, Std Dev, Percentiles, Quartiles, IQR

Probability: Basics, Conditional probability, Independent events, Bayes' theorem

Distributions: Normal, Binomial, Poisson, Skewness

Inferential: Population vs Sample, Sampling, Confidence intervals, Hypothesis testing, p-value, Type I/II error, Statistical significance

A/B Testing: Control vs Treatment, Null/Alternative hypothesis, Statistical vs Practical significance

📊 STEP 7 — Power BI

⏱️ Time: 4–6 weeks