Data Analyst Roadmap 2026
A data analyst turns raw data into decisions. This roadmap covers Excel, SQL, Python, statistics, visualisation with Power BI or Tableau, and storytelling.
4 stages · 10 topics · Beginner · about 260 hours · Last reviewed 19 November 2026
What is a data analyst?
A data analyst turns raw data into answers a business can act on. The work covers pulling data with SQL, cleaning and exploring it in Excel or Python, checking it with statistics, building dashboards in Power BI or Tableau, and presenting a clear recommendation. This roadmap follows that workflow from spreadsheets to storytelling.
Data Analyst fresher salary in India
Typical fresher offers for this role are about 3 to 7 LPA per year. This is an indicative range, not a guarantee. Pay depends on city, company type and how strong your projects and interview performance are.
Step-by-step data analyst roadmap
- 1
Spreadsheets and SQL
The tools every analyst uses daily.
- Excel
Excel is the most common tool for quick analysis, using formulas, pivot tables and charts.
- SQL for analysis
SQL retrieves and summarises data from databases and is the most tested skill in analyst interviews.
- Excel
- 2
Python for data
Clean and explore data at scale.
- Python basics
Python is the most popular language for data work thanks to simple syntax and a large library ecosystem.
- Pandas
Pandas is a Python library for loading, cleaning, filtering and aggregating tabular data.
- NumPy
NumPy provides fast arrays and numerical operations that Pandas and many other libraries are built on.
- Python basics
- 3
Statistics
Reason about data correctly.
- Descriptive statistics
Descriptive statistics summarise data with measures such as mean, median, variance and distributions.
- Hypothesis testing and A/B tests
Hypothesis testing checks whether an observed difference is likely real or just random chance.
- Descriptive statistics
- 4
Visualisation and storytelling
Make results easy to act on.
- Power BI
Power BI builds interactive dashboards from multiple data sources using DAX measures.
- Tableau
Tableau creates interactive visualisations and dashboards through drag and drop.
- Data storytelling
Data storytelling means presenting findings as a clear narrative with a recommendation, not just charts.
- Power BI
Projects to build
Sales dashboard in Excel (Beginner)
Pivot tables, charts and slicers on a sales dataset.
SQL analysis of an e-commerce database (Beginner)
Revenue, retention and top products with joins and window functions.
Customer churn analysis in Python (Intermediate)
Clean data with Pandas and find churn drivers.
Power BI executive dashboard (Intermediate)
Multi-page report with DAX KPIs.
A/B test case study (Advanced)
Design and analyse an experiment with significance testing.
Frequently asked questions
Ready to practise for interviews?
Practise data analyst questions with an AI mock interviewer and get feedback on your answers.